On trying to load any of the forums created (viewforum.php) I get this error message:

You have an error in your SQL syntax near '.id as topic_id, t.subject as t_subject, u.name as t_author, count(p.id) as numr' at line 1
SELECT SQL_CALC_FOUND_ROWS t.id as topic_id, t.subject as t_subject, u.name as t_author, count(p.id) as numreplies, t.date_posted as t_posted, tmp.postdate as re_posted FROM forum_users u JOIN forum_posts t ON t.author_id = u.id LEFT JOIN tmp ON t.id = tmp.topic_id LEFT JOIN forum_posts p ON p.topic_id = t.id WHERE t.forum_id = 2 AND t.topic_id = 0 GROUP BY t.id ORDER BY re_posted DESC LIMIT 0, 10

I've looked through all the other postings, and I've seen no reference to this problem. This make me think that it is something that I've done wrong!

Please, can anyone can give me a pointer as to what's gone wrong?

Me again!
I've re-uploaded the original files (the ones unchanged by myself and the ones downloaded from the source code) to the server, and I am getting exactly the same error!
Therefore, it isn't anything that I've done!
PS. It is the same error whether I have changed all the known bugs in the scripts or not!

Why has no one else had this problem?

Hi all,

I'm getting the same error as above:

You have an error in your SQL syntax near 'ON t.author_id = u.id LEFT JOIN tmp ON t.id = tmp.topic_id LEFT JOIN forum_posts' at line 1
SELECT SQL_CALC_FOUND_ROWS t.id as topic_id, t.subject as t_subject, u.name as t_author, count(p.id) as numreplies, t.date_posted as t_posted, tmp.postdate as re_posted FROM forum_users u JOIN forum_posts t ON t.author_id = u.id LEFT JOIN tmp ON t.id = tmp.topic_id LEFT JOIN forum_posts p ON p.topic_id = t.id WHERE t.forum_id = 1 AND t.topic_id = 0 GROUP BY t.id ORDER BY re_posted DESC LIMIT 0, 10

This only happens when clicking on the forum links - anyone have a fix for this?

- Dave

Just FYI, I'll take a look at this evening if I can.

Any updates as to a solution for this?

- Dave

Hi,
If anyone is currently working on this problem could you please place a thread to let us know.

I've now tried everything I know to fix this problem, and I can't work it out!

It definitely seems to be related to SELECT SQL_CALC_FOUND_ROWS, because if I cut it out and repeat a count it kind of works.

I shall look elsewhere if I think no one can help.

In order for it to work properly you need to have MySQL 4.0.0 and up. Could u please check u have the proper version.

Christian

Yes!
I'm running PHP 4.0
Heres the link to my phpinfo file:
http://www.trebrown.com/phpinfo.php

You need MYSQL 4.0.0 and up not PHP 4.0

Christian

Sorry!
I got that wrong!
If you were to look at my PHPinfo file you would see that I have PHP 4.1.2