impossible to install vm3 row size too large

[berges]

hello when i try to install vm3 on j3.4.1 i have this error

Code Select Expand

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

[Milbo]

reduce the size of file_params manually to file_params varchar(17000)

[berges]

you say in phpmyadmin ? or in file (how file)?
regards

[Milbo]

for example with phpmyadmin, yes

[berges]

sorry i try to search file_params in my db i didn't find can explain more ?

[Milbo]

how looks your hba_virtuemart_medias?

[berges]

file_params is varchar 19000
need to be reduce to 17000?

[Milbo]

reduce the size of file_params manually to file_params varchar(17000)

[berges]

yes it works 1000000 thanks

[jamnagarsoftware]

Worked like a charm for me.

Thank you so much.

[glenanpl]

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 !

[Milbo]

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.

[glenanpl]

Hi Milbo,
vmmigrator 4.2.1
Joomla 3.6.2
Virtuemart 3.0.18
Regards

[glenanpl]

Hi Milbo,
I uninstall Virtuemart and VMMigrator
I delete all the table #_virtuemart*
I reinstall virtuemart and Vmmigrator and the migration is OK
Thanks !