Support

Site Restoration

#37585 Table doesn't exist in engine

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
7.4.29
CMS Type
Joomla!
CMS Version
3.10.11
Backup Tool Version
Akeeba Backup Professional 8.1
Kickstart version
kickstart-core-7.1.2

Latest post by SITech on Wednesday, 24 August 2022 03:10 CDT

Monday, 22 August 2022 00:43 CDT

SITech
Error Table 'j4_public.#__banners' doesn't exist in engine   I am beginning the change from J3 to J4. The online site works fine with no known problem with banners or anything else. Restoring a backup to localhost results in this error, and no menus on the frontend when starting in J3. Everything else seems to work fine.   As best I can I have checked out your "Troubleshooting restored sites" and "Kickstart User's Guide", including using FTP binary transfer mode. I have tried making new backups and restoring them. Always the same result..   What could be the problem and how do I fix it?   Thanks
David

Monday, 22 August 2022 01:20 CDT

nicholas

This is a problem coming from your database server and it tells me that your database is moderately corrupt. Go to phpMyAdmin, select all tables, scroll all the way down, find the "- With selected: " dropdown and choose Repair. You may have to repeat this step a few times until it runs without errors.

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!

Tuesday, 23 August 2022 18:57 CDT

SITech

Thanks heaps. The site is now running on localhost. All tables except 2 now report status OK with phpMyAdmin Check table - finder_tokens and finder_tokens_aggregate don't support check.

Check table also reported "Problems with indexes of table `jpub_admintools_badwords`" saying, "The indexes word and word_5 seem to be equal and one of them could possibly be removed." Also word_2, word_3, word_4. No bad words have been defined by us. Is it safe to simply drop them in phpMyAdmin?

David

Edited by SITech on 2022-08-23 18:59 CDT

Wednesday, 24 August 2022 02:09 CDT

nicholas

> Check table - finder_tokens and finder_tokens_aggregate don't support check.

That's okay, these are memory tables. They are emptied every time your database server shuts down / is restarted. Since they are rebuilt in memory every time they don't get corrupt and don't support repairing. Of course, they can't break so they don't need repairing either.

> Check table also reported "Problems with indexes of table `jpub_admintools_badwords`" saying, "The indexes word and word_5 seem to be equal and one of them could possibly be removed." Also word_2, word_3, word_4. No bad words have been defined by us. Is it safe to simply drop them in phpMyAdmin?

Rename the table, changing jpub_ to bak_. Log into your site's backend and go to Components, Admin Tools. Now check the database. There should be a new jpub_admintools_badwords table. Now you can drop the bak_admintools_badwords table.

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!

Wednesday, 24 August 2022 03:10 CDT

SITech

Perfect result. Much appreciated.
David

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!