[rt-users] Upgrading to 3.8.0: schema.mysql, column_info selection problem
Ruslan Zakirov
ruz at bestpractical.com
Wed Jul 16 09:56:47 EDT 2008
In 3.8.0 it's one step :)
However, we've done changes to mysql DB that require additional
upgrade steps for mysql, and this step fails.
On Wed, Jul 16, 2008 at 5:24 PM, <jmoseley at corp.xanadoo.com> wrote:
> Did you follow these steps first?
>
> You may also need to update RT's database. To find out, type:
>
> ls etc/upgrade
>
> For each item in that directory whose name is greater than
> your previously installed RT version, run:
>
> /opt/rt3/sbin/rt-setup-database --action schema \
> --datadir etc/upgrade/<version>
> /opt/rt3/sbin/rt-setup-database --action acl \
> --datadir etc/upgrade/<version>
> /opt/rt3/sbin/rt-setup-database --action insert \
> --datadir etc/upgrade/<version>
>
>
> There are 10 3.7.xx directories that you'll need to go through.
>
>
> James Moseley
>
>
>
>
>
> "web master"
> <webmaster at acelle
> ra.com> To
> Sent by: rt-users at lists.bestpractical.com
> rt-users-bounces@ cc
> lists.bestpractic
> al.com Subject
> [rt-users] Upgrading to 3.8.0:
> schema.mysql, column_info
> 07/16/2008 05:00 selection problem
> AM
>
>
>
>
>
>
>
>
>
> Hi there
> I am having schema.mysql-4.0-4.1.pl problems upgrading to version
> 3.8.0 from 3.6.6.
> make upgrade worked well.
>
> As in point 4) of UPGRADING.mysql
>
> [X at Y]#perl etc/upgrade/schema.mysql-4.0-4.1.pl > sql.queries
>
> but
>
> usage: etc/upgrade/schema.mysql-4.0-4.1.pl db_name db_user db_password
>
> Ok, then I inserted the info needed
>
> [X at Y]#perl etc/upgrade/schema.mysql-4.0-4.1.pl DB USER PASS > sql.queries
>
> but
>
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
> DBD::mysql::db column_info failed: column_info doesn't support column
> selection at etc/upgrade/schema.mysql-4.0-4.1.pl line 227.
>
> RT 3.6.6 was installed a month ago on MySQL 5.0, maybe I do not need
> to run chema.mysql-4.0-4.1.pl, but UPGRADING.mysql (not present in
> 3.6.6 tarball), it seems to suggest so.
>
> Can anybody please help?
> Cheers
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list