Jump to content

Edit History

qnev

qnev

Witam wszystkich, od kilku dni walczę z uruchomieniem mojego sklepu na hostingu Cyberfolks'owym.

Ogólnie rozchodzi się o to, że na lokalnej wersji na serwerze WAMP sklep działa, natomiast po przerzuceniu go na serwer współdzielony pojawiają się poniższe błędy i od kilku dni próbuję wszystkiego co mi do głowy przychodzi niestety z mizernym skutkiem.

Lista rzeczy, które próbowałem:

- różne wersje PHP

- zwiększenie parametrów serwera typu memory_limit, generalnie phppsinfo.php zwraca wszystkie parametry na zielono, od strony konfiguracji niby wszystko jest zapewnione

- wcześniej błąd wskazywał na brak kolumny locale tabeli ps_lang, tą tabele zaimportowałem osobno

- założyłem nawet kopie sklepu lokalnie (WAMP) i działa 

- miałem też problem z wgraniem plików na sewer, błąd przy rozpakowywaniu archiwum zip, finalnie rozpakowywałem katalog przez SSH

- plik, na który wskazuje błąd czyli Regexp.php istnieje w podanej ścieżce

- wyłączałem moduły wszystkie, wyłączałem też szablon, admin dalej leżał

Błędy związane z tabelą ps_lang wskazują, że może coś jest nie tak z wersją językową, tłumaczeniami?

Zamieściłem poniżej komunikaty błędów, które mogą pomóc w określeniu, w którą stronę drążyć dalej temat.

Debugger w BO (https://nazwadomeny/admin1) zwraca:

(1/1) ContextErrorException
Warning: include(tutaj-sciezka-do-katalogu/public_html/vendor/composer/../beberlei/doctrineextensions/src/Query/Mysql/Regexp.php): failed to open stream: No such file or directory

in DebugClassLoader.php line 155
at include()
in DebugClassLoader.php line 155
at DebugClassLoader->loadClass('DoctrineExtensions\\Query\\Mysql\\Regexp')
at spl_autoload_call('DoctrineExtensions\\Query\\Mysql\\Regexp')
in Parser.php line 3541
at Parser->CustomFunctionsReturningStrings()
in Parser.php line 3414
at Parser->CustomFunctionDeclaration()
in Parser.php line 3378
at Parser->FunctionDeclaration()
in Parser.php line 2851
at Parser->ArithmeticPrimary()
in Parser.php line 2812
at Parser->ArithmeticFactor()
in Parser.php line 2780
at Parser->ArithmeticTerm()
in Parser.php line 2754
at Parser->SimpleArithmeticExpression()
in Parser.php line 2741
at Parser->ArithmeticExpression()
in Parser.php line 3072
at Parser->ComparisonExpression()
in Parser.php line 2605
at Parser->SimpleConditionalExpression()
in Parser.php line 2486
at Parser->ConditionalPrimary()
in Parser.php line 2462
at Parser->ConditionalFactor()
in Parser.php line 2435
at Parser->ConditionalTerm()
in Parser.php line 2405
at Parser->ConditionalExpression()
in Parser.php line 1373
at Parser->WhereClause()
in Parser.php line 893
at Parser->SelectStatement()
in Parser.php line 860
at Parser->QueryLanguage()
in Parser.php line 273
at Parser->getAST()
in Parser.php line 372
at Parser->parse()
in Query.php line 287
at Query->_parse()
in Query.php line 299
at Query->_doExecute()
in AbstractQuery.php line 1000
at AbstractQuery->executeIgnoreQueryCache(null, 1)
in AbstractQuery.php line 954
at AbstractQuery->execute(null, 1)
in AbstractQuery.php line 757
at AbstractQuery->getResult()
in DatabaseTranslationLoader.php line 92
at DatabaseTranslationLoader->load('AdminActions.pl-PL.db', 'pl-PL', 'AdminActions')
in Translator.php line 385
at Translator->doLoadCatalogue('pl-PL')
in Translator.php line 277
at Translator->initializeCatalogue('pl-PL')
in Translator.php line 128
at Translator->initializeCatalogue('pl-PL')
in Translator.php line 314
at Translator->dumpCatalogue('pl-PL', object(ResourceCheckerConfigCache))
in Translator.php line 299
at Translator->Symfony\Component\Translation\{closure}(object(ResourceCheckerConfigCache))
in ResourceCheckerConfigCacheFactory.php line 43
at ResourceCheckerConfigCacheFactory->cache('tutaj-sciezka-do-katalogu/public_html/var/cache/dev/translations/catalogue.pl-PL.L8dqxxF.php', object(Closure))
in Translator.php line 300
at Translator->initializeCacheCatalogue('pl-PL')
in Translator.php line 265
at Translator->loadCatalogue('pl-PL')
in Translator.php line 241
at Translator->getCatalogue('pl-PL')
in Translator.php line 198
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in PrestaShopTranslatorTrait.php line 61
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in LoggingTranslator.php line 47
at LoggingTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in DataCollectorTranslator.php line 50
at DataCollectorTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in PrestaShopTranslatorTrait.php line 61
at DataCollectorTranslator->trans('Successful deletion.', array(), 'Admin.Notifications.Success', null)
in Controller.php line 338
at ControllerCore->trans('Successful deletion.', array('legacy' => 'htmlspecialchars'), 'Admin.Notifications.Success')
in AdminController.php line 481
at AdminControllerCore->__construct()
in LegacyContext.php line 86
at LegacyContext->getContext()
in UserLocaleListener.php line 39
at UserLocaleListener->__construct(object(LegacyContext))
in appDevDebugProjectContainer.php line 3848
at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()
in appDevDebugProjectContainer.php line 4377
at appDevDebugProjectContainer->Container7ohiaop\{closure}()
in EventDispatcher.php line 231
at EventDispatcher->sortListeners('kernel.request')
in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')
in ContainerAwareEventDispatcher.php line 129
at ContainerAwareEventDispatcher->getListeners('kernel.request')
in TraceableEventDispatcher.php line 259
at TraceableEventDispatcher->preProcess('kernel.request')
in TraceableEventDispatcher.php line 137
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))
in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)
in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)
in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)
in index.php line 82

