Products Module - Product link not working

[chill_e_g]

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

[chill_e_g]

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

[jenkinhill]

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.

[GJC Web Design]

and the updating of VM could well solve the missing table field

[chill_e_g]

Thanks Guys, the culprit was Jcomments! and something to do with languages