Support

Akeeba Solo

#24369 SQL Restoration Error

Posted in ‘Akeeba Solo (standalone)’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
Akeeba Solo version
n/a

Latest post by on Thursday, 10 March 2016 17:20 CST

Friday, 05 February 2016 07:26 CST

user79622
Hello there,

This ticket concerns a site restoration issue but i'm posting it here because when I select "site restoration" from the ticket submission drop-down option, it throws a 403 error.

Anyway, I'm trying to restore a backup from akeeba solo and it stops with the error SQL=UPDATE `options` SET `option_value` = 'http://localhost/entre' WHERE `option_name` = 'siteurl' on step 3 of 5.

Friday, 05 February 2016 08:01 CST

nicholas
I believe you forgot to enter a database table name prefix in the database restoration step.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 05 February 2016 08:16 CST

user79622
The database is a local wamp installation, it doesn't have a prefix.

Am i wrong? Attaching screenshot.

Friday, 05 February 2016 09:08 CST

nicholas
Something's wrong in these pictures. When backing up you need to set the site type to WordPress and the included restoration script to ANGIE for WordPress. Otherwise the backup will not give you all the restoration options you need to successfully restore your WordPress site on a different server.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 February 2016 01:10 CST

user79622
These are my backup settings.

I believe they are correct, no?

Monday, 08 February 2016 03:01 CST

nicholas
Oh, hold on, you've installed WordPress without a database prefix? That can be problematic :( During restoration click on "Show advanced options (for experts)" and set a table prefix one to five letters/numbers followed by an underscore, e.g. wp_

If this doesn't help please check your database setup. Did you give the database user full privileges to the database, including the privilege to run UPDATE? The error message indicates that something in a run of the mill UPDATE statement didn't work. You can try running that by hand (through phpMyAdmin) and tell me what the actual error message by MySQL is?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 08 February 2016 06:39 CST

user79622
It was not working, until I used the wordpress plugin to perform the backup (instead of akeeba solo).

Now I was able to restore the website without problems.

Monday, 08 February 2016 08:47 CST

user79622
Actually all links except the home page are broken...

I'm looking into it at the moment.

Monday, 08 February 2016 09:24 CST

nicholas
It doesn't make sense that one is working and the other isn't as they are both the same application (AB for WordPress is just a plugin wrapper around Solo).

As for the links, the SQL error you previously got indicates that the installer cannot update the internal links in WordPress. If you are restoring on the same server and same site try to delete the information in the textboxes of the Data Replace page to tell the installation script to avoid making any changes to those links.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tuesday, 09 February 2016 02:09 CST

user79622
Ah the problem was that I was missing the .htaccess file on my website.

The solution was to go to settings > permalinks and click on "save", thus a new htaccess file was created.

Tuesday, 09 February 2016 03:53 CST

nicholas
That does make sense :D

FWIW I was trying yesterday to reproduce your issue. However, WordPress does not let me install it without a database table prefix. I suspect you used something like Fantastico or a similar cPanel tool to install WordPress. In order to avoid any further issues I recommend that the next time you restore your site you use a database table prefix, available under "Show advanced options (for experts)".

Also note that if you use the integrated restoration (from Akeeba Backup for WordPress) you need to clear your cookies after the restoration. Apparently WordPress doesn't like having an old login cookie and you creating a new one when logging in again to the (restored) site. In this case it tells you you don't have the required privileges to access wp-admin. It happened to me yesterday while testing.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 10 March 2016 17:20 CST

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
Edited by on 2016-03-10 17:20 CST

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!