1.8.0 błąd w wyszukiwaniu prostym

praski

Przy wyszukiwaniu prostym słowa z polską literą przy większej ilości kolumn w RecordBrowser.
Udało się go uzyskać w module "Szanse sprzedaży". Szukam słowa "istniejący", które występuje w polu Typ.

NIe występuje w modułach Company czy Tasks. Niestety boli mnie, bo i w moich modułach występuje.

Błąd nie występuje w szansach sprzedaży jeśli stosujemy szukanie szczegółowe.

Obrazek poniżej.

Komunikat błędu poniżej.

Type: E_USER_ERROR (256)
Message: mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE("SELECT COUNT() FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))")
File: /home/narzedzia/test1/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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))\") ", "/home/narzedzia/test1/libs/adodb/adodb-errorhandler.inc.php", 79, Array ("mysqli", "EXECUTE", 1271, "Illegal mix of collations for operation 'like'", "SELECT COUNT() FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))", false, Object (ADODB_mysqli), "SELECT COUNT() FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))", false, "mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE(\"SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))\") "))

File: /home/narzedzia/test1/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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))\") ", 256)

File: /home/narzedzia/test1/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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))", false, "Object (ADODB_mysqli)")

File: /home/narzedzia/test1/libs/adodb/adodb.inc.php
line 1175
function called: _Execute("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%istniejący%' AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%istniejący%')) OR ((r.f_data LIKE '%istniejący%')))")

File: /home/narzedzia/test1/libs/adodb/drivers/adodb-mysqli.inc.php
line 163
function called: Execute("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = ? AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE ?)) OR ((r.f_data LIKE ?)))", Array ("%istniejący%", "1", "%istniejący%", "%istniejący%"))

[PHP core called function]
function called: GetOne("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = ? AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE ?)) OR ((r.f_data LIKE ?)))", Array ("%istniejący%", "1", "%istniejący%", "%istniejący%"))

