Hi Guys, Can anyone please assist me with a new issue I have on this site. I have the products module set to display newest items. They display fine, but clicking on the product title produces an error:
On further inspection: its all the new products added to the site, older products are fine.
1054 - Unknown column 'created_by' in 'field list' SQL=SELECT product_name, created_by FROM #__virtuemart_products_en_gb WHERE virtuemart_product_id =41161
VirtueMart 3.0.7.4
Joomla 3.6.2
Template from Template Monster
Test copy
http://testing.scrapbookstudio.co.za/test
Please , anyone, all new products added to the site have this issue, its not the module. Its xmas shopping time and my clients site is not working.
Error happens when trying to view product details page : 1054 - Unknown column 'created_by' in 'field list' SQL=SELECT product_name, created_by FROM #__virtuemart_products_en_gb WHERE virtuemart_product_id =41161
http://shop.scrapbookstudio.co.za
Before doing anything else, update your Joomla!!!
You must update to Joomla 3.6.5!! https://www.joomla.org/announcements/release-news/5693-joomla-3-6-5-released.html
Critical security issues were identified and fixed with J3.6.4 and now 3.6.5 apparently adds further fixes.
See
http://www.theregister.co.uk/2016/11/02/hurried_crims_target_30000_sites_to_pop_unpatched_joomla/
https://developer.joomla.org/security-centre/661-20161003-core-account-modifications.html
http://thehackernews.com/2016/10/joomla-security-update.html
Check if you have new Joomla users with administrator permissions - if so hackers have paid you a visit!
Similarly all VirtueMart 3 versions before 3.0.12 are insecure. http://forum.virtuemart.net/index.php?topic=118683.0
You should test all updates on a backup copy of your site, as almost certainly you will need to edit the TM template overrides.
Then you should start looking at fixing your table issue, if still present.
and the updating of VM could well solve the missing table field
Thanks Guys, the culprit was Jcomments! and something to do with languages