[CMS] 4.2 PL2 upgrade Styles issue

[gusstrand]

I updated normally, and now it seems that the default style is mobile, and I'm lost. Can't seem to even find where things went awry.

www.tenkara-fisher.com

[Amaury]

4.1.18? There is no vBulletin 4.1.18.

Anyway, what are Default Style for Old Mobile Browsers and Default Style for Modern Mobile Browsers set to?

Admin CP -> Settings -> Options -> Style & Language Options

[gusstrand]

Doh! sorry. fat fingered that one.

None and None

[Amaury]

Doh! sorry.

None and None

So, which version did you upgrade from?

Also, set them to Default Mobile Style.

[gusstrand]

And in the same area under default style, I have a blank, then Mobile Styles in Bold and the two normal choices under that.

- - - Updated - - -

On the versioning, not sure now. It was a few behind, but 4.1.x

[Matthew Gordon]

It's possible that your default style got set as a mobile style. Try the following:

This MySQL query should move your default style back to a standard style. Run it in phpMyAdmin or Admin CP -> Maintenance -> Execute SQL Query. Things to note: if you have a table prefix, you need to add that in front of "style" at the beginning of the query, and if your style's styleid isn't 1 (if it is the default style, it should be) then you need to change that at the end of the query to the proper styleid.

UPDATE style SET parentid = '-1', type = 'standard' WHERE styleid = 1;

After the query successfully runs, go to http://yoursite.com/admincp/template.php?do=rebuild in your browser to rebuild the styles. Also, since it seems that there isn't a default mobile style, I'd suggest making a new style called "Default Mobile Style" (Admin CP -> Styles & Templates -> Style Manager -> [Add New Style] at the bottom) making sure to select "No Parent Style" under "Mobile Styles" (it defaults to "No Parent Style" under "Standard Styles", this is not what you want).

After all that, go to Admin CP -> Settings -> Options -> Style & Language Settings, make sure "Default Style" is your default style and that "Default Style for Old Mobile Browsers" and "Default Style for Modern Mobile Browsers" both show the default mobile style. Save those settings.

[Amaury]

And in the same area under default style, I have a blank, then Mobile Styles in Bold and the two normal choices under that.

- - - Updated - - -

On the versioning, not sure now. It was a few behind, but 4.1.x

Is the separate mobile styles table not showing for you?

[gusstrand]

Saw that in another thread... when I try, says I'm not authorized to execute SQL queries.

[Amaury]

Saw that in another thread... when I try, says I'm not authorized to execute SQL queries.

You'll need to give yourself permission in your config.php folder.

[gusstrand]

Is the separate mobile styles table not showing for you?

[ATTACH=CONFIG]60246[/ATTACH]

Is that Styles--> Style Manager? If so, I have Default and Default Mobile as choices.

[Matthew Gordon]

If you are given a message saying that you are not authorized to run MySQL queries, you need to give yourself this permission by editing your includes/config.php file:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = ''; 

Add your userid there. For example, if your userid is 1 (as it would be if you are using the user created during the initial installation of the software), change it to this:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1'; 

Is that Styles--> Style Manager? If so, I have Default and Default Mobile as choices.

Are they separated like Amaury's screenshot, though?

[gusstrand]

You'll need to give yourself permission in your config.php folder.

Lost me. Old dude.

[Amaury]

Lost me. Old dude.

See Matthew's reply above yours.

[gusstrand]

OK... I go out there and my config.php is there, but there is a .new version uploaded with the update. Which should I use? Editing the "normal" one

- - - Updated - - -

Got it changed, getting query task done now.

- - - Updated - - -

I think herein lies the problem... I have another user who actually owns the site, he's done some editing...

This is what I get:

vBulletin Message

An error occurred while attempting to execute your query. The following information was returned. error number: 1146 error desc: Table 'tenkaravb.style' doesn't exist

- - - Updated - - -

Are they separated like Amaury's screenshot, though?

This is what I see...

[Matthew Gordon]

This is what I see...

Yeah, it is definitely set as a mobile style.

It sounds like you are using a table prefix. To find out what this is, locate the following in the config.php file (yes, includes/config.php, just ignore the .new version):

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = ''; 

You'll need to add the value set there in front of style in the query. For example, if the table prefix setting looks like this:

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vbulletin_'; 

You'll need to change the query like this:

UPDATE vbulletin_style SET parentid = '-1', type = 'standard' WHERE styleid = 1;