News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

impossible to install vm3 row size too large

Started by berges, March 25, 2015, 09:05:51 AM

Previous topic - Next topic

berges

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

Milbo

reduce the size of file_params manually to file_params varchar(17000)
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

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

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

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

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges

file_params is varchar 19000
need to be reduce to 17000?

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

berges


jamnagarsoftware


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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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 !