ahh - here it is again with the right case : mysql> select Name from Queues; +------------------------------------+ | Name | +------------------------------------+ | A General Request | | Approvals | | Audit-related | | backup issue | | Backup-related | | Data Center Issue | | Data Center Project | | Database Account | | Database Issue | | Database-clients | | Database-related | | DBA_Work_Tracking | | General_queue | | Infrastructure Service | | ldap-related | | nagios-related | | RT Configuration/Enhancement/Issue | +------------------------------------+
UnixMan wrote: > > 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-tp33541424p33541557.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
