UseBB Community

The official board for UseBB help and discussion

UseBB Community » Help & Support » Can't view topics of my forum...

Can't view topics of my forum...

Moderators: Gaia.

Page: 1

Author Post
Member
Registered: May 2004
Posts: 1
I don't know if this is a bug, perhaps have I done something bad in my configuration ?

I successfully created a category and a forum in UseBB v0.2; I posted in this one a topic, but now when i want to see the list of topics in my forum, I had the following problem:

SQL - Unable to get topic list!

Query causing the error:
SELECT t.id, t.topic_title, t.last_post_id, t.count_replies, t.count_views, t.status_locked, t.status_sticky, p.poster_guest, p2.poster_guest AS last_poster_guest, p.post_time AS last_post_time, u.id AS poster_id, u.name AS poster_name, u.level AS poster_level, u2.id AS last_poster_id, u2.name AS last_poster_name, u2.level AS last_poster_level FROM usebb_topics t, ( usebb_posts p LEFT JOIN usebb_users u ON p.poster_id = u.id ), ( usebb_posts p2 LEFT JOIN usebb_users u2 ON p2.poster_id = u2.id ) WHERE t.forum_id = 1 AND p.id = t.first_post_id AND p2.id = t.last_post_id ORDER BY t.status_sticky DESC, p2.post_time DESC

I executed this in phpmyadmin and it tells me that the error is at the level of the first '(' - my SQL is a bit rusty, so I am not able to detect where the problem (which is perhaps obvious) is.

So is it a bug or am I guilty ?

Nevertheless, your program is great, go on!
Developer
Registered: Apr 2004
Posts: 2202
Location: Belgium
This is a known bug in UseBB 0.2, due to MySQL 4.x syntax on MySQL 3.x.

Download the latest version of forum.php from the CVS: http://cvs.sourceforge.net/viewcvs.py/usebb/UseBB/forum.php?view=markup
_______________
--Dietrich (developer)
UseBB roadmap, dev mailing list & weblog

Page: 1

UseBB Community » Help & Support » Can't view topics of my forum...

UseBB Community is powered by UseBB 1 Forum Software