version 1.2.1 cannot update to 1.2.2 corrupted upgrade file

[chrisoft]

I tried to auto-update my 1.2.1 version of abantecart to 1.2.2 with no success. Error: Error in data of page with controller: 'pages/product/product'. Please check for key_value present where key_param was set.

Now I want to manual-update to 1.2.2 but it seems that the version abantecart_1.2.2_upgrade_only.tar.gz is corrupted from both of your official sites. Can you send me a new copy please?

[abolabo]

i guess you have inconsistency of layout data.
You need fix it before upgrade process.
Can you post here content of your database table "pages"?
Probably you should delete one row from it....

[chrisoft]

i am a bit rookie on this one.
Where i can find this database table "pages"??

You mean this?
    Edit Edit    Copy Copy    Delete Delete    1    0    generic          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    2    0    pages/index/home          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    3    0    pages/checkout          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    4    0    pages/account/login          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    5    0    pages/product/product          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    10    0    pages/index/maintenance          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    11    0    pages/account          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    12    0    pages/product/product    product_id    335    2015-10-24 17:22:32    2015-10-24 17:22:32

[abolabo]

i am a bit rookie on this one.
Where i can find this database table "pages"??

You mean this?
    Edit Edit    Copy Copy    Delete Delete    1    0    generic          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    2    0    pages/index/home          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    3    0    pages/checkout          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    4    0    pages/account/login          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    5    0    pages/product/product          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    10    0    pages/index/maintenance          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    11    0    pages/account          2015-03-10 22:21:29    2015-03-10 22:21:29
   Edit Edit    Copy Copy    Delete Delete    12    0    pages/product/product    product_id    335    2015-10-24 17:22:32    2015-10-24 17:22:32

yes.. but a do not see any issues here.
is it all data from this table?

[chrisoft]

i will give us much information as i can

1) I have 339 products right now. on datapage i send you is says product_id 335. Is it normal?

2) I tried to upgrade now with no success again. this is the log error message:
2015-12-03 15:24:02 - database error: AbanteCart core v.1.2.1 Error:
SELECT dataset_id
FROM ac_datasets
WHERE dataset_name = 'install_upgrade_history'
AND dataset_key='admin' LIMIT 1 in <b>/home/chrisoft/public_html/core/database/amysqli.php</b> on line <b>105</b>

p.s
3)From day 1 i Install abantecart the version and the footer info it doesn't appear nor on the login screen footer nor in the admin page footer. normaly it should show at least the version i have install us I know.

[abolabo]

I have 339 products right now. on datapage i send you is says product_id 335. Is it normal?

you should check wors like you sent..
i mean

Code: [Select]

Edit Edit    Copy Copy    Delete Delete    12    0    pages/product/product    product_id    335    2015-10-24 17:22:32    2015-10-24 17:22:32this row is correct... you have "product_id" as param_key and 335 as param_value.
You need to find row where only "product_id" was set, but param_value column is emply and delete it.

or send me credentials via PM, i can look on it..

[webdevmerc]

Hi devs, I see this error pop up every so often here, but seeing it myself just now...Maybe someone in the know can help debug it further with additional info.

I am trying to upgrade from 1.2.4 to 1.2.5.  I get the error below when I do the file upload select upgrade:
Extensions -> Install Extension -> Extension Upload
I select my file: "abantecart_1.2.5_upgrade_only.tar.gz"

Click <CONTINUE>, it checks it, then says I am upgrading to 1.2.5...<CLICK AGREE>

Errors out with like a file not found error.

On error log:
2016-01-24 11:43:56 - warning: AbanteCart core v.1.2.4 Error while sending QUERY packet. PID=520142 in <b>/home/webdevmerc/tst/core/database/amysqli.php</b> on line <b>70</b>
2016-01-24 11:43:56 - database error: AbanteCart core v.1.2.4 Error:
SELECT dataset_id
FROM abc_datasets
WHERE dataset_name = 'install_upgrade_history'
AND dataset_key='admin' LIMIT 1 in <b>/home/webdevmerc/tst/core/database/amysqli.php</b> on line <b>105</b>


Now, however, if I do the exact same thing again (same steps), it will work and update now...

Cause?  Is there a timeout or something I can tweak?

[llegrand]

Hi WebDev - 

Check the prefix on your database -  it should be ac_

If you look at the sql update file,  the statements are for datasets ac_ 

I expect you know this,  but in case not,  you can use phpMyAdmin to easily change the prefix on your database

Let us know if this did the trick.

Lee

[webdevmerc]

Hi WebDev - 

Check the prefix on your database -  it should be ac_

If you look at the sql update file,  the statements are for datasets ac_ 

I expect you know this,  but in case not,  you can use phpMyAdmin to easily change the prefix on your database

Let us know if this did the trick.

Lee

Hi Lee,

My database prefixes are all abc_ actually.  I think this was the default when you do a manual install.

The upgrade.sql individual script does point to using ac_, but I think the script automatically factors in databases using abc_ as running the exact same thing twice seems to work.  I don't know why though.

Also, using the auto network update worked as did when I did the select upgrade_only file going from 1.2.3 -> 1.2.4...

Is there a reason why the docs show abc_
http://docs.abantecart.com/pages/tips/change_domain.html

I think we discussed this maybe a year back, trying to find that old post...

[llegrand]

Yes,  there are a lot of old posts regarding the database prefixes,   it was a big issue when we all moved from 1.1.9  forward

According to AbanteCart -  the default prefix has always been ac_ 
I have several posts about why the default always comes up with abc_ in the manual install, as well as in Softaculous it is usually abc or ab_  but so far the still keep showing up. There also remains nothing in the docs that suggest changing the default to ac_.
One of the inconsistencies that remains and does cause some issues.

Just do a search in the forum for "prefix" and you'll find lots of posts.

since I have changed all of my DB to the ac_ prefix and use that when I start a new install, I have not encountered issue with upgrades.  which has saved me tons of time and frustrations.