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 04-26-2008, 02:27 AM
Ohiosweetheart Ohiosweetheart is offline
Member
 
Join Date: Aug 2006
Posts: 53
Default DB error while installing the "FIX"

I followed the instructions you laid out for the RC4 fix for GARS and got a db error when importing the product.

Quote:
Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
REPLACE INTO vb_phrase
(languageid,
varname,
text,
phrasetypeid,
product
)
VALUES
(
0,
'gars10_title',
'Screenshot 1',
1,
'geek_gars'
),
(
0,
'gars10_desc',
'',
1,
'geek_gars'
);

MySQL Error : Unknown column 'phrasetypeid' in 'field list'
Error Number : 1054
Request Date : Friday, April 25th 2008 @ 10:16:38 PM
Error Date : Friday, April 25th 2008 @ 10:16:38 PM
Script : http://www.themesbydesign.net/forums...=productimport
Referrer : http://www.themesbydesign.net/forums...?do=productadd
IP Address : 24.154.105.233
Username : Peggy
Classname : vB_Database
MySQL Version : 5.0.45-community
Help??
Reply With Quote
  #2  
Old 04-26-2008, 03:12 AM
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

Looks like you don't have all the GARS v.2.1.8m files on your server. That query looks to be from the GARS v.2.1.8c gars_admin_phrases.php file, so make sure all the GARS files on your server are the v.2.1.8m versions, and then re-import the v.2.1.8m product-gars.xml file - 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
  #3  
Old 04-26-2008, 04:14 AM
Ohiosweetheart Ohiosweetheart is offline
Member
 
Join Date: Aug 2006
Posts: 53
Default

oooooooops, I only ftp'd the files you said to ftp.

Back to the drawing board!
Reply With Quote
  #4  
Old 04-26-2008, 04:52 AM
Ohiosweetheart Ohiosweetheart is offline
Member
 
Join Date: Aug 2006
Posts: 53
Default

Ok I did the full upgrade, and everything looks like it's working great! Thanks so much Morgan.


I have one question. I have a designs site, with several vBulletin themes on it for download. My question is - is there a way to force members to view the release threads using the main style?
Reply With Quote
  #5  
Old 04-26-2008, 05:44 AM
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

Untested, but try the following plugin (how to add a plugin):
Code:
Product: whatever you want
Hook Location: style_fetch
Title: whatever you want
Execution Order: 5 is okay
Plugin PHP Code:

if ($forumid && $forumid == X) // set X to the forum id
{
	$styleid = Y; // set Y to the style id
	$vbulletin->options['styleid'] = $styleid;
}

Plugin is Active: Yes
__________________
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 04-26-2008, 02:00 PM
Ohiosweetheart Ohiosweetheart is offline
Member
 
Join Date: Aug 2006
Posts: 53
Default

great, thank you again!

BTW - can more than one forum ID be placed in there?
Reply With Quote
  #7  
Old 04-27-2008, 04:00 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

You could use in_array or repeat the code with a different X.
__________________
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
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
There is not "member rating" in "newreply.php" gollo Geek Article and Review System 9 11-11-2008 04:57 AM
[BUG] A liittle "phrase"-error za4a tuner Geek Article and Review System 2 10-15-2008 05:00 PM
Database error - missing field "softdelete" pixie Geek Article and Review System 5 03-27-2007 07:00 AM
fehler "kein benuzername.." error "username" hohleweg Geek Article and Review System 7 03-22-2007 10:28 PM
"GARS Rating" Just Like "Hot-or-Not" Voting Pehchaan Geek Article and Review System 4 12-10-2006 06:51 PM


All times are GMT. The time now is 02:18 PM.


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