Have you tried to install any mods or anything? I don't know any other way that would cause a syntax error like this unless the database your host is using may have changed slightly or they upgraded MySQL to a version that has a slightly different SQL command.
No longer supporting phpBB. PM or email me regarding support and you will be ignored. I'm fully done with phpBB and everything.