08-23-2011, 06:58 PM
(08-04-2011, 10:07 PM)berberama Wrote: After much trying, I've narrowed down the offending MySQL entry to:
Code:CREATE TABLE `tblCategory` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Which throws this error:
Quote:#1170 - BLOB/TEXT column 'name' used in key specification without a key length
MySQL version is: 5.1.41
PHP version is: 5.2.13
Server API is: CGI/FastCGI
Apache version is: 2.2.15
OS versions is: centOS 5.6 i686
Please can someone help?Thanks!
I was directed to the following information by another PHP developer:
...
just remove the
UNIQUE('name')
Uwe