The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Article and Review System (http://www.thevbgeek.com/forumdisplay.php?f=26)
-   -   DB error while installing the "FIX" (http://www.thevbgeek.com/showthread.php?t=4192)

Ohiosweetheart 04-26-2008 03: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.

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??

Morgan 04-26-2008 04: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 05:14 AM

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

Back to the drawing board!

Ohiosweetheart 04-26-2008 05: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 06:44 AM

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


Ohiosweetheart 04-26-2008 03:00 PM

great, thank you again!

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

Morgan 04-27-2008 05:00 PM

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


All times are GMT. The time now is 11:37 PM.

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