Author Topic: Error No: 1054 / Unknown column 'meta_keywords' in 'field list'  (Read 6102 times)

Offline shawnlg777

  • Newbie
  • *
  • Posts: 20
  • Karma: +3/-0
    • View Profile
    • Lite House Media
Error No: 1054 / Unknown column 'meta_keywords' in 'field list'
« on: January 12, 2018, 02:02:24 PM »
After I updated my site to the latest version... AbanteCart V1.2.12 I got a 1054 Database error when I try to add information in the content section or create a new content item. Please let me know how I can fix this.  Thanks!


core/database/amysqli.php on line 109


Offline shawnlg777

  • Newbie
  • *
  • Posts: 20
  • Karma: +3/-0
    • View Profile
    • Lite House Media
Re: Error No: 1054 / Unknown column 'meta_keywords' in 'field list'
« Reply #1 on: January 12, 2018, 09:00:02 PM »
I went ahead and added the fields meta_keywords, meta_description under content_descriptions table.  I am a newbie to this so please forgive the terminology if it is wrong.  I just thought this may help someone else.

Shawn

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5819
  • Karma: +274/-2
    • View Profile
Re: Error No: 1054 / Unknown column 'meta_keywords' in 'field list'
« Reply #2 on: January 15, 2018, 01:57:59 AM »
Hello.
Here is the solution http://forum.abantecart.com/index.php/topic,6190.msg26473.html#msg26473
Make sure to change ac_ to your database prefix.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5819
  • Karma: +274/-2
    • View Profile
Re: Error No: 1054 / Unknown column 'meta_keywords' in 'field list'
« Reply #3 on: January 15, 2018, 07:15:05 AM »
If you run upgrade manually maybe you missed upgrade.sql or forgot to change default database prefix to yours

 

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.