[rt-users] RT 3.8.8 to RT 4.0.5 DB Upgrade Warning

UnixMan senior.unix at gmail.com
Tue Mar 20 16:45:40 EDT 2012


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.




More information about the rt-users mailing list