News:

Looking for documentation? Take a look on our wiki

Main Menu

Unknown column error for added table row

Started by Holger, October 07, 2015, 15:40:01 PM

Previous topic - Next topic

Holger

VM 2.0

Hi,

i added an additional row in table ...virtuemart_products for inserting additional infos for my products.
For backend i added a fieldset in product_edit_description.php so in backend the textarea is shown. But i get an error during saving:
vmError: Product store TableProducts: :store fehlgeschlagen!
Unknown column 'product_pricelist' in 'field list' SQL=UPDATE...

The frontend shows all correct, if i fill in the field via phpmyadmin.

Do i have to register this new table row in a special file, so i can user it? Or what could be the reason?

Thanks
Holger

________________


There was a second table _virtuemart_products_en and i added the row in the wrong table...

GJC Web Design

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