[SOLVED]: MySQL error when updating database structure

Started by lysov, July 27, 2012, 10:47:04 AM

Previous topic - Next topic

lysov

MySQL    5.5.25a utf8_general_ci
PHP    5.3.14
Joomla! 2.5.6
VM 208e
Wnen I try to update database structure (Developers tools) (url administrator/index.php?option=com_virtuemart&view=updatesmigration) I got an error
vmError: alterTable CHANGE nobugs_virtuemart_medias.file_params :
vmError: Tableupdater updating table nobugs_virtuemart_medias throws 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 `nobugs_virtuemart_medias` CHANGE COLUMN `file_params` `file_params` VARCHAR(21000)


I set maximum length of the `file_params` to 8840 by using phpMyAdmin (when value greater than this it says: #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535)

Best regards

lysov