The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 08-27-2006, 07:35 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
database error beduino Geek Gazette 1 06-24-2008 05:43 PM
Database Error jiggle Geek Article and Review System 1 01-03-2008 10:54 AM
Database error? cookiepants Geek Article and Review System 3 10-20-2006 07:46 PM
Database error vitoreis Geek Article and Review System 5 10-01-2006 09:29 PM
database error agiacosa Geek Auto-Linker 7 10-15-2005 05:19 PM


All times are GMT. The time now is 10:11 AM.


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