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 07-14-2008, 05:05 PM
pipin pipin is offline
Member
 
Join Date: Dec 2006
Posts: 35
Geek Article and Review System License Holder 
Default Updating GARS due to Securitytoken problem

Hi,

i was just about to update GARS after updating to the 3.7 branch of vbulletin and i got it working for updating thread(thx morgan for updating it even if the licence expired).

But i had a glitch when i overwrote the plugin:



Quote:
databe error in vBulletin 3.7.2:

Invalid SQL:

UPDATE cron
SET nextrun = 1216501140
WHERE cronid = 45 AND nextrun =;

MySQL-Fehler : 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 '' at line 3
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 14.07.2008 @ 18:57:37
Datum : Monday, 14.07.2008 @ 18:57:37
Skript : xxx/plugin.php?do=productimport
Referrer : xxx/plugin.php?do=productadd
IP-Adresse : xxxxx
Benutzername : pipin
Klassenname : vB_Database_Slave_MySQLi
MySQL-Version : 5.0.54-log
and it seems the templates were not updated at all.
__________________
Regards,
Jens

Free and Open Source: TGS Content Management with vB-Content-Bridge

Last edited by pipin; 07-14-2008 at 05:09 PM..
Reply With Quote
  #2  
Old 07-14-2008, 05:50 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
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

Don't see a reason for that except maybe your database connection dropped during import. Try importing the product XML file again and see if it's a go. Also check http://www.vbulletin.com/forum/showthread.php?t=247658 as the same problem with that query was posted there.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #3  
Old 07-14-2008, 08:50 PM
pipin pipin is offline
Member
 
Join Date: Dec 2006
Posts: 35
Geek Article and Review System License Holder 
Default

Quote:
Originally Posted by Morgan View Post
Don't see a reason for that except maybe your database connection dropped during import. Try importing the product XML file again and see if it's a go. Also check http://www.vbulletin.com/forum/showthread.php?t=247658 as the same problem with that query was posted there.
You are right, there seems to be a glitch in vB at plugins import, when you have a master and a slave db.
__________________
Regards,
Jens

Free and Open Source: TGS Content Management with vB-Content-Bridge
Reply With Quote
  #4  
Old 07-14-2008, 09:44 PM
pipin pipin is offline
Member
 
Join Date: Dec 2006
Posts: 35
Geek Article and Review System License Holder 
Default

It worked the way discribed at vbulletin.com.

The update finished, but now i got new problems:

The bottom reads: Artikel powered by GARS 2.1.8c ©2005-2006

And i get a database error every time i click on a term set:

Quote:
Datenbankfehler in vBulletin 3.7.2:

Invalid SQL:
SELECT phrasetypeid id FROM phrasetype WHERE fieldname='GARS_1_phrases';

MySQL-Fehler : Unknown column 'phrasetypeid' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 14.07.2008 @ 23:44:05
Datum : Monday, 14.07.2008 @ 23:44:05
Skript : xxx/gars_admin.php?do=editterm&id=1
Referrer : xxx/gars_admin.php?do=displayterms
IP-Adresse : 91.0.200.76
Benutzername : pipin
Klassenname : vB_Database_Slave_MySQLi
MySQL-Version : 5.0.54-log
__________________
Regards,
Jens

Free and Open Source: TGS Content Management with vB-Content-Bridge
Reply With Quote
  #5  
Old 07-15-2008, 07:12 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
Join Date: Jul 2006
Posts: 2,255
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

Grab the latest GARS package and do an upgrade. If you already did this, reFTP all the PHP files from the latest GARS package and re-import the latest product-gars.xml file via the ACP - do not uninstall, do allow overwrite.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote
  #6  
Old 07-16-2008, 06:48 PM
pipin pipin is offline
Member
 
Join Date: Dec 2006
Posts: 35
Geek Article and Review System License Holder 
Default

Quote:
Originally Posted by Morgan View Post
Grab the latest GARS package and do an upgrade. If you already did this, reFTP all the PHP files from the latest GARS package and re-import the latest product-gars.xml file via the ACP - do not uninstall, do allow overwrite.
That helped, thanks to the best support in the world.
__________________
Regards,
Jens

Free and Open Source: TGS Content Management with vB-Content-Bridge
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
Problem updating module set RootX Geek Article and Review System 19 10-28-2008 09:41 PM
Thread Titles not updating? UltraVR Geek Article and Review System 1 01-17-2007 09:12 AM
Unknown column 'user.vbbux' in 'field list' vb 3.6 rc2 due to GARS Neal Geek Article and Review System 7 07-26-2006 06:43 AM
updating issue eko Geek Article and Review System 5 06-01-2006 12:46 PM
Not updating Stryker Geek Article and Review System 3 04-05-2006 10:23 AM


All times are GMT. The time now is 06:12 AM.


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