I cannot update any content on my site. Amysqli.php error on line 109.

Started by pcshost, August 11, 2021, 12:35:14 PM

Previous topic - Next topic

pcshost

I haven't in years to begin with but I am using version 1.2.13  The error for any change or update of content is: amysqli.php on line 109.


There has been a critical error processing your request
SQL Error: Unknown column 'meta_description' in 'field list'
Error No: 1054
SQL: INSERT INTO abnt_content_descriptions (`title`, `description`, `meta_description`, `meta_keywords`, `content`, `content_id`, `language_id`) VALUES ('New to the Pizza Crisp Website?', 'New to the website? Open up or download this document to help you review the process! ', '', '', 'New to the Pizza Crisp Website? Open or<a href="Https://www.pizzacrisp.com/image/new-to-pizzacrisp.pdf" title="New to Pizza Crisp Website?"> Download this document</a> to help you review the ordering process.', '7', '1') in /home/site73/public_html/store/core/database/amysqli.php on line 109

pcshost

I can update the product itself in the site. Just not any of the page content.

SQL Error: Unknown column 'meta_keywords' in 'field list'
Error No: 1054

pcshost

Okay I found the fix on the boards. These columns in the ac_content_descriptions table needed to be added.

  `meta_keywords` varchar(255) NOT NULL DEFAULT '',
  `meta_description` varchar(255) NOT NULL DEFAULT '',

https://github.com/abantecart/abantecart_2.0/commit/89801cf222d9f9b536f8729d37614b27361914f3#

I added them to the database using PHP Admin by expanding the columns in the table, selecting NEW and adding.

Name: meta_description  Type: Varchar Length/Values: 255 Default: As Defined  Collation: utf8_general_ci   I left everything else blank. Click Save. Once successfully saved repeat using meta_keywords.



Basara

Hello.
It looks like the previous upgrade fails to add these columns to your database, maybe other tables missing.

Forum Rules Code of conduct
AbanteCart.com 2010 -