Author Topic: [SOLVED]: MySQL error when updating database structure  (Read 3872 times)

lysov

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 105
    • Litera ltd
[SOLVED]: MySQL error when updating database structure
« on: July 27, 2012, 10:47:04 am »
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
Code: [Select]
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

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 105
    • Litera ltd
Re: VM 208e: MySQL error when updating database structure
« Reply #1 on: August 08, 2012, 15:11:13 pm »
Solved in the svn version > 6320