Comment 4 for bug 484120
Revision history for this message
| Kristian Nielsen (knielsen) wrote Re: "ERROR: 1136 Column count doesn't match value count at row 1" when installing mariadb-server-5.1 | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
Cafuego, I tested this, and it seems to not work.
I get this when installing:
dpkg: error processing mariadb-server-5.1 (--configure):
subprocess post-installation script returned error exit status 1
And in /var/lib/daemon.err I get this:
Dec 8 21:06:15 vm-debian5-i386 mysqld_safe[2988]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
(I merged it into a recent ourdelta version to test in buildbot, the tree is here: lp:~knielsen/ourdelta/bug484120)
So not sure why I get this ...
And there is another problem. In the upgrade case, the ADD COLUMN statements will definitely fail, and with the set pipefail that will also cause the installation to fail. Thus these particular statements need protection with || /bin/true or similar. The set pipefail is still good for statements that should not fail.