Product Details / Flypage on 2.5 Template

Ok, so from looking at virtuemart_products_en_gb and then product_desc field, I noticed that the type has changed from text in VM 1.9.8 to varchar with an 18400 character limit in VM 2.0.10.

I edited the product_desc field type from varchar to text using phpMyAdmin and then copied the description again from the real site.

All working perfectly. Just need to figure out how to import all my products again.

Thanks
Vexon

Hi,

thanks for sharing that info with us.

Pleasure Ivan

Can you advise how I could adjust the upgrade process from VM 1.9.8 RC2-H to VM 2.0.10 so that the product_desc field in the virtuemart_products_gb_en table is given the "text" type and not varchar.

I am sure there is a way of adjusting the virtuemart upload files before installing via extensions.

I know that I need to upgrade to VM 1.9.8 M first then to VM 2.0.0 and then finally to VM 2.0.10, so I assume I will have to adjust the scripts in all the files in each of these packages, but not sure where these files are.

Your assistance will be appreciated.

Thanks
Vexon

Backup your database first!
I'am think you will have to shorten descriptions of your products because i dough vm team will ever return to "Text" type. "Varchar" is 3 times faster than "Text" in select..like XXX so they have fallen for that. The problem is that varchar max size for utf8 is 21844. If you save table copy, then update , then change type to Text, and then using SQL statements return original field values that would work but problem will be you will have to be causes with every update and possibly you will have to repeat whole process often (always backup).

If there is no particular reason why you need so long descriptions then best you just write your descriptions shorter.

Thanks Ivan

The descriptions are not really that long but the formatting is somewhat complex. As a result of this, there is a lot of html code and that seems to be the reason why there is too many characters in each product.

I will explore a few options and post if there is anything that works.

Regards
Vexon