[Zoints]

Note to anyone getting the following SQL error:

Invalid SQL: SELECT
blog.*, category.title As cattitle, blogoptions.options,
mood.imagename As moodimage, mood.title As moodtitle,
group_concat(tag.tag) as blogtags, tagassoc.tagid
FROM zp_blog_entry AS blog
LEFT JOIN zp_blogcategory As category ON(blog.catid = category.catid)
LEFT JOIN zp_mood As mood ON(blog.moodid = mood.moodid)
LEFT JOIN zp_tagsassoc As tagassoc ON (blog.entryid = tagassoc.itemid AND
tagassoc.entity = 'ENTRY')
LEFT JOIN zp_tags As tag ON (tag.tagid = tagassoc.tagid)
LEFT JOIN zp_blogoptions As blogoptions ON(blogoptions.userid =
blog.masterid)
WHERE blog.masterid = 1
AND blog.private = 0
GROUP BY blog.entryid
ORDER BY blog.dateline DESC
LIMIT 10
mysql error:
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 '(tag.tag) as blogtags,
tagassoc.tagid
FROM zp_blog_entry A
mysql error number: 1064

This is a compatibility issue with your MySQL version: as of now we require MySQL 4.1 to be installed on your server. We're looking to see if we can bypass this requirement with alternative solutions, but for now - please don't install unless you meet the system requirements posted in the first post:

***System Requirements***

Zoints Local requires the following:

- A linux or windows based webserver. Windows in ISAPI mode is not currently supported.
- vBulletin forum software (additional platforms will be added soon).
- PHP 4.3.3 or greater.
- MySQL 4.1 or greater.
- Your server must allow port 80 post and get requests to be made to Zoints.com
- Safemode is not currently supported.