Support

Akeeba Backup for Joomla!

#26281 Warning - Column value of table #__admintools_storage contains...

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
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

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Wednesday, 09 November 2016 17:20 CST

rikbrown
Just recently, I've been receiving the following type of warning when I manually start a backup:

Warnings
Column value of table #__admintools_storage contains 8015324 bytes of data. This may cause restoration issues.

I've looked at the subject table and find that the key column 'fixperms_stack' row shows a 'value' in the amount of 8 million+ bytes in length. I assume that is related to the fact that we have around 600k pages on our site (a review site).

However, I had not seen this error message until we recently upgraded from php 5.x to php 7.x. I'm not sure this is related to that php change but I can't think of any other system change recently.

BTW, all of my automatic, daily backups seem to be working fine. I had to do a restoration yesterday (due to a problem when some new software we tried to install) and the restoration went fine, as far as I can tell.

Is there something I should be doing to rectify this situation and/or deal with the warning?

Thanks. -- Rik

nicholas
Akeeba Staff
Manager
This means that you have set up custom permissions for each and every single file and folder on your site (through the Permissions Configuration page of Admin Tools). You are not supposed to do that! You should set the Default permissions at the top of that page. All other files and folders should have the permissions selection set to "---" (this means "use the default values"). You should only specify different permissions for files and folders which need permissions different than the default ones.

Unfortunately you have to go to the Permissions Configuration page of Admin Tools and make all those changes manually. There is no quick way to reset these options.

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!

rikbrown
Thank you for your reply.

I made the suggested manual permission changes to "---" within Admin Tools. However, even with another successful backup, I got the exact same warning message down to the same wording showing "8015324 bytes of data". However, when I extract the value from the 'fixperms_stack' row that value is now less than 500 characters in length.

So is the 8015324 bytes of data number, perhaps, being stored elsewhere (perhaps in a file on disk)?

Anything else to look at?

Thank you. -- Rik

nicholas
Akeeba Staff
Manager
What is the total length of the value text in that record?

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!

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!