[rt-users] migrating from mysql to postgresl

Sterpu Victor victor at ambra.ro
Fri Dec 2 15:27:58 EST 2005


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?




More information about the rt-users mailing list