[rt-users] Upgrade RT and AT and now can not create assets

[Ruslan Zakirov]

On Thu, Jan 12, 2012 at 01:09, Kevin Squire <gentgeen at wikiak.org> wrote:
> On Thu, 8 Dec 2011 02:14:30 +0400
> Ruslan Zakirov <ruz at bestpractical.com> wrote:
>
>> On Tue, Dec 6, 2011 at 5:04 PM, Kevin Squire <gentgeen at wikiak.org>
>> wrote:
>> > 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
>>
>> You don't run `make initdb` when you upgrade. You should read
>> documentation to perform proper upgrade. It's possible that your DB
>> inconsistent right now.
>>
>>
>
> I have tried reading documentation... searching list... etc... I just
> can't seem to find how I can correct this problem.
>
> It will be acceptable for our install for me to 'loose' all of the
> Asset Tracker stuff.... but I can not just dump the DB and start over -
> We need to keep the ticket side of things.
>
> Any way I can do a complete 'uninstall' of Asset Tracker, and start
> over?

No automation for that. You should go over etc/initialdata file in the
extension and delete tables and records it creates during
installation.   Strongly recommend to do it in a test environment
before performing it on production.

> --
> 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
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston  March 5 & 6, 2012



-- 
Best regards, Ruslan.