File: /home/narzedzia/test1/include/database.php
line 213
function called: call_user_func_array(Array (Object (ADODB_mysqli), "GetOne"), Array ("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = ? AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE ?)) OR ((r.f_data LIKE ?)))", Array (#4)))

File: /home/narzedzia/test1/include/database.php
line 525
function called: call_with_retry("GetOne", Array ("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = ? AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE ?)) OR ((r.f_data LIKE ?)))", Array (#4)))

File: /home/narzedzia/test1/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1482
function called: GetOne("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE %s AND r.f_opportunity_name IS NOT NULL)) OR ((false)) OR ((false)) OR (((r.f_type = %s AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE %s)) OR ((r.f_data LIKE %s)))", Array ("%istniejący%", 1, "%istniejący%", "%istniejący%"))

File: /home/narzedzia/test1/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 646
function called: get_records_count("premium_salesopportunity", Object (Utils_RecordBrowser_Crits), false, Array ())

File: /home/narzedzia/test1/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 328
function called: show_data(Object (Utils_RecordBrowser_Crits), Array (), Array ())

[PHP core called function]
function called: body()

File: /home/narzedzia/test1/include/module.php
line 924
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())

File: /home/narzedzia/test1/include/module.php
line 844
function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)

File: /home/narzedzia/test1/modules/Premium/SalesOpportunity/SalesOpportunity_0.php
line 38
function called: display_module(Object (Utils_RecordBrowser))

[PHP core called function]
function called: body()

File: /home/narzedzia/test1/include/module.php
line 924
function called: call_user_func_array(Array (Object (Premium_SalesOpportunity), "body"), Array ())

File: /home/narzedzia/test1/include/module.php
line 844
function called: get_html_of_module(Object (Premium_SalesOpportunity), null, null)

File: /home/narzedzia/test1/modules/Base/Box/Box_0.php
line 142
function called: display_module(Object (Premium_SalesOpportunity))

File: /home/narzedzia/test1/include/epesi.php
line 246
function called: body()

File: /home/narzedzia/test1/include/epesi.php
line 291
function called: go(Object (Base_Box))

File: /home/narzedzia/test1/include/epesi.php
line 314
function called: process("action_module=%2FBase_Box%7C0%2FPremium_SalesOpportunity%7Cmain_7e031bb0c4ba75ef95efe0178ea6f69d%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity&__location=1475236207.3632", false, true)

Pozdrawiam
Praski

ajb

Problem wynika z różnych collation. Możliwe, że collation połączenia jest inne niż collation tabeli.
Wklej wynik wykonania w EPESI shell (/admin -> Run php command) tego:

return DB::GetAll('SHOW VARIABLES LIKE %s', array('%collat%'));

W EPESI baza i wszystkie tabele poza tymi z roundcube powinny mieć charset=utf8 i collation=utf8_unicode_ci albo utf8_general_ci

Pozdrawiam i przepraszam za laga w odpowiedzi spowodowanego urlopem.

praski

WYchodzi:

array(3) {
[0]=>
array(4) {
[0]=>
string(20) "collation_connection"
["Variable_name"]=>
string(20) "collation_connection"
[1]=>
string(15) "utf8_general_ci"
["Value"]=>
string(15) "utf8_general_ci"
}
[1]=>
array(4) {
[0]=>
string(18) "collation_database"
["Variable_name"]=>
string(18) "collation_database"
[1]=>
string(15) "utf8_general_ci"
["Value"]=>
string(15) "utf8_general_ci"
}
[2]=>
array(4) {
[0]=>
string(16) "collation_server"
["Variable_name"]=>
string(16) "collation_server"
[1]=>
string(17) "latin1_swedish_ci"
["Value"]=>
string(17) "latin1_swedish_ci"
}
}
Wydaje się, że jest OK. Ten latin1 na collation_server nie powinien być tu problemem, a przynajmniej we wczesniejszych wersjach nie był.

Pozdrawiam
Praski.

ajb

pytanie jaki collation ma tabela premium_salesopportunity_data_1

return DB::GetRow('SHOW TABLE STATUS LIKE %s', array('premium_salesopportunity_data_1'));

praski

utf8_unicode_ci.
To nie to. Obserwuję problem w kilku miejscach.

Wrzuciłem to bezpośrednio na MySQL.

Problem jest w ostatnim warunku
r.f_data LIKE '%istniejący%'

Kiedy usuniesz z niego polską literę nie zgłasza błędu. Kiedy dodasz dowolną zgłasza. U mnie f_data ma wyłącznie wartość null na wszystkich rekordach.

ajb

Ok, jest różnica z collation general vs unicode, ale myślałem że to nie powinno być problemem.
Może jednak collation_server=latin1_swedish_ci ma znaczenie.

Spróbuj w zapytaniu dodać COLLATE i przetestować różne collation.

SELECT ... WHERE (r.f_data LIKE '%istniejący%' COLLATE utf8_unicode_ci) ...

SELECT ... WHERE (r.f_data LIKE '%istniejący%' COLLATE utf8_general_ci) ...

SELECT ... WHERE (r.f_data LIKE '%istniejący%' COLLATE latin1_swedish_ci) ...

wg moich oczekiwać dwa pierwsze powinny zadziałać (u mnie na mariadb działają), a ostatnie rzucić błędem.

praski

Wszystkie trzy poszły z błędem dopóki była polska litera.
Zamiana ą na a w "istniejący" generuje 2 pierwsze wyniki poprawne a trzeci na latin1_swedish_ci błędem

#1253 - COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

Co jest dość rozsądnym komunikatem ;-)

W moim przypadku problem jest w NULL'u i traktowaniu go like'm.
Jak napisałem f_data może przyjmować NULL.

Wystarczy zrobić
SELECT ... WHERE (ifnull(r.f_data,'') LIKE '%istniejący%') ...
i kwerenda działa.

Aczkolwiek wcale nie musi to oznaczać rozwiązania problemu.

Pozdrawiam
Praski.

ajb

A jaka jest definicja tego pola data? Bo ja nie mam takiego pola, to musi być coś dodane przez Ciebie.

show create table premium_salesopportunity_data_1;
select * from premium_salesopportunity_field;

praski

Masz rację - nie ma takiego pola. Aby było to powtarzalne to podszedłem bardziej metodycznie:

Odinstalowałem SalesOpportunity (był 1.7.2.2).
Wylogowałem się epesi
Zalogowalem sie
Zainstalowałem SalesOpportunity v 1.8.0
Dodałem standardowy nowy rekord, aby coś było.
Wyszukałem literkę "ą"
Znalazł bez błędu.
Wszedłem do administrator->Przeglądarka rekordów->Sprzedaż (premium_salesppportunity)
Dodałem nowe pole "Jakas data" typ danych "Data" i nic poza tym.
Wszedłem do modułu SalesOpportunity
Teraz wyszukałem ą
Błąd poniższy.

Type: E_USER_ERROR (256)
Message: mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_opportunity_name LIKE '%ą%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (1,2,3,4,5,6,7,8,10,11,12,13,14,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,52,53,54,55,56,57,58,59,60,61,62,63,65,66))))) OR (((r.f_employees IS NOT NULL AND (r.f_employees LIKE '%__1__%' OR r.f_employees LIKE '%__2__%' OR r.f_employees LIKE '%__3__%' OR r.f_employees LIKE '%__4__%' OR r.f_employees LIKE '%__5__%' OR r.f_employees LIKE '%__6__%' OR r.f_employees LIKE '%__7__%' OR r.f_employees LIKE '%__8__%' OR r.f_employees LIKE '%__10__%' OR r.f_employees LIKE '%__11__%' OR r.f_employees LIKE '%__12__%' OR r.f_employees LIKE '%__13__%' OR r.f_employees LIKE '%__14__%' OR r.f_employees LIKE '%__16__%' OR r.f_employees LIKE '%__17__%' OR r.f_employees LIKE '%__18__%' OR r.f_employees LIKE '%__20__%' OR r.f_employees LIKE '%__21__%' OR r.f_employees LIKE '%__22__%' OR r.f_employees LIKE '%__23__%' OR r.f_employees LIKE '%__24__%' OR r.f_employees LIKE '%__25__%' OR r.f_employees LIKE '%__26__%' OR r.f_employees LIKE '%__27__%' OR r.f_employees LIKE '%__28__%' OR r.f_employees LIKE '%__29__%' OR r.f_employees LIKE '%__30__%' OR r.f_employees LIKE '%__31__%' OR r.f_employees LIKE '%__32__%' OR r.f_employees LIKE '%__33__%' OR r.f_employees LIKE '%__34__%' OR r.f_employees LIKE '%__35__%' OR r.f_employees LIKE '%__36__%' OR r.f_employees LIKE '%__37__%' OR r.f_employees LIKE '%__38__%' OR r.f_employees LIKE '%__39__%' OR r.f_employees LIKE '%__40__%' OR r.f_employees LIKE '%__41__%' OR r.f_employees LIKE '%__42__%' OR r.f_employees LIKE '%__43__%' OR r.f_employees LIKE '%__44__%' OR r.f_employees LIKE '%__45__%' OR r.f_employees LIKE '%__46__%' OR r.f_employees LIKE '%__47__%' OR r.f_employees LIKE '%__48__%' OR r.f_employees LIKE '%__49__%' OR r.f_employees LIKE '%__50__%' OR r.f_employees LIKE '%__52__%' OR r.f_employees LIKE '%__53__%' OR r.f_employees LIKE '%__54__%' OR r.f_employees LIKE '%__55__%' OR r.f_employees LIKE '%__56__%' OR r.f_employees LIKE '%__57__%' OR r.f_employees LIKE '%__58__%' OR r.f_employees LIKE '%__59__%' OR r.f_employees LIKE '%__60__%' OR r.f_employees LIKE '%__61__%' OR r.f_employees LIKE '%__62__%' OR r.f_employees LIKE '%__63__%' OR r.f_employees LIKE '%__65__%' OR r.f_employees LIKE '%__66__%')))) OR (((r.f_type = '1' AND r.f_type IS NOT NULL))) OR ((r.f_contract_amount LIKE '%ą%')) OR ((r.f_jakas_data LIKE '%ą%')))")
File: /home/narzedzia/test1/libs/adodb/adodb-errorhandler.inc.php
Line=79
... itd

Teraz ponownie wszedłem do administrator->Przeglądarka rekordów->Sprzedaż (premium_salesppportunity)
zablokowałem nowe pole "Jakas data"
Wszedłem do modułu SalesOpportunity
wyszukałem ą -> bez błędu.

Teraz ponownie wszedłem do administrator->Przeglądarka rekordów->Sprzedaż (premium_salesppportunity)
Dodałem nowe pole tym razem typu text długość 43
Wszedłem do modułu SalesOpportunity
wyszukałem ą -> bez błędu.

Teraz ponownie wszedłem do administrator->Przeglądarka rekordów->Sprzedaż (premium_salesppportunity)
Odblokowałem pole Jakas Data
Wszedłem do modułu SalesOpportunity
wyszukałem ą -> I znowu pokazał się powyższy błąd.

Zobacz czy u siebie powtórzysz i dlaczego pole typu Data rozwala to.

Pozdrawiam
Praski.

ajb

Hm... no ja nie mam błędu...

MariaDB [epesi]> show variables like '%colla%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_unicode_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

Tabela sales op

CREATE TABLE `premium_salesopportunity_data_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `indexed` tinyint(4) DEFAULT '0',
  `active` tinyint(4) DEFAULT '1',
  `f_opportunity_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `f_opportunity_manager` int(11) DEFAULT NULL,
  `f_employees` text COLLATE utf8_unicode_ci,
  `f_customers` text COLLATE utf8_unicode_ci,
  `f_type` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `f_lead_source` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `f_probability____` int(11) DEFAULT NULL,
  `f_status` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `f_start_date` date DEFAULT NULL,
  `f_follow_up_date` date DEFAULT NULL,
  `f_close_date` date DEFAULT NULL,
  `f_contract_amount` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `f_description` text COLLATE utf8_unicode_ci,
  `f_sales_op` int(11) DEFAULT NULL,
  `f_data_realizacji` datetime DEFAULT NULL,
  `f_jakas_data` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `premium_salesopportunity_idxed` (`indexed`,`active`),
  KEY `premium_salesopportunity_act` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=2198 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Szukanie 'ą' z debug SQL_TIMES:

GetOne array ( 0 => 'SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_employees LIKE ? AND r.f_employees IS NOT NULL)) AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (1))))) OR (((r.f_employees IS NOT NULL AND (r.f_employees LIKE \'%\\_\\_1\\_\\_%\')))) OR ((r.f_contract_amount LIKE ?)) OR (((r.f_sales_op LIKE ? AND r.f_sales_op IS NOT NULL))) OR ((r.f_jakas_data LIKE ?))))', 1 => array ( 0 => '%\\_\\_1\\_\\_%', 1 => '%ą%', 2 => '%ą%', 3 => '%ą%', 4 => '%ą%', ), ) 0.0038, Called by Utils_RecordBrowserCommon::get_records_count, File '/srv/http/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php: 646
SelectLimit array ( 0 => 'SELECT r.* FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND ((false OR (r.f_employees LIKE ? AND r.f_employees IS NOT NULL)) AND (((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (1))))) OR (((r.f_employees IS NOT NULL AND (r.f_employees LIKE \'%\\_\\_1\\_\\_%\')))) OR ((r.f_contract_amount LIKE ?)) OR (((r.f_sales_op LIKE ? AND r.f_sales_op IS NOT NULL))) OR ((r.f_jakas_data LIKE ?))))', 1 => '50', 2 => 0, 3 => array ( 0 => '%\\_\\_1\\_\\_%', 1 => '%ą%', 2 => '%ą%', 3 => '%ą%', 4 => '%ą%', ), ) 0.0008, Called by Utils_RecordBrowserCommon::get_records, File '/srv/http/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php: 673

bez błedu...

eltonik

Witam Panowie.
Jakieś postępy? Szykuję się do upgradu na 1.8 i jak na razie wszysto działa za wyjątkiem tego błędu

praski

Eltonik - Ale potwierdzasz, że u Ciebie też występuje?

Pozdrawiam
Praski

eltonik

Tak, brak wyszukiwania polskich znaków w sales opportunity

Type: E_USER_ERROR (256)
Message: mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))") 
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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))\") ", "/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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))", false, Object (ADODB_mysqli), "SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))", false, "mysqli error: [1271: Illegal mix of collations for operation 'like'] in EXECUTE(\"SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))\") "))

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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))\") ", 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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))", false, "Object (ADODB_mysqli)")

