His problem appears to be that he's using MySQL 5.2. I was using 5.1 for my server and no items would appear at all, none, zip, zero, nada.
Here is the exact quote from the guide.
Quote:
NOTE: In mysql 5.1.* they introduced a new reserved keyword 'range' into the sql language,
unfortunately the items table in the peq database already has a field named "range".
To avoid this conflict we're using a 5.0.* version.
|
I swapped my version to the one on the guide and viola! I was a happy camper.
Here is the direct link to the download
http://dev.mysql.com/downloads/mysql/5.0.html#win32
I hope this helps!