[debian-mysql] Bug#574995: mysql-server-5.1: Got syntax error when install package

Oliver Peng oliver.peng at skywave.com
Mon Mar 22 18:45:14 UTC 2010


Package: mysql-server-5.1
Version: 5.1.41-3
Severity: normal


Got following error message in mysql.err when I install mysql-server-5.1
package. 

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

ERROR: 1054  Unknown column 'Event_priv' in 'field list'


-- System Information:
Debian Release: testing/unstable
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.17
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages mysql-server-5.1 depends on:
ii  adduser                 3.87             Add and remove users and groups
ii  debconf [debconf-2.0]   1.5.1            Debian configuration management sy
ii  libc6                   2.7-6            GNU C Library: Shared libraries
ii  libdbi-perl             1.50-2           Perl5 database interface by Tim Bu
ii  libgcc1                 1:4.2.1-4        GCC support library
ii  libmysqlclient16        5.1.41-3         MySQL database client library
ii  libstdc++6              4.2.1-4          The GNU Standard C++ Library v3
ii  libwrap0                7.6.dbs-9        Wietse Venema's TCP wrappers libra
ii  lsb-base                3.1-5            Linux Standard Base 3.1 init scrip
ii  mysql-client-5.1        5.1.41-3         MySQL database client binaries
ii  mysql-common            5.1.41-3         MySQL database common files (e.g. 
ii  passwd                  1:4.0.15-7       change and administer password and
ii  perl                    5.8.8-4          Larry Wall's Practical Extraction 
ii  psmisc                  22.2-1           Utilities that use the proc filesy
ii  zlib1g                  1:1.2.3.3.dfsg-5 compression library - runtime

Versions of packages mysql-server-5.1 recommends:
pn  libhtml-template <none>                  (no description available)
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information:
  mysql-server-5.1/postrm_remove_databases: false
  mysql-server-5.1/really_downgrade: false
  mysql-server/error_setting_password:
  mysql-server-5.1/start_on_boot: true
  mysql-server-5.1/nis_warning:
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb:





More information about the pkg-mysql-maint mailing list