[rt-users] upgrade mysql schema problem in rt4

[Kevin Falcone]

On Tue, Nov 08, 2011 at 05:34:35PM +0100, Francesc Guasch wrote:
> Al 08/11/11 17:26, En/na Kevin Falcone ha escrit:
> >On Tue, Nov 08, 2011 at 01:13:41PM +0100, Francesc Guasch wrote:
> >>Hi. I am trying to upgrade to rt4.
> >>
> >>rt4 is in debian squeeze, db is a mysql 5.1.49-3 (Debian).
> >>
> >>I'm stuck upgrading the database. I am trying to upgrade from
> >>an old mysql 4.0.24.
> >>
> >>perl etc/upgrade/upgrade-mysql-schema.pl
> >>
> >>Can't use an undefined value as an ARRAY reference at
> >>etc/upgrade/upgrade-mysql-schema.pl line 442.
> >>
> 
> >You should look to see if any of your information_schema is filled
> >
> Hi, thank you Kevin, there is something there:
> 
> mysql> select count(*) from acl;
> | count(*) |
> +----------+
> |      932 |
> 
> select count(*) from information_schema.columns;
> +----------+
> | count(*) |
> +----------+
> |     7756 |

Then look at the other parts of the where clause.  Is the database
name right?  Are the column names right?

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20111108/9107e94a/attachment.sig>