The vB Geek

The vB Geek (
-   Geek Article and Review System (
-   -   Database error (

good2laugh 08-27-2006 06:20 AM

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

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 :
Referrer :
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 08:35 AM

Thanks :)

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

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