hello when i try to install vm3 on j3.4.1 i have this error
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `hba_virtuemart_medias` ADD file_class char(64) NOT NULL DEFAULT '' AFTER `file_meta`
do you have some idea ?
regards
reduce the size of file_params manually to file_params varchar(17000)
you say in phpmyadmin ? or in file (how file)?
regards
for example with phpmyadmin, yes
sorry i try to search file_params in my db i didn't find can explain more ?
how looks your hba_virtuemart_medias?
file_params is varchar 19000
need to be reduce to 17000?
Quote from: Milbo on March 25, 2015, 15:46:18 PM
reduce the size of file_params manually to file_params varchar(17000)
yes it works 1000000 thanks
Worked like a charm for me.
Thank you so much.
Hi,
with I reduce the size but I have the same bug
TABLE `#__virtuemart_orders` ADD `customer_note` varchar(9000);
What can I do
Thanks !
lol which vm version? The customer note is NOT stored in the virtuemart_orders table in vm3, that was in vm2. Now it is handled as normal userfield.
Hi Milbo,
vmmigrator 4.2.1
Joomla 3.6.2
Virtuemart 3.0.18
Regards
Hi Milbo,
I uninstall Virtuemart and VMMigrator
I delete all the table #_virtuemart*
I reinstall virtuemart and Vmmigrator and the migration is OK
Thanks !