[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