I’m still having no luck at all getting the AutoAssign scrip to work in RT
2.0.15. A fellow RT user has clued me in to a possible cause of this
problem; when he ran the insertdata script on his system, he ended up with
two choices of action in the scrip config page, AutoAssignToAnyWatcher and
AutoAssignToAnyCC. When I run the insertdata script that I got from
http://www.fsck.com/pub/rt/contrib/2.0/ I only get an AutoAssign action.
Further comparison of our insertdata scripts led to the realization that
his version is 504 lines. The one referenced above is 75… Our
AutoAssign.pm files match, however.
So I took the 500 line insertdata script from him, tweaked it to match my
setup, and ran it. Now at least it fails with some error data:
DBD::mysql::st execute failed: Duplicate entry ‘RT_System’ for key 2 at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 365.
RT::Handle=HASH(0x80fd46c) couldn’t execute the query 'INSERT INTO Users
(LastUpdated, Creator, Comments, Password, Name, RealName, LastUpdatedBy,
Privileged, Created) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)‘Duplicate entry
’RT_System’ for key 2
Creating system user…Could not create user
Does anyone know:
- How I can resolve these errors
- If the correct insertdata script was overwritten with an incorrect one
in the contrib area
- How I can get rid of the six AutoAssign actions that are now in my
setup, the result of various attempts to get this to work, which apparently
All input gratefully appreciated as usual,
Owen B. Mehegan
MIS Manager, Perseus Development Corp.
Landline: (781) 848-8100 x263
Mobile: (617) 285-1701
SurveySolutions for the Web: Winner of the PC Magazine Editors’ Choice