I have a system that we upgraded from RT 3.6.7 to 3.8.8 back in Aug.
I did a fresh install of RT. Then restored the database. Then
one-by-one added back in any customizations, plugins, etc.
We where using Asset Tracker on our 3.6.7 install (so the data was
restored when the DB was restored). I have installed
rt-extension-assettracker-2.0.0b2-0-g2b51b9a.tar.gz
We can see, search, and even edit assets without any problem. The
(only?) problem comes when I try to create new assets. When I try to
create new assess, error shows in web browser:
Can't call method "HasRight" on an undefined value
at /usr/share/request-tracker3.8/lib/RT/User_Overlay.pm line 1357.
When I did the install of AT, I was able to do the first 3 steps no
problem:
$ RTHOME=/path/to/rt perl Makefile.PL
$ make
$ make install
When I would run 'make initdb' I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation "at_types" already exists
at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. ...returned
with error: 65280 make: *** [initdb] Error 255
I have attached a segment of my syslog output. What is shown is Right
after hitting the 'submit' button when trying to create an asset.
Any help fixing this so we can create new assets again would be greatly
appreciated.
--
http://www.wikiak.org
#############################################################
Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company. - George Washington, Rules of Civility
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: relation
"at_scrips" does not exist LINE 1: SELECT DISTINCT main.* FROM AT_Scrips main
JOIN ScripConditi... ^ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ORDER BY main.Description ASC ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditio...') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 236
^IDBIx::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/request-tracker3.8/lib/RT/SearchBuilder.pm line 378
^IRT::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/local/share/request-tracker
3.8/plugins/RTx-AssetTracker/lib/RTx/Asse
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT COUNT(DISTINCT main.id) FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
522 ^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT COUNT(DISTINCT main.id) FROM AT_Scrips main JOIN Scrip...') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 292
^IDBIx::SearchBuilder::_DoCount('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/request-tracker3.8/lib/RT/SearchBuilder.pm line 389
^IRT::SearchBuilder::_DoCount('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 1392 ^IDBIx::
SearchBuilder::Count('RTx::AssetTracker::
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ORDER BY main.Description ASC ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditio...') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 236
^IDBIx::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/request-tracker3.8/lib/RT/SearchBuilder.pm line 378
^IRT::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/perl5/DBIx/SearchBuil
der.pm line 504 ^IDBIx::SearchBuilder::Ne
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT * FROM Principals WHERE id = ?' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT * FROM Principals WHERE id = ?', 1) called at
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1207
^IDBIx::SearchBuilder::Record::_LoadFromSQL('RT::Principal=HASH(0xbbe90570)',
'SELECT * FROM Principals WHERE id = ?', 1) called at
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1126
^IDBIx::SearchBuilder::Record::LoadByCols('RT::Principal=HASH(0xbbe90570)',
'id', 1) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line
119
^IDBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::Principal=HASH(0xbbe90570)',
'id', 1) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 368
^IRT::Record::LoadByCols('RT::Principal=HASH(0xbbe90570)', 'id', 1) called at
/usr/share/perl5/DBIx/SearchBuilde
r/Record.pm line 1141 ^IDBIx::SearchBuild
Dec 5 18:46:34 outrigger RT: No principal for user #1
(/usr/share/request-tracker3.8/lib/RT/User_Overlay.pm:1268)
Dec 5 18:46:34 outrigger RT: Transaction not committed. Usually indicates a
software fault.Data loss may have occurred
(/usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm:199) --------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
