Re: [otrs] update woes with current cvs

On Sunday 14 March 2004 21:18, Robert Kehl wrote:

On Sunday, March 14, 2004 8:23 PM

Wiktor Wodecki wrote:

...

is there any way of exporting data from an old otrs 1.2 cvs version and to import it into a new one? The update scripts seem to have some bugs - the result is an inconsistent database.

Could you provide some more detail that allow debugging of the encountered issues?

the dbupdate-to-1.2 script runs through the OTRS seems to have lost all queue information. I still have one new ticket and 5 locked tickets, however when I try to access them the OTRS crashes while trying to find them in the database. The problem seems to be in the new group permission tables, since I get lot's of such messages in the logfile: Message: ERROR: No such attribute gu.permission_key, SQL: 'SELECT g.id, g.name, gu.permission_key, gu.permission_value, gu.user_id FROM groups g, group_user gu WHERE g.valid_id in ( 1 ) AND g.id = gu.group_id AND gu.permission_value = 1 AND gu.permission_key IN ('ro', 'rw') AND gu.user_id = 3' Traceback (31269): Module: Kernel::System::Group::GroupMemberList (v1.19) Line: 409 Module: Kernel::System::Ticket::IndexAccelerator::RuntimeDB::TicketAcceleratorIndex (v1.19) Line: 58 Module: Kernel::Modules::AgentQueueView::BuildQueueView (v1.53) Line: 348 Module: Kernel::Modules::AgentQueueView::Run (v1.53) Line: 151 Module: /data/opt0/otrs.test/bin/cgi-bin/index.pl (v1.66) Line: 687 A quick look through the group_user table shows correct content, tho. Even when I switch off the LDAP authentication and log in as root@localhost I see no queues and no admin interface (the button is missing)

The raw commands to trigger a dump of an existing MySQl/PostGreSQL database can be read from the source code of /scripts/{backup,restore}.sh, so if anything goes wrong with those commands: please tell us. File a bug report on: http://bugs.otrs.org/

oh I have backups and this was just a test-setup to see if the update runs smoothly :-) -- Regards, Wiktor Wodecki net mobile AG - 40470 Duesseldorf - Germany 923B DCF8 070C 9FDD 5E05 9AE3 E923 5A35 182C 9783