Thread: Database error
View Single Post
  #1  
Old 08-27-2006, 05:20 AM
good2laugh's Avatar
good2laugh good2laugh is offline
Junior Member
 
Join Date: Jul 2006
Location: on the outskirts of London with no night life and high taxes
Posts: 23
Geek Article and Review System License Holder 
Default Database error

Just making geeky aware of this - haven't been able to reproduce yet

History..
Posted a new review - didn't rate it as author.
Posted a comment containing a review, with no ratings...

got the error posted below...

When the error appeared, I pressed back in the browser and was taken back to the pre-post screen, so pressed post again.. I got the message it was a duplicate yadda yadda, but this time no error.


Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE gars SET avg_rating=, avg_rating_data='a:4:{i:0;d:0;i:1;d:0;i:2;d:0;i:3; d:0;}', rating_count='1' , ratings_data ='a:4:{i:0;i:0;i:1;i:0;i:2;i:0;i:3;i:0;}',overall_ rating = 0 WHERE threadid=6418;

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 ' avg_rating_data='a:4:{i:0;d:0;i:1;d:0;i:2;d:0;i:3; d:0;}', rating_count='1' , ra' at line 1
Error Number : 1064
Date : Sunday, August 27th 2006 @ 06:10:10 AM
Script : sitename.com/newreply.php?do=postreply&t=6418
Referrer : sitename.com/newreply.php?do=newreply&noquote=1&p=61766
IP Address : ipaddress
Username : FredFlintstone
Classname : vB_Database

Please note, this is for the penultimate GARS, I didn't yet have time to upgrade..... so if this is a known problem it could be fixed.. This post is a FYI only.

Cheers
Reply With Quote