WordPress.org

Forums

FG Joomla to WordPress
[resolved] Can't connect to Joomla Database (10 posts)

  1. cmazz
    Member
    Posted 1 year ago #

    The joomla site and wordpress site are not hosted at the same place. I exported the joomla .SQL file and imported it onto the wordpress database. I used those credentials in the plugin and it's telling me the table doesn't exist?

    Thank you in advance for your help.

    https://wordpress.org/plugins/fg-joomla-to-wordpress/

  2. Kerfred
    Member
    Plugin Author

    Posted 1 year ago #

    Which exact error message did you get?

  3. cmazz
    Member
    Posted 1 year ago #

    [fgj2wp] Couldn't connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.
    Table 'the1408406250357.jos_content' doesn't exist

  4. Kerfred
    Member
    Plugin Author

    Posted 1 year ago #

    This message says that:
    - your MySQL login and password are correct
    - your database (the1408406250357) exists
    - but the prefix jos_ is incorrect.
    You have to check the Joomla table prefix and that you have Joomla data in the database the1408406250357.

  5. cmazz
    Member
    Posted 1 year ago #

    Joomla's global configuration settings tell me the table prefix is hnmvp_ so when I put that in the plugin fields it still gives me the same error, only:

    [fgj2wp] Couldn't connect to the Joomla database. Please check your parameters. And be sure the WordPress server can access the Joomla database.
    Table 'the1408406250357.hnmvp_content' doesn't exist

    Is there any way to check the Joomla table prefix? Is that the only thing that's throwing this migration off?

    Thank you for your help.

  6. Kerfred
    Member
    Plugin Author

    Posted 1 year ago #

    Yes, you have to look at the database tables with phpMyAdmin.
    Or you can find the Joomla prefix in the Joomla file configuration.php.

  7. cmazz
    Member
    Posted 1 year ago #

    Nope, the prefix is correct. Anything else that might be causing it? I JUST realized that the database type was mysqli and I exported it to a .sql file - correct?

    Other than that, the URL I am using for the plugin is where the old site is still up and running - correct?

    hostname is the wordpress database host - correct?

  8. Kerfred
    Member
    Plugin Author

    Posted 1 year ago #

    All seems correct. Can you check that you have a table named hnmvp_content in the the1408406250357 database? And is this table accessible by the user you filled in the plugin settings?

  9. klattimonsterbrain
    Member
    Posted 1 year ago #

    Hi,

    i have exactly the same problem.

    "Can you check that you have a table named hnmvp_content in the the1408406250357 database? And is this table accessible by the user you filled in the plugin settings?"

    it is!

    is there a solution?

    Thank you

  10. klattimonsterbrain
    Member
    Posted 1 year ago #

    now it works...weird! Sorry. -> Solved

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • FG Joomla to WordPress
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.