SQL Error when trying to upgrade

[abolabo]

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"

[cookie]

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!

[gordontaylor]

mine has a prefix of _ab, which is placed there automatically in the Database config file.

[gordontaylor]

uploaded the upgrade manually, same error, can't create SQL dump during backup.

[cookie]

don't know what to say ... mine worked.
the only thing I had to watch is to replace their ac_ bit with mine ...

[gordontaylor]

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?

[cookie]

In the upgrade pack only! Don't touch your existing database and you are safe

[gordontaylor]

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.

[cookie]

\abantecart_1.1.8_upgrade_only\abantecart_1.1.8_upgrade_only\upgrade.sql

[gordontaylor]

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'.

[abolabo]

replace file public_html/core/lib/backup.php
before upgrade by attached

[gordontaylor]

SUCCESS!!

Thanks for all your help!

[abantecart]

Glad to see red success message, although standard is GREEN -> Success  and RED -> error/failed. 

[abolabo]

SUCCESS!! 

[gordontaylor]

SUCCESS!! 

I wanted everyone to see that it worked, hence the RED!