Hello.
I'm trying to update several servers from mysql 4.1.22 (mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3) to mysql 5.0 changing mysql-version=4.1
at /var/cpanel/cpanel.config and then running /scripts/mysqlup --force but I'm allways getting ERROR: 1136 Column count doesn't match value count at row 1 error.
I think this is because grant columns at tables inside db mysql are different from 4.X to 5.X. As far as I know, version 5 has more columns per row, at least at users table. Probably script is trying to inject mysql queries without specifiyng column names (like INSERT INTO users VALUES (val1, val2, ...)
which will result in count error.
Script result suggest log consult at "Examine the logs in /var/lib/mysql for more information" but I found nothing.
My questions are:
1. I'm the first one to get this problem? (I made several searchs on this forum without success)
2. Is my suggest right?
3. where the script mysqlup saves sql dump?
Thank you.
Regards.
I'm trying to update several servers from mysql 4.1.22 (mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3) to mysql 5.0 changing mysql-version=4.1
at /var/cpanel/cpanel.config and then running /scripts/mysqlup --force but I'm allways getting ERROR: 1136 Column count doesn't match value count at row 1 error.
I think this is because grant columns at tables inside db mysql are different from 4.X to 5.X. As far as I know, version 5 has more columns per row, at least at users table. Probably script is trying to inject mysql queries without specifiyng column names (like INSERT INTO users VALUES (val1, val2, ...)
Script result suggest log consult at "Examine the logs in /var/lib/mysql for more information" but I found nothing.
My questions are:
1. I'm the first one to get this problem? (I made several searchs on this forum without success)
2. Is my suggest right?
3. where the script mysqlup saves sql dump?
Thank you.
Regards.