Re: [rt-users] QueueSummaryByLifecycle warning
On Thu, Feb 20, 2014 at 09:44:17AM +0100, Marko Cupać wrote: I re-run database upgrade, this time starting from 4.0.8, it went fine until 4.1.1 where it failed complaining thatTable 'ObjectScrips' already exists. As I know it was created in earlier upgrade I did not worry. If you actually reran *all* of the upgrade scripts (instead of telling make upgrade-database to run 4.0.8 - 4.0.19) then I suspect something else will be wrong down the road. -kevin pgp1g5zaG132v.pgp Description: PGP signature -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] QueueSummaryByLifecycle warning
I re-run database upgrade, this time starting from 4.0.8, it went fine until 4.1.1 where it failed complaining thatTable 'ObjectScrips' already exists. As I know it was created in earlier upgrade I did not worry. My Queues table looks as follows now: mysql select Name, Lifecycle from Queues; +---+---+ | Name | Lifecycle | +---+---+ | General | default | | ___Approvals | approvals | | AvalaAda Laboratorija | default | +---+---+ ... and there are no more warnings in log. Hope I did not spoil something else. -- Marko Cupać -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] QueueSummaryByLifecycle warning
On Fri, 14 Feb 2014 11:11:49 -0500 Alex Vandiver ale...@bestpractical.com wrote: This points to having skipped the 4.0.9 upgrade step. You should check your upgrade history in Admin → Tools → System Configuration. Sorry for late reply, I was offline for weekend. System configuration shows history starts from 4.0.19. Database was exported on another server where rt was at 4.0.19. After that, new server was installed with 4.2.2, database was imported, and then upgraded to current version. Anyway, how can this be fixed? Can I just re-run database upgrade from earlier version? If so, from which? I am afraid at this moment it can't be said with certainty what was the original rt version, and which database upgrades were skipped. -- Marko Cupać -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] QueueSummaryByLifecycle warning
On Thu, 13 Feb 2014 09:52:47 -0500 Kevin Falcone falc...@bestpractical.com wrote: This implies your database doesn't have correct Lifecycles on Queues. show: select Name, Lifecycle from Queues; mysql select Name, Lifecycle from Queues; +---+---+ | Name | Lifecycle | +---+---+ | General | NULL | | ___Approvals | approvals | | Quality Dept. | default | +---+---+ 3 rows in set (0.00 sec) Quality Dept. was just a test, actually for now we use only General Queue. -- Marko Cupać -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] QueueSummaryByLifecycle warning
On Fri, 2014-02-14 at 10:54 +0100, Marko Cupać wrote: mysql select Name, Lifecycle from Queues; +---+---+ | Name | Lifecycle | +---+---+ | General | NULL | | ___Approvals | approvals | | Quality Dept. | default | +---+---+ 3 rows in set (0.00 sec) This points to having skipped the 4.0.9 upgrade step. You should check your upgrade history in Admin → Tools → System Configuration. - Alex -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] QueueSummaryByLifecycle warning
On Thu, Feb 13, 2014 at 11:05:02AM +0100, Marko Cupać wrote: [10853] [Thu Feb 13 09:53:35 2014] [warning]: Use of uninitialized value in lc at /usr/local/share/rt42/html/Elements/QueueSummaryByLifecycle line 131. (/usr/local/share/rt42/html/Elements/QueueSummaryByLifecycle:131) [10853] [Thu Feb 13 09:53:35 2014] [warning]: Use of uninitialized value in lc at /usr/local/share/rt42/html/Elements/QueueSummaryByLifecycle line 66. I haven't encountered any problem in functionality. Should I be worried about this? This implies your database doesn't have correct Lifecycles on Queues. show: select Name, Lifecycle from Queues; -kevin pgpNgSKargc0e.pgp Description: PGP signature -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training