The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Article and Review System (http://www.thevbgeek.com/forumdisplay.php?f=26)
-   -   Database error (http://www.thevbgeek.com/showthread.php?t=2006)

good2laugh 08-27-2006 05:20 AM

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 :)

The Geek 08-27-2006 07:35 AM

Thanks :)


All times are GMT. The time now is 07:57 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.