FUDforum - خوراک RDF
http://fudforum.org/forum/index.php
2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162150&th=119229#msg_162150
Fortunately, I decided to do this in a Dev environment, so I'm not hard down, but I'd like to get this sorted out so I can upgrade my prod environment and replace the server in the process. I got the Dev environment set up based on an rsync of the FUD Forum directories and built the db from a dump of the Prod forum. I'm also upgrading from RHEL4 (Apache 2.0 + PHP 4.3 + Mysql 4.1) to CentOS5 (Apache 2.2 + PHP 5.1.6 + Mysql 5.0.) I started by performing a Mysql table upgrade (from 4.1 to 5.0,) then verified that the Dev copy of the forum works properly. First, I performed a consistency check and db check prior to doing the upgrade. I copied the 3.0 upgrade.php script in place and set the permissions to be owned by the Apache user and gave it 775 permissions. When I run the upgrade script, it processed a good number of files and finally failed throwing an error. I've attached a screenshot showing the error. I logged in to the admin portal and ran a consistency check a second time (which resulted in no errors) and tried the upgrade script again. I am still getting the same errors.
Some additional background on the forum... It's been running for about 5 years. I can't remember what version I started out with, but it was the current version at the time. I have upgraded a couple times, as I recall, but other than updating the RedHat revision of the Apache, PHP and Mysql RPMs, nothing else has changed on the forum. I run two themes. The stock (largely unmodified) theme and one skin that I downloaded and imported to the forum. No hackery whatsoever was done to the forum files or db schema.
Any suggestions on how I can go about troubleshooting this?
Error text for searchability:
ERROR: Duplicate entry 'com ' for key 2
QUERY: ALTER TABLE fud26_search CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci
]]>gotzoom?2010-03-26T22:56:00-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162153&th=119229#msg_162153
I get the same exact error:
]]>gotzoom?2010-03-26T23:15:18-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162154&th=119229#msg_162154
naudefj2010-03-27T07:30:48-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162159&th=119229#msg_162159
Screenshot of the continuing upgrade from where it errored out previously:
]]>gotzoom?2010-03-27T17:05:24-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162162&th=119229#msg_162162
naudefj2010-03-27T18:57:10-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162169&th=119229#msg_162169
I'll try another upgrade with a fresh db import and check it again.]]>gotzoom?2010-03-29T15:03:33-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162172&th=119229#msg_162172
naudefj2010-03-29T18:49:36-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162195&th=119229#msg_162195
I did another complete upgrade yesterday and the fix seems to work without issue, as the upgrade completed without error. The message loss that I initially saw, must have been related to the way that I made a copy of the db.
I do believe that I found a bug, though. I don't think you're handling extended character sets correctly when you upgrade the user profile signatures. Not sure where this lives in the db, though. In my example, a user's signature has Japanese characters (all katakana and hiragana. didn't test with kanji) and after the upgrade, I get a garbled mess where the Japanese characters normally are. You can go into the profile and change the garbled characters to Japanese and everything works happily as normal from there. I didn't notice this problem happening anywhere but the signatures. ]]>gotzoom?2010-03-31T15:19:53-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162196&th=119229#msg_162196
gotzoom? wrote:
I did another complete upgrade yesterday and the fix seems to work without issue, as the upgrade completed without error.
Great news!
gotzoom? wrote:
I do believe that I found a bug, though. I don't think you're handling extended character sets correctly when you upgrade the user profile signatures.
Signatures are stored in the fud30_users table. FUDforum makes no attempt to convert the charset of table data, except for issuing an ALTER TABLE CONVERT statement. If something is wrong, you may want to log a call with the MySQL team.
]]>naudefj2010-03-31T17:45:19-00:00Re: 2.77 -> 3.0 upgrade Issue
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=162199&th=119229#msg_162199
gotzoom?2010-03-31T22:01:47-00:00