Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Upgrade error from 1.2.6 to 1.2.7  (Read 5367 times)

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Upgrade error from 1.2.6 to 1.2.7
« on: May 16, 2016, 03:01:53 PM »
Hi

I keep getting the following error when I try and upgrade from 1.2.6 to 1.2.7. Can someone help me please?

2016-05-16 18:38:40 - database error: AbanteCart core v.1.2.6 Error:
SELECT dataset_id
FROM abc_datasets
WHERE dataset_name = 'install_upgrade_history'
AND dataset_key='admin' LIMIT 1 in <b>/home/MYSITE/public_html/core/database/amysqli.php</b> on line <b>106</b>


In the amysqli.php, line 106 looks like this:

throw new AException(AC_ERR_MYSQL, 'Error: ' . $result->error . '<br />' . $sql);


Shall I try and change the DB driver to SQL instead of amysqli in config.php?

Thanks

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #1 on: May 16, 2016, 03:37:14 PM »
please try to run this query via phpMyAdmin
Code: [Select]
SELECT dataset_id
FROM abc_datasets
WHERE dataset_name = 'install_upgrade_history'
AND dataset_key='admin' LIMIT 1

is table abc_datasets presents in your database?
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #2 on: May 16, 2016, 03:52:47 PM »
Hi

I ran the query and can see the correct tables (see attachment).


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #3 on: May 16, 2016, 04:25:13 PM »
please post data from this table
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #4 on: May 18, 2016, 10:48:21 AM »
Hi

Is this the info you would like to see? I tried to attach a screenshot but your system says that my 200kb file if too large.


+ Options
 Full texts   
dataset_id
dataset_name
dataset_key

Edit Edit
 Copy Copy
 Delete Delete
1
menu
storefront

Edit Edit
 Copy Copy
 Delete Delete
2
menu
admin

Edit Edit
 Copy Copy
 Delete Delete
3
menu
storefront_description

Edit Edit
 Copy Copy
 Delete Delete
4
install_upgrade_history
admin

Edit Edit
 Copy Copy
 Delete Delete
5
file_uploads
admin

Edit Edit
 Copy Copy
 Delete Delete
6
slideshow
slideshow2
With selected: Check All With selected: Change Change Delete Delete Export Export

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #5 on: June 05, 2016, 02:31:03 PM »
Can someone please helo with my uograde error?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Upgrade error from 1.2.6 to 1.2.7
« Reply #6 on: June 05, 2016, 02:59:07 PM »
please post CONTENT of your table abc_datasets
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod