Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
V5 Import Plugin Missing Topics/Posts
Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Feb 29, 2012 - 3:48 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 29, 2012 - 4:44 am

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Feb 29, 2012 - 5:30 am

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

Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Feb 29, 2012 - 5:42 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 29, 2012 - 6:42 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Feb 29, 2012 - 8:27 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 29, 2012 - 12:23 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Mar 1, 2012 - 3:26 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 1, 2012 - 4:17 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
jamesmonk
Member
Free Members
sp_UserOfflineSmall Offline
Mar 1, 2012 - 6:21 am

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

 

Thanks again,

James

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79605