« previous next »
Pages: 1 [2] 3

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

Offline abolabo

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

Offline cookie

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

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #17 on: January 27, 2014, 11:06:14 AM »
mine has a prefix of _ab, which is placed there automatically in the Database config file.
Logged

gordontaylor

  • Guest
Re: SQL Error when trying to upgrade
« Reply #18 on: January 27, 2014, 11:08:26 AM »
uploaded the upgrade manually, same error, can't create SQL dump during backup.
Logged

Offline cookie

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

gordontaylor

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

Offline cookie

  • Jr. Member
  • **
  • Posts: 65
  • Karma: +10/-0
    • View Profile
Re: SQL Error when trying to upgrade
« Reply #21 on: January 27, 2014, 11:19:04 AM »
In the upgrade pack only! Don't touch your existing database and you are safe :)
Logged

gordontaylor

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

Offline cookie

  • Jr. Member
  • **
  • Posts: 65
  • Karma: +10/-0
    • View Profile
Re: SQL Error when trying to upgrade
« Reply #23 on: January 27, 2014, 11:23:53 AM »
\abantecart_1.1.8_upgrade_only\abantecart_1.1.8_upgrade_only\upgrade.sql
Logged

gordontaylor

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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error when trying to upgrade
« Reply #25 on: January 27, 2014, 11:58:40 AM »
replace file public_html/core/lib/backup.php
before upgrade by attached
Logged
“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 #26 on: January 27, 2014, 12:03:26 PM »
SUCCESS!!

Thanks for all your help!
Logged

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: SQL Error when trying to upgrade
« Reply #27 on: January 27, 2014, 12:36:25 PM »
Glad to see red success message, although standard is GREEN -> Success  and RED -> error/failed.  ;D
Logged
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: SQL Error when trying to upgrade
« Reply #28 on: January 27, 2014, 12:41:08 PM »
SUCCESS!!  :)
Logged
“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 #29 on: January 27, 2014, 01:01:53 PM »
Quote from: abolabo on January 27, 2014, 12:41:08 PM
SUCCESS!!  :)

I wanted everyone to see that it worked, hence the RED!
Logged
Pages: 1 [2] 3
« previous next »
 

Powered by SMFPacks Social Login Mod