Jump to content


Photo

[this site] Profile -> Likes --> Calendar -> Received


community.invisionpower.com Driver Error


:)

Status: Fixed
Version: 3.3.0
Fixed In: 3.3.0


1 Comments

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			   |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'