Hey everyone,

I have downloaded the code for the message board in chapter 15, however, after I have created all the database tables, I receieve the following error from the main index page:

'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts'

Anybody have any ideas?

Cheers!

I have exactly the same problem, someone please help us.....

Yer you guys me 2. Not a clue on it really.

Why is this still a problem with no solution. I am having same problem!

Chapter 15. sql that causes error
SELECT f.id as id, f.forum_name as forum, f.forum_desc as description,
         count(forum_id) as threads, u.name as mod
         FROM forum_forum f
         LEFT JOIN forum_posts p
         ON f.id = p.forum_id
         AND p.topic_id=0
         LEFT JOIN forum_users u
         ON f.forum_moderator = u.id
         GROUP BY f.id

Error is listed here:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod FROM forum_forum f LEFT JOIN forum_posts p ON f.i' at line 2

On of you geniuses that took our money want to provide a fix???

I am having the same problem and can't find a solution already listed in this forum. Any help out there?

OK.. I figured it out.

The problem is with the 'u.name as mod' portion of the SELECT statement in index.php. The word 'mod' is a reserved word in MySQL 5.0.

To fix this problem, change the 'u.name as mod' to 'u.name as moderator'.

You will then need to change the code later in the file which accesses this field.

Change
     echo "<td class='center'>" . $row['mod'] . "</td>";
to
    echo "<td class='center'>" . $row['moderator'] . "</td>";

It seems to work correctly after this....