[rt-users] migrating from mysql to postgresl

[Ruslan Zakirov]

We don't know how you migrated, but I remember only old (RT 3.0.x)
discussions of the migration process and some results are at
http://wiki.bestpractical.com/index.cgi?MySQLToPg, but I can't confirm
that scripts from that page work as expected with recent versions.

On 12/2/05, Sterpu Victor <victor at ambra.ro> wrote:
> I copied the database from mysql to postgresql.
> At first everithing seemd ok.
> But when I try to create a ticket I receive the follwing error:
>
> Dec  2 22:36:32 ambranagios RT: DBD::Pg::st execute failed: ERROR:
> column "oid" does not exist (/opt/rt3/lib/RT.pm:287)
> Dec  2 22:36:32 ambranagios RT: RT::Handle=HASH(0xb8f6570) couldn't
> execute the query 'SELECT id FROM Tickets WHERE oid = ?' at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
> 506
> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb8f6570)',
> 'SELECT id FROM Tickets WHERE oid = ?', 0) called at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 538
> DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0xb8f6570)',
> 'SELECT id FROM Tickets WHERE oid = ?', 0) called at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Pg.pm line 73
> DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0xb8f6570)',
> 'Tickets', 'Subject', 'test', 'Status', 'new', 'Queue', 15, 'Creator',
> ...) called at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 1291
> DBIx::SearchBuilder::Record::Create('RT::Ticket=HASH(0xc803238)',
> 'Subject', 'test', 'Status', 'new', 'Queue', 15, 'Creator', 12, ...)
> called at /opt/rt3/lib/RT/Record.pm line 300
> RT::Record::Create('RT::Ticket=HASH(0xc803238)', '
> Dec  2 22:36:32 ambranagios RT: Couldn't create a ticket: Object could
> not be created (/opt/rt3/lib/RT/Ticket_Overlay.pm:590)
> Dec  2 22:36:32 ambranagios RT: WebRT: Ticket could not be created due
> to an internal error () (/opt/rt3/share/html/Elements/Error:78)
>
> But the table tickets never had a column oid.
> How can I fix this?
>


--
Best regards, Ruslan.