Author Topic: SQL Error when trying to upgrade  (Read 17215 times)

gordontaylor

  • Guest
SQL Error when trying to upgrade
« 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!
« Last Edit: January 27, 2014, 09:33:51 AM by gordontaylor »

Online llegrand

  • Hero Member
  • *****
  • Posts: 1352
  • Karma: +342/-2
    • View Profile
Re: SQL Error when trying to upgrade
« Reply #1 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

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #2 on: January 27, 2014, 09:43:23 AM »
My man!

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #3 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.
« Last Edit: January 27, 2014, 09:50:21 AM by gordontaylor »

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #4 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.

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #5 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?

Online llegrand

  • Hero Member
  • *****
  • Posts: 1352
  • Karma: +342/-2
    • View Profile
Re: SQL Error when trying to upgrade
« Reply #6 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

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #7 on: January 27, 2014, 10:23:25 AM »
Yep, growing pains!!!

Man do I love this cart!

Offline cookie

  • Jr. Member
  • **
  • Posts: 65
  • Karma: +10/-0
    • View Profile
Re: SQL Error when trying to upgrade
« Reply #8 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!

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #9 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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1744
  • Karma: +235/-10
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error when trying to upgrade
« Reply #10 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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #11 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.
« Last Edit: January 27, 2014, 10:50:27 AM by gordontaylor »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1744
  • Karma: +235/-10
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error when trying to upgrade
« Reply #12 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:)

“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #13 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

« Last Edit: January 27, 2014, 10:55:11 AM by gordontaylor »

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #14 on: January 27, 2014, 10:59:07 AM »
Checked my cPanel, DB checks OK, no protections on it.

 

Maternity Dress