vb.org Archive - DB issues :(

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - DB issues :( (https://vborg.vbsupport.ru/showthread.php?t=55604)

ProParadox

07-25-2003 04:07 PM

DB issues :(

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1059146227,replycount=0,postusername='Bri an L.', postuserid='2', lastposter='Brian L.',attach= WHERE threadid=3
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=3' at line 1

mysql error number: 1064

I JUST installed my forums. I dont get why, or whats happening.

Kriek

07-25-2003 06:56 PM

I experienced a similar problem. Open admin/misc.php and verify your variables have double quotes enclosed within single quotes, so for instance if the attach sum is empty (attachments turned off) then the correct syntax will still be outputted.

PHP Code:


		
			
$DB_site->query("UPDATE thread SET lastpost='".$lastpost."',replycount='".$numberposts."',

postusername='".addslashes($firstusername)."', postuserid='".$firstuserid."', 

lastposter='".addslashes($lastusername)."',attach='".$attachsum."' WHERE threadid='".$threadid."'");

ProParadox

07-25-2003 09:16 PM

fixed. Thanks!

Erwin

07-25-2003 11:55 PM

ProParadox,

You are currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (vB-germany users click here) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

Thank you.

Kriek

07-26-2003 12:22 AM

Quote:

Today at 06:16 PM ProParadox said this in Post #3
Fixed. Thanks!

No problem, glad I could be of assistance to you ;)

Erwin

07-26-2003 06:26 AM

Okay, you are now appearing as licensed. Thanks! :)

lifesourcerec

09-03-2003 04:02 AM

That worked :) Thanks.

TLucent

09-03-2003 05:17 AM

PHP Code:


		
			
$DB_site->query("UPDATE thread SET lastpost=$lastpost,replycount=$numberposts,postusername='".addslashes($firstusername)."', postuserid='$firstuserid', lastposter='".addslashes($lastusername)."',attach=$attachsum WHERE threadid=$threadid");

this is what I have in my misc.php file

ExSIK

09-03-2003 06:30 AM

It didnt fix my Error :( http://www.exsic.org

lifesourcerec

09-03-2003 10:28 AM

Quote:

Today at 07:17 AM TLucent said this in Post #8

PHP Code:

$DB_site->query("UPDATE thread SET lastpost=$lastpost,replycount=$numberposts,postusername='".addslashes($firstusername)."', postuserid='$firstuserid', lastposter='".addslashes($lastusername)."',attach=$attachsum WHERE threadid=$threadid");

this is what I have in my misc.php file

I had that also, but commented it out and replaced it with what's above and it fixed my problem.

All times are GMT. The time now is 01:53 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00991 seconds Memory Usage 1,742KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: