The vB Geek

The vB Geek (
-   Geek Article and Review System (
-   -   DB error while installing the "FIX" (

Ohiosweetheart 04-26-2008 02:27 AM

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.


Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
REPLACE INTO vb_phrase
'Screenshot 1',

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 :
Referrer :
IP Address :
Username : Peggy
Classname : vB_Database
MySQL Version : 5.0.45-community

Morgan 04-26-2008 03:12 AM

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.

Ohiosweetheart 04-26-2008 04:14 AM

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

Back to the drawing board!

Ohiosweetheart 04-26-2008 04:52 AM

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?

Morgan 04-26-2008 05:44 AM

Untested, but try the following plugin (how to add a plugin):

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

Ohiosweetheart 04-26-2008 02:00 PM

great, thank you again!

BTW - can more than one forum ID be placed in there?

Morgan 04-27-2008 04:00 PM

You could use in_array or repeat the code with a different X.

All times are GMT. The time now is 01:33 PM.

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