On Sunday 14 March 2004 21:18, Robert Kehl wrote:
> On Sunday, March 14, 2004 8:23 PM
>
> Wiktor Wodecki <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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
> <OTRS_HOME>/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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting f�r Ihr OTRS System?
=> http://www.otrs.de/
