"The maximum row size for the used table type, not counting BLOBs, is 65535"...

Started by kyovev, October 23, 2016, 20:30:04 PM

Previous topic - Next topic

kyovev

Hi. I've moved a database of VM 2.0.10 (export via phpmyadmin and rename of prefix + import into a new database) to a clean joomla installation of 3.6.2.

My idea is to migrate my website from VM 2 to 3.
After moving the database, I installed the latest VM 3.0.18. I've got a message after the installation:

Max messages reached
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 `#__virtuemart_medias` ADD `file_class` varchar(64) NOT NULL DEFAULT '' AFTER `file_meta`


Can you give me an sql query so I can fix this? The name of my database is:

sportdir_oct23

prefix:

jv465_

:)


If you can't assist me with query can you tell me which columns should I edit (type) so I can start working?

Regards,
Kiks

Milbo

Just use the update tables in the tools section.
https://docs.virtuemart.net/manual/tools-menu/70-tools-migration.html
"INSTALL TABLES OR IF NECESSARY UPDATE THEM"

Just execute it two times the message shoud be gone then.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/