Your message dated Fri, 21 Jan 2011 10:13:40 +0100
with message-id <[email protected]>
and subject line Re: Bug#486684: mysql-server: corrupt check fails in
hyphenated table names.
has caused the Debian Bug report #486684,
regarding mysql-server: corrupt check fails in hyphenated table names.
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
486684: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=486684
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
On 21-1-2011 9:01, Jon Westgate wrote:
I'm pretty sure its fixed, though I'm running sid now
In that case I'll close the bug.
Olaf
--- End Message ---
