Print Page - Upgrade error from 1.2.6 to 1.2.7

Title: Upgrade error from 1.2.6 to 1.2.7
Post by: jaysbar 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 /home/MYSITE/public_html/core/database/amysqli.php on line 106

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

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

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

Thanks

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: abolabo 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?

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: jaysbar on May 16, 2016, 03:52:47 PM

Hi

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

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: abolabo on May 16, 2016, 04:25:13 PM

please post data from this table

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: jaysbar 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

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: jaysbar on June 05, 2016, 02:31:03 PM

Can someone please helo with my uograde error?

Title: Re: Upgrade error from 1.2.6 to 1.2.7
Post by: abolabo on June 05, 2016, 02:59:07 PM

please post CONTENT of your table abc_datasets

AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: jaysbar on May 16, 2016, 03:01:53 PM