[rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

[Larry Han]

>Which forum?
Sorry, I meant the wiki and the mailing list.

>You mean that attahcments worked fine with new RT 3.8.0 on clean DB
>hosted on mysql 5.0 server?
>Have you tested old attachments that were in old DB on mysql 4.0?
When I view the ticket, the correspondence text shows up, aren't those attachments. I cant verify that binary attachments work because I'm fiddling with the perl installation right now and rt is currently not working at all.




>I think here is problem. Could you share config of your new mysql 5.0
>and all commands you used to migrate DB from old 4.0 server to 5.0?
>At this point I can suggest you reimport DB from dump (I think you
>used mysqldump for migration) using --default-character-set=binary
>option. Then again apply schema upgrade scrip.

I used the bash script in the wiki to backup my previous database
http://wiki.bestpractical.com/view/backupRTDB

except this line I had to change to
mysqldump $rtDB --opt --default-character-set=binary Attachments  | gzip > $attachfullfn
mysqldump $rtDB --opt  Attachments  | gzip > $attachfullfn

I skipped the gzip and just did >backup.dump and >backup.att

because mysql gave me errors about how binary was not a recognized charset.

Then on the new server. I imported the files it into the database by
mysql -p rt3 < backup.dump
mysql -p rt3 < backup.att


Then I ran rt-setup-database --action upgrade
and then the mysql schema upgrade

perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 user pass> sql.queries
mysql -u root -p rt3 < sql.queries

My new mysql 5.0 config is the same as the 4.0 config. Could there lie the problem?
>At this point I can suggest you reimport DB from dump (I think you
>used mysqldump for migration) using --default-character-set=binary
>option. Then again apply schema upgrade scrip.

Are you saying on the import use --default-character-set=binary ?
How? Like this?
mysql -p rt3 --default-character-set=binary< backup.att


Thanks for the help

Larry H

________________________________________
From: ruslan.zakirov at gmail.com [ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov [ruz at bestpractical.com]
Sent: Wednesday, August 06, 2008 5:26 PM
To: Larry Han
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT at a Glance HASH ref error during upgrade from 3.4 to 3.8

On Thu, Aug 7, 2008 at 3:20 AM, Larry Han <lhan at semaphore.com> wrote:
> I'm in the process of moving and upgrading our RT server from
> rt 3.4.1
> mysql 4.0
> to
> rt 3.8
> mysql 5.0
>
> I have followed the steps on the forum and I have the database moved over to mysql 5.0
Which forum?

and everything seems to work including attachments.
You mean that attahcments worked fine with new RT 3.8.0 on clean DB
hosted on mysql 5.0 server?

Have you tested old attachments that were in old DB on mysql 4.0?

> I did a mysql dump from the old 4.0 database and then imported the dump into the 5.0 database. Then I applied the 'rt-setup-database --action upgrade' command and then did the mysql schema upgrade.

I think here is problem. Could you share config of your new mysql 5.0
and all commands you used to migrate DB from old 4.0 server to 5.0?

At this point I can suggest you reimport DB from dump (I think you
used mysqldump for migration) using --default-character-set=binary
option. Then again apply schema upgrade scrip.

> All tickets seeem to be present in the current database and all attachments look fine. However, I get the following error in the RT at a glance page.
>
> Can't use string ("BQYDAAAAAgQCAAAAAwQDAAAAAgoKTXkg") as a HASH ref while "strict refs" in use at /var/www/tickets01/share/html/Elements/MyRT line 76, line 504.
>
> The RT at a Glance config pages show a similar error.
>
> Searching google for this error message or parts of this error message return nothing. Is there a step that I forgot to do or something that causes this problem? Do I have a misconfigured or incorrect perl package?
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>



--
Best regards, Ruslan.