dev.log zwraca:

[2024-04-04 10:38:38] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []
[2024-04-05 07:29:11] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []
[2024-04-07 22:19:07] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []

 

Z góry dziękuje za rady.

qnev

qnev

Witam wszystkich, od kilku dni walczę z uruchomieniem mojego sklepu na hostingu Cyberfolks'owym.

Ogólnie rozchodzi się o to, że na lokalnej wersji na serwerze WAMP sklep działa, natomiast po przerzuceniu go na serwer współdzielony pojawiają się poniższe błędy i od kilku dni próbuję wszystkiego co mi do głowy przychodzi niestety z mizernym skutkiem.

Lista rzeczy, które próbowałem:

- różne wersje PHP

- zwiększenie parametrów serwera typu memory_limit, generalnie phppsinfo.php zwraca wszystkie parametry na zielono, od strony konfiguracji niby wszystko jest zapewnione

- wcześniej błąd wskazywał na brak kolumny locale tabeli ps_lang, tą tabele zaimportowałem osobno

- założyłem nawet kopie sklepu lokalnie (WAMP) i działa 

- miałem też problem z wgraniem plików na sewer, błąd przy rozpakowywaniu archiwum zip, finalnie rozpakowywałem katalog przez SSH

- plik, na który wskazuje błąd czyli Regexp.php istnieje w podanej ścieżce

Błędy związane z tabelą ps_lang wskazują, że może coś jest nie tak z wersją językową, tłumaczeniami?

Zamieściłem poniżej komunikaty błędów, które mogą pomóc w określeniu, w którą stronę drążyć dalej temat.

