Currently running RT Version 3.4.1 and the MySQL 5.0 database (rt3) has
been imported into the new 3.6.1 install.
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
Apache is up and running and can login with credentials that work with
3.4.1.
I am aware that the upgrade scripts should solve this error but they are
not and my patience is shot.
Using a new MySQL database called "rtdb" works fine so I know the
problem is with the upgrade.
I am running the following upgrade scripts.
#/usr/sbin/rt-setup-database-3.6 --action schema --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password "password";
/*Creating database schema.
Couldn't find schema file for mysql
*/
/#usr/sbin/rt-setup-database-3.6 --action acl --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password "password";
/*Couldn't find ACLS for mysql in /etc/request-tracker3.6/upgrade/3.5.1/*/
/#usr/sbin/rt-setup-database-3.6 --action insert --datadir
/etc/request-tracker3.6/upgrade/3.5.1/ --dba rt3 --dba-password "password";
/*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)
(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)
(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)
done.
Done setting up database content.*/
/*error: Can't call method "Content" on an undefined value at
/usr/share/request-tracker3.6/html/Elements/MyRT line 75.
context: ...
71:
72: unless (exists $session{'my_rt_portlets'}) {
73: my ($d_portlets) =
RT::System->new($session{'CurrentUser'})->Attributes->Named('HomepageSettings');
74: my $user = $session{'CurrentUser'}->UserObj;
75: $session{'my_rt_portlets'} = $user->Preferences('HomepageSettings',
$d_portlets->Content);
76: }
77:
78: my $portlets = $session{'my_rt_portlets'};
79:
...
code stack: /usr/share/request-tracker3.6/html/Elements/MyRT:75
/usr/share/request-tracker3.6/html/index.html:79
/usr/share/request-tracker3.6/html/autohandler:279*/
What am I missing? I would appreciate any assistance in troubleshooting
this issue.
Thanks.
CBrew
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch
today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
