Error: Joomla tables not found

  • Resolved chicadita

    (@chicadita)


    5 years ago

    I feel like I must be missing a step.

    I have done this:

    1. With phpMyAdmin, export the Joomla database into a SQL file.

    2. Still with phpMyAdmin but on the WordPress host, import this SQL file. So you will have both the Joomla and the WordPress databases on the same host.

    3. Then on the plugin screen, you must fill in the database settings: Hostname, Port, Database, Username, Password, Joomla Table Prefix. You can find them in the WordPress file wp-config.php, except the table prefix that stays the Joomla one.

    I am able to connect to the Joomla database in WordPress. The error I get is about the tables:

    === START test_database 2019-11-06 00:07:04 ===
    [ERROR] Joomla tables not found. Please make sure you have entered the right Joomla database name and table prefix.

    If I make any changes to the database name in the plugin, it will not connect to the database, which tells me I have the database name correct.
    I opened the .sql file created by Joomla and verified the tables do use the default jos_ prefix.

    So if the database is correct because I can log in, and the table prefixes are the same, why can it not find the Joomla tables? Do I have the .sql file in the wrong folder? I have it in the main database directory which is a long line of numbers and letters. Should it be in the html folder or maybe the wp-admin folder?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Kerfred

    (@kerfred)

    Please check that the table jos_content exists in the database.
    And double check the prefix field in the plugin settings.

    Thread Starter chicadita

    (@chicadita)

    jos_content is there in the database. The prefix field in the plugin setting is the same jos_

    What else might be wrong?

    This is how the jos_content section starts in the database:

    Table structure for table jos_content
    —

    CREATE TABLE jos_content (
    id int(11) UNSIGNED NOT NULL,
    title varchar(255) NOT NULL DEFAULT ”,
    alias varchar(255) NOT NULL DEFAULT ”,
    title_alias varchar(255) NOT NULL DEFAULT ”,
    introtext mediumtext NOT NULL,
    fulltext mediumtext NOT NULL,
    state tinyint(3) NOT NULL DEFAULT ‘0’,
    sectionid int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    mask int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    catid int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    created datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    created_by int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    created_by_alias varchar(255) NOT NULL DEFAULT ”,
    modified datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    modified_by int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    checked_out int(11) UNSIGNED NOT NULL DEFAULT ‘0’,
    checked_out_time datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    publish_up datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    publish_down datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,

    Thread Starter chicadita

    (@chicadita)

    === START empty 2019-11-14 18:51:25 ===
    WordPress content removed
    === END empty 2019-11-14 18:51:25 ===

    === START test_database 2019-11-14 18:51:35 ===
    [ERROR] Joomla tables not found. Please make sure you have entered the right Joomla database name and table prefix.

    === END test_database 2019-11-14 18:51:35 ===

    Thread Starter chicadita

    (@chicadita)

    I also tried using phpmyadmin to transfer the SQL file rather than FileZilla at your suggestion. I emptied the wordpress site via the plugin, then went to phpmyadmin.

    I get the following error:

    Error
    SQL query:

    —
    — Database: winemakers_joomla
    —
    — ——————————————————–
    —
    — Table structure for table jos_ak_profiles
    —
    CREATE TABLE jos_ak_profiles (

    id INT( 10 ) UNSIGNED NOT NULL ,
    description VARCHAR( 255 ) NOT NULL ,
    configuration LONGTEXT,
    filters LONGTEXT
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8;

    MySQL said: Documentation

    #1050 – Table ‘jos_ak_profiles’ already exists

    Plugin Author Kerfred

    (@kerfred)

    When you export the Joomla database through phpMyAdmin, you must select the option “DROP TABLES”. Then you will be able to import the database again.

    If you still encounter any problem, please write me on https://www.fredericgilles.net/support/ and I will help you.

    When I received the “[ERROR] Joomla tables not found. Please make sure you have entered the right Joomla database name and table prefix” I used Admin Tools inside of Joomla to change the table prefix. After that I was able to connect. This may help someone else.

    Plugin Author Kerfred

    (@kerfred)

    @btwebmedia You don’t have to change the prefix of the Joomla tables. You just have to enter the good table prefix in the database settings on the plugin screen.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error: Joomla tables not found’ is closed to new replies.

Tags