Need Prefix Error

  • Resolved ecogmedia

    (@ecogmedia)


    7 years, 1 month ago

    I have exported the Drupal DB from the current external host and created a new MySQL database on my localhost and imported the data. When I try and do the text connection I keep getting the following error.

    [ERROR] Couldn’t connect to the Drupal database. Please check the Drupal table prefix.

    However looking at the tables I don’t see a table prefix but it will not let me do the import without that field.

    I ran the plugin on some text data from that external site from the development database and worked fine, removed the import to do the full data and getting the error now.

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

    (@kerfred)

    You can let the prefix field empty if your Drupal tables don’t have a prefix.

    Did you import all the Drupal tables on your local MySQL?
    And did you choose the right database name?

    Thread Starter ecogmedia

    (@ecogmedia)

    Looking at the tables again and the SQL dump file it doesn’t appear that it is creating all the tables on the local. This could be the issue so I’ll work at getting the import put in all the way, might be timing out during the import and let you know.

    Thread Starter ecogmedia

    (@ecogmedia)

    That seemed to be the issue with the missing tables and I’m able to connect now. However it doesn’t appear to be pulling in all the posts so I’ll have to double check to make sure the tables are pulling all the way in.

    Thread Starter ecogmedia

    (@ecogmedia)

    Ok, I’ve got a clean install and checked the node_revision table and see the posts but they are not being imported it.

    Plugin Author Kerfred

    (@kerfred)

    Please open a ticket on https://www.fredericgilles.net/support/ and give details about your issue (screenshot, log).
    We will investigate on your issue.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Need Prefix Error’ is closed to new replies.