Support

Akeeba Backup for Joomla!

#19402 AJAX Loading Error - Table doesn't exist

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 tampe125 on Thursday, 06 March 2014 07:35 CST

Wednesday, 05 March 2014 03:59 CST

user74268
Description of my issue:

Tried running backup but ran into this error...
Looks like this is refering to an extension I removed called JSN Power Admin.

AJAX Loading Error
HTTP Status: 500 (Internal Server Error)
Internal status: error
XHR ReadyState: 4

Error
An error has occurred.
1146 Table 'jml.jngfy_jsn_poweradmin_favourite' doesn't exist SQL=SHOW CREATE TABLE `jngfy_jsn_poweradmin_favourite`
Return to Control Panel

Wednesday, 05 March 2014 09:25 CST

tampe125
Hello Robert,

it seems that you have a corrupted table.
In this cases MySQL could not delete it because it's corrupted.
You can try to repair it logging in inside phpMyAdmin and do a check/repair on it.
If that's not working, you can try to exclude the table from the backup.

If even this is not working, you should contact your hosting and ask for support, since you can't do anything else.

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, 05 March 2014 13:18 CST

user74268
in phpMyAdmin when I expand the list on the left it's there and when I click on it I receive a message 
#1146 - Table
'jml.jngfy_jsn_poweradmin_favourite' does't exist


When I scan the right side of the list it's just not on the list.
I'm guessing that's what you mean, select the table and click repair on it, but it's not on the list to select.

Going to work, will try more later. Any other advice welcomed.

Thursday, 06 March 2014 02:10 CST

tampe125
mhm... sadly you're in the latest scenario: you have to contact your hosting and explain the problem.
Most likely this is what happened: the table got deleted, but MySQL still has a "reference" to it.
So it thinks the table is still alive, leading to the errors you reported.

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, 06 March 2014 03:30 CST

user74268
Aghhhhhhh!!!!!
sorry just had to get that out. I'm building the site on my local MAMP so no one to call but myself. Unfortunately I don't know how to clear the reference to it. Any further advice or a site that goes over the steps would be very appreciated.

Thursday, 06 March 2014 07:35 CST

tampe125
Did you tried to exclude the table from the backup?
In Akeeba Backup control panel go inside Database Tables exclusion page.
Please exlude that table and try again.

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!

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!