Sorry to hear about the initial time-outs. We really do need to address this in the importer but most conversions are much smaller and it would mean a complete rewrite.

To be frank if the error says duplicate key then I would believe it. I do not remember fully the data storage of wp-forum but is it at all possible that there could indeed be duplicate topic IDs in your source data? The error message seems to suggest that is the case. But you would need to look at the original table data.

We already looked in the original table data and there’s no duplicate topics ids. We are trying to migrate for more than a month ago.

Yesterday we tried to touch the importer code to try to skip this duplicates errors, bout today we found all this errors:

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_redirection_items.*,wp_redirection_groups.tracking,wp_redirection_groups.position AS group_pos,wp_redirection_modules.id AS module_id FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status=’enabled’ INNER JOIN wp_redirection_modules ON wp_redirection_modules.id=wp_redirection_groups.module_id AND wp_redirection_modules.type=’wp’ WHERE( wp_redirection_items.regex=1 OR wp_redirection_items.url=’/wp-content/plugins/sp-import/engine/spimport.php?action=forumPhase&phase=12′) realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, WordPress_Module->init, Red_Item->get_for_url, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘opiniones’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘marca’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘modelo’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘segmento’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘combustible’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT wp_posts.post_name rnttttttttFROM wp_posts rnttttttttWHERE wp_posts.post_status = ‘publish’ rn tttttttttAND wp_posts.post_type = ‘acf’rn tttttttttAND wp_posts.post_date < NOW() realizada por require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, UWT_RemoveSlugCustomPostType::init, UWT_RemoveSlugCustomPostType->__construct, UWT_RemoveSlugCustomPostType->rewrite_rules, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT * FROM wp_users WHERE ID=1 realizada por sp_forum_api_support, sp_load_current_user, sp_get_user, spUser->__construct, spdb_table, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

Can you give me some directions in why this errors may occur?

Regards,

And more errors:

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT special_rank FROM wp_sfspecialranks WHERE user_id=0 realizada por sp_forum_api_support, sp_load_current_user, sp_get_user, spUser->__construct, sp_get_user_special_ranks, sp_get_special_rank, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT * FROM wp_posts WHERE ID=16125 realizada por sp_forum_api_support, include_once(‘/plugins/simple-press/sp-startup/sp-load-forum.php’), include_once(‘/plugins/simple-press/sp-startup/forum/sp-forum-constants.php’), spdb_table, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT * FROM wp_sftrack WHERE trackname=’172.22.254.113′ realizada por sp_forum_api_support, sp_get_track_id, spdb_table, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:19 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT error_count FROM wp_sferrorlog WHERE keycheck=”Notice31-press/sp-api/sp-api-auths.php” AND error_type=”php” realizada por spi_import_forums, spi_create_forum, sp_filter_text_save, sp_filter_save_kses, sp_kses_array, sp_get_auth, sp_construct_php_error, spdb_table, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

[Mon Mar 31 19:59:39 2014] [error] [client 172.22.254.113] Error MySQL server has gone away de la base de datos de WordPress para la consulta SELECT error_count FROM wp_sferrorlog WHERE keycheck=”151-press/sp-api/sp-api-error.php” AND error_type=”database” realizada por spi_import_forums, spi_create_forum, sp_filter_text_save, sp_filter_save_kses, sp_kses_array, sp_get_auth, sp_construct_php_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, sp_construct_database_error, spdb_table, spdb_select, referer: http://example.com.ar/wp-admin/admin.php?page=sp-import/admin/spimport-setup.php&sys=wpforum

These are all the same error – ‘MySQL server has gone away’.

This means that the mySQL database engine is not responding to the requests. This most usually suggests a configuration issue with the server and would be something you need to discuss with your site host support.

Hi,

we have been debugging the import process and the Error MySQL server has gone away is being generated case the import script is not parsing right certain posts form WP-Forum.

As you can see in post 64867 (error_post_64867.txt attached), the import script didn’t parse ok the original post (postoriginal_64867.txt attached) and generated an INSERT code that generate an error even when you try to make the INSERT via phpmyadmin

In post 65943 the INSERT query, is broken in:

alt=”http://www.deautos.com/images/fotosplaya/517495_3c.jpg

Looking to the original post, that line belongs to the following part of the post:

Red what process correctly

Black where the error is created.

and blue is some of the content that follows.

<img src="http://www.deautos.com/images/fotosplaya/516787_2c.jpg” alt=”http://www.deautos.com/images/fotosplaya/516787_2c.jpg” />

<img src="http://www.deautos.com/images/fotosplaya/516787_3c.jpg” alt=”http://www.deautos.com/images/fotosplaya/516787_3c.jpg” />

            <a href="http://www.deautos.com/usados/ad_518035_Honda-Civic-2006.html”>http://www.deautos.com/usados/ad_518035_Honda-Civic-2006.html[/url

original post and error attached too for 65943.

Apologies for the delay.

Also sorry but I do not follow any of this. What are these links? They all seem to take me to a 404 page and a photo of an old black car. You mention bad insert statements but where are they? There is also no attachment…

Hi, here are the attachments.

Download error_post_64867.pdf

Download error_post_65943.pdf

Download postoriginal_64867.pdf

Download postoriginal_65943.pdf

as I tried to explain in my post we have been debugging the import process and the Error MySQL server has gone away is being generated because the import script is not parsing right certain posts from WP-Forum.

As you can see in post 64867 (error_post_64867.txt attached), the import script didn’t parse ok the original post (postoriginal_64867.txt attached) and generated an INSERT code that generate an error even when you try to make the INSERT via phpmyadmin

In post 65943  (error_post_65943.txt attached) the INSERT query, is broken in:

alt=”http://www.deautos.com/images/…..495_3c.jpg

Looking to the original post (postoriginal_65943.txt attached), you will find the line where the insert is broken.

Regards,

Looking at this heavily escaped text is really not an easy way to analyse these issues.

Looking at the specific example you cited I do not see what the ‘error’ in the query is you are referring to. Unless you are referring to the fact that the error text has been truncated.

(If you have a properly formatted query (without all the escape sequences and surrounding garbage) from the error log that you want to show us then please paste JUST the query text here using the code syntax highlighter button on the toolbar. Paste the text – select the text – use the button drop-down and select ‘sql’.)

Have you actually taken the time to investigate the ‘server gone away’ situation which is the real error underlying your problem? http://dev.mysql.com/doc/refman/5.0/en/gone-away.html