I also had such error:
Code: Select all
Notice: Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` ...
So i solved it by googling about "cannot be part of FULLTEXT index"
And here are my results:
http://stackoverflow.com/questions/1330 ... o-fulltext
so fields in product_description are in
utf8_bin
but the table has not the same collation (utf8_general_ci or some other _ci)
So what i did, i manually runned such query:
Code: Select all
ALTER TABLE <YOUR DB_PREFIX>product_description CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
And after that badass querry
Code: Select all
ALTER TABLE `<YOUR DB_PREFIX>product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id`
And it whent good. But it not so easy at must be, i must change the upgrade model class in install folder.
Ive done this changes in /install/module/update.php:
In line 169 before line of code
Code: Select all
if (isset($table['option']['CHARSET']) && isset($table['option']['COLLATE'])) {
i placed
Code: Select all
if($table['name'] == '<YOUR DB_PREFIX>product_description') {
$table['option']['COLLATE'] = 'utf8_bin'
}
And then i had second error!
But fixed the same way:
after previous change in line near 246 (original 242) after code of line
Code: Select all
if ($result['Key_name'] != 'PRIMARY') {
i placed
Code: Select all
if($result['Key_name'] == 'ft_namerel') continue;
And UPGRADE WAS DONE!
I used 1.5.5.1 upgrade onto 1.5.3.1 OpenCart version
P.S.: Sorry for my English...