Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: SQL Error: Unknown column updated to 1.2.12 critical error  (Read 970 times)

Offline chrisoft

  • Newbie
  • *
  • Posts: 35
  • Karma: +5/-0
    • View Profile
SQL Error: Unknown column updated to 1.2.12 critical error
« on: December 27, 2017, 01:30:58 PM »
Hello, I updated from 1.2.11 to 1.2.12 when I try to modify content pages, it throughs a critical error.

2017-12-27 17:56:14 - database error: AbanteCart core v.1.2.12 SQL Error: Unknown column 'meta_keywords' in 'field list'
Error No: 1054
SQL: UPDATE ac_content_descriptions SET title = 'Return Policy', description = 'Waranty and Return', meta_keywords = '', meta_description = '', content = 'Client is able to return a product if it is faulty or not as described within 10 days of delivery.\r\n' WHERE content_id = '3' AND language_id = '1' in <b>/public_html/core/database/amysqli.php</b> on line <b>109</b>

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1745
  • Karma: +236/-10
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error: Unknown column updated to 1.2.12 critical error
« Reply #1 on: December 28, 2017, 04:06:03 AM »
Please run this sql-query in phpMyAdmin to solve

Code: [Select]
ALTER TABLE `ac_content_descriptions` ADD COLUMN `meta_keywords` varchar(255) NOT NULL COMMENT 'translatable',
ADD COLUMN `meta_description` varchar(255) NOT NULL COMMENT 'translatable';
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline chrisoft

  • Newbie
  • *
  • Posts: 35
  • Karma: +5/-0
    • View Profile
Re: SQL Error: Unknown column updated to 1.2.12 critical error
« Reply #2 on: December 28, 2017, 05:45:05 AM »
ok now its working. thank you
In more details what I have done to solve the issue if anyone needs it in more details.
Went to cpanel account
Open phpMyAdmin from databases
Clicked on name_ac1
clicked on query & console
Write the code query attached above
Press Ctrl+Enter to execute query

thats it.
Thank you

 

Maternity Dress