AbanteCart Community

Shopping Cart Operations => Support => Topic started by: gordontaylor on January 27, 2014, 09:23:21 AM

Title: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 09:23:21 AM
During the upgrade process (within the Admin Panel)  it's asking for an Encryption key. I don't have one, so it gives me the following error.

2014-01-27 14:01:34 - Error: Can't create sql dump of database during backup

I tried setting one via the System>Settings>System menu, but to no avail.

I can do a manual back up from the control panel.

What to do!
Title: Re: SQL Error when trying to upgrade
Post by: llegrand on January 27, 2014, 09:39:32 AM
Gordon,  you must have missed this when you initially installed - the very last thing on an installation is this Message with a Key in it.  At least there was on mine.

You can find the key in /system/config.php then look for the line  define('SALT', 'xxxx');
that should do it for you.

Lee
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 09:43:23 AM
My man!
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 09:47:30 AM
No Joy, I put the 4 digit code in, says it's invalid. Still can't create SQL dump.
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 09:57:21 AM
As soon as I click Agree on the install, I get that error that it can't create an SQL dump, there is where it's asking for An installation Key

It's not asking for any of the Database Configuration information.
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 09:59:54 AM
Now getting this error

Error: Cannot download file. Repository error or invalid extension key. Try one more time. If problem persist download file in your order history and install manually.

Must be because I'm using the wrong key?
Title: Re: SQL Error when trying to upgrade
Post by: llegrand on January 27, 2014, 10:03:17 AM
Seems like there are changing something on the download at the moment.  There is no update available on my Admin panel right now,  and if I go to  Download link on the Documentation I get a notice that 1.1.i could not be found or is not available. 

So maybe just give it a few and watch the board.  I'll give you a shout back when I see the ability for upgrade return to my system.

The joys of change!?!?!
Lee
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 10:23:25 AM
Yep, growing pains!!!

Man do I love this cart!
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 10:29:07 AM
wow, you could do an update from within the admin?
I didn't find any such option so I just did the manual upgrade.
Maybe you try that too?

Good luck!
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 10:39:38 AM
@cookie, there was a message within my admin panel, but it's gone now. Must be something wrong with the installer, I think they're fixing it.
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 10:42:24 AM
You can to upgrade Abantecart with installation key mask "abantecart_upgrade_xxx" where xxx is next version of cart without dots.
For ex. : to upgrade Abantecart v1.1.7 up to 1.1.8 you need go to menu Extensions->install extension and paste key abantecart_upgrade_118
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 10:43:29 AM
Same issue....


Error: Can't create sql dump of database during backup.

Screen shot attached.

The info you gave is already pre-filled during the upgrade process. This error comes after you click all the agree buttons.
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 10:50:41 AM
regarding    Error: Can't create sql dump of database during backup

actually it's not an fatal error but some critical situation. We decided to to give critical status cause cart owner needs to know all about install and upgrade process to prevent this in the future.

In your case i guess you have some file permission restrictions.. If you did backup before upgrade it's not important for you:)

Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 10:53:17 AM
Yes, I did a manual back up first....however, that error won't let me proceed with the upgrade.

I haven't installed any protections on my database.

When I try to proceed, I get this error

Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 10:59:07 AM
Checked my cPanel, DB checks OK, no protections on it.
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 11:00:14 AM
Also you can try to download upgrade package http://sourceforge.net/projects/abantecart/files/abantecart_1.1.8_upgrade_only.tar.gz/download
and upload it via tab "extension upload"
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 11:04:43 AM
oh, by the way ...
It could be the database prefix

As I did the upgrade manually I have noticed that the tables in the sql upgrade file have an "ac_" before so in case you called your table prefix differently you need to change that.

I know I had to change that bit in the sql file so maybe the issue is connected to it?

@abolado Thanks for the tip! didn't know about that!
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 11:06:14 AM
mine has a prefix of _ab, which is placed there automatically in the Database config file.
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 11:08:26 AM
uploaded the upgrade manually, same error, can't create SQL dump during backup.
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 11:11:54 AM
don't know what to say ... mine worked.
the only thing I had to watch is to replace their ac_ bit with mine ...
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 11:15:09 AM
Where did you change that? If you change the DB config file, you can't access the data base. Did you change it in the upgrade package? Or did you create a new database with the ac_ prefix?
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 11:19:04 AM
In the upgrade pack only! Don't touch your existing database and you are safe :)
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 11:20:07 AM
Well, that needs to be fixed, not everyone will know how to do that.

