Support

Admin Tools

#27052 An error has occured, admintools_log crashed

Posted in ‘Admin Tools 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
Admin Tools version
n/a

Latest post by vault257 on Monday, 06 February 2017 05:20 CST

Sunday, 05 February 2017 22:10 CST

vault257
 Hi
The following error message appears when I attempt to open admintools
"An error has occurred.
0 Table './gsv10274_04/#__admintools_log' is marked as crashed and last (automatic?) repair failed SQL=SHOW FULL COLUMNS FROM `#__admintools_log` (View template: /home/gsv10274/public_html/administrator/components/com_admintools/View/ControlPanel/tmpl/stats.php) (View template: /home/gsv10274/public_html/administrator/components/com_admintools/View/ControlPanel/tmpl/stats.php)
Return to Control Panel"

Akeeba backup fails
The two tables j16_admintools_customperms and j16_admintools_logs are marked as crashed when viewed with phpmyadmin
The problem started after we had an hard disk full "event".....
Help please
cheers
Peter

Monday, 06 February 2017 00:28 CST

nicholas
Repairing a crashed table requires root privileges on the database server and probably root access to the filesystem. For obvious security reasons your host won't give you such permissions. Therefore you need to contact your host and have them fix those tables.

Since the tables are crashed you cannot even delete them. If you could delete them you could simply revisit Admin Tools' control panel page afterwards to have Admin Tools create the missing tables afresh. So, if your host cannot fix the tables they can delete them.

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, 06 February 2017 05:20 CST

vault257
Thank you Nicholas.
The host successfully repaired the table. However when I attempted a backup it failed.
Ill raise a ticket under akeeba backup!
cheers
peter

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!