News:

Looking for documentation? Take a look on our wiki

Main Menu

Error message uploading product image

Started by MooseMoney, March 20, 2013, 00:32:07 AM

Previous topic - Next topic

MooseMoney

Website is in development on my PC | Joomla 2.5.9 | Virtuemart 2.0.20b | PHP 5.3.1

I created a product and then tried to upload the product image (product101.jpg).
I then get the following error message;

vmError: store medias TableMedias: :store failed
Unknown column 'file_lang' in 'field list' SQL=INSERT INTO `zWxlk_virtuemart_medias` (`virtuemart_media_id`,`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`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','product101.jpg','','','image/jpeg','product','images/stories/virtuemart/product/product101.jpg','','1','0','0','0','0','','','2013-03-19 23:26:18','473','2013-03-19 23:26:18','473')


The image file is indeed in the "images/stories/virtuemart/product" directory but it does not show up in the "Product/Product Images" admin panel!?
Please help!!


<a href="http://sportscarsimage.com/2008-chevrolet-hhr-ss/">2008 chevrolet hhr ss</a> <a href="http://sportscarsimage.com/2012-chevrolet-camaro-convertible-eu-version/">2012 chevrolet camaro convertible eu version</a>

MooseMoney

Help will be appreciated!  :)

Quote
File C:\wamp\www\NewWEBSITE\images\stories\virtuemart\product\ProductImage12.jpg uploaded

vmError: store medias TableMedias: :store failed
Unknown column 'file_lang' in 'field list' SQL=INSERT INTO `zWxlk_virtuemart_medias` (`virtuemart_media_id`,`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`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','drslickcombo4g.jpg','','','image/jpeg','product','images/stories/virtuemart/product/drslickcombo4g.jpg','','1','0','0','0','0','','','2013-03-26 05:27:17','473','2013-03-26 05:27:17','473')


.
<a href="http://sportscarsimage.com/2008-chevrolet-hhr-ss/">2008 chevrolet hhr ss</a> <a href="http://sportscarsimage.com/2012-chevrolet-camaro-convertible-eu-version/">2012 chevrolet camaro convertible eu version</a>

JulesVerne

I also have this problem; after upgrading to the latest version of VirtueMart it won't let me add new images for products and it will throw that same error.

Could anyone give us some feedback?

Thanks

wiringproducts

I am also experiencing the same problem. There isn't a field in the virtuemart_medias table called 'file_lang'.

jenkinhill

Try Tools / Install or if necessary update tables  - test on a backup copy.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

rangkuk

Quote from: jenkinhill on April 07, 2013, 16:25:34 PM
Try Tools / Install or if necessary update tables  - test on a backup copy.

i have still problem :(

avnkhanh


GJC Web Design

hmm .. why do u say that?

the most recent stable is http://dev.virtuemart.net/attachments/download/1000/com_virtuemart.3.0.16_extract_first.zip

3.0.17.6 is on final testing and should be released soon as 3.0.18
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Jörgen

#8
Hello

I know why he sais that, if You go to download section You still get this:
http://dev.virtuemart.net/attachments/download/995/com_virtuemart.3.0.14_extract_first.zip

No offense, but I don´t see why a user should browse the whole VM website to see what is the latest official release.

Shouldn´t the official download link should be the official download link .... Updating this link would stop a lot of unnecessary posts from being sent. Just my two cents.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

GJC Web Design

QuoteNo offense, but I don´t see why a user should browse the whole VM website to see what is the latest official release.

Shouldn´t the official download link should be the official download link .... Updating this link would stop a lot of unnecessary posts from being sent. Just my two cents.

None ever taken...  :)

and agree...  as 3.0.16 is the latest stable .. unless there is a good reason.. shouldn't it be the download?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation