Package: mysql-server
Version: 5.0.51a-7
Severity: normal

The corrupt check that is run on startup does not handle hyphenated table 
names, it seems to chop off anything before the hypen, resulting in errors like 
this:

ERROR 1064 (42000) at line 1: 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 '-items' at line 1

Annoyingly the debian supplied jabberd2 package includes hypenated table names 
in its default mysql database schema.

It seems that this error can be fixed by inclosing the table names in quotes. I 
would have ago at fixing this if I could figure out how it works, but after 
looking I'm totally baffled.


-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.25.4 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server depends on:
pi  mysql-server-5.0              5.0.51a-6  MySQL database server binaries

mysql-server recommends no packages.

-- no debconf information



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to