I tried "upgrading" to VB4 when it came out, just as a test and the process failed rather poorly back then, so I decided to try it again since the upgrade process has been slipstreamed or whatnot.
To say it hasn't gone well, would be an understatement, heh.
What I did:
1) Duplicated the live forum onto another domain
2) Copied all the uploaded avatars/attachments etc over
3) Uploaded VB 3.8.7, logged in, changed the details to the new domain, repointed the paths, uninstalled all plugins
4) Removed all 3.8 files, uploaded VB 4 files
5) Ran upgrade, recorded a video of the upgrade process, which you can see here -
Part 1: http://www.youtube.com/watch?v=i1ncne5S4HY
Part 2: http://www.youtube.com/watch?v=FcvuhWz0DBM
End result:
First error was due to a mysql misconfiguration, the default collation type was set to latin1_general_si (or something), whereas, the existing tables were latin1_swedish_si.
Second error was:
So, I emptied the database, reimported the live one, moved all attachments/avatars/sigs into the database, from the file system, reran the upgrade process again.
Got a fair bit further this time (yay!), but again, another error, this time, it was:
So I removed the keywordtext entry from the Fulltext index entry (thankgod for Phpmyadmin)
Refreshed the page, it carried on.
Got to the part where it was processing XML files (Step 6 of 6), 99% of the way there..and it just sat there.
6 minutes or so went by, with no obvious activity, so another page refresh.
Process carried on, upgrading the blog, cms etc and then finished, yay
Went to the main page and, well, you can see the mess my test forum is in. :P
I had the exact same layout issue way back when I tried to upgrade to 4.0
Not sure what's interfering with the style, but I never did figure it out
The only way I could seem to get around it, was by emptying certain database tables like the template/styles tables.
To say it hasn't gone well, would be an understatement, heh.
What I did:
1) Duplicated the live forum onto another domain
2) Copied all the uploaded avatars/attachments etc over
3) Uploaded VB 3.8.7, logged in, changed the details to the new domain, repointed the paths, uninstalled all plugins
4) Removed all 3.8 files, uploaded VB 4 files
5) Ran upgrade, recorded a video of the upgrade process, which you can see here -
Part 1: http://www.youtube.com/watch?v=i1ncne5S4HY
Part 2: http://www.youtube.com/watch?v=FcvuhWz0DBM
End result:
First error was due to a mysql misconfiguration, the default collation type was set to latin1_general_si (or something), whereas, the existing tables were latin1_swedish_si.
Second error was:
Invalid SQL: UPDATE attachment SET filedataid = 0 WHERE filedataid IN ();
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 ')' at line 1
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 ')' at line 1
Got a fair bit further this time (yay!), but again, another error, this time, it was:
Column 'keywordtext' cannot be part of FULLTEXT index.
Query:
ALTER TABLE searchcore_text (Blah blah)
Query:
ALTER TABLE searchcore_text (Blah blah)
Refreshed the page, it carried on.
Got to the part where it was processing XML files (Step 6 of 6), 99% of the way there..and it just sat there.
6 minutes or so went by, with no obvious activity, so another page refresh.
Process carried on, upgrading the blog, cms etc and then finished, yay
Went to the main page and, well, you can see the mess my test forum is in. :P
I had the exact same layout issue way back when I tried to upgrade to 4.0
Not sure what's interfering with the style, but I never did figure it out
The only way I could seem to get around it, was by emptying certain database tables like the template/styles tables.
Comment