Unable to connect to the database

Thomas, I’m sorry about the trouble. Are you positive that you can connect the database from the command line from the new server to old? Have you tried copying the TYPO3 database to a more local instance and running TYPO3 Importer that way?

Hi,

its the same local machine. I can connect via command line and also via phpmyadmin on the same host. TYPO3 and WordPress work on the same host, on which also MySQL runs.

Can you enable debug mode in the plugin and for the website and then check the debug.log?

Hello,

enabling

define(‘WP_DEBUG’, true);
define(‘WP_DEBUG_LOG’, true);

logs:

[12-Feb-2015 12:22:03 UTC] WordPress database error for query made by update_option, sanitize_option, apply_filters(‘sanitize_option_t3i_options’), call_user_func_array, T3I_Settings->validate_settings

And here the debug bar query output:

require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/typo3-importer/typo3-importer.php’), require_once(‘/plugins/typo3-importer/settings.typo3-importer.php’), T3I_Settings->__construct, T3I_Settings->get_settings, get_users, WP_User_Query->__construct, WP_User_Query->query #2 (0.1ms)

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC

require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/typo3-importer/typo3-importer.php’), require_once(‘/plugins/typo3-importer/settings.typo3-importer.php’), T3I_Settings->__construct, T3I_Settings->get_settings, get_users, WP_User_Query->__construct, WP_User_Query->query, WP_User->__construct, WP_User->init, WP_User->for_blog, WP_User->_init_caps, get_user_meta, get_metadata, update_meta_cache #3 (0.1ms)

SELECT option_value FROM wp_options WHERE option_name = ‘WPLANG’ LIMIT 1

require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/typo3-importer/typo3-importer.php’), require_once(‘/plugins/typo3-importer/settings.typo3-importer.php’), T3I_Settings->__construct, load_plugin_textdomain, get_locale, get_option

Does the debug.log file by some hope give what the exact query error was that caused “[12-Feb-2015 12:22:03 UTC] WordPress database error for query made by update_option, sanitize_option, apply_filters(‘sanitize_option_t3i_options’), call_user_func_array, T3I_Settings->validate_settings”?

Or is that what’s in debug.log?

Frankly, I’ve not had to use TYPO3 Importer in a couple of years and I’m hard pressed to support it. However, I’m inducting one or two more developers to begin assisting me, but they won’t be able to begin public support until March 1st.

The error part T3I_Settings->validate_settings, directs me to https://github.com/michael-cannon/typo3-importer/blob/master/settings.typo3-importer.php#L775. If there’s a problem, an admin error panel should come up. However, it seems not to. Are you able to debug this code further?

The output is part of the debug.log, no further information. I am not able to get more debug information out of it.

Thanks for your support until that point.

Please respond here in early March if you’re still stuck. I’ll try to get one of my new guys to look into this then.

Kofl, are you still encountering the problem?

Thanks for asking.

We decided to do the migration by hand in the meantime, so we have no update so far.

hello Michael,

Congratulations for this good expansion

but i have a problem when I import news. i get 230 news imported. The total number is 521 news.

Do you have a proposal for me?

use ==== Wp 4.4

Best regards

Hi i3lani, Please create a new support ticket so that other folks can get the benefit as this does not belong to original ticket post.

Thanks