I do the below and it looks like the queues table exists though : mysql> show tables; +-------------------------+ | Tables_in_rt405 | +-------------------------+ | ACL | | AT_Assets | | AT_IPs | | AT_Ports | | AT_Types | | Articles | | Attachments | | Attributes | | CachedGroupMembers | | Classes | | CustomFieldValues | | CustomFields | | FM_Articles | | FM_Classes | | FM_ObjectTopics | | FM_Topics | | GroupMembers | | Groups | | Links | | ObjectClasses | | ObjectCustomFieldValues | | ObjectCustomFields | | ObjectTopics | | Principals | | Queues | | ScripActions | | ScripConditions | | Scrips | | Templates | | Tickets | | Topics | | Transactions | | Users | | sessions | +-------------------------+ 34 rows in set (0.01 sec)
UnixMan wrote: > > I get : > > mysql> select name from queues; > ERROR 1146 (42S02): Table 'rt405.queues' doesn't exist > > I ran this on the source system too and get the same thing for its rt388 > DB > > > > > Thomas Sibley wrote: >> >> On 03/20/2012 04:02 PM, senior.unix wrote: >>> I'm getting the below warning when I'm upgrading my RT 3.8.8 mySQL DB to >>> RT 4.0.5. >>> >>> I checked the source DB I used >>> mysql> SELECT * FROM `rt388`.`Tickets` where Type = 'approval'; >>> >>> and the upgraded DB using the below command >>> mysql> SELECT * FROM `rt405`.`Tickets` where Type = 'approval'; >> >> Tickets of a certain type have nothing to do with the warning about a >> _queue_. What does 'select Name from Queues;' return? >> >> Not having an ___Approvals queue will be... interesting. >> >> > > -- View this message in context: http://old.nabble.com/RT-3.8.8-to-RT-4.0.5-DB-Upgrade-Warning-tp33541424p33541546.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