I still can't get it to work. I can't even find it in the upgrade package.
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 11:23:53 AM
\abantecart_1.1.8_upgrade_only\abantecart_1.1.8_upgrade_only\upgrade.sql
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 11:32:11 AM
That is not a valid fix, not everyone can do that...something needs to change. I see it in the sql install, that is a lot of ac_ to change (easy to do), but then you need to re-zip and and re-upload that to the extension manager!

Not a good fix for everyone, I'm just sayin'.
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 11:58:40 AM
replace file public_html/core/lib/backup.php
before upgrade by attached
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 12:03:26 PM
SUCCESS!!

Thanks for all your help!
Title: Re: SQL Error when trying to upgrade
Post by: abantecart on January 27, 2014, 12:36:25 PM
Glad to see red success message, although standard is GREEN -> Success  and RED -> error/failed.  ;D
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 12:41:08 PM
SUCCESS!!  :)
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 01:01:53 PM
SUCCESS!!  :)

I wanted everyone to see that it worked, hence the RED!
Title: Re: SQL Error when trying to upgrade
Post by: llegrand on January 27, 2014, 02:03:43 PM
Is it required that everyone needs to update the backup.php  file PRIOR to updating? 

If so, can you change the info within the message block to indicate that somehow?

Thanks
Lee
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 27, 2014, 02:08:30 PM
Is it required that everyone needs to update the backup.php  file PRIOR to updating? 

If so, can you change the info within the message block to indicate that somehow?

Thanks
Lee
i don't know yet.. i contacted hosting provider support of gordontaylor with question about their php configuration and waiting for answer.
You can try to upgrade on your hostong provider server and let us know about result
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 02:09:58 PM
seems like user cookie had no issues....
Title: Re: SQL Error when trying to upgrade
Post by: cookie on January 27, 2014, 02:19:02 PM
had no issues with the manual upgrade
Title: Re: SQL Error when trying to upgrade
Post by: llegrand on January 27, 2014, 04:00:59 PM
Abolabo,
An answer for you:
"You can try to upgrade on your hostong provider server and let us know about result"


HaPPy to report -  I had no issue in running the upgrade by using the link on the message box.  Back up was flawless,  and the key was showing in the Network Install tab.  A couple of clicks and all was done.

Lee
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 27, 2014, 04:10:31 PM
Excellent Lee,

After I changed that backup.php file, it went smooth as glass!

Seems my hosting provider had something wrong with populating the backup.php when I did the original install.
Title: Re: SQL Error when trying to upgrade
Post by: mohit on January 29, 2014, 07:13:03 AM
success ......
thank you
Title: Re: SQL Error when trying to upgrade
Post by: abolabo on January 29, 2014, 07:29:12 AM
Excellent Lee,

After I changed that backup.php file, it went smooth as glass!

Seems my hosting provider had something wrong with populating the backup.php when I did the original install.

i guess you should to check directive of php.ini related function call "system" in your hosting provider CPanel. They wrote that you probably enabled it, but they are have this directive off by default. You can ask them about it. i think enabled 'system' not secure for your site..
P.S. http://www.cyberciti.biz/faq/linux-unix-apache-lighttpd-phpini-disable-functions/
Title: Re: SQL Error when trying to upgrade
Post by: gordontaylor on January 29, 2014, 09:07:00 AM
Thanks Dimitri, I didn't enable anything, but I'll check.
Title: Re: SQL Error when trying to upgrade
Post by: Eddie on March 06, 2014, 06:46:03 AM
Worked like charm thank you so much
Title: Re: SQL Error when trying to upgrade
Post by: Old Fossil on May 14, 2014, 09:23:19 PM
I didn't even realise the upgrade was available until I logged into my admin area.

Used the backup file as supplied and all is well.

 :)

Title: Re: SQL Error when trying to upgrade
Post by: abantecart on May 15, 2014, 11:00:32 AM
Long and old post. Closing