Your message dated Thu, 09 Aug 2012 22:46:36 +0100 with message-id <[email protected]> and subject line done has caused the Debian Bug report #490094, regarding mysql-server-5.0: CREATE INDEX falsely reports "BLOB/TEXT column 'fn' used in key specification without a key length" 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.) -- 490094: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=490094 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Subject: mysql-server-5.0: CREATE INDEX falsely reports "BLOB/TEXT column 'fn' used in key specification without a key length" Package: mysql-server-5.0 Version: 5.0.45-1 Severity: normal *** Please type your report below this line *** CREATE INDEX with a key length is falsely reported to lack the key length, and to refer to a field other than the specified one. For example: dev1 94 # mysql reviews Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1387 Server version: 5.0.45-Debian_1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show create table people; +--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | people | CREATE TABLE `people` ( `id` int(11) NOT NULL auto_increment, `email` tinytext NOT NULL, `password` tinytext NOT NULL, `groups` enum('Admin','Copy Editor','Review Editor','Reviewer') default NULL, `fn` tinytext NOT NULL, `mi` tinytext NOT NULL, `ln` tinytext NOT NULL, `adr1` tinytext NOT NULL, `adr2` tinytext NOT NULL, `adr3` tinytext NOT NULL, `city` tinytext NOT NULL, `state` tinytext NOT NULL, `country` tinytext NOT NULL, `postcode` tinytext NOT NULL, `license` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20320 DEFAULT CHARSET=utf8 | +--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> CREATE INDEX `fnix` ON people (`fn`(255)); Query OK, 20319 rows affected (2.49 sec) Records: 20319 Duplicates: 0 Warnings: 0 mysql> CREATE INDEX `miix` ON people (`mi`(255)); ERROR 1170 (42000): BLOB/TEXT column 'fn' used in key specification without a key length mysql> CREATE INDEX `lnix` ON people (`ln`(255)); ERROR 1170 (42000): BLOB/TEXT column 'fn' used in key specification without a key length mysql> Bye -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.24.2 (SMP w/1 CPU core) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-server-5.0 depends on: ii adduser 3.105 add and remove users and groups ii debconf [debconf-2.0] 1.5.14 Debian configuration management sy ii libc6 2.7-6 GNU C Library: Shared libraries ii libdbi-perl 1.59-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.2.1-5 GCC support library ii libmysqlclient15off 5.0.45-1 MySQL database client library ii libncurses5 5.6+20080203-1 Shared libraries for terminal hand ii libreadline5 5.2-3 GNU readline and history libraries ii libstdc++6 4.2.1-5 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-14 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-24 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.45-1 MySQL database client binaries ii mysql-common 5.0.45-1 MySQL database common files ii passwd 1:4.0.18.1-11 change and administer password and ii perl 5.8.8-12 Larry Wall's Practical Extraction ii psmisc 22.5-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3.3.dfsg-6 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii bsd-mailx [mailx] 8.1.2-0.20071201cvs-2 A simple mail user agent ii mailx 1:20071201-2 Transitional package for mailx ren -- debconf information: mysql-server/root_password: (password omitted) mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true * mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false * mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes: * mysql-server-5.0/need_sarge_compat: true mysql-server/error_setting_password: mysql-server-5.0/need_sarge_compat_done: true
--- End Message ---
--- Begin Message ---This was never a bug as discussed in these google search results. http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/ http://stackoverflow.com/questions/9850218/getting-error-on-using-alter-change-in-mysql
--- End Message ---
