Messages

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.

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

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

Oh great thank llegrand and BDLG!

Ah okay. Let me check into it. Thanks.

Naw it's the first option. I just want them to have the ability to order a quantity of more than one if desired. There is no quantity option on the product option that I can find. Here's the example: https://pizzacrisp.com/store/  Scroll down and see the product. It just has an add to cart option rather than a quantity button and then an add to cart. You can only change the quantity in the view shopping cart window. ( I only have one product in the store )

Thx

Is there an option I am missing in AbanteCart Cart 1.213 to have a quantity option available for the Products? I can't find one.
Modify message

John read my side notes. I got the same error code running it as a PHP query because the column did not exist for that particular table.

Okay so that worked on the demo site. I will try it on the production this weekend. Does this mean that all my other updates via the admin console will now fail and I have to do this from now on? Or was this just a fluke occurrence? Side notes for others reading this: When you paste and cut the upgrade.sql code into phpmyadmin it fails if there is no table to upgrade because no data was ever entered so those lines need to be deleted and the query re-run.

Thanks, I'll give that a try.

I did restore a backup and tried to upgrade on 1.2.14 on a copied version of the store and same error. Looks like something preventing the database from upgrading. It did work on one other site I have. I'm just not sure of what the fix is or what needs to be done to upgrade. Hopefully someone has seen the error before.

Thx.

SQL Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SQL: SELECT * FROM `abnt_custom_lists` WHERE custom_block_id = '24' AND store_id = '0' ORDER BY sort_order in /home/site73/public_html/store/core/database/amysqli.php on line 109


Any help?

John

Okay here was the problem:

If you enter site with http: //pizzacrisp.com/store/ fonts will be accessible.
If you enter with http:// w.w.w.pizzacrisp.com/store/ it will not work.

I just need to create a redirect to enter the store as it was configured to be entered via an .htaccess redirect.

Interesting. You using PC / MAC / Smartphone? And what browser?

pizzacrisp.com/store

What you first go into the store it shows no icons for the main menu, product sales buttons or where the shipping, easy payment, blah-blah.

BUT, when you click on the home button all the icons show up. I compared code by viewing the source of the not working and the working page and it looks the same. Only guess is the javascripts might not be launching at first or it's because I have the store in a sub-folder. Any thoughts anyone?