Support » Plugin: TYPO3 tt_news Importer » Unable to connect to the database

  • Resolved d.weaver

    (@dweaver-1)


    Hi,

    When looking at the TYPO3 Importer Settings and in the “TYPO3 Access” tab, I have entered all fields 100% correctly.

    Eg:
    Database Host: localhost
    Database Name: tm_typo
    Database Username: tm_typo_usr
    Database Password: xxxxxx

    And when I click the “Save Changes” button the message “Unable to connect to the database” appears.

    Just wondering if anybody has come across this? Or if there are any other settings etc?

    http://wordpress.org/plugins/typo3-importer/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Michael Cannon

    (@comprock)

    Are you on the same server?

    Are you able to connect to the database via the command line?

    It’s possible that you don’t allow the WordPress site host to access the database server.

    Thanks for your response,

    I managed to connect to the database and the settings have been saved.

    I now go to import the TYPO3 news and begin to import but now it fails all the news articles trying to import.

    Eg:

    Import Failures: 4

    1.function (){if(a){var t=a.length;(function r(t){v.each(t,function(t,n){var i=v.type(n);i===”function”?(!e.unique||!c.has(n))&&a.push(n):n&&n.length&&i!==”string”&&r(n)})})(arguments),i?o=a.length:n&&(s=t,l(n))}return this}

    Just wondering what the problem could be?

    Thanks

    Plugin Author Michael Cannon

    (@comprock)

    Oh boy… I’ll be the first to admin that debugging for TYPO3 Importer can be a pain.

    Have you tried setting a limit of say 3, enabling debug mode, and then try importing?

    Hi,

    I have enabled debug mode, then tried to import again and this error came up:

    WordPress database error: [Table ‘tm_typo.tx_realurl_uniqalias’ doesn’t exist]
    SELECT a.value_alias slug FROM tx_realurl_uniqalias a WHERE a.tablename = ‘tt_news’ AND a.value_id = 1 ORDER BY a.tstamp DESC LIMIT 1

    Fatal error: Call to undefined function mb_decode_numericentity() in /u/web/wordpress/wptest/wp-content/plugins/typo3-importer/typo3-importer.php on line 534

    Any ideas?

    Thanks

    Plugin Author Michael Cannon

    (@comprock)

    Ask you hosting provider to enable MB for PHP.

    @ref http://php.net/manual/en/function.mb-decode-numericentity.php

    It worked! Awesome plugin!

    Thanks

    Plugin Author Michael Cannon

    (@comprock)

    Glad it’s all worked out.

    Thank you for the plugin compliment.

    Plugin Author Michael Cannon

    (@comprock)

    On the same thread here, if you’re having troubles with remote database connections, copy the old database tables and data to a new one at your new web host. Then connect via localhost using the the new-old database credentials.

    You still need to use your old TYPO3 url to make sure media files make it over.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unable to connect to the database’ is closed to new replies.