News:

Support the VirtueMart project and become a member

Main Menu

Sql error product création

Started by amlil71, January 07, 2016, 06:21:32 AM

Previous topic - Next topic

amlil71

Hello, since i have installed VM 3.0.12 on my Joomla website 3.4.8 i have this sql error on the frontend when i créate a new  product : "1054 - Unknown column 'created_by' in 'field list' SQL=SELECT product_name, created_by FROM j25_virtuemart_products_fr_fr WHERE virtuemart_product_id =554"
I don't understand this error since There is'nt "créated by" field on this table . This field is only présent in j25_virtuemart_product. I uninstalled and réinstalled VM 3.0.12 but the problem doesn't solve. Thank you for your Help.

GJC Web Design

You don't say if or what u have updated from? Is this a fresh install?
are there 3rd party ext. or plugins doing this call?

Indeed.. that column doesn't exist in the prod lang tables
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

amlil71

Hello, i have update VM from VM 3.0.11 . My website work sur with t3 plugin frame work. You can Check url hère : http://loisillon.fr/accessoires/mangeoires/mangeoire-inox-7-cm-avec-crochets.html . Thank you.

GJC Web Design

so this only started since the update?

you need to back trace where the query comes from as it is wrong
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

amlil71

Thank you. To be honest with you i don't Know when this problem bégin bécause 1 don't créat new product since 2 months. The problem could happen before between VM 3.0.10 and VM 3.0.12. How a plugin can interfer with virtuemart calls ? Thank's.

GJC Web Design

well  .. the query has to come from somewhere.. and it seems to me a totally wrong query like selecting a non existent table column wont come from the VM core

that leaves 3rd party extensions
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

amlil71

#6
indeed you say right. I try an another template and there isn't  problem. I Will contact the template support. Thank you.

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

amlil71

Hello,

i have a answer from template support. It's a conflict with jcomments component . The last version of jcomments create this problem. It's solve now. Than you:)