Resolved Error upgrading to 7.5.1

Thank you Tharuna!!

Hello Tony,

Would I need to run the patch for future updates or will the issue be resolved in future updates?

No, you don't need to run the patch in future. The patch has been included in our next release.

Hi Tharuna

Just one last question. Would I need to run the patch for future updates or will the issue be resolved in future updates?

Thanks

Tony

Hi Tharuna

Thanks for all your help. Much appreciate

Regards

Tony

Hello Tony,
Yes since you are seeing this on checkout you need to check this error with VirtueMart.

Hi Tharuna

OK Thanks

Just cant understand where it comes from. Could it be the Virtuemart update perhaps?

Once again

Thank you for your help

Regards

Tony

Hello Tony,
This SQL error is not related to CSVI Update or CSVI component itself.

Hi Tharuna

Thank you so much for your efforts. I see 7.5.1 is on sqclothing but now I have a problem when customers try checkout.

I have to roll back the database to activate 7.4.1 so customer can order or my employer will be furious

Regards

Tony

Hello,
We have fixed this SQL error and have updated the fix with the patch file in the post here. Can you try to load the patch file and go to CSVI About page and click on Fix Database button? Check if it fixes your SQL errors.

Hello,

We have identified another issue that can occur on some systems like yours. Can you send me a private message with Joomla login details and (S)FTP access details? This way I can verify if our solution works. Thank you.

Good morning!

First, thank you so much for working so hard on this. We really appreciate it!
However, my install did not work either. here is the error message:
×
Warning
An error occured running the query ALTER TABLE `kfdsviucsvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. 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_csvi_7.6.0-beta_pro.zip
×
Error
Error installing package


When I tried (just in case) Fix Database on About page, this same error occurred.
×
Error
An error occured running the query ALTER TABLE `kfdsviucsvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. This generates the error Index column size too large. The maximum column size is 767 bytes.

Hi Tharuna

I have emailed you

Thanks

Tony

Hello,
Can you send a private message on access details of the site you see this error?

Hi Roland

I get the following error message

Warning
An error occured running the query ALTER TABLE `bsnda_csvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. 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_csvi_7.6.0-beta_pro.zip
Error
Error installing package

Found it thanks

Will let you know what happens

Thanks Roland

How do I access the message?

Hello,

I have sent you guys a private message with details. Please check and let me know.

Hi Roland

Once again. Thank You for going the extra mile......

Regards

Tony

Hello Tony,

I am going to prepare a full installation package for those of you who have update problems. I believe that should fix these issues, an email will be sent to you later today with instructions.

Hi Roland

I tried to update to 7.5.1 and got the error

Warning
COM_CSVI_FAILED_QUERY
Package Update: There was an error installing an extension: com_csvi_7.5.1_pro.zip
Error
Error installing package

I tried the patch then got

Error
An error occured running the query ALTER TABLE `asup8_csvi_sefurls` MODIFY `plainurl` VARCHAR(512) ;. This generates the error Index column size too large. The maximum column size is 767 bytes

when I tried to fix the database

I have had no problems with the extension until I tried to update to 7.5

The problem is now on all of my sites except the one that Tharuna and you worked on

Is there a way that I can get these sites sorted or should I wait for now?

Thanks

Tony