Support Forum
Support Forum
Offline
As title says, the whole forums list don't get loaded. The page stops after the "last visited" message of the forum header.
If I look the HTML the last thing in the code is the forums quicklinks dropdown (however it's not displayed on the page) and then the page stops. Not even the WP footer gets loaded.
What could be the problem?
As additional info: I'm using the default theme with a custom WP page to display the forum. Also this is a PHPBB import and I can manage the forums in admin just fine. Everything was working in my test installation on the same server.
Offline
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.
 |
YELLOW
SWORDFISH
|
Offline
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.
Offline
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.
Offline
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.
|
YELLOW
SWORDFISH
|
Offline
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.
Offline
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?
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
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.
Offline
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.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)