Database schema question

Hi!

I tried to upgrade my RT 2.0 database to 3.0 version. Because I
couldn’t find any script for doing this I assumede there is no such a
script.

Well, it seemed that manual creating users, queues and groups
and migrating tickets and transactions and updating owner’s and
creator’s fields in tickets and transactions would be enough. It worked
almost very well with the exception that all tickets have an empty
‘requestor’ property displayed. I thought it is taken from ‘creator’
field wich should contain probably id (from table users) of user which
requested this ticket, but I updated that field too and it still doesn’t
work.

Is there any other place containing requestor of ticket?

Richard.

** Internet Designers S.A., ul. Przedmiejska 6-10, 54-201 Wrocław **
tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/

Hi!

I tried to upgrade my RT 2.0 database to 3.0 version. Because I
couldn’t find any script for doing this I assumede there is no such a
script.

There is a conversion tool in the devel subdirectory of the rt download
area. It is not yet complete and has a few wrinkles to iron out, but it
works (albeit a little bit slow for a large number of tickets).
The latest version is ‘rt2-to-rt3-v1.8.tar.gz’

Well, it seemed that manual creating users, queues and groups
and migrating tickets and transactions and updating owner’s and
creator’s fields in tickets and transactions would be enough. It worked
almost very well

How fast is Your version? Maybe You should have a look at Jesse’s
complete conversion tool, where You will find Your answers. It would
also be nice to see Your migration script…

Regards,
Harald

Harald Wagener * FCB/Wilkens * An der Alster 42 * 20099 Hamburg

Well, it is rt2-to-rt3 tool, indeed. I think it could be mentioned in
README of 3.0 version.

Anyway, it is a problem with running it. rt2-to-dump went ok, but
dump-to-rt3 did not (I’m usuer, that ‘use lib’ is set ok):

siaco:/usr/src/rt2-to-rt3# ./dumpfile-to-rt-3.0 dump
Importing users
…[Thu Apr 17 09:49:35 2003] [error]: Could not create a new user - (/opt/rt3/lib/RT/User_Overlay.pm:274)
.NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
NOTICE: current transaction is aborted, queries ignored until end of transaction block
[Thu Apr 17 09:49:35 2003] [crit]: RT::User::crit Unimplemented in RT::User. (/opt/rt3/lib/RT/User_Overlay.pm line 263) (/opt/rt3/lib/RT.pm:228)

Do you have any ideas how can I debug it?

Richard.

** Internet Designers S.A., ul. Przedmiejska 6-10, 54-201 Wrocław **
tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/

How fast is Your version? Maybe You should have a look at Jesse’s
complete conversion tool, where You will find Your answers. It would
also be nice to see Your migration script…

Well, I didn’t make a conversion script, I’ve just dumped users,
tickets, transactions, modified them a little bit, then imported to new
base, set sequences, updated id’s, owners etc, so my time spent on this
was pretty long.

I won’t write a new conversion script, if the rt2-to-rt3 will not work -
I will leave my database as is, i.e. without requestors on old tickets.
I have a lot of work with polish translation…

Richard.

** Internet Designers S.A., ul. Przedmiejska 6-10, 54-201 Wrocław **
tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/