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 02-13-2006, 09:16 AM
Dstressed's Avatar
Dstressed Dstressed is offline
Junior Member
 
Join Date: Feb 2006
Posts: 5
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Question DB error when trying to edit article

Hi there,

whenever I try to edit an already published article I get the following error when trying to save the changes:

Quote:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE gars SET userid = 1pagecount=1,
byline='on music, Pharrell and his new label',
synopsis='Chances are you already heard of this man. Worked with various names in both the Pop- as Dance-scene his star is rising. Not yet heard of him? Most probably you have. The latest Roger Sanchez track, you know the one, with Bobby Farrell in the music video, is the Axwell edit. We spoke with him.',
data='a:5:{s:7:\"post_as\";s:9:\"Dstressed\";s:10: \"post_as_id\";s:1:\"1\";s:6:\"gal_id\";N;s:12:\"g al_keywords\";s:0:\"\";s:8:\"gal_text\";s:0:\"\";} ',
ratings_data='a:0:{}',
overall_rating=0,
header_image='./geek/gars/images/1/axmini.jpg',
custom1='a:4:{i:1;N;i:2;N;i:3;N;i:4;N;}'
,feature_untill = '1146373200'
WHERE threadid=5;

MySQL Error : Unknown column '1pagecount' in 'field list'
Error Number : 1054
Date : Monday, February 13th 2006 @ 05:16:02 AM
Script : http://www.dstressed.net/editpost.php
Referrer : http://www.dstressed.net/editpost.php?do=editpost&p=21
anyone got an idea how i can fix this?
Reply With Quote
  #2  
Old 02-13-2006, 01:54 PM
JirQUEST JirQUEST is offline
Member
 
Join Date: Jan 2006
Posts: 47
Geek Article and Review System License Holder 
Default

i think u gotta look through your editpost.php and change that line up there to:

UPDATE gars SET userid=<whatever is in file>, pagecount=<whatever is in file>,

something like that.
Reply With Quote
  #3  
Old 02-13-2006, 05:00 PM
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

Hmmm. That does look like an error with a recent update I made. Ill go pop open the code in a minute and double check
Reply With Quote
  #4  
Old 02-13-2006, 08:52 PM
Dstressed's Avatar
Dstressed Dstressed is offline
Junior Member
 
Join Date: Feb 2006
Posts: 5
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

thanks for the quick response! I did just purchase it today and installed it immediately so it is the most recent version of GARS

Thanks again for the quick response and help so far!
Reply With Quote
  #5  
Old 02-13-2006, 09:41 PM
racerx racerx is offline
Junior Member
 
Join Date: Jan 2006
Posts: 1
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder 
Default

Got this error when trying to use some "Byline" value.


Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE vb_gars SET  userid = 23pagecount=1,
                        byline='yes',
	                    synopsis='',
	                    data='a:5:{s:7:\"post_as\";s:6:\"badboy\";s:10:\"post_as_id\";s:2:\"23\";s:6:\"gal_id\";N;s:12:\"gal_keywords\";s:0:\"\";s:8:\"gal_text\";s:0:\"\";}',
	                    ratings_data='a:0:{}',
	                    overall_rating=0,
	                    header_image='./geek/gars/images/types/2/default.jpg',
                        custom1='a:4:{i:1;N;i:2;N;i:3;N;i:4;N;}'
	                    ,feature_untill = '1140411600'
	                    WHERE threadid=394;

MySQL Error  : Unknown column '23pagecount' in 'field list'
Error Number : 1054
Date         : Monday, February 13th 2006 @ 05:40:46 PM
Script       : http://www.site.com/editpost.php
Referrer     : http://www.site.com/edit-post-413.html
IP Address   : 125.240.118.130
Username     : user
Classname    : vb_database
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
Stopping the simply article display and always showing the full article peterska2 Geek Article and Review System 1 05-16-2008 03:08 PM
Error: Parse error: syntax error unexpected T_ENCAPSED_AND_WHITESPACE BeautUtes.com Geek Article and Review System 1 05-16-2007 08:12 AM
[Pre-sale Question] Possible to display only article title and article image on index VAFan Geek Article and Review System 3 11-24-2006 01:16 PM
Database error when starting new article Stoosh Geek Article and Review System 1 11-03-2006 05:58 AM
Weird SQL Error when trying to go to "Next Article" Mithan Geek Article and Review System 2 07-11-2006 05:55 PM


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


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