DB issues :(

[ProParadox]

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]

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]

fixed. Thanks!

[Erwin]

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]

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

No problem, glad I could be of assistance to you

[Erwin]

Okay, you are now appearing as licensed. Thanks!

[lifesourcerec]

That worked Thanks.

[TLucent]

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]

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

[lifesourcerec]

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.