Problem in Database error in vBulletin 4.2.0:
Hello
Sometime server send me following email error:
[QUOTE]Database error in vBulletin 4.2.0:
Invalid SQL:
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
Request Date : Wednesday, September 25th 2013 @ 04:01:28 PM
Error Date : Wednesday, September 25th 2013 @ 04:01:28 PM
Script :
IP Address : 212.7.212.113
Username : not registered
Classname : vB_Database
MySQL Version :
my config in my.cnf is: [QUOTE][mysqld] local-infile=0 join_buffer_size=512 query_cache_size=16M tmp_table_size=32M max_heap_table_size=256M thread_cache_size=4 max_allowed_packet=32M key_buffer_size=963M query_cache_limit=1M open_files_limit=43042
can you help me for resolve? Thanks.
my config in my.cnf is: [QUOTE][mysqld] local-infile=0 join_buffer_size=512 query_cache_size=16M tmp_table_size=32M max_heap_table_size=256M thread_cache_size=4 max_allowed_packet=32M key_buffer_size=963M query_cache_limit=1M open_files_limit=43042
can you help me for resolve? Thanks.
-
[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 -
i not underestand correctly, so problem is for script? not is for config database? Thanks! 0 -
Please help me:( 0 -
[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 -
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.
Comments
5 comments