This is the query your having an issue with
Content visible to verified customers only.
I would suspect that you incorrectly installed like wrong table prefix maybe. For example my prefix is xf_ and there is an xf_option table on my install. The query seems valid so please check your site and let me know. A community photo gallery - My Photo Gallery Main Index - PhotoPost Classifieds
I have two separate installs there.
If you want me to look at your site you would need to send a url admin login and ftp through the contact us link.
I would suspect your seeing this query error because your on the login page and thats the first thing that pops up.