There is an issue that is happening on one of our Movable Type installations, and I have absolutely no idea what could be. Looking into the databases, the needed data is there, so I am suspecting that there is an issue elsewhere. Please let me know if you have any idea what could be causing this issue.
SELECT COUNT *, extract(year from visitorstats_visitor_created_on), extract(month from visitorstats_visitor_created_on), extract(day from visitorstats_visitor_created_on) FROM mt_visitorstats_visitor, mt_permission WHERE (visitorstats_visitor_created_on >= ?) AND (permission_author_id = ?) AND (permission_blog_id = entry_blog_id) GROUP BY extract(year from visitorstats_visitor_created_on), extract(month from visitorstats_visitor_created_on), extract(day from visitorstats_visitor_created_on)
The issue appears to be happening in areas that the user does not have permissions to (for instance, a blog author trying to access the system overview panel). But this is an exceptionally ugly error message. Is this a normal message (some of our other sites have a higher version that doesnt do this)
Thanks for your help!
Reported on Movable Type 4.1x
Is the SQL statement itself the error message?
Yes, it is only displaying this message, nothing else. Looking into the database, all of the fields marked with "?" is populated, so that isnt the issue.