Coming from JIRA v4.1.2, and trying to migrate to JIRA 5.0.6.
Went through the migration steps, I think correctly. On first attempt to migrate got the following error message :
"(SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xEF\x83\xA"
This is quite similar to this report : https://answers.atlassian.com/questions/55520/error-importing-data-while-migrating-jira-incorrect-string-value
So dropped&recreated the database, unzipped the xml backup and uploaded it to the server (debian).
Issued sed -i 's/^C//g' backup.xml - there was no output (no error, no summary not success confiramtion), have no clue if that's good or bad...
And tried the migration again. This time again the same error message. Could anyone give some help/hint?
Great...clean debian install, clean mysql-server install, clean installation of jira.
on migration : "Unable to find ActiveObjects plugin. The plugin must be enabled for the restore to work."
This is getting more and more wierd...
Magic...Just reattempted the migration and seems it worked fine. But as far as I remember I have not done anything differently...
I'll ask one of the users to verify if everything is migrated. If that get's verified I'll perform an addtional test migartion to see if I could reproduce the same result. Let's hope the best.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just checked, the command select charset('jiraaction'); seems not returning useful data...
mysql> select charset('jiraaction');
+-----------------------+
| charset('jiraaction') |
+-----------------------+
| latin1 |
+-----------------------+
1 row in set (0.00 sec)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dieter, thanks for your comment.
Server version: 5.1.61-0+squeeze1 (Debian)
CREATE
DATABASE
jiradb
CHARACTER
SET
utf8;"...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what is your MySQL version and the encoding of your table jiraaction? Please post the result of
select charset('jiraaction')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.