Witam
Mam problem z przeniesieniem bazy lmsa z jednej bazy do drugiej. Niby wszystko działa a jednak mam krzaki i problemy z sortowaniem klientów.
Na serwerze z nową bazą jest Slack 11. Sam lms stoi również na tym serwerze (przełączam się tylko konfigiem z jednej bazy na drugą. Najpierw zrobiłem kopię bezpieczeństwa. Sprawdziłem ją i wygląda, że jest UTF-8
Zgodnie z instrukcją zapodałem localedef -v -c -i pl_PL -f UTF-8 /usr/share/locale/pl_PL.UTF-8 i dostałem taką listę komunikatów:
/usr/share/i18n/locales/pl_PL:24: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:25: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:26: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:28: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:31: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:32: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:33: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:34: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:36: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:37: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:38: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:39: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:40: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:41: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:42: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:43: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:44: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:45: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:46: non-symbolic character value should not be used /usr/share/i18n/locales/i18n:1107: non-symbolic character value should not be used /usr/share/i18n/locales/i18n:1313: non-symbolic character value should not be used /usr/share/i18n/locales/i18n:1345: non-symbolic character value should not be used /usr/share/i18n/locales/i18n:1373: non-symbolic character value should not be used /usr/share/i18n/locales/pl_PL:2119: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:10: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:11: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:12: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:13: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:14: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:15: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:16: non-symbolic character value should not be used /usr/share/i18n/locales/translit_neutral:17: non-symbolic character value should not be used LC_NAME: field `name_gen' not defined LC_NAME: field `name_mr' not defined LC_NAME: field `name_mrs' not defined LC_NAME: field `name_miss' not defined LC_NAME: field `name_ms' not defined LC_ADDRESS: field `country_name' not defined LC_ADDRESS: field `country_post' not defined LC_ADDRESS: field `country_car' not defined LC_ADDRESS: field `country_isbn' not defined LC_ADDRESS: field `lang_name' not defined LC_ADDRESS: field `lang_term' not defined LC_ADDRESS: field `lang_ab' not defined LC_TELEPHONE: field `int_select' not defined LC_IDENTIFICATION: field `audience' not defined LC_IDENTIFICATION: field `application' not defined LC_IDENTIFICATION: field `abbreviation' not defined LC_IDENTIFICATION: no identification for category `LC_MEASUREMENT' LC_CTYPE: table for class "upper": 1564 bytes LC_CTYPE: table for class "lower": 1564 bytes LC_CTYPE: table for class "alpha": 3616 bytes LC_CTYPE: table for class "digit": 600 bytes LC_CTYPE: table for class "xdigit": 600 bytes LC_CTYPE: table for class "space": 792 bytes LC_CTYPE: table for class "print": 5144 bytes LC_CTYPE: table for class "graph": 5144 bytes LC_CTYPE: table for class "blank": 792 bytes LC_CTYPE: table for class "cntrl": 664 bytes LC_CTYPE: table for class "punct": 4120 bytes LC_CTYPE: table for class "alnum": 3616 bytes LC_CTYPE: table for class "combining": 2076 bytes LC_CTYPE: table for class "combining_level3": 2076 bytes LC_CTYPE: table for map "toupper": 14364 bytes LC_CTYPE: table for map "tolower": 12828 bytes LC_CTYPE: table for map "totitle": 14364 bytes LC_CTYPE: table for width: 22744 bytes
Założyłem bazę zgodnie z dokumentacją, wrzuciłem dane z backupa
Na starym serwerze jest Slack 10.2 Info o LMS pokazuje: Wersja LMS: 1.9-cvs (1.779/1.16) Wersja LMSDB: 1.9-cvs (core: 1.38 / driver: mysql 1.37) Wersja MySQL: 4.0.23a Wersja PHP: 4.4.4 Wersja Smarty: 2.6.12
Na nowym pokazuje: Wersja LMS: 1.9-cvs (1.779/1.16) Wersja LMSDB: 1.9-cvs (core: 1.38 / driver: mysql 1.37) Wersja MySQL: 5.0.24a Wersja PHP: 4.4.4 Wersja Smarty: 2.6.12
Na starym wszystko jest ok. Na nowym mysql jest problem z polskimi znakami w nazwiskach problem głównie z Ś Ń i dziwacznie sortuje. Np nazwiska na Ż mam na początku przed A. Jeśli edytuję nazwisko z Ś to w polu edycji jest prawidłowo a po zapisaniu krzaczek
Co jeszcze można sprawdzić?
Pozdrowienia Tomek
---------------------------------------------------- NIEWYGODNA PRAWDA - wstrząsający dokument nominowany do Oscara - od 16 lutego w kinach Cinema City Sadyba w Warszawie, Kinepolis w Poznaniu i Plaza w Krakowie. Zobacz więcej: http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Fcos.html&si...
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms