[rt-users] question about pointer to info for upgrade/conversion of RT

[Tim Mitchell]

Hi all

I have my db converted from postgresql to mysql after a bit of trouble and
inserted into a new 3.8 install, getting an error trying to change my "rt at
a glance" preferences:

Internal Error: Couldn't execute the query 'INSERT INTO Attributes
(ContentType, Creator, ObjectId, LastUpdatedBy, Created, Content, Name,
Description, LastUpdated, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
?)'Duplicate entry '0' for key 1

removed all saved items in the Attributes table (had 6) and get the same
error. I think this may just be a db schema issue, but not 100% sure.




This was my original question, but the mail bounced, if anyone has
experience with the below question, I'd appreciate any pointers.

<snip>
I'd like to move from postgresql to mysql and upgrade from 3.4.4 to at least
3.8.2. Does anyone have any experience with a change like this? Docs,
How-to's? Tips on DB conversion? I have seen the upgrade notes to go from
older mysql to newer mysql but none about converting DB dists specifically
to an RT install/upgrade.

Currently:
PostgreSQL version 7.4.12
Ubuntu dapper
Linux rt-support 2.6.15-26-386 #1 PREEMPT Thu Aug 3 02:52:00 UTC 2006 i686
GNU/Linux
RT 3.4.4

Want to be:
MySQL version 5.0.51
Ubuntu hardy
Linux rt-lab 2.6.24-19-server #1 SMP Wed Aug 20 23:54:28 UTC 2008 i686
GNU/Linux
RT 3.8.2
</snip>


Thanks,

-TM






-- 
Thanks,
-TM

"Ravioli is the square root of pasta."
- Max K., Age 11
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090521/b0878a73/attachment.htm>