[rt-users] Table 'rt3.ObjectCustomFields' doesn't exist

[raymond at pilotsupplies.com]

Hi,

Thank you for the suggestion.

I'll give that a shot. This is a migration from an old box running 3.2.2 
to a  new server which is rt 3.8.4 fresh 
install.  Will I need to do "make upgrade" as 
indicated in the 3.8.4 README file?


I am exporting rt 3.2.2 db on old server and importing to the new server 
running rt 3.8.4


mysql -u root -p rt3 < oldrt3.2.2.db.sql



raymond





On Wed, 29 Jul 2009, Ruslan Zakirov wrote:

> Then you missed one step. You have to upgrade DB first from 3.2.2 to
> 3.7.89 first. It's `rt-setup-database --action update ...` command
> described in more details in UPGRADING.mysql and README files.
>
> On Tue, Jul 28, 2009 at 11:39 PM, <raymond at pilotsupplies.com> wrote:
>> Hi Ruslan,
>>
>>
>> My apologies.  I was upgrading from 3.2.2
>>
>>
>> raymond
>>
>>
>>
>> On Tue, 28 Jul 2009, Ruslan Zakirov wrote:
>>
>>> Why do you even need mysqlupgrade.sql if it's fresh install?
>>>
>>> On Tue, Jul 28, 2009 at 10:13 PM, <raymond at pilotsupplies.com> wrote:
>>>>
>>>> ubuntu vmware esx4i with ubuntu 9.04 4GB of memory dual xeon processor
>>>>
>>>> fresh 3.8.4 install, apache2, perl_Mode 2, mysql 5
>>>>
>>>> go error "Table 'rt3.ObjectCustomFields' doesn't exist"
>>>>
>>>> so I went and commented out the following, see below and proceed with the
>>>> install with no other issues.
>>>>
>>>> Am wondering if there are any implications, issues or problems with this
>>>> or is there a better way to fix this ?
>>>>
>>>>
>>>> thanx!
>>>>
>>>>
>>>>
>>>> /usr/local/src/rt-3.8.4/etc/upgrade# mysql -u root -p rt3 <
>>>> mysqlupgrade.sql
>>>> Enter password:
>>>> ERROR 1146 (42S02) at line 77: Table 'rt3.ObjectCustomFields' doesn't
>>>> exist
>>>>
>>>>
>>>> root at joeblow:/usr/local/src/rt-3.8.4/etc/upgrade# vi mysqlupgrade.sql
>>>>
>>>> #ALTER TABLE ObjectCustomFields
>>>> #   DEFAULT CHARACTER SET utf8;
>>>> #ALTER TABLE ObjectCustomFieldValues
>>>> #   DEFAULT CHARACTER SET utf8;
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Raymond Wong
>>>>
>>>>
>>>> Personal motto: P.E.A.C.E
>>>> Enjoy the present
>>>> Assert your goals
>>>> Champion peace
>>>> Entrust others
>>>> _______________________________________________
>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>
>>>> Community help: http://wiki.bestpractical.com
>>>> Commercial support: sales at bestpractical.com
>>>>
>>>>
>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>>>> Buy a copy at http://rtbook.bestpractical.com
>>>>
>>>
>>>
>>>
>>>
>>
>> --
>>
>>
>>
>> Regards,
>>
>> Raymond Wong
>>
>>
>> Personal motto: P.E.A.C.E
>> Enjoy the present
>> Assert your goals
>> Champion peace
>> Entrust others
>
>
>
>

-- 



Regards,

Raymond Wong


Personal motto: P.E.A.C.E
Enjoy the present
Assert your goals
Champion peace
Entrust others