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
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.