Error 1054

[alain1]

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

[Milbo]

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?

[stawebnice]

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

[Milbo]

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