error on statement on local server

[sjhf]

I'm testing locally and got the following error. I'm stumped because this same
page runs fine on the actual server running exactly the same: CF MX 6.1 and
MySQL 4.1.1.

Any ideas? All other pages running from this system seem to be fine. It was
just this one.

Thanks!

Syntax error or access violation: 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 'SELECT SiteTypeID FROM SeasonDates INNER JOIN Seasons

Can the code area this refers to is below:

SELECT SiteTypeID, Name
FROM SiteTypes
WHERE CampID = #Session.CampID#
AND IsActive <> 0
AND SiteTypeID IN (
SELECT SiteTypeID
FROM SeasonDates
INNER JOIN Seasons
ON SeasonDates.SeasonID = Seasons.SeasonID
WHERE IsActive <> 0
)
ORDER BY SortBy

[adonis1976]

it is a permission issue on the local.. make sure u have right permission..

[See4th]

Are you referring to MySql user permissions or NTFS system permissions?