default userpic

SQL statement as an error when trying to access system overview

Vote 0 Votes

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

2 Replies

| Add a Reply

Add a Reply

If you need to share template code, replace all the "<" signs with "&lt;" or use this utility.

Forum Groups

1773 6162

Last Topic: Excluding categories from blog by kholechek on Feb 9, 2012

86 302

Last Topic: website entries by masoud on Oct 26, 2011

1429 5077

Last Topic: What apocalypse hit this community in the middle of 2011? by 75th on Feb 10, 2012

695 2910

Last Topic: Insert Image / File Fails by Russ Miller on Feb 10, 2012

84 291

Last Topic: How to have some other characters in entry basename automatically written by Afshin Haghighatnia on Dec 22, 2011

173 737

Last Topic: About the MT version stated in HTML source by Alex E. Schneider on Feb 7, 2012

190 567

Last Topic: Analytics Reporting by michael webster on Feb 5, 2012

48 210

Last Topic: An idea and also a request by Afshin Haghighatnia on Jun 29, 2011

64 246

Last Topic: jQuery in MT 5.1 still at 1.4 - why? by perlmonkey on May 25, 2011

code.sixapart.com

137 478

Last Topic: Getting a thumbnail with xpath by Peter on Mar 13, 2011

222 720

Last Topic: Custom Field for Asset Not Appearing by android on Feb 9, 2012