1. cyberspyder
  2. RO CSVI
  3. Wednesday, 03 November 2021
  4.  Subscribe via email
Can't update/install 8.0.0 rc1 on one site.
Get error:

An error occured running the query ALTER TABLE `kfdsviucsvi_icecat_index` ADD INDEX `product_mpn` (`prod_id`);. This generates the error Index column size too large. The maximum column size is 767 bytes.
Package Update: There was an error installing an extension: com_ro_csvi_8.0.0-rc+1.zip

This happens on update or install/overwrite. Latest Joomla 3.x version.

Updated/installed correctly on three other sites.
Accepted Answer Pending Moderation
Hello,

The error comes because in the table kfdsviucsvi_icecat_index the query is trying to build an index on the prod_id field, the index becomes larger than 767 bytes. The field size is 255 characters, each character takes 3 bytes. So if you have a prod_id that is 255 characters long, we multiply that by 4 you get a size of 1020 which triggers the error.

You can empty the table csvi_icecat_index and run the update.

Do you use ICEcat on this site? If so, you should be able to reload the indexes after the update. I am also going to check if there is indeed such long product IDs.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,

I would get back to you, so I loaded the ICEcat index, just over 2 million records and the longest prod_id I have is 63 characters. So I think there may be something wrong with your csvi_icecat_index table.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
We do not use ICEcat on this site. Our ICEcat tables are empty, and I even deleted them completely and tried installing the package. It did get the error, but at least we can access the component now. It wasn't loading at all and said it was missing files.

I did still see that error, but it could have been cached because the page says I am on RO CSVI 8.0.0-rc+1

I have set it to run a job and make sure everything is good. Thank you for your help!
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!