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

UnixMan senior.unix at gmail.com
Tue Mar 20 16:42:36 EDT 2012


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.




More information about the rt-users mailing list