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

Support AbanteCart eCommerce

Author Topic: (Solved)-Cannot Change or Add Content to Design -> Content Pages  (Read 3658 times)

Offline TheChief

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
(Solved)-Cannot Change or Add Content to Design -> Content Pages
« on: November 25, 2018, 03:41:58 PM »
Running AC 1.2.13, PHP version 7.2

I can create a new Content page.  Everything shows up and is working until I try to add content.
When I try to add keywords, I get:

2018-11-25 19:48:56 - database error: AbanteCart core v.1.2.13 SQL Error: Unknown column 'meta_keywords' in 'field list'
Error No: 1054
SQL: UPDATE ac_content_descriptions SET meta_keywords = 'About Us' WHERE content_id = '1' AND language_id = '1' in <b>/xxxx/xxxxxxxxx/tm.com/core/database/amysqli.php</b> on line <b>109</b>

If I try to change Content on existing pages, I get

SQL Error: Unknown column 'meta_keywords' in 'field list'
Error No: 1054
SQL: UPDATE ac_content_descriptions SET title = 'About Us', description = 'Our Tribe, The Brodites', meta_keywords = '', meta_description = '', content = 'We are family owned and operated. This will never change. <br /><span style="color: #000000;"><!--n--><!--n--></span><br /><span style="color: #000000;">Some interesting facts about us; </span><br /><br /><ol><li><span style="color: #000000;">We like each other, really. </span></li><li><span style="color: #000000;">We learn together.</span></li><li><span style="color: #000000;">We have a passion for health.</span></li><li><span style="color: #000000;">We enjoy creating.</span></li><li><span style="color: #000000;">We play together.</span></li><li><span style="color: #000000;">We talk in movie language, quoting lines from movies, like a lot.</span></li></ol><span style="color: #000000;">After years of learning and then un-learning, we then re-learned.  Health comes from within.  It is written that we have been given every herb bearing seed upon the earth and he that is wise shall not abhor them.  The fruit shall be for meat and the leaf for medicine.  TribalMama was birthed from harnessing the blessings already bestowed upon us.  <br /><br /></span><strong><span style="color: #000000;">Be Free, Live Clean, and Thrive!</span></strong><br /><span style="color: #000000;"><br /> </span><!--n--><!--n--><span style="color: #000000;"><img src="resources/image/18/72/1.jpg" /><br /><br /></span>' WHERE content_id = '1' AND language_id = '1' in /xxxx/xxxxxxx/tm.com/core/database/amysqli.php on line 109

If I try to edit the Meta Tag Description, I get:

2018-11-25 19:56:15 - database error: AbanteCart core v.1.2.13 SQL Error: Unknown column 'meta_description' in 'field list'
Error No: 1054
SQL: UPDATE ac_content_descriptions SET meta_description = 'Add description' WHERE content_id = '1' AND language_id = '1' in <b>/xxxx/xxxxxxxxx/tm.com/core/database/amysqli.php</b> on line <b>109</b>

I can create a new page if I do not try to add anything to the above fields.  I really don't care about the keywords or meta tag description but I do need to be able to create and edit the content.
I have tried:
newbielink:http://forum.abantecart.com/index.php/topic,6190.msg26471.html#msg26471 [nonactive]  ( did not seem to do anything)
newbielink:http://forum.abantecart.com/index.php/topic,5638.msg24291.html#msg24291 [nonactive]  ( If i understand, it was already there)
« Last Edit: January 01, 2019, 03:34:07 PM by TheChief »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
  • Karma: +274/-2
    • View Profile
Re: Cannot Change or Add Content to Design -> Content Pages
« Reply #1 on: November 25, 2018, 08:18:45 PM »
Hello.
Its looks like you have an upgraded store and database was not updated right.
You need to add columns manually similar to this

https://github.com/abantecart/abantecart_2.0/commit/89801cf222d9f9b536f8729d37614b27361914f3#diff-9a68eb2c547ed73ef6ab345a363d8614

Offline TheChief

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Cannot Change or Add Content to Design -> Content Pages
« Reply #2 on: November 26, 2018, 06:37:02 PM »
Thank you Basara for taking the time to answer.

However, data bases are new to me. 
So, I am confused.

" abantecart/install/mysql.database.sql" does not exist on the server nor did I see anything like it in the database.  I am guessing it is part of the files from the download to install.

I did find `ac_content_descriptions` in the database but do not understand how to add:
  `meta_keywords` varchar(255) NOT NULL DEFAULT '',
  `meta_description` varchar(255) NOT NULL DEFAULT '',
to the list nor see anything that looks like the rest of the file from your link

I have looked up how to add tables but, I am sorry, I just don't get it yet.
I am using cPanel.
The instructions on how to add tables are not yet making sense to me, do you have any suggestions?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5791
  • Karma: +274/-2
    • View Profile
Re: Cannot Change or Add Content to Design -> Content Pages
« Reply #3 on: November 27, 2018, 12:28:33 AM »
Ask your hosting support or find someone to help you add columns into database

Offline TheChief

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Cannot Change or Add Content to Design -> Content Pages
« Reply #4 on: January 01, 2019, 03:32:02 PM »
Thank you, finally figured it out! 
You were correct.

 

Powered by SMFPacks Social Login Mod