Anonymous Login
2022-12-06 06:32 PST

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001187Pending RequestsCore Infrastructurepublic2014-08-16 10:09
Assigned To 
Product Version 
Target VersionFixed in Version 
Summary0001187: Error while execute an sql statment eith non latin characters
DescriptionSQL fails while try to execute a search within date fields with non latin characters (being fully utf8 tuned) in LIKE statement. Appears in search on Events. Noo problems with latin characters.

Additional InformationERROR: /var/www/web2project/classes/w2p/Database/Query.class.php(1121) : query failed(SELECT DISTINCT(event_id),event_title,event_description,event_start_date,event_end_date FROM ((`events` AS events)) WHERE ( event_title LIKE "%??%" or event_description LIKE "%??%" or event_start_date LIKE "%??%" or event_end_date LIKE "%??%") ORDER BY event_start_date) - error was: Illegal mix of collations for operation 'like'
0 /var/www/web2project/classes/w2p/Database/Query.class.php:1121 dprint()
1 /var/www/web2project/classes/w2p/Database/Query.class.php:1158 exec()
2 /var/www/web2project/modules/smartsearch/smartsearch.class.php:35 loadList()
3 /var/www/web2project/modules/smartsearch/index.php:293 fetchResults()
4 /var/www/web2project/index.php:282 require()
TagsNo tags attached.
Attached Files


There are no notes attached to this issue.

-Issue History
Date Modified Username Field Change
2012-09-27 03:11 svsta New Issue
2012-09-27 03:15 svsta File Added: phpmyadmin 2012-09-27 15:14:14.png
2012-10-21 22:51 caseydk Project v2.4 Release (Closed) => Pending Requests
2014-08-16 10:09 caseydk Category General => Core Infrastructure
+Issue History