Testing DB Connection – Ajax 500 error

  • Resolved nkals722

    (@nkals722)


    5 years, 8 months ago

    I’m trying to set up the plugin. Entering the DB info and hitting test db connection. The ajax it is sending is erroring out with “500 (Internal Server Error)”. This is coming from running the test_database javascript function via the admin-ajax.php file it looks like. I can’t think of why it would be doing this, though – whether its an issue with the plugin or what.

    Any ideas?

    Thanks

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

    (@kerfred)

    First verify your login and password to your Magento database.

    If Magento and WordPress are not installed on the same host, you can do this:

    • export the Magento database to a SQL file (with phpMyAdmin for example)
    • import this SQL file on the same database as WordPress
    • run the migration by using WordPress database credentials (host, user, password, database) instead of the Magento ones in the plugin settings.
    Thread Starter nkals722

    (@nkals722)

    Will it be able to grab images if I have to pull the database down to my other host?

    Plugin Author Kerfred

    (@kerfred)

    Yes, it will grab the images from the original site. For that you must put the URL of the original site in the URL field.

    Thread Starter nkals722

    (@nkals722)

    SO I’ve grabbed the database and put it on the same host as my wordpress. Its’s still doing admin ajax javscript error though when running a test database. I don’t think it’s even getting to the part with it is testing the credentials.

    Thread Starter nkals722

    (@nkals722)

    I ended up pulling everything down to a development server and it is currently importing without error. Hopefully it stays that way.

    One thought was that the server was trying to get this going on was a .dev server with forced https. I wonder if that was messing some of the calls up? It looks like it was trying to access some json via http, at least for logs and progression.

    Plugin Author Kerfred

    (@kerfred)

    Ah I understand.
    It is because your WordPress site is configured in http (in the WordPress settings) whereas the back-end is in https.
    You can fix it easily by changing http by https in the WordPress general settings.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Testing DB Connection – Ajax 500 error’ is closed to new replies.

Tags