PHP Pear - Re: [PEAR] PEAR::Translation2 bug with MySQL when adding new language.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [PEAR] PEAR::Translation2 bug with MySQL when adding new language.

Lorenzo Alberton

2006-02-22, 6:58 pm

Hi AJ,

> When I add a new language using the PEAR::DB container I get this error
>
> CREATE UNIQUE INDEX translation_en_iso_8859_15_translation_i
d_index ON
> translation_en_iso_8859_15 (translation_id) [nativecode=1170 **
> BLOB/TEXT column 'translation_id' used in key specification without a
> key length]
>
> I'm using MySQL 4.1.13 on SuSE linux. According to MySQL's manual when
> creating a unique index on a column with the type 'TEXT' you need to
> specify a length. So the query for MySQL should be

many thanks for the report. I've updated the files in CVS;
now I'm going through a few more tweaks, then I'll roll out
a new release, hopefully today. Stay tuned...

Cheers,
--
Lorenzo Alberton
http://pear.php.net/user/quipo

Sponsored Links