Skip to main content

Problem in Database error in vBulletin 4.2.0:

Comments

5 comments

  • Aaron.Edwards
    [QUOTE]SELECT COUNT(*) as cnt,max(lastpost) as lastupdate FROM thread AS thread INNER JOIN tagcontent AS tagcontent ON (tagcontent.tagid = 1 AND tagcontent.contentid = thread.threadid) WHERE thread.forumid IN() AND thread.visible = 1 AND thread.sticky IN (0, 1) AND thread.open <> 10 GROUP BY tagcontent.tagid; MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND thread.visible = 1 AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064
    Note:- Noticed that statement IN () is empty inside the Parenthesis. Please open the file cron.php and search for : "thread.forumid" and make appropriate changes in this cron.php file.
    0
  • morteza3245
    i not underestand correctly, so problem is for script? not is for config database? Thanks!
    0
  • morteza3245
    Please help me:(
    0
  • Aaron.Edwards
    [QUOTE]MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND thread.visible = 1 AND thread.sticky IN (0, 1)' at line 5
    The above error message states that at line no 5, there is an error. It also indicates that there is something wrong near the closed parenthesis. This should be definitely be the script error as it states, its a syntax error, the statement entered in the script is incorrect.
    0
  • cPanelMichael
    Hello :) Yes, this error message appears directly related to your script as opposed to cPanel or MySQL itself. You may want to consult directly with Vbulletin's support if you are unable to resolve the issue. Thank you.
    0

Please sign in to leave a comment.