It is probably timing out I am afraid. I admit that I need to put a little more work into that aspect of things. Are you able to increase the timeout settings that keep a php script alive on your server or is that not going to be an option?

Thanks for the quick reply.

I thought it might be something to do with the server, I’ll email the hosting company that I have my reseller account with and see if there’s anything they can do about it.

I presume if I hit a brick wall with them there aren’t any other options?

Thanks,

James

Just heard back and it doesn’t look like they’re prepared to alter it.

Another option is to bring the database to a local server and perform it there. But I appreciate that if you don’t have that environment available then it is not so easy to set up either.

It might not even actually be the problem as quite a large number of users have done this successfully.

I would be willing to try it for you if you wanted to zip up a copy of the db backup – at least that would tell us if there are other issues at play.

Hi,

Okay a quick update, my hosting company have agreed to increase the time-out for a short period of time however it seems to be even worse now. Before the importer would just complete and the data would be missing, now it gets to a certain amount and displays a 404 error page in some sort of fram beneath the results of the import and is now frozen.

Thanks for the kind of offer of taking a look (my development skills are very limited), how would you like the database file, with a blank version of Simple Press installed or a version with as much content imported already?

Thanks for all the help,

James

Blank will be best but I will probably try it out into another database. You can send it to andy at simple-press dot com

That’s great thanks, after talking with my hosting company they’ve pointed out to check the error log on the site. This seems to contain the same group of errors over and over:

[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query select parent_id from wp_forum_forums where id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_parent_id
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT name FROM wp_forum_groups WHERE id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_groupname
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT name FROM wp_forum_forums WHERE id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_forumname
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query select parent_id from wp_forum_forums where id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, All_in_One_SEO_Pack->wp_head, ob_end_flush, All_in_One_SEO_Pack->output_callback_for_title, All_in_One_SEO_Pack->rewrite_title, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_parent_id
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT name FROM wp_forum_groups WHERE id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, All_in_One_SEO_Pack->wp_head, ob_end_flush, All_in_One_SEO_Pack->output_callback_for_title, All_in_One_SEO_Pack->rewrite_title, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_groupname
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT name FROM wp_forum_forums WHERE id =  made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, All_in_One_SEO_Pack->wp_head, ob_end_flush, All_in_One_SEO_Pack->output_callback_for_title, All_in_One_SEO_Pack->rewrite_title, wp_title, apply_filters, call_user_func_array, vasthtml->set_pagetitle, vasthtml->get_pagetitle, vasthtml->get_forumname
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT parent_id FROM wp_forum_forums WHERE id =  made by require, require_once, include, the_content, apply_filters, call_user_func_array, vasthtml->go, vasthtml->showthread, vasthtml->forum_get_group_from_post, vasthtml->forum_get_parent
[29-Feb-2012 18:46:49 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT id FROM wp_forum_groups WHERE id =  made by require, require_once, include, the_content, apply_filters, call_user_func_array, vasthtml->go, vasthtml->showthread, vasthtml->forum_get_group_from_post, vasthtml->forum_get_group_id

Any ideas or would you like me to just send over the database file?

Thanks for all your help.

James

You can send it but now it is Thursday I may not be able to get around to it until after the weekend I am afraid due to other commitments.

Looking at those errors they suggest (at least) that there are some orphaned rows in the wp-forums data – i.e., perhaps topics that point to non-existent forums or something like that. Odd as we do check for orphaned items but they seem to be slipping through. Curious.

Okay that’s great thanks, I’ll email it over to you shortly.

Thanks again,

James

will look for it…