Please or Register to create posts and topics.

Problem displaying forum / No categories created message / But categories have been created.

Dear Asgaros

  1. I set up some categories and set them to “Only when logged in”.
  2. Then I played around with the settings, finally leaving the two “Hide…” settings unticked.
  3. The forum is not displaying as per 1.
  4. Then I set the Categories to “Everyone”, still the categories do not show when not logged in
  5. They do show fine when logged in.
  6. Site is https://www.coderslament.uk

Nice piece of work …

KR

David

Dear Asgaros

  1. I was getting an 500 server error searching from the search box…This might be part of the problem.
  2. I turned on debug.
  3. Turns out a SQL Statement was causing a problem. / I think “AND f.parent_id IN ()” is the culprit.
  4. SELECT t.*, f.id AS forum_id, f.name AS forum_name, (SELECT (COUNT(*) - 1) FROM wp_forum_posts WHERE parent_id = t.id) AS answers, su.topic_id, SUM(su.score_name + su.score_text) AS score FROM (SELECT id AS topic_id, MATCH (name) AGAINST ('A*' IN BOOLEAN MODE) AS score_name, 0 AS score_text FROM wp_forum_topics WHERE MATCH (name) AGAINST ('A*' IN BOOLEAN MODE) GROUP BY topic_id UNION SELECT parent_id AS topic_id, 0 AS score_name, MATCH (text) AGAINST ('A*' IN BOOLEAN MODE) AS score_text FROM wp_forum_posts WHERE MATCH (text) AGAINST ('A*' IN BOOLEAN MODE) GROUP BY topic_id) AS su, wp_forum_topics AS t, wp_forum_forums AS f WHERE su.topic_id = t.id AND t.parent_id = f.id AND t.approved = 1 AND f.parent_id IN () GROUP BY su.topic_id ORDER BY score DESC, su.topic_id DESC LIMIT 0, 20
  5. I am attaching a screen shot of the forum forum data table.
  6. The issue described in the previous thread is still occurring.

KR

David

Uploaded files:
  • SQL-Asgaros-1.PNG

Hello @hkdave95

Sorry for the late reply! Do you have access to your PHPs error.log-file? It would be helpful to see the exact error-message when this issue occurs.

Have you by accident assigned some user-groups to the forum? For some reasons it seems, that the forum-system cannot fetch accessible categories for you. Which user-role are you using when this issue occurs? Have you modified your themesĀ functions.php file?

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!

Hello Asgaros

I shall locate the error log. 6:14pm post I believe I have located the problem. Try running the SQL on same version data and you get the same.

AND f.parent_id IN ()

This is an empty set, and is not allowed in SQL. The software generated the statement, so must be a problem with the software?

I think it is related to the fact that the forum is not displaying properly.

Could the installation, or setup be duff?

Right. Looking for error log.

KR

David

 

Further to your questions.

User groups / no.

Functions.php / no.

The forum has two or three user groups, I believe.

Thank you. @Asgaros / It was the user groups selection (I now note, and furthermore, understand the text).

However, when no categories are created (or visible), the search box throws the error.

Onwards…

Hi @hkdave95

Good catch! I fixed the query-error on the dev-version and the bugfix will be included in the upcoming release:

https://github.com/Asgaros/asgaros-forum/commit/2929902fe7544d4e784c30ea3ed4a0063e83e371

hkdave95 has reacted to this post.
hkdave95
If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!