Joomla tables not found

Are you sure that the WordPress database and the Joomla database are on the same server?
I don’t see the WordPress database on your screenshots.

Thank you for your reply.

Yes, I have the wordpress database on the same server. The screenshot does not cover all databases. But does that matter? I thought that it was only the Joomla database connection that is tested when I press the “Test the database connection button”. Maybe I need to check the privileges for the WordPress database also. Which database user is used for the test (and the import)? I will check that later.

In this case, please double check the hostname, database name, username, password and the table prefix, and the privileges granted to this user. If both databases are on the same server, it should work.

So far I have tested changing the database and user name and password, and then I get another error “Couldn’t connect to the Joomla database…”, so I assume that hostname, database name, username and password are correct when I instead get the “Joomla tables not found” error.

I can login to PhpMyadmin with the same credentials, and run SELECT queries against the Joomla database.

I use the prefix “jos39_” in the import. The create table DDL for a table in phpAdmin looks like this:

CREATE TABLE jos39_action_logs_extensions (
id int UNSIGNED NOT NULL,
extension varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ”
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

• This reply was modified 1 year, 6 months ago by tryggvas.

I think I have understood. It is because the copy of your Joomla database is not complete. For example the “content” table is missing.

Please ensure that all Joomla tables are present in the database.

Of course. I have to check the database export.

Thank you very much!