Post by yousifhalwachi » Mon Jul 08, 2013 8:12 pm

Hello All,

I have tried to update my opencart version to the latest from version 1.5.4.1. I followed all the instructions that were in the documentation included in the upgrade folder and I received the following error when I clicked 'Continue' when I was asked to upgrade.

Notice: Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `oc_lushishaproduct_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` in /home/lushisha/public_html/system/database/mysql.php on line 50

I have many extensions installed so I don't know if that could be one of the reasons.


Posts

Joined
Fri Jul 05, 2013 7:52 am

Post by Qphoria » Mon Jul 08, 2013 10:50 pm

So after uploading the 1.5.5.1 files, what did you do next?

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by yousifhalwachi » Tue Jul 09, 2013 12:40 am

Qphoria wrote:So after uploading the 1.5.5.1 files, what did you do next?
I went to mydomainname.com/install (obviously, instead of 'mydomainname' I actually placed my website's address) and clicked the 'Continue' button when asked to upgrade.

Then this error came up and as it says in the 'Read Me' file, I should report all errors on the forums


Posts

Joined
Fri Jul 05, 2013 7:52 am

Post by Qphoria » Tue Jul 09, 2013 1:53 am

Hmm what version were you running before this one?
That error seems to relate to the collation on the table not matching the other table collations.

http://stackoverflow.com/questions/6530 ... text-index

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by yousifhalwachi » Tue Jul 09, 2013 5:34 pm

Qphoria wrote:Hmm what version were you running before this one?
That error seems to relate to the collation on the table not matching the other table collations.
1.5.4.1.

How do I fix it?


Posts

Joined
Fri Jul 05, 2013 7:52 am

Post by thinks » Tue Jul 16, 2013 2:02 pm

Same error. Upgraded from 1.5.4 to 1.5.5.1, "Notice: Error: Column 'description' cannot be part of FULLTEXT index

Code: Select all

Error No: 1283
ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` in /home/xxx/public_html/system/database/mysql.php on line 50"
Have no idea where to proceed from here- someone please tell me how to correct this!

Newbie

Posts

Joined
Sat Jul 07, 2012 9:28 pm
Who is online

Users browsing this forum: No registered users and 10 guests