Zaobserwowałem ten sam błąd w Ticketach przy wyszukiwaniu pprostym:
Type: E_USER_ERROR (256)
Message: mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))")
File: /var/www/epesi_test/libs/adodb/adodb-errorhandler.inc.php
Line=79
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE(\"SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))\") ", "/var/www/epesi_test/libs/adodb/adodb-errorhandler.inc.php", 79, Array ("mysqli", "EXECUTE", 1271, "Illegal mix of collations for operation 'like'", "SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))", false, Object (ADODB_mysqli), "SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))", false, "mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE(\"SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))\") "))
File: /var/www/epesi_test/libs/adodb/adodb-errorhandler.inc.php
line 79
function called: trigger_error("mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE(\"SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))\") ", 256)
File: /var/www/epesi_test/libs/adodb/adodb.inc.php
line 1235
function called: ADODB_Error_Handler("mysqli", "EXECUTE", 1271, "Illegal mix of collations for operation 'like'", "SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))", false, "Object (ADODB_mysqli)")
File: /var/www/epesi_test/libs/adodb/adodb.inc.php
line 1175
function called: _Execute("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE '%dąb%' AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE '%dąb%' AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE '%dąb%'))) AND (((NOT ((r.f_permission = '2' AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE '%\\_\\_1\\_\\_%' AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = 1 AND r.f_ticket_owner IS NOT NULL)))))")
File: /var/www/epesi_test/libs/adodb/drivers/adodb-mysqli.inc.php
line 163
function called: Execute("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE ? AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE ?))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE ? AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = ? AND r.f_ticket_owner IS NOT NULL)))))", Array ("%dąb%", "%dąb%", "%dąb%", "2", "%\_\_1\_\_%", 1))
[PHP core called function]
function called: GetOne("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE ? AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE ?))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE ? AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = ? AND r.f_ticket_owner IS NOT NULL)))))", Array ("%dąb%", "%dąb%", "%dąb%", "2", "%\_\_1\_\_%", 1))
File: /var/www/epesi_test/include/database.php
line 213
function called: call_user_func_array(Array (Object (ADODB_mysqli), "GetOne"), Array ("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE ? AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE ?))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE ? AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = ? AND r.f_ticket_owner IS NOT NULL)))))", Array (#6)))
File: /var/www/epesi_test/include/database.php
line 525
function called: call_with_retry("GetOne", Array ("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE ? AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE ? AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE ?))) AND (((NOT ((r.f_permission = ? AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE ? AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = ? AND r.f_ticket_owner IS NOT NULL)))))", Array (#6)))
File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1485
function called: GetOne("SELECT COUNT(*) FROM premium_tickets_data_1 AS r WHERE r.active=1 AND ((((r.f_title LIKE %s AND r.f_title IS NOT NULL)) OR ((r.f_ticketout LIKE %s AND r.f_ticketout IS NOT NULL)) OR (((r.f_klient IS NOT NULL AND (r.f_klient IN (7306,7307,7331,7332,7334,7335,9140,9151,9670,11022,11710,11828,12197,12249,12547,12881,12963,13043,13352,14088,14104,14230,14720,14765,14964,15168,15416))))) OR (((r.f_maszyna IS NOT NULL AND (r.f_maszyna IN (328,329,1680,1927,1944,1945,1946,2038,2039,2040,2591,2601,3238,3854,3893,3894,3987,4019))))) OR (((r.f_ticket_owner IS NOT NULL AND (r.f_ticket_owner IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR ((r.f_date LIKE %s))) AND (((NOT ((r.f_permission = %s AND r.f_permission IS NOT NULL))) OR ((r.f_assigned_to LIKE %s AND r.f_assigned_to IS NOT NULL)) OR ((r.f_ticket_owner = %d AND r.f_ticket_owner IS NOT NULL)))))", Array ("%dąb%", "%dąb%", "%dąb%", "2", "%\_\_1\_\_%", "1"))
File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 646
function called: get_records_count("premium_tickets", Object (Utils_RecordBrowser_Crits), false, Array (Array (#3), Array (#3)))
File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 328
function called: show_data(Object (Utils_RecordBrowser_Crits), Array (), Array ("ASC", "ASC"))
[PHP core called function]
function called: body()
File: /var/www/epesi_test/include/module.php
line 924
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())
File: /var/www/epesi_test/include/module.php
line 844
function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)
File: /var/www/epesi_test/modules/Premium/Projects/Tickets/Tickets_0.php
line 52
function called: display_module(Object (Utils_RecordBrowser))
[PHP core called function]
function called: body()
File: /var/www/epesi_test/include/module.php
line 924
function called: call_user_func_array(Array (Object (Premium_Projects_Tickets), "body"), Array ())
File: /var/www/epesi_test/include/module.php
line 844
function called: get_html_of_module(Object (Premium_Projects_Tickets), null, null)
File: /var/www/epesi_test/modules/Base/Box/Box_0.php
line 142
function called: display_module(Object (Premium_Projects_Tickets))
File: /var/www/epesi_test/include/epesi.php
line 246
function called: body()
File: /var/www/epesi_test/include/epesi.php
line 291
function called: go(Object (Base_Box))
File: /var/www/epesi_test/include/epesi.php
line 314
function called: process("__action_module__=%2FBase_Box%7C0%2FPremium_Projects_Tickets%7Cmain_5b86da593867a09abde7aed49b254274%2FUtils_RecordBrowser%7Cpremium_tickets%2FUtils_GenericBrowser%7Cpremium_tickets&__location=1477466373.2704", false, true)
File: /var/www/epesi_test/process.php
line 41
function called: process("_qf__libs_qf_d7857a6d62a886dede2083b45c427c4f=&submited=1&show_all_pressed=0&submit_search=Search&search=d%C4%85b&show_all=Show%20all&__action_module__=%2FBase_Box%7C0%2FPremium_Projects_Tickets%7Cmain_5b86da593867a09abde7aed49b254274%2FUtils_RecordBrowser%7Cpremium_tickets%2FUtils_GenericBrowser%7Cpremium_tickets", "")
Jak widać problem jest globalny z wyszukiwaniem polskich znaków
