Author Topic: Error code 1054 - unknown column  (Read 5422 times)

trumples

  • Beginner
  • *
  • Posts: 3
Error code 1054 - unknown column
« on: September 27, 2016, 01:58:40 am »
I am trying to make some adjustments in the manufacturers module but when I go to save I get this message comes up. I've tied making changes to another listing in this module and the same error comes up.

1054 Unknown column 'metadesc' in 'field list' SQL=UPDATE `#__virtuemart_manufacturers_en_gb` SET `mf_name`='Pelican Products, Inc',`mf_email`='',`mf_desc`='',`mf_url`='www.pelican.com',`metadesc`='',`metakey`='',`customtitle`='',`slug`='pelican' WHERE `virtuemart_manufacturer_id`='11'

I am using Joomla 3.6.2, PHP 5.6.18 and Virtuemart 3.0.18

I updated to the latest AIO VM release a couple of days back but I'm not sure if my problems existed before that as the site has been stable since going live some months ago and I've not needed to make any changes.

Thoughts and guidance will be greatly appreciated.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10530
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Error code 1054 - unknown column
« Reply #1 on: September 29, 2016, 21:48:45 pm »
Just use the table updater again.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Mathalis

  • Beginner
  • *
  • Posts: 25
    • Mathalis Web Studio
  • Skype Name: mathaliswebstudio
Re: Error code 1054 - unknown column
« Reply #2 on: September 30, 2016, 19:21:24 pm »
Hello Max,
I encounter the same truble.

U mean "Update Joomla Database for pros, use only if you know what you do" ?
If yes i have this " Message : You are using joomla 3, or File not found"

Thanks for your help.
Regards


jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28456
  • Always on vacation
    • Jenkin Hill Internet
Re: Error code 1054 - unknown column
« Reply #3 on: September 30, 2016, 19:41:29 pm »
In VM backend. Tools / Tools & Migration on the DB Tools tab is "Install or if necessary update tables" button.

Note that "Enable database Update tools    " must be turned on in VM Configuration / Shop / Advanced Settings
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 4.0.12 10777  J 3.10.11 PHP 7.4.30

Mathalis

  • Beginner
  • *
  • Posts: 25
    • Mathalis Web Studio
  • Skype Name: mathaliswebstudio
Re: Error code 1054 - unknown column
« Reply #4 on: October 03, 2016, 17:54:09 pm »
Hello,
Thanks !

Hugues

chinoponpeto

  • Beginner
  • *
  • Posts: 2
  • A beginner
    • Thermometer
Re: Error code 1054 - unknown column
« Reply #5 on: December 20, 2016, 07:07:41 am »
thank you.