Product description field (product_Desc)

[inferenza]

A greeting to all
Field type of product description
The product description field (product_desc) is a varchar(19000).
Sometime this field it is not sufficient to include all article information as in an article.
This force you to create a link to an article.
I ask if it is possible to change the filed type from "varchar(19000) in mediumtext" to include all article information avoiding in this way to create a specific linked article ?
Sorry for my English, if the question it is not clear please tell me.
Regards

[jenkinhill]

You can use phpMyAdmin to change the field type in the database.

[inferenza]

Sorry,
my Joomla is the last version 1.7 the virtuemart is the last version 2.0

[Vexon]

Good day

Sorry for posting on an old topic, but I thought it may be useful for others searching for the same thing.

To update your product_desc field type, you need to log into phpMyAdmin, select the applicable database and then select virtuemart_products table. From there select edit and then change the type of the product_desc field from "varchar" to "text". Delete the limit of characters and leave this field blank.

Hope this helps.

I have a question though on how to change the field type in the upload/install files before install/update occurs. The reason for this is that i have several products that have more than the 18400 characters allowed in description in VM 2.0.10.

I need to know the all the files that need to be changed and also the script (if any) that needs to be adjusted for all the following:

VM 1.9.8M (not sure if the product_desc field was still text here)
VM 2.0.0 Stable
VM 2.0.10

The reason for all the above versions is that I need to update my current VM edition 1.9.8 RC2-H to the current version.

I have managed to update successfully to VM 2.0.10 however my product descriptions have been cut and this has resulted in broken html code and thus broken flypages.

Any help would be most appreciated

Regards
Vexon

[Vexon]

Hi All

Would love a reply to this topic.

I have also found that the product_desc field is changed back to varchar (18400) default every time I update the virtuemart configuration in the back end.

This is not ideal as it deletes a lot of product description (html) in the product and ends up breaking the flypage html.

If anyone can help in fixing this permanently or at least on every upgrade, that would be perfect.

Thanks
Vexon

[jenkinhill]

Maybe see http://forum.virtuemart.net/index.php?topic=98328