I just downloaded the Chapter 16 source code, not wanting to write all the code myself just yet. When I ran the code under apache it said a lot of the tables weren't created, so I downloaded mysql admin and created these tables. On startup of the forum I get this error message:

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.id = p.forum_id AND ' at line 3

I still have a search box, home,login, register buttons. When I try and register a new user I get this:

Could not create user account; Unknown column 'name' in 'field list'

Can anyone help me with where these errors are coming from and how I can fix them. Any help will be appreciated. Thank you in advance.

I think the expression mod is a function in MySQL; it confuses the database. In the query change mod ( there two instances) to anything (e.g. modd)