Migrating from mysql to postgresl

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?

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@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.