AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: TheChief on November 25, 2018, 03:41:58 PM

Title: (Solved)-Cannot Change or Add Content to Design -> Content Pages
Post by: TheChief 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 /xxxx/xxxxxxxxx/tm.com/core/database/amysqli.php on line 109

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.  Some interesting facts about us; <ol><li>We like each other, really. </li><li>We learn together.</li><li>We have a passion for health.</li><li>We enjoy creating.</li><li>We play together.</li><li>We talk in movie language, quoting lines from movies, like a lot.</li></ol>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. Be Free, Live Clean, and Thrive! <img src="resources/image/18/72/1.jpg" /> ' 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 /xxxx/xxxxxxxxx/tm.com/core/database/amysqli.php on line 109

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:
http://forum.abantecart.com/index.php/topic,6190.msg26471.html#msg26471 ( did not seem to do anything)
http://forum.abantecart.com/index.php/topic,5638.msg24291.html#msg24291 ( If i understand, it was already there)
Title: Re: Cannot Change or Add Content to Design -> Content Pages
Post by: Basara 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
Title: Re: Cannot Change or Add Content to Design -> Content Pages
Post by: TheChief 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?
Title: Re: Cannot Change or Add Content to Design -> Content Pages
Post by: Basara on November 27, 2018, 12:28:33 AM: Ask your hosting support or find someone to help you add columns into database
Title: Re: Cannot Change or Add Content to Design -> Content Pages
Post by: TheChief on January 01, 2019, 03:32:02 PM: Thank you, finally figured it out!
You were correct.