News:

Looking for documentation? Take a look on our wiki

Main Menu

Error 1054

Started by alain1, February 20, 2015, 15:38:53 PM

Previous topic - Next topic

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
Joomla 3.7 , Virtuemart 3.2.1 and PHP 7.0.7

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?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/