Support is online

Cannot install CSVI 8.9.0 #78054

Open atrus opened this topic Wednesday, 01 November 2023 · 3 replies
Author

Good day!

Tried to install 8.9.0 over 8.8.0 but i get the attached error.

Regards,
Chris

  • csvi890-error.jpg

CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31

Support

Hello Chris,

That is rather unfortunate. What is happening as the error states that the Rules index already exists, which is odd because we delete the index before creating it again.

Can you try to go to the About page in RO CSVI and click on Verify database and let me know if that finishes successfully? I am wondering if the script is allowed to drop indexes on the table.

We may have to delete the index manually if the script cannot do it. You can run the following query via PhpMyAdmin for example if you use that to maintain the database:

ALTER TABLE `y9zak_csvi_templatefields_rules` DROP INDEX `Rules`;

after that you can install RO CSVI and see if that works.

Let me know how it goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hello Roland,

Many thanks for the guidance, managed to install 8.9.3 using the phpmyadmin solution.

Verify Database was indeed giving an error:

"An error occurred running the query ALTER TABLE y9zak_csvi_templatefields_rules ADD UNIQUE INDEX Unique (csvi_templatefield_id,csvi_rule_id);. This generates the error Duplicate key name 'Unique'"

Cheers,
Chris

CSVI 7.16.1, Virtuemart 3.8.2, Joomla 3.9.18, PHP 7.2.31

Support

Hello Chris,
So I guess your installation problems are solved. Do let us know so we can set this topic to solved.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.