Debugger w BO (https://nazwadomeny/admin1) zwraca:

(1/1) ContextErrorException
Warning: include(tutaj-sciezka-do-katalogu/public_html/vendor/composer/../beberlei/doctrineextensions/src/Query/Mysql/Regexp.php): failed to open stream: No such file or directory

in DebugClassLoader.php line 155
at include()
in DebugClassLoader.php line 155
at DebugClassLoader->loadClass('DoctrineExtensions\\Query\\Mysql\\Regexp')
at spl_autoload_call('DoctrineExtensions\\Query\\Mysql\\Regexp')
in Parser.php line 3541
at Parser->CustomFunctionsReturningStrings()
in Parser.php line 3414
at Parser->CustomFunctionDeclaration()
in Parser.php line 3378
at Parser->FunctionDeclaration()
in Parser.php line 2851
at Parser->ArithmeticPrimary()
in Parser.php line 2812
at Parser->ArithmeticFactor()
in Parser.php line 2780
at Parser->ArithmeticTerm()
in Parser.php line 2754
at Parser->SimpleArithmeticExpression()
in Parser.php line 2741
at Parser->ArithmeticExpression()
in Parser.php line 3072
at Parser->ComparisonExpression()
in Parser.php line 2605
at Parser->SimpleConditionalExpression()
in Parser.php line 2486
at Parser->ConditionalPrimary()
in Parser.php line 2462
at Parser->ConditionalFactor()
in Parser.php line 2435
at Parser->ConditionalTerm()
in Parser.php line 2405
at Parser->ConditionalExpression()
in Parser.php line 1373
at Parser->WhereClause()
in Parser.php line 893
at Parser->SelectStatement()
in Parser.php line 860
at Parser->QueryLanguage()
in Parser.php line 273
at Parser->getAST()
in Parser.php line 372
at Parser->parse()
in Query.php line 287
at Query->_parse()
in Query.php line 299
at Query->_doExecute()
in AbstractQuery.php line 1000
at AbstractQuery->executeIgnoreQueryCache(null, 1)
in AbstractQuery.php line 954
at AbstractQuery->execute(null, 1)
in AbstractQuery.php line 757
at AbstractQuery->getResult()
in DatabaseTranslationLoader.php line 92
at DatabaseTranslationLoader->load('AdminActions.pl-PL.db', 'pl-PL', 'AdminActions')
in Translator.php line 385
at Translator->doLoadCatalogue('pl-PL')
in Translator.php line 277
at Translator->initializeCatalogue('pl-PL')
in Translator.php line 128
at Translator->initializeCatalogue('pl-PL')
in Translator.php line 314
at Translator->dumpCatalogue('pl-PL', object(ResourceCheckerConfigCache))
in Translator.php line 299
at Translator->Symfony\Component\Translation\{closure}(object(ResourceCheckerConfigCache))
in ResourceCheckerConfigCacheFactory.php line 43
at ResourceCheckerConfigCacheFactory->cache('tutaj-sciezka-do-katalogu/public_html/var/cache/dev/translations/catalogue.pl-PL.L8dqxxF.php', object(Closure))
in Translator.php line 300
at Translator->initializeCacheCatalogue('pl-PL')
in Translator.php line 265
at Translator->loadCatalogue('pl-PL')
in Translator.php line 241
at Translator->getCatalogue('pl-PL')
in Translator.php line 198
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in PrestaShopTranslatorTrait.php line 61
at Translator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in LoggingTranslator.php line 47
at LoggingTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in DataCollectorTranslator.php line 50
at DataCollectorTranslator->trans('Successful deletion.', array(), 'AdminNotificationsSuccess', null)
in PrestaShopTranslatorTrait.php line 61
at DataCollectorTranslator->trans('Successful deletion.', array(), 'Admin.Notifications.Success', null)
in Controller.php line 338
at ControllerCore->trans('Successful deletion.', array('legacy' => 'htmlspecialchars'), 'Admin.Notifications.Success')
in AdminController.php line 481
at AdminControllerCore->__construct()
in LegacyContext.php line 86
at LegacyContext->getContext()
in UserLocaleListener.php line 39
at UserLocaleListener->__construct(object(LegacyContext))
in appDevDebugProjectContainer.php line 3848
at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()
in appDevDebugProjectContainer.php line 4377
at appDevDebugProjectContainer->Container7ohiaop\{closure}()
in EventDispatcher.php line 231
at EventDispatcher->sortListeners('kernel.request')
in EventDispatcher.php line 61
at EventDispatcher->getListeners('kernel.request')
in ContainerAwareEventDispatcher.php line 129
at ContainerAwareEventDispatcher->getListeners('kernel.request')
in TraceableEventDispatcher.php line 259
at TraceableEventDispatcher->preProcess('kernel.request')
in TraceableEventDispatcher.php line 137
at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))
in HttpKernel.php line 127
at HttpKernel->handleRaw(object(Request), 1)
in HttpKernel.php line 68
at HttpKernel->handle(object(Request), 1, false)
in Kernel.php line 200
at Kernel->handle(object(Request), 1, false)
in index.php line 82

dev.log zwraca:

[2024-04-04 10:38:38] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []
[2024-04-05 07:29:11] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []
[2024-04-07 22:19:07] doctrine.DEBUG: SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.locale AS locale_6, t0.date_format_lite AS date_format_lite_7, t0.date_format_full AS date_format_full_8, t0.is_rtl AS is_rtl_9 FROM ps_lang t0 WHERE t0.locale = ? LIMIT 1 ["pl-PL"] []

 

Z góry dziękuje za rady.

×
×
  • Create New...
tracking pixel