VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: amlil71 on January 07, 2016, 06:21:32 AM

Title: Sql error product création
Post by: amlil71 on January 07, 2016, 06:21:32 AM
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.
Title: Re: Sql error product création
Post by: GJC Web Design on January 07, 2016, 10:35:27 AM
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
Title: Re: Sql error product création
Post by: amlil71 on January 07, 2016, 11:48:32 AM
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.
Title: Re: Sql error product création
Post by: GJC Web Design on January 07, 2016, 13:37:54 PM
so this only started since the update?

you need to back trace where the query comes from as it is wrong
Title: Re: Sql error product création
Post by: amlil71 on January 07, 2016, 13:48:13 PM
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.
Title: Re: Sql error product création
Post by: GJC Web Design on January 07, 2016, 13:58:34 PM
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
Title: Re: Sql error product création
Post by: amlil71 on January 07, 2016, 14:07:17 PM
indeed you say right. I try an another template and there isn't  problem. I Will contact the template support. Thank you.
Title: Re: Sql error product création
Post by: GJC Web Design on January 07, 2016, 15:28:14 PM
see...   ;)
Title: Re: Sql error product création
Post by: amlil71 on January 08, 2016, 09:35:18 AM
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:)