File: /var/www/epesi_test/libs/adodb/adodb.inc.php
    line 1175
    function called: _Execute("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE '%dąb%' AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE '%dąb%' AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE '%dąb%')) OR ((r.f_follow_up_date LIKE '%dąb%')) OR ((r.f_close_date LIKE '%dąb%')) OR ((r.f_contract_amount LIKE '%dąb%')) OR ((false)) OR ((r.f_konkurencja LIKE '%dąb%' AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE '%dąb%')))")

File: /var/www/epesi_test/libs/adodb/drivers/adodb-mysqli.inc.php
    line 163
    function called: Execute("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE ? AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE ?)) OR ((r.f_follow_up_date LIKE ?)) OR ((r.f_close_date LIKE ?)) OR ((r.f_contract_amount LIKE ?)) OR ((false)) OR ((r.f_konkurencja LIKE ? AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE ?)))", Array ("%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%"))

[PHP core called function]
    function called: GetOne("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE ? AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE ?)) OR ((r.f_follow_up_date LIKE ?)) OR ((r.f_close_date LIKE ?)) OR ((r.f_contract_amount LIKE ?)) OR ((false)) OR ((r.f_konkurencja LIKE ? AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE ?)))", Array ("%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%"))

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_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE ? AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE ?)) OR ((r.f_follow_up_date LIKE ?)) OR ((r.f_close_date LIKE ?)) OR ((r.f_contract_amount LIKE ?)) OR ((false)) OR ((r.f_konkurencja LIKE ? AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE ?)))", Array (#8)))

File: /var/www/epesi_test/include/database.php
    line 525
    function called: call_with_retry("GetOne", Array ("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE ? AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE ? AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE ?)) OR ((r.f_follow_up_date LIKE ?)) OR ((r.f_close_date LIKE ?)) OR ((r.f_contract_amount LIKE ?)) OR ((false)) OR ((r.f_konkurencja LIKE ? AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE ?)))", Array (#8)))

File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
    line 1484
    function called: GetOne("SELECT COUNT(*) FROM premium_salesopportunity_data_1 AS r WHERE r.active=1 AND (((r.f_numerbo LIKE %s AND r.f_numerbo IS NOT NULL)) OR ((r.f_opportunity_name LIKE %s AND r.f_opportunity_name IS NOT NULL)) OR (((r.f_opportunity_manager IS NOT NULL AND (r.f_opportunity_manager IN (840,870,871,872,873,875,876,877,878,879,880,881,882,884,886,6510,8094,8737,8747,8962))))) OR (((r.f_customers2 IS NOT NULL AND (r.f_customers2 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_start_date LIKE %s)) OR ((r.f_follow_up_date LIKE %s)) OR ((r.f_close_date LIKE %s)) OR ((r.f_contract_amount LIKE %s)) OR ((false)) OR ((r.f_konkurencja LIKE %s AND r.f_konkurencja IS NOT NULL)) OR ((r.f_datamontazu LIKE %s)))", Array ("%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%", "%dąb%"))

File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowser_0.php
    line 646
    function called: get_records_count("premium_salesopportunity", Object (Utils_RecordBrowser_Crits), false, Array ())

File: /var/www/epesi_test/modules/Utils/RecordBrowser/RecordBrowser_0.php
    line 328
    function called: show_data(Object (Utils_RecordBrowser_Crits), Array (), Array ())

[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/SalesOpportunity/SalesOpportunity_0.php
    line 38
    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_SalesOpportunity), "body"), Array ())

File: /var/www/epesi_test/include/module.php
    line 844
    function called: get_html_of_module(Object (Premium_SalesOpportunity), null, null)

File: /var/www/epesi_test/modules/Base/Box/Box_0.php
    line 142
    function called: display_module(Object (Premium_SalesOpportunity))

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_SalesOpportunity%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity&__location=1477376103.9894", false, true)

File: /var/www/epesi_test/include/epesi.php
    line 314
    function called: process("__action_module__=%2FBase_Box%7C0%2FPremium_SalesOpportunity%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity&__location=1477376103.7481", false, true)

File: /var/www/epesi_test/process.php
    line 41
    function called: process("_qf__libs_qf_5d8c6b24c7d47c6b8f9b0f3a77345f8d=&submited=1&show_all_pressed=0&submit_search=Search&search=d%C4%85b&show_all=Show%20all&__action_module__=%2FBase_Box%7C0%2FPremium_SalesOpportunity%7Cmain_0%2FUtils_RecordBrowser%7Cpremium_salesopportunity%2FUtils_GenericBrowser%7Cpremium_salesopportunity", "")

praski

Eltonik - też dodałeś pole data (datamontazu).
Adam - czyli jest nie tylko u mnie.
Pytanie co się zmieniło od EPESI 1.7.2 gdzie ten błąd nie występował na tej samej bazie danych.

eltonik

Nie mam bladego pojęcia, to pytanie do Adama, jeśli chodzi o kodowanie to na wszystkich tabelach i na bazie mam utf8_unicode_ci

praski

A na serwerze MySQL?

Adam.
Na bazie gdzie występuje błąd mam efekt zapytania: show variables like '%colla%';
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci

Ale mam drugi hosting u zupełnie innego providera i tam błąd nie wystepuje, ale collaction mam:

collation_connection utf8mb4_polish_ci
collation_database utf8_unicode_ci
collation_server utf8_polish_ci

Pytanie dlaczego do wersji 1.7.2 to działało, a od wersji 1.8.0 generuje błędy. Coś się musiało w EPESI zmienić.
Eltonik a jak u ciebie odpowiedź na show variables like '%colla%'; (głównie chodzi o collation_server)

Pozdrawiam
Praski.

eltonik

U mnie jest tak:
collation_connection utf8mb4_general_ci
collation_database utf8_polish_ci
collation_server latin1_swedish_ci

Właśnie zmieniam na drugiej bazie testowej całość na utf8_polish_ci, chwilę to trwa bo baza strasznie duża

ajb

Ustawiłem u siebie collation_server na latin1_swedish_ci i nadal nie mam błędu.
Nikt z was nie wkleił mi SHOW CREATE TABLE premium_salesopportunity_data_1. Będę szukać błędu, ale na razie wszystkie moje próby odtworzenia nie działają.

I jeszcze poproszę o show variables like '%chara%'.

eltonik

show variables like '%chara%'.:

character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8
character_set_filesystem binary
character_set_results utf8mb4
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

SHOW CREATE TABLE premium_salesopportunity_data_1

premium_salesopportunity_data_1 CREATE TABLE premium_salesopportunity_data_1 (
id int(11) NOT NULL AUTO_INCREMENT,
created_on datetime DEFAULT NULL,
created_by int(11) DEFAULT NULL,
active tinyint(4) DEFAULT '1',
f_opportunity_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_opportunity_manager int(11) DEFAULT NULL,
f_employees text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
f_customers text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
f_type varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_lead_source varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_status varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_start_date date DEFAULT NULL,
f_follow_up_date date DEFAULT NULL,
f_close_date date DEFAULT NULL,
f_contract_amount varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_description text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
f_producent tinyint(4) DEFAULT NULL,
f_typ_maszyny tinyint(4) DEFAULT NULL,
f_maszynyuzywane tinyint(4) DEFAULT NULL,
f_maszyna int(11) DEFAULT NULL,
f_maszynazaplacona tinyint(4) DEFAULT NULL,
f_datamontazu date DEFAULT NULL,
indexed tinyint(4) DEFAULT '0',
f_zaliczka tinyint(4) DEFAULT NULL,
f_konkurencja varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_numerbo varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_customers2 text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
f_probability____ int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY premium_salesopportunity_idxed (indexed,active),
KEY premium_salesopportunity_act (active)
) ENGINE=InnoDB AUTO_INCREMENT=19009 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci
Drukuj

eltonik

to zmieniłem z "palca"
ENGINE=InnoDB AUTO_INCREMENT=19009 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge