AbanteCart Community
Shopping Cart Operations => Support => Topic started by: pcshost on May 05, 2019, 06:25:48 PM
-
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
-
Hello.
Looks like database was not upgraded.
Restore backup or upgrade database manually
-
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.
-
The issue on the 1.2.14 upgrade is the prefix on the database. You either need to manually change the prefix in the sql prior to running upgrade
Please backup and upgrade your database manually:
1. change the database prefix to yours in upgrade.sql
2. Run modified upgrade.sql in your phpMyAdmin or command line tool
https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually
or change the prefix on your database via phpMyAdin to ac_
If you change the database prefix you will need to change your config file to the same prefix.
-
Thanks, I'll give that a try.
-
I had a similar issue during the upgrade. Any thoughts on how I could fix below:
SQL Error: Unknown column 'title' in 'ab_store_descriptions'
Error No: 1054
SQL: ALTER TABLE `ab_store_descriptions` CHANGE COLUMN `description` `description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' , CHANGE COLUMN `title` `title` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' , CHANGE COLUMN `meta_description` `meta_description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' , CHANGE COLUMN `meta_keywords` `meta_keywords` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ;
-
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.
-
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.
-
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?
In our many years of using AbanteCart - ac_ was the only prefix that worked without issue. Then several versions ago they "fixed" the upgrades to retrieve the prefix and that went well until 1.2.14 which has been somewhat problematic in several areas.
I am guessing the next versions of upgrade with handle prefix check - but all 1.2.14 need adjustment.
The Support Team
from We Hear You 2, Inc. (WHY2)
-
I am getting the same error. I need some help please. What do I do? :'(
-
I am getting the same error. I need some help please. What do I do? :'(
Hello. You need to add missing column in database