<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Currently running RT Version 3.4.1 and the MySQL 5.0 database (rt3) has
been imported into the new 3.6.1 install.<br>
Install of 3.6.1 on a new debian-etch box using: apt-get install
request-tracker3.6 and apt-get install rt3.6-apache2<br>
<br>
Apache is up and running and can login with credentials that work with
3.4.1.<br>
I am aware that the upgrade scripts should solve this error but they
are not and my patience is shot.<br>
Using a new MySQL database called "rtdb" works fine so I know the
problem is with the upgrade.<br>
<br>
I am running the following upgrade scripts.<br>
#/usr/sbin/rt-setup-database-3.6 --action schema --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password
"password";<br>
<i><b><small>Creating database schema.<br>
Couldn't find schema file for mysql</small><br>
</b></i><br>
/#usr/sbin/rt-setup-database-3.6 --action acl --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password
"password";<br>
<small><i><b>Couldn't find ACLS for mysql in
/etc/request-tracker3.6/upgrade/3.5.1/</b></i></small><br>
<br>
/#usr/sbin/rt-setup-database-3.6 --action insert --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password
"password";<br>
<small><i><b>Creating predefined searches...(Error: Internal Error:
Couldn't execute the query 'INSERT INTO Attributes (ContentType,
Creator, ObjectId, LastUpdatedBy, Created, Content, Description,
LastUpdated, Name, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
?)'Duplicate entry '0' for key 1)<br>
(Error: Internal Error: Couldn't execute the query 'INSERT INTO
Attributes (ContentType, Creator, ObjectId, LastUpdatedBy, Created,
Content, Name, Description, LastUpdated, ObjectType) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?)'Duplicate entry '0' for key 1)<br>
(Error: Internal Error: Couldn't execute the query 'INSERT INTO
Attributes (ContentType, Creator, ObjectId, LastUpdatedBy, Created,
Content, Name, Description, LastUpdated, ObjectType) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?)'Duplicate entry '0' for key 1)<br>
done.<br>
Done setting up database content.</b></i></small><br>
<br>
<br>
<font color="#ff0000"><small><i><b>error: Can't call method "Content"
on an undefined value at
/usr/share/request-tracker3.6/html/Elements/MyRT line 75.<br>
<br>
context: ... <br>
71: <br>
72: unless (exists $session{'my_rt_portlets'}) { <br>
73: my ($d_portlets) =
RT::System->new($session{'CurrentUser'})->Attributes->Named('HomepageSettings');
<br>
74: my $user = $session{'CurrentUser'}->UserObj; <br>
75: $session{'my_rt_portlets'} =
$user->Preferences('HomepageSettings', $d_portlets->Content); <br>
76: } <br>
77: <br>
78: my $portlets = $session{'my_rt_portlets'}; <br>
79: <br>
... <br>
<br>
code stack: /usr/share/request-tracker3.6/html/Elements/MyRT:75<br>
/usr/share/request-tracker3.6/html/index.html:79<br>
/usr/share/request-tracker3.6/html/autohandler:279</b></i></small></font><br>
<br>
<br>
What am I missing? I would appreciate any assistance in
troubleshooting this issue.<br>
<br>
Thanks.<br>
CBrew<br>
</body>
</html>