Author Topic: Version 1.2.14 database issue  (Read 3429 times)

Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Version 1.2.14 database issue
« on: May 07, 2019, 08:07:31 AM »
Hi

I have version 1.2.14 installed and upgraded from 1.2.13 and previous versions and decided to do a fresh installation of 1.2.14 on a testing site so that in future upgrades i will test the upgrade before upgrading the live site and here what i found as an issue but don't if it is something important.

In the live site, the upgraded version, in the database table "custom_lists" the available fields are
(`rowid`, `custom_block_id`, `data_type`, `id`, `store_id`, `sort_order`, `date_added`, `date_modified`)

while in the 1.2.14 version fresh installation the available fields are
(`rowid`, `custom_block_id`, `data_type`, `id`, `sort_order`, `date_added`, `date_modified`)

note the [store_id] column is not available!!

Possibly that this is an issue or bug that affects the cart??

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Version 1.2.14 database issue
« Reply #1 on: May 07, 2019, 09:34:22 AM »
1.2.14 upgrade script does contain alter to this table

Code: [Select]
ALTER TABLE `ac_custom_lists`
ADD COLUMN `store_id` INT NULL DEFAULT 0 AFTER `id`;

Did you get any error during upgrade?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Re: Version 1.2.14 database issue
« Reply #2 on: May 07, 2019, 12:09:48 PM »
The upgrade version of 1.2.14 does contain the column [store_id] but the fresh installation of 1.2.14 does not. teh question is which is correct?? to have the column [store_id]  or without??

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Version 1.2.14 database issue
« Reply #3 on: May 07, 2019, 07:40:59 PM »
Are you sure? I can see this column in 1.2.14 right now:
https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database.sql#L10256

Where do you see it missing?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Re: Version 1.2.14 database issue
« Reply #4 on: May 07, 2019, 11:33:28 PM »
When i did the installation this column was missing possibly an error in the installation process   

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Version 1.2.14 database issue
« Reply #5 on: May 08, 2019, 01:45:41 AM »
while in the 1.2.14 version fresh installation the available fields are
(`rowid`, `custom_block_id`, `data_type`, `id`, `sort_order`, `date_added`, `date_modified`)

Hi. I am just install 1.2.14 from the source https://github.com/abantecart/abantecart-src/archive/1.2.14.zip and store_id column present in database so where did you get you installation files or what way you use to install AbanteCart (cPanel installer, bitnami or any other)?

Offline hani

  • Full Member
  • ***
  • Posts: 119
  • Karma: +14/-1
    • View Profile
Re: Version 1.2.14 database issue
« Reply #6 on: May 08, 2019, 05:51:38 AM »
I had it downloaded when it was released in the beginning and installed it but never mind i just wanted to bring your attention to this issue.


Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Version 1.2.14 database issue
« Reply #7 on: May 08, 2019, 07:34:50 AM »
Installation process would not have this issue, if install SQL is correct.
Very strange.
Keep us posted if you encounter this again.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

 

Powered by SMFPacks Social Login Mod