No Styles after upgrade for 4.2.2 to 5.2.3

[bszopi]

Let's get the site info out of the way first...

0. Site URL : www.60degreev6.com/vb5
1. vBulletin version : 5.2.3
2. PHP version : 5.6.25
3. MySQL version : 5.5.50-cll
4. No addons installed
5. There is no default style
6. Using provided English language
7. No error messages on the screen
8. Firefox 48.0.2, also tested on Chrome
9. Have cleared browser cache

The problem is there are NO STYLES shown in the ACP (see attached sccreenshot). This occurred when I decided to try to update my site from vB4 to vB5. I made a copy of the database, and then created a new directory for the vB5 installation (per Wayne's tutorial : http://www.vbulletin.com/forum/forum...ll-vbulletin-5). Once the update was complete, I had no CSS loading. Doing some research on this issue, I changed the setting for Store CSS Stylesheets as Files? to NO. The problem persisted. Using Firebug, I noticed that the CSS files it was trying to load started with a 0 (0-color_style.css). When looking in /clientscript/vbulletin_css/ under the different style folders, the files were shown with what appears to be a timestamp (1474160267-color_style.css). I tried deleting all of these folders out of the vbulletin_css folder, I did receive an error (FileOp Failure: Failed to move 'style00001l' to trash (System Error: Permission denied)). I was able to change of the folder names, create a new folder using the old name, and then upload files renamed to start with a 0. From here, I was able to get a single style to work.

I have tried rebuilding all styles with no luck. I tried uploading a new style, using the default vB5 style, and it didn't work. I also deleted out all of the old vB4 styles from the database in case they were causing issues. As a last resort, I deleted the new database, copied over the old one again, and re-ran the upgrade script. This didn't change any of the issues.

Any insight to the problem would be greatly appreciated.

[Mark.B]

I can see the default style on your site ok.

[bszopi]

I was able to SSH in to the server and delete all of the folders in the vbulletin_css directory. From there, I tried rebuilding the styles and it still didn't work. So I redid the renaming folder, creating new folder, and uploading files starting with the 0 to get the style back.

I did figure out that I am getting a database error, so perhaps this will help determine the issue:

Database error in vBulletin 5.2.3:

Invalid SQL:
INSERT INTO vb_template_temp
(styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly)
SELECT {styleid, title, template, template_un, templatetype, dateline, username, version, product, mergestatus, textonly} FROM vb_template ORDER BY styleid, templatetype, title

/**template_table_query_insert**/;

MySQL Error : 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 ' title, template, template_un, templatetype, dateline, username, version, produc' at line 3
Error Number : 1064
Request Date : Sunday, September 18th 2016 @ 04:05:14 PM
Error Date : Sunday, September 18th 2016 @ 04:05:17 PM
Script : http:///vb5/admincp/misc.php?do=rebuildstyles
Referrer : http://www.60degreev6.com/vb5/adminc...hp?do=chooser&
IP Address : xx.xx.xx.xx
Username : bszopi
Classname : vB_Database_MySQLi
MySQL Version : 5.5.50-cll

[Mark.B]

Make sure you have NO old vBulletin 4 files or folders present. It will break vB5 if you don't remove them.

The only exception to this is any attachment or avatar folders if you have these stored in the file system.

if you have just uploaded vB5 over the top of vB4, you would probably be best deleting all the files and folders and uploading a fresh copy of the vB5 files into the empty directory.

[bszopi]

vB4 was installed in public_html/forum and vB5 was installed in public_html/vb5, so they are completely separate. I did have some files in public_html that were for the vB4 CMS, but I moved those all to a different folder prior to running the upgrade the 2nd time. Or do I need to completely delete all of these files and folders from the server? If that's the case, I may just set up a new account on the server and start fresh.

Edit : I also renamed /forum to /_forum just to be sure.

[Mark.B]

vB5 needs a directory with NO old files at all.

However, if you're going to use a different folder name you need to ensure you have changed the URL settings in the admincp BEFORE you run the upgrade.

[bszopi]

It was installed in a directory with no old files. The old files were in a different directory. Or are you saying it needs to be installed on a server with no old files? 2 completely different scenarios...<br />
<br />
I'm confused by your other statement. So on the old vB4 install, I need to change the URL to the new blank directory prior to running the upgrade? That isn't mentioned in Wayne's how-to...<br />
<br />
Everything is working just fine from what I can tell except the styles. Surely there should be a way to fix them.

[Wayne Luke]

Please turn on debug mode and try the operation again. It will give us more information.

Please see this entry in our Blogs on how to enable Debug Mode within vB5:

http://www.vbulletin.com/go/vb5debug

[bszopi]

Thanks Wayne. Here is what the ACP Style Manager looks like in Debug mode (before AND after running the rebuild styles action).

[bszopi]

I ran the rebuild styles from the maintenance options and noticed an error message. See screenshot showing the error, plus other screenshots showing that all settings referenced by the error appear correct.

[Mark.B]

Did the upgrade actually complete properly? As it has no styles listed.

I suggest uploading all the files again, and re-running the upgrade script. It should import all the styles.

[bszopi]

Ok, uploaded all new files, ran the upgrade script, and still having issues. I didn't go through fixing the CSS files this time (as I mentioned previously), so there is NO style. Still seeing all the same issues. What if I purge all of the style and template tables in the database and then run the upgrade script?

[Mark.B]

Did the upgrade script complete correctly? In other words, did it get right to the end and say 'Upgrade Complete'?

[bszopi]

Yes, it completed successfully.

[Mark.B]

Ok, you can try removing all the styles and templates from the database - although BACK UP the database first, and ideally back up the tables you empty separately as well.