Issue information
-
#035523
-
Fixed
-
3.3.0
-
3.3.0
-
5 - Critical
Issue Confirmations
-
Yes (0)No (0)
0
[this site] Profile -> Likes --> Calendar -> Received
Posted by Lazek on 24 January 2012 - 10:22 AM
community.invisionpower.com Driver Error
changed status to: Confirmed - General,
changed severity to: 4 - High,
moved issue from IP.Board 3.x
Just had the same issue locally, the problem is the group by in the query:
mySQL query error: SELECT count(*) as dracula FROM reputation_index r LEFT JOIN reputation_cache rc ON ( rc.app=r.app AND rc.type=r.type AND rc.type_id=r.type_id ) LEFT JOIN cal_event_comments c ON ( r.type="comment_id" AND r.type_id=c.comment_id ) LEFT JOIN cal_events e ON ( e.event_id = IFNULL(c.comment_eid, r.type_id) ) WHERE r.app='calendar' AND ( ( r.type='event_id' AND e.event_member_id=2 ) OR ( r.type='comment_id' AND c.comment_mid ) AND e.event_id<>0 AND ( ( FIND_IN_SET(1,e.event_calendar_id) OR FIND_IN_SET(2,e.event_calendar_id) ) ) GROUP BY r.app, r.type, r.type_id SQL error: 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 'GROUP BY r.app, r.type, r.type_id' at line 3 SQL error code: 1064 Date: Friday 03rd February 2012 11:54:28 AM ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 03 Feb 2012 11:54:28 +0000 Error: 1064 - 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 'GROUP BY r.app, r.type, r.type_id' at line 3 IP Address: 127.0.0.1 - /user/2-test/page__tab__reputation__app_tab__calendar__type__received ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT count(*) as dracula FROM reputation_index r LEFT JOIN reputation_cache rc ON ( rc.app=r.app AND rc.type=r.type AND rc.type_id=r.type_id ) LEFT JOIN cal_event_comments c ON ( r.type="comment_id" AND r.type_id=c.comment_id ) LEFT JOIN cal_events e ON ( e.event_id = IFNULL(c.comment_eid, r.type_id) ) WHERE r.app='calendar' AND ( ( r.type='event_id' AND e.event_member_id=2 ) OR ( r.type='comment_id' AND c.comment_mid ) AND e.event_id<>0 AND ( ( FIND_IN_SET(1,e.event_calendar_id) OR FIND_IN_SET(2,e.event_calendar_id) ) ) GROUP BY r.app, r.type, r.type_id .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | XXXXXXXXXXXXXXXXXXXX\admin\applications\members\modules_public\profile\view.php| [profile_reputation].return_html_block | 490 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | XXXXXXXXXXXXXXXXXXXX\admin\applications\members\modules_public\profile\view.php| [public_members_profile_view]._viewModern | 73 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | XXXXXXXXXXXXXXXXXXXX\admin\sources\base\ipsController.php | [public_members_profile_view].doExecute | 302 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
1 user(s) are reading this issue
0 members, 1 guests, 0 anonymous users
