Akeeba Backup for Joomla!

#21302 DB Error When Restoring To New Server

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 crash3903 on Friday, 24 October 2014 03:07 CDT

Friday, 24 October 2014 02:37 CDT

crash3903

Good morning

I ma trying to restore a site on my local server (Bitnami) and I am getting the following error

SQL=SELECT COUNT(extension_id) FROM `mmikp_extensions` WHERE `type` = 'plugin' AND `folder` = 'twofactorauth' AND `enabled` = '1'

I have seen that this may be caused by the case of the table name and they are all lower case and still I get the error

Any suggestions please?

Thanks

Mark

PS I can't upload the log file as I haven't been able to install to get the file

Edited by crash3903 on 2014-10-24 02:38 CDT

Friday, 24 October 2014 02:40 CDT

crash3903

I forgot to say that the error is on heart internet but I am also trying to install on local server on my windows machine using Bitnami - I have upgraded the PHP version on Heart Internet but the error remains

Friday, 24 October 2014 02:47 CDT

nicholas

Does the mmikp_extensions table exist after restoring your site? If not, you have excluded this core Joomla! table (#__extensions) from your backup. Without it neither Joomla! nor the restoration script will work correctly.

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, 24 October 2014 03:07 CDT

crash3903

Thanks Nicholas, thats great. Seems the tables are not being backed up, I'll go into akeeba and see what tables have been excluded

Thanks for your speedy response ;)

Support