Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2011, 07:20 AM
mr1dul mr1dul is offline
 
Join Date: May 2011
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Got Error Number : 1064

Just received the following email from my Vbulletin
Please help and tell what to do...

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
thread.lastpost, thread.replycount,
forum.title AS forumtitle
,post.pagetext AS preview


FROM discuss_thread AS thread
INNER JOIN discuss_forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN discuss_post AS post ON (post.postid = thread.firstpostid)



WHERE thread.threadid IN (136, 175, 174, 134, 125, 274, 281, 235, 151, 156, 266, ) AND thread.visible = 1
AND forum.password = ''


ORDER BY lastpost DESC;

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 forum.password = ''


ORDER BY lastpost ' at line 13
Error Number : 1064
Request Date : Wednesday, May 25th 2011 @ 03:07:04 AM
Error Date : Wednesday, May 25th 2011 @ 03:07:04 AM
Script : http://studychacha.com/discuss/279-a...ance-exam.html
Referrer :
IP Address : 66.249.71.42
Username : Unregistered
Classname : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 05-25-2011, 07:52 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try going to the admin control panel -> Maintenance -> Update Counters, and select "Rebuild Similar Threads".
Reply With Quote
  #3  
Old 05-25-2011, 07:55 AM
mr1dul mr1dul is offline
 
Join Date: May 2011
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for replying...

I did that but getting the same error.
Reply With Quote
  #4  
Old 05-25-2011, 08:02 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try it one more time, but set "Number of threads to process per cycle" to 300.
Reply With Quote
  #5  
Old 05-25-2011, 08:10 AM
mr1dul mr1dul is offline
 
Join Date: May 2011
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

tried it twice .... but its still the same...
Reply With Quote
  #6  
Old 05-25-2011, 08:17 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK, try this: execute this SQL statement:

Code:
UPDATE discuss_thread set similar=('136, 175, 174, 134, 125, 274, 281, 235, 151, 156, 266') WHERE threadid = 279
Reply With Quote
  #7  
Old 05-25-2011, 08:23 AM
mr1dul mr1dul is offline
 
Join Date: May 2011
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Done.... You rock dude...

thanks

--------------- Added [DATE]1306318139[/DATE] at [TIME]1306318139[/TIME] ---------------

Hello..
I am getting those errors again
now on URL

http://studychacha.com/discuss/292-t...ance-exam.html

and 2 more... isn't there a permanent solution for this?
Reply With Quote
  #8  
Old 05-25-2011, 12:53 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't understand how that could happen, so I don't know what the fix is. It looks like that could only happen if there was a null threadid in the thread table, but that shouldn't be possible. ETA: Do you have any mods that affect similar threads?

You could turn off "Automatic Similar Thread Search" if it becomes a big problem - not a fix of course but at least your site will work.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:18 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03668 seconds
  • Memory Usage 2,221KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete