I have been using Profile Manager and Search Plugin together and they were doing great. However, just now I re-installed Elgg ver 1.9 and now using both of these plugins simultaneously gives me a fatal error regarding my sql syntax as given below. Can anyone guide me out of this 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 ') AND msv.string LIKE '%m%'))) AND ((e.type = 'user')) AND (e.site_guid IN (1)' at line 1
QUERY: SELECT count(DISTINCT e.guid) as total FROM elgg_entities e WHERE (((ue.username LIKE '%m%' OR ue.name LIKE '%m%')) OR ((() AND msv.string LIKE '%m%'))) AND ((e.type = 'user')) AND (e.site_guid IN (1)) AND ((1 = 1) AND (e.enabled = 'yes'))
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Wincent Nobel@Wincent
Wincent Nobel - 0 likes
- Evan Winslow@ewinslow
Evan Winslow - 0 likes
- Wincent Nobel@Wincent
Wincent Nobel - 0 likes
- Matt Beckett@Beck24
Matt Beckett - 0 likes
- Wincent Nobel@Wincent
Wincent Nobel - 0 likes
You must log in to post replies.Well, I resolved it myself. QED
It might be helpful to others in the future if you explain what you did to fix it.
Well, I just simply commented the code under database.php that was creating this problem at line 366. Now, it works like a charm.
/*if (mysql_errno($dblink)) {
throw new DatabaseException(mysql_error($dblink) . "\n\n QUERY: $query");
}*/
That is not a valid fix for this issue, the issue is in fact an invalid query - note the empty parentheses in the OR statement. Removing the exception does not fix the problem.
Well I do know that it ain't the valid fix for it, but it worked out, at least for now. however, I'd be glad to hear the exact solution for this.