Zawartość artykułu
Jak się objawia problem?
Niekiedy po aktualizacji sklepu PrestaShop do nowszej wersji możemy natrafić na problem z angielskimi zakładkami w adminie:
Co dziwne – inne tłumaczenia w interface są w pełni wprowadzone. Aktualizacja języka nic nie daje i tak na prawdę trzeba by było ręcznie to tłumaczyć..
Na szczęście wystarczy tutaj 1 zapytanie do bazy danych;)
Ustalenie ID języka polskiego i dostępów do bazy.
Na początek wejdź w dział:
International -> Languages
I ustal ID języka.
Po czym pobierz dane do logowania do MySQL z pliku:
app/config/parameters.php
Ustal u Twojego admina serwera jaki jest adres do narzędzia PhpMyAdmin. Zaloguj sie tam i wybierz bazę Twojego sklepu.
Nazwę bazy sklepu ustalisz na zakładce: Advanced Parameters -> Information
Wykonanie zapytania SQL
Przed wykonaniem zapytania wykonaj kopię bezpieczeństwa:
Advanced Parameters -> Database -> DB Backup
Wykonaj następnie zapytanie:
UPDATE `ps_tab_lang` SET `name` = 'Pulpit' WHERE `id_lang` = 1 AND `name` = 'Dashboard'; UPDATE `ps_tab_lang` SET `name` = 'Sprzedaż' WHERE `id_lang` = 1 AND `name` = 'Sell'; UPDATE `ps_tab_lang` SET `name` = 'Zamówienia' WHERE `id_lang` = 1 AND `name` = 'Orders'; UPDATE `ps_tab_lang` SET `name` = 'Zamówienia' WHERE `id_lang` = 1 AND `name` = 'Orders'; UPDATE `ps_tab_lang` SET `name` = 'Faktury' WHERE `id_lang` = 1 AND `name` = 'Invoices'; UPDATE `ps_tab_lang` SET `name` = 'Druki kredytowe' WHERE `id_lang` = 1 AND `name` = 'Credit Slips'; UPDATE `ps_tab_lang` SET `name` = 'Druk wysyłki' WHERE `id_lang` = 1 AND `name` = 'Delivery Slips'; UPDATE `ps_tab_lang` SET `name` = 'Koszyki zakupowe' WHERE `id_lang` = 1 AND `name` = 'Shopping Carts'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Catalog'; UPDATE `ps_tab_lang` SET `name` = 'Produkty' WHERE `id_lang` = 1 AND `name` = 'Products'; UPDATE `ps_tab_lang` SET `name` = 'Kategorie' WHERE `id_lang` = 1 AND `name` = 'Categories'; UPDATE `ps_tab_lang` SET `name` = 'Monitorowanie' WHERE `id_lang` = 1 AND `name` = 'Monitoring'; UPDATE `ps_tab_lang` SET `name` = 'Atrybuty & Cechy' WHERE `id_lang` = 1 AND `name` = 'Attributes & Features'; UPDATE `ps_tab_lang` SET `name` = 'Atrybuty' WHERE `id_lang` = 1 AND `name` = 'Attributes'; UPDATE `ps_tab_lang` SET `name` = 'Funkcje' WHERE `id_lang` = 1 AND `name` = 'Features'; UPDATE `ps_tab_lang` SET `name` = 'Marki & Dostawcy' WHERE `id_lang` = 1 AND `name` = 'Brands & Suppliers'; UPDATE `ps_tab_lang` SET `name` = 'Marki' WHERE `id_lang` = 1 AND `name` = 'Brands'; UPDATE `ps_tab_lang` SET `name` = 'Dostawcy' WHERE `id_lang` = 1 AND `name` = 'Suppliers'; UPDATE `ps_tab_lang` SET `name` = 'Pliki' WHERE `id_lang` = 1 AND `name` = 'Files'; UPDATE `ps_tab_lang` SET `name` = 'Rabaty' WHERE `id_lang` = 1 AND `name` = 'Discounts'; UPDATE `ps_tab_lang` SET `name` = 'Kody rabatowe' WHERE `id_lang` = 1 AND `name` = 'Cart Rules'; UPDATE `ps_tab_lang` SET `name` = 'Reguły cenowe katalogu' WHERE `id_lang` = 1 AND `name` = 'Catalog Price Rules'; UPDATE `ps_tab_lang` SET `name` = 'Stocks' WHERE `id_lang` = 1 AND `name` = 'Stocks'; UPDATE `ps_tab_lang` SET `name` = 'Klienci' WHERE `id_lang` = 1 AND `name` = 'Customers'; UPDATE `ps_tab_lang` SET `name` = 'Klienci' WHERE `id_lang` = 1 AND `name` = 'Customers'; UPDATE `ps_tab_lang` SET `name` = 'Adresy' WHERE `id_lang` = 1 AND `name` = 'Addresses'; UPDATE `ps_tab_lang` SET `name` = 'Saldo' WHERE `id_lang` = 1 AND `name` = 'Outstanding'; UPDATE `ps_tab_lang` SET `name` = 'Obsługa klienta' WHERE `id_lang` = 1 AND `name` = 'Customer Service'; UPDATE `ps_tab_lang` SET `name` = 'Obsługa klienta' WHERE `id_lang` = 1 AND `name` = 'Customer Service'; UPDATE `ps_tab_lang` SET `name` = 'Wiadomości zamówienia' WHERE `id_lang` = 1 AND `name` = 'Order Messages'; UPDATE `ps_tab_lang` SET `name` = 'Zwroty produktów' WHERE `id_lang` = 1 AND `name` = 'Merchandise Returns'; UPDATE `ps_tab_lang` SET `name` = 'Statystyki' WHERE `id_lang` = 1 AND `name` = 'Stats'; UPDATE `ps_tab_lang` SET `name` = 'Magazyny' WHERE `id_lang` = 1 AND `name` = 'Warehouses'; UPDATE `ps_tab_lang` SET `name` = 'Zarządzanie magazynem' WHERE `id_lang` = 1 AND `name` = 'Stock Management'; UPDATE `ps_tab_lang` SET `name` = 'Zarządzanie magazynem' WHERE `id_lang` = 1 AND `name` = 'Stock Management'; UPDATE `ps_tab_lang` SET `name` = 'Ruch magazynowy' WHERE `id_lang` = 1 AND `name` = 'Stock Movement'; UPDATE `ps_tab_lang` SET `name` = 'Stany magazynowe' WHERE `id_lang` = 1 AND `name` = 'Instant Stock Status'; UPDATE `ps_tab_lang` SET `name` = 'Aktualne pokrycie stanu' WHERE `id_lang` = 1 AND `name` = 'Stock Coverage'; UPDATE `ps_tab_lang` SET `name` = 'Dostawa zamówień' WHERE `id_lang` = 1 AND `name` = 'Supply orders'; UPDATE `ps_tab_lang` SET `name` = 'Konfiguracja' WHERE `id_lang` = 1 AND `name` = 'Configuration'; UPDATE `ps_tab_lang` SET `name` = 'Ulepszenia' WHERE `id_lang` = 1 AND `name` = 'Improve'; UPDATE `ps_tab_lang` SET `name` = 'Moduły' WHERE `id_lang` = 1 AND `name` = 'Modules'; UPDATE `ps_tab_lang` SET `name` = 'Module Manager' WHERE `id_lang` = 1 AND `name` = 'Module Manager'; UPDATE `ps_tab_lang` SET `name` = 'Moduły' WHERE `id_lang` = 1 AND `name` = 'Modules'; UPDATE `ps_tab_lang` SET `name` = 'Powiadomienia' WHERE `id_lang` = 1 AND `name` = 'Alerts'; UPDATE `ps_tab_lang` SET `name` = 'Aktualizacje' WHERE `id_lang` = 1 AND `name` = 'Updates'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Module Catalog'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Module Catalog'; UPDATE `ps_tab_lang` SET `name` = 'Module Selections' WHERE `id_lang` = 1 AND `name` = 'Module Selections'; UPDATE `ps_tab_lang` SET `name` = 'Wygląd' WHERE `id_lang` = 1 AND `name` = 'Design'; UPDATE `ps_tab_lang` SET `name` = 'Szablony' WHERE `id_lang` = 1 AND `name` = 'Theme & Logo'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Theme Catalog'; UPDATE `ps_tab_lang` SET `name` = 'Szablon maila' WHERE `id_lang` = 1 AND `name` = 'Email Theme'; UPDATE `ps_tab_lang` SET `name` = 'Szablon maila' WHERE `id_lang` = 1 AND `name` = 'Email Theme'; UPDATE `ps_tab_lang` SET `name` = 'Strony' WHERE `id_lang` = 1 AND `name` = 'Pages'; UPDATE `ps_tab_lang` SET `name` = 'Pozycje' WHERE `id_lang` = 1 AND `name` = 'Positions'; UPDATE `ps_tab_lang` SET `name` = 'Zdjęcia' WHERE `id_lang` = 1 AND `name` = 'Image Settings'; UPDATE `ps_tab_lang` SET `name` = 'Wysyłka' WHERE `id_lang` = 1 AND `name` = 'Shipping'; UPDATE `ps_tab_lang` SET `name` = 'Przewoźnicy' WHERE `id_lang` = 1 AND `name` = 'Carriers'; UPDATE `ps_tab_lang` SET `name` = 'Preferencje' WHERE `id_lang` = 1 AND `name` = 'Preferences'; UPDATE `ps_tab_lang` SET `name` = 'Płatność' WHERE `id_lang` = 1 AND `name` = 'Payment'; UPDATE `ps_tab_lang` SET `name` = 'Płatności' WHERE `id_lang` = 1 AND `name` = 'Payment Methods'; UPDATE `ps_tab_lang` SET `name` = 'Preferencje' WHERE `id_lang` = 1 AND `name` = 'Preferences'; UPDATE `ps_tab_lang` SET `name` = 'Międzynarodowy' WHERE `id_lang` = 1 AND `name` = 'International'; UPDATE `ps_tab_lang` SET `name` = 'Lokalizacja' WHERE `id_lang` = 1 AND `name` = 'Localization'; UPDATE `ps_tab_lang` SET `name` = 'Lokalizacja' WHERE `id_lang` = 1 AND `name` = 'Localization'; UPDATE `ps_tab_lang` SET `name` = 'Języki' WHERE `id_lang` = 1 AND `name` = 'Languages'; UPDATE `ps_tab_lang` SET `name` = 'Waluty' WHERE `id_lang` = 1 AND `name` = 'Currencies'; UPDATE `ps_tab_lang` SET `name` = 'Geolokalizacja' WHERE `id_lang` = 1 AND `name` = 'Geolocation'; UPDATE `ps_tab_lang` SET `name` = 'Położenie' WHERE `id_lang` = 1 AND `name` = 'Locations'; UPDATE `ps_tab_lang` SET `name` = 'Strefy' WHERE `id_lang` = 1 AND `name` = 'Zones'; UPDATE `ps_tab_lang` SET `name` = 'Kraje' WHERE `id_lang` = 1 AND `name` = 'Countries'; UPDATE `ps_tab_lang` SET `name` = 'Województwa lub regiony' WHERE `id_lang` = 1 AND `name` = 'States'; UPDATE `ps_tab_lang` SET `name` = 'Podatki' WHERE `id_lang` = 1 AND `name` = 'Taxes'; UPDATE `ps_tab_lang` SET `name` = 'Podatki' WHERE `id_lang` = 1 AND `name` = 'Taxes'; UPDATE `ps_tab_lang` SET `name` = 'Reguły podatków' WHERE `id_lang` = 1 AND `name` = 'Tax Rules'; UPDATE `ps_tab_lang` SET `name` = 'Tłumaczenia' WHERE `id_lang` = 1 AND `name` = 'Translations'; UPDATE `ps_tab_lang` SET `name` = 'Konfiguruj' WHERE `id_lang` = 1 AND `name` = 'Configure'; UPDATE `ps_tab_lang` SET `name` = 'Preferencje' WHERE `id_lang` = 1 AND `name` = 'Shop Parameters'; UPDATE `ps_tab_lang` SET `name` = 'Ogólny' WHERE `id_lang` = 1 AND `name` = 'General'; UPDATE `ps_tab_lang` SET `name` = 'Ogólny' WHERE `id_lang` = 1 AND `name` = 'General'; UPDATE `ps_tab_lang` SET `name` = 'Przerwa techniczna' WHERE `id_lang` = 1 AND `name` = 'Maintenance'; UPDATE `ps_tab_lang` SET `name` = 'Zamówienia' WHERE `id_lang` = 1 AND `name` = 'Order Settings'; UPDATE `ps_tab_lang` SET `name` = 'Zamówienia' WHERE `id_lang` = 1 AND `name` = 'Order Settings'; UPDATE `ps_tab_lang` SET `name` = 'Statusy' WHERE `id_lang` = 1 AND `name` = 'Statuses'; UPDATE `ps_tab_lang` SET `name` = 'Produkty' WHERE `id_lang` = 1 AND `name` = 'Product Settings'; UPDATE `ps_tab_lang` SET `name` = 'Klienci' WHERE `id_lang` = 1 AND `name` = 'Customer Settings'; UPDATE `ps_tab_lang` SET `name` = 'Klienci' WHERE `id_lang` = 1 AND `name` = 'Customers'; UPDATE `ps_tab_lang` SET `name` = 'Grupy' WHERE `id_lang` = 1 AND `name` = 'Groups'; UPDATE `ps_tab_lang` SET `name` = 'Tytuły' WHERE `id_lang` = 1 AND `name` = 'Titles'; UPDATE `ps_tab_lang` SET `name` = 'Kontakt' WHERE `id_lang` = 1 AND `name` = 'Contact'; UPDATE `ps_tab_lang` SET `name` = 'Kontakty' WHERE `id_lang` = 1 AND `name` = 'Contacts'; UPDATE `ps_tab_lang` SET `name` = 'Sklepy' WHERE `id_lang` = 1 AND `name` = 'Stores'; UPDATE `ps_tab_lang` SET `name` = 'Ruch' WHERE `id_lang` = 1 AND `name` = 'Traffic & SEO'; UPDATE `ps_tab_lang` SET `name` = 'SEO & URL' WHERE `id_lang` = 1 AND `name` = 'SEO & URLs'; UPDATE `ps_tab_lang` SET `name` = 'Wyszukiwarki' WHERE `id_lang` = 1 AND `name` = 'Search Engines'; UPDATE `ps_tab_lang` SET `name` = 'Polecający' WHERE `id_lang` = 1 AND `name` = 'Referrers'; UPDATE `ps_tab_lang` SET `name` = 'Szukaj' WHERE `id_lang` = 1 AND `name` = 'Search'; UPDATE `ps_tab_lang` SET `name` = 'Szukaj' WHERE `id_lang` = 1 AND `name` = 'Search'; UPDATE `ps_tab_lang` SET `name` = 'Tagi' WHERE `id_lang` = 1 AND `name` = 'Tags'; UPDATE `ps_tab_lang` SET `name` = 'Zaawansowane' WHERE `id_lang` = 1 AND `name` = 'Advanced Parameters'; UPDATE `ps_tab_lang` SET `name` = 'Informacja' WHERE `id_lang` = 1 AND `name` = 'Information'; UPDATE `ps_tab_lang` SET `name` = 'Wydajność' WHERE `id_lang` = 1 AND `name` = 'Performance'; UPDATE `ps_tab_lang` SET `name` = 'Administracja' WHERE `id_lang` = 1 AND `name` = 'Administration'; UPDATE `ps_tab_lang` SET `name` = 'Adres e-mail' WHERE `id_lang` = 1 AND `name` = 'E-mail'; UPDATE `ps_tab_lang` SET `name` = 'Importuj' WHERE `id_lang` = 1 AND `name` = 'Import'; UPDATE `ps_tab_lang` SET `name` = 'Zespół' WHERE `id_lang` = 1 AND `name` = 'Team'; UPDATE `ps_tab_lang` SET `name` = 'Pracownicy' WHERE `id_lang` = 1 AND `name` = 'Employees'; UPDATE `ps_tab_lang` SET `name` = 'Profile' WHERE `id_lang` = 1 AND `name` = 'Profiles'; UPDATE `ps_tab_lang` SET `name` = 'Uprawnienia' WHERE `id_lang` = 1 AND `name` = 'Permissions'; UPDATE `ps_tab_lang` SET `name` = 'Baza danych' WHERE `id_lang` = 1 AND `name` = 'Database'; UPDATE `ps_tab_lang` SET `name` = 'Menadżer SQL' WHERE `id_lang` = 1 AND `name` = 'SQL Manager'; UPDATE `ps_tab_lang` SET `name` = 'Kopia zapasowa DB' WHERE `id_lang` = 1 AND `name` = 'DB Backup'; UPDATE `ps_tab_lang` SET `name` = 'Logi' WHERE `id_lang` = 1 AND `name` = 'Logs'; UPDATE `ps_tab_lang` SET `name` = 'API' WHERE `id_lang` = 1 AND `name` = 'Webservice'; UPDATE `ps_tab_lang` SET `name` = 'Multisklep' WHERE `id_lang` = 1 AND `name` = 'Multistore'; UPDATE `ps_tab_lang` SET `name` = 'Multisklep' WHERE `id_lang` = 1 AND `name` = 'Multistore'; UPDATE `ps_tab_lang` SET `name` = 'Szybki dostęp' WHERE `id_lang` = 1 AND `name` = 'Quick Access'; UPDATE `ps_tab_lang` SET `name` = 'Więcej' WHERE `id_lang` = 1 AND `name` = 'More'; UPDATE `ps_tab_lang` SET `name` = 'Dashgoals' WHERE `id_lang` = 1 AND `name` = 'Dashgoals'; UPDATE `ps_tab_lang` SET `name` = 'ps_faviconnotificationbo' WHERE `id_lang` = 1 AND `name` = 'ps_faviconnotificationbo'; UPDATE `ps_tab_lang` SET `name` = 'Link Widget' WHERE `id_lang` = 1 AND `name` = 'Link Widget'; UPDATE `ps_tab_lang` SET `name` = 'Szablony' WHERE `id_lang` = 1 AND `name` = 'Theme & Logo'; UPDATE `ps_tab_lang` SET `name` = 'Homepage Configuration' WHERE `id_lang` = 1 AND `name` = 'Homepage Configuration'; UPDATE `ps_tab_lang` SET `name` = 'Advanced Customization' WHERE `id_lang` = 1 AND `name` = 'Advanced Customization'; UPDATE `ps_tab_lang` SET `name` = 'Welcome' WHERE `id_lang` = 1 AND `name` = 'Welcome'; UPDATE `ps_tab_lang` SET `name` = 'Merchant Expertise' WHERE `id_lang` = 1 AND `name` = 'Merchant Expertise'; UPDATE `ps_tab_lang` SET `name` = 'Advertising' WHERE `id_lang` = 1 AND `name` = 'Advertising'; UPDATE `ps_tab_lang` SET `name` = 'psgdpr' WHERE `id_lang` = 1 AND `name` = 'psgdpr'; UPDATE `ps_tab_lang` SET `name` = 'psgdpr' WHERE `id_lang` = 1 AND `name` = 'psgdpr'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Module Catalog'; UPDATE `ps_tab_lang` SET `name` = 'Katalog' WHERE `id_lang` = 1 AND `name` = 'Theme Catalog'; UPDATE `ps_tab_lang` SET `name` = 'ps_buybuttonlite' WHERE `id_lang` = 1 AND `name` = 'ps_buybuttonlite';
Oczywiście w `id_lang` = 1 podaj ID języka polskiego w Twoim sklepie.
