virtuemart update with altered tables (product_desc)

If you are runnig Joomla 3.x and Virtuemart 3.x please post to this forum your questions or support tickets about One Page Checkout

virtuemart update with altered tables (product_desc)

Postby admin » Mon Jun 08, 2015 1:47 pm

hello friends, if you altered your product_desc and product_s_desc to text type or larger mysql type so you can enter more information about product, you may want to try to update virtuemart with these options:

1. there are some hidden options which may help you, but they did not work for us on vm3.0.10:
http://forum.virtuemart.net/index.php?topic=128956.0

we tried to:
dblayoutstrict=0

but for some reason the installer still failed.


2. so we copied the VM3 installer to /tmp after that we also uploaded our unzip.php file from here:
http://www.rupostel.com/unzip/unzip.php
and modified the extracted installer of VM3


\tmp\26382 (or other random number generated from unzip.php)\administrator\components\com_virtuemart\helpers\tableupdater.php

from this:
Code: Select all
if($table=='products'){
               $fields['product_s_desc'] = 'varchar('.VmConfig::get('dbpsdescsize',2000).') '.$linedefault;
               $fields['product_desc'] = 'varchar('.VmConfig::get('dbpdescsize',18400).') '.$linedefault;

               $key = array_search('product_desc', $translatableFields);
               unset($translatableFields[$key]);

               $key = array_search('product_s_desc', $translatableFields);
               unset($translatableFields[$key]);




with this:



Code: Select all
if((false) && ($table=='products')){
               $fields['product_s_desc'] = 'varchar('.VmConfig::get('dbpsdescsize',2000).') '.$linedefault;
               $fields['product_desc'] = 'varchar('.VmConfig::get('dbpdescsize',18400).') '.$linedefault;

               $key = array_search('product_desc', $translatableFields);
               unset($translatableFields[$key]);

               $key = array_search('product_s_desc', $translatableFields);
               unset($translatableFields[$key]);




only the condition (if) section got changed to if (false) so whole section is skipped.

the installer gave a few notices, but was able to proceed without loosing any data at
#__virtuemart_products_sk_sk.product_desc and product_s_desc

i hope this helps.

best regards, stan
admin
Site Admin
 
Posts: 2708
Joined: Wed Jan 06, 2010 11:43 pm

Return to One Page Checkout for Virtuemart 3 on Joomla 3.x