Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Reload this Page i'm having this database error
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
i'm having this database error Details »»
i'm having this database error
MOD Information
The Developer
msimplay's Avatar
 
Version: , by msimplay msimplay is offline
Developer Last Online: May 2021 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 06-18-2003 Last Update: Never Installs: 0
 
No support by the author.

Quote:
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055889283,replycount=4,postusername='Tan ny', postuserid='85', lastposter='KALKI',attach= WHERE threadid=1163
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 'WHERE threadid=1163' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 03:18:37 AM
Script: http://www.wambam.net/Vbulletin/Vbul...admin/misc.php
Referer:
it happens when i try to Update Thread Info from admin cp
please help

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-18-2003, 06:41 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Mmm... an attachment is missing? Something is wrong in that thread...

Go here:

http://www.wambam.net/Vbulletin/show...?threadid=1163

And delete the attachment, or delete the whole thread if you don't need, and try again...
Reply With Quote
  #3  
Old 06-18-2003, 06:43 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055887296,replycount=39,postusername='wA mbAm', postuserid='1', lastposter='Ree',attach= WHERE threadid=1162
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 'WHERE threadid=1162' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 03:41:11 AM
Script: http://www.wambam.net/Vbulletin/Vbul...admin/misc.php
Referer:
now i get this
p.s theres are no attachments in that thread :s
Reply With Quote
  #4  
Old 06-18-2003, 07:06 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Did you hack your misc.php? Try uploading an unhacked one.

The query you are trying to run:

PHP Code:
UPDATE thread SET lastpost=1055887296,replycount=39,postusername='wAmbAm', postuserid='1', lastposter='Ree',attach= WHERE threadid=1162 
will not work since there is nothing in "attach=" - see where it runs into trouble? The issue is finding out why.
Reply With Quote
  #5  
Old 06-18-2003, 07:09 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
yeh tried that
i was thinkin they might ave changed the mysql on server and its causing errors now

is this possible
Reply With Quote
  #6  
Old 06-18-2003, 07:19 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
now its just moved on again
after deleting that thread

Quote:
Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1055886725,replycount=11,postusername='Th ugangel', postuserid='19', lastposter='Tanny',attach= WHERE threadid=1160
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 'WHERE threadid=1160' at line 1

mysql error number: 1064

Date: Wednesday 18th of June 2003 04:18:02 AM
Script: http://www.wambam.net/Vbulletin/Vbul...admin/misc.php
Referer:
Reply With Quote
  #7  
Old 06-18-2003, 09:30 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It seems to be a problem when there is no attachment in the post
Reply With Quote
  #8  
Old 06-18-2003, 09:38 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i dont understand it the Misc.php is default
Reply With Quote
  #9  
Old 06-18-2003, 09:50 AM
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Location: UK
Posts: 1,059
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
erm is it serios if i can't update the threads ?
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 10:50 PM.

Contact Us - Archive - Top

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.04345 seconds
  • Memory Usage 2,279KB
  • Queries Executed 22 (?)
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)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)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