Trouble viewing the forum (ch. 16)

[Draconian]

I'm having trouble with my viewforum.php code. When I try and access the page, I get this error message:

quote: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 = 1 AND t.topic_id = 0 GROUP BY t.id ORDER BY re_posted DESC, t_posted DESC, LIMIT 0, 10

This is the offending pice of code:

$sql = "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 = $forumid " .
         "AND t.topic_id = 0 " .
         "GROUP BY t.id " .
         "ORDER BY re_posted DESC, t_posted DESC, " .
         "LIMIT $start, $limit";
  $result = mysql_query($sql)
    or die(mysql_error()."<br>".$sql);
    $numrows = mysql_num_rows($result);

I really can't see where I'm going wrong. Any help would be marvelous.

[Draconian]

Also, it's running on MySQL 3.23.49 if that makes any difference.

[jason.gerner]

Actually, it does.
SQL_CALC_FOUND_ROWS was introduced in MySQL 4.0.0: http://dev.mysql.com/doc/mysql/en/in...functions.html

[andrene]

go to your functions.php file and change all: mod to: 'mod'