Author Topic: Upgrade crashed my site  (Read 4504 times)

Offline pcshost

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Upgrade crashed my site
« 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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5776
  • Karma: +274/-2
    • View Profile
Re: Upgrade crashed my site
« Reply #1 on: May 06, 2019, 01:56:20 AM »
Hello.
Looks like database was not upgraded.
Restore backup or upgrade database manually

Offline pcshost

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #2 on: May 06, 2019, 09:49:00 AM »
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.

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: Upgrade crashed my site
« Reply #3 on: May 06, 2019, 10:30:31 AM »
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.

Offline pcshost

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #4 on: May 06, 2019, 09:14:48 PM »
Thanks, I'll give that a try.

Offline johnriley

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #5 on: May 06, 2019, 09:55:58 PM »
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' ;


Offline pcshost

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #6 on: May 06, 2019, 10:51:15 PM »
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.


Offline pcshost

  • Newbie
  • *
  • Posts: 20
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #7 on: May 06, 2019, 10:54:31 PM »
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.

Offline llegrand

  • Hero Member
  • *****
  • Posts: 1798
  • Karma: +520/-7
    • View Profile
Re: Upgrade crashed my site
« Reply #8 on: May 06, 2019, 11:06:27 PM »
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)


Offline Stephanie Plummer Wilkins

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Upgrade crashed my site
« Reply #9 on: May 15, 2019, 03:43:38 PM »
I am getting the same error.  I need some help please.  What do I do?  :'(

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5776
  • Karma: +274/-2
    • View Profile
Re: Upgrade crashed my site
« Reply #10 on: May 16, 2019, 03:30:53 AM »
I am getting the same error.  I need some help please.  What do I do?  :'(
Hello. You need to add missing column in database

 

Powered by SMFPacks Social Login Mod