Without any reason, i've got this error message, when i'm trying to add an image to a product in the backend:
Error
1054 Unknown column 'file_class' in 'field list' SQL=INSERT INTO `jos_virtuemart_medias` (`virtuemart_media_id`,`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`published`,`file_is_downloadable`,`file_is_forSale`,`file_is_product_image`,`shared`,`file_params`,`file_lang`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','1','respir3.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/respir3.jpg','','1','0','0','0','0','','','2015-02-20 14:35:35','206','2015-02-20 14:35:35','206')
How to solve this ?
I'm running Virtuemart 3.0.6 on Joomla 3.3.6 and Php 5.4.27
Hmm please run the table updater again. Somehow your system is missing the file_class field in the media table.
What is the history of the system?
Informace pro vás
vmdebug $siteLang: cs-CZ self::$vmlangSef: self::$_jpConfig->lang cs_cz DefLang cs_cz
vmdebug vmTime: time to load config: 0.00709915161132812
vmdebug Start used Ram 4.25M
vmdebug Update of VM3
Database updated
vmdebug $siteLang: cs-CZ self::$vmlangSef: self::$_jpConfig->lang cs_cz DefLang cs_cz
vmdebug vmTime: time to load config: 0.00411009788513184
vmdebug Start used Ram 4.5M
vmdebug vmTime: VirtueMartControllerUpdatesmigration Finished task updatesmigration: 0.0235450267791748
vmdebug End used Ram 6M
vmdebug Peak memory peak 6M
--
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again
http://docs.virtuemart.net/manual/general-concepts/218-installation-updating.html
Answered in troubleshooting
compareUpdateTable alterKey not finished, please rise execution time and update tables again
alterColumns alterKey not finished, please rise execution time and update tables again