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

[Ruslan Zakirov]

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



-- 
Best regards, Ruslan.