Support Forum
Support Forum
Offline
Hi All,
I have a site that I'm trying to get Simple Press working on, it's currently running WP Forum and has around 800 topics and around 4500 posts. I've been trying to import all the data across into a fresh install of Simple Press but the 2 largest forums which contain the most number of topics/posts aren't being copied across fully, no errros occur during the import but when I view the forums it only seems to copy over half a dozen topics for each rather than the 200+ which should be in there.
I was wondering if it could be down to size of the forums and the importer struggling because they're so much bigger than the others?
Has anybody else experienced anything llike this before or have any suggestions as to how to get around it?
Thanks in advance,
James
Offline
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?
 |
YELLOW
SWORDFISH
|
Offline
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
Offline
Just heard back and it doesn't look like they're prepared to alter it.
Offline
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.
|
YELLOW
SWORDFISH
|
Offline
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
Offline
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
|
YELLOW
SWORDFISH
|
Offline
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
Offline
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.
|
YELLOW
SWORDFISH
|
All RSS