Support

Site Restoration

#27714 Error in restoring table xx_ak_storage

Posted in ‘Site restoration’
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
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Sunday, 11 June 2017 17:17 CDT

Wednesday, 10 May 2017 03:43 CDT

activha
 Hello

We have a DB restoration error with table xx_ak_storage checking a web site reinstall

Is this table still used in latest akeeba versions ? It seems to be related to old backup points

Thanks
Jean

Wednesday, 10 May 2017 07:54 CDT

tampe125
Hello,

yes, the #__ak_storage is used by Akeeba Backup component.
What's the error you are receiving?

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 10 May 2017 08:29 CDT

activha
This is a standard mysql syntax error which says the query is not correct.

Wednesday, 10 May 2017 08:36 CDT

tampe125
Can you please post it?
By the way, what's the hosting you're restoring to? OVH?

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 10 May 2017 08:45 CDT

activha
That was a syntax mysql error on the attached statement

Yes we restore to OVH Public cloud with Centos 7 MariaDB and Nginx instance.

Wednesday, 10 May 2017 09:01 CDT

tampe125
It seems you are using database storage for temporary data.
During a backup, we store temporary information in this table and, depending on the size of the backup, it could be very large.
OVH doesn't play nice with large queries: sometime it will result in "Couldn't connect to MySQL" errors or say that the primary key is already used (??).
Anyway, you can skip restoring such table contents, your site will run just fine.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Thursday, 11 May 2017 11:56 CDT

activha
Ok thanks

We got into another problem while trying to restore files
Though ftp is correctly set up and lots of files and folders extract correctly, we ran into an error :

Could not upload components/com_crmery/documents/5bdefb2ddf8a1bbf5b65a4296fe1bfee.pdf

And fail to get it right.
Could it be a problem with nginx or php-fpm stopping pdf writing ? this file is not too big (7,3 MB) Could it be a delay needed ?

I am out of ideas
Thanks
Jean

Thursday, 11 May 2017 14:08 CDT

activha
Sorry that was an awful disk size on the instance :-(

All is ok
Thanks

Friday, 12 May 2017 02:13 CDT

tampe125
Are you using the Transfr Wizard to move your site file by file?
Sometimes the remote host will stop FTP connections, since they are limited or there is any inbound rule.
Site Wizard usually work flawless out of the box, if you get any issue our suggestion is to fallback to the previous method (backup + transfer + restore), since it will save you a lot of time.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 12 May 2017 08:30 CDT

activha
Yes we switched back to backup transfer restore which is much faster ! :-)

Thanks
Jean

Friday, 12 May 2017 09:33 CDT

tampe125
You're welcome!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 12 May 2017 09:36 CDT

activha
I am back and think have found a glitch with nginx maker

When a keyword is added to the administrator url for server protection, nginx maker does not add it and forbid access to backend

I guess :

# Allow access to the back-end index.php file
location = /administrator/index.php{
	fastcgi_pass   127.0.0.1:9000;
	break;
}
location ~* ^/administrator$ {
	return 301 /administrator/index.php;
}
location ~* ^/administrator/$ {
	return 301 /administrator/index.php;
}


would maybe better :
# Allow access to the back-end index.php file
location = /administrator/index.php?mysecretkeyword {
	fastcgi_pass   127.0.0.1:9000;
	break;
}
location ~* ^/administrator$ {
	return 301 /administrator/index.php;
}
location ~* ^/administrator/$ {
	return 301 /administrator/index.php;
}


Can you let me know ?

Also, is it possible to add specific rules to nginx maker from within the backend such as your htaccess maker ?

Thanks
Jean

Friday, 12 May 2017 09:53 CDT

tampe125
Regarding such rules, I'll have to ask Nicholas, since he's more experienced than me on nginx.

Regarding the maker, we already have one: https://www.akeebabackup.com/documentation/admin-tools/nginx-maker.html

It is enabled when you're using NginX as your webserver (not reverse proxy).
If it's not enabled, 99% of times it means that you have a reverse proxy with NginX

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Friday, 12 May 2017 09:57 CDT

activha
Yes we are using it but you have a problem when a Administrator secret URL parameter is set in the WAF protection.

This would block access to the back end so you have to change the nginx maker accordingly

Friday, 12 May 2017 10:02 CDT

tampe125
Ok, thank you, I'll report that to Nicholas.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Sunday, 11 June 2017 17:17 CDT

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.

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!