If it completely stops like that then I would expect there to be an entry in the php error log.

You could look in the forum admin > toolbox > error log – just see if there is an actual ‘error’ recorded. If there is not then you may need to look at the full php error log on your server.

That’s the problem, there is no error in logs! I removed the whole search/quickliks block from the forum theme and everything works. So it’s something in there. I’m retrying an import from scratch now for the third time. (2 times same error, but i fixed something in the phpbb db now).

After import i have an error in SF logs, something wrong in an UPDATE wp_sfposts where the postid is empty. I don’t have the full log now since i reseted the install to try from scratch again, but i will post it after this import ends (it’s a big forum).

If the fact that removing the search/quicklinks block from the theme rings you a bell just let me know. I’m familiar with php/mysql, so if you need some more info just ask.

PS: There is no error in both PHP logs or SF logs.

I managed to get it working. However I have some errors after the import in SP logs like this:

spimport.php
line: 232
function: sp_build_post_index
error: 

UPDATE wp_sftopics SET post_id=, post_count=0, post_id_held=0, post_count_held=0 WHERE topic_id=1172

the post_id is missing for a bunch of them. Is this a bad thing? I can manually change them in db if needed.

Do you know what the original error was that was stopping it? Or did it just vanish with the re-run?

As to the post_id – absolutely it is critical. If you are referring to the ‘sfposts’ table then the question is how is it possible that rows were created without it as this is an auto-increment primary key without which it should not be possible to create a row at all…

If you can ascertain what happened there it would be useful information but the bottom line is that yes – it needs this data.

If you are referring to the sftopics table then it might be worth going to the forum admin > toolbox > housekeeping and rebuilding the indexing for each forum. At least worth a try before manually adjusting data.

to fix the initial problem i run a repair tool on phpbb original tables. About the critical error, i was already thinking about rebuilding index. It seems to only affect the sftopics table. However some posts seems to be empty and display the “you don’t have permission to view this topix” even if i’m admin.

Also I went to check sftopics table and all post_id’s are present, but some topics have NULL post_id_held value, which i guess should be the same of post_id?

Using the index rebuild tool should put all the values in place. Has this not happened?

For the permissions issue try toolbox > housekeeping > reset auths cache although why yours should be an issue I am not sure.

When you abandoned the first import did you actually uninstall SP so that all the tables were properly cleared out?

Yes I always started from scratch. I’m rebuilding each forum now, but since it’s a big forum (around 200 subforums and 300k posts) it will take some times. Is there a way to rebuild everything at once instead of selecting individual forums each time?

Also i found where the problem arise: if i comment sp_QuickLinksTopic(‘tagClass=spControl spSelect spRight’, __sp(‘New/Recently Updated Topics’)); in the theme everything works. This dropdown is causing something that breaks the loading.

We can not really do everything in one big sweep I am afraid. Too much work for the server to realistically take on. I would start by just doing the one forum that you know is causing the error to see if this puts it right.

When everything is indexed correctly then I would also try the quicklinks again. If they still break (and the lack of an error on your server error log is somewhat disturbing) then I would first of all suspect some sort of oddity in the forum or topic title and/or slug. A very rare thing but I have seen odd characters in posts stop the display before now despite the set if WordPress filters that posts are passed through.

Yeah the lack of any errors in log is kinda annoying. I even enabled E_ALL without luck. I’ll update when i finish rebuilding everything.

I’m trying to rebuild index on the forum I suspect it’s causing all the issues, but it looks like it’s doing nothing. It’s an huge subforum, I keep having the “please wait” message after 2+hours and with my top i don’t see queries being done. It’s possible to split the process or doing it in shell with CLI php?

Oh dear – this is probably the issue then. The indexing routine is earmarked for breaking it up into batches but it is not done yet so I assume it is running out of time on your server. It probably hit your timeout limit and then stopped at that point.

Is there any chance you can increase the timeout?

Yes, I own th server and I’m root. I set unlimited max_execution_time and increased memory_limit, and seems that SF rebuilt index in a snap on that big forum. Now everything appear to be correct and I reenabled the dropdown, everyting is working.

So I guess I can mark this as solved, still puzzled as why I don’t have a memory limit error in stderr but at least it’s solved

thanks for the update!  good news!