Create Database Tables Error Prestashop 8 Install

[mawhatt]

Hi

 

I have been running Prestashop v1.6 for a long time with no issues. I am now trying to install a fresh install of Prestashop 8 and cannot get the install to complete. It errors when it is trying to create database tables. I have tried all the suggestions that I have found on the web and none have worked. Please see attached files showing the error and phppsinfo.php screenshot showing that all requirements are meet.

The error takes 10-15seconds from when it first says Create database tables to show up.

The database is populated but Im guessing not fully due to the error.

Any help at this point would be appreciated.

Server = Godaddy

MySQL = 5.7

PHP = 7.3 (I have also tried 8.0)

I have tried using chrome, firefox and internet explorer.

I have delete/recreated the database over and over and tried different database users.

I have attached a screenshot of my php.ini showing what I have set there.

 

 

Edited January 18, 2023 by mawhatt (see edit history)

[ComGrafPL]

Have you created db during install either before? ( for 1.8 you need to use PHP 8+ ). For now 1.8 is more like beta, it isnt recommended for live stores.

Also you could try with install clean 1.7.8.7 and then use 1-click upgrade to 1.8 if you really need newest version.

[mawhatt]

Hi ComGraftPL

Thank you for your reply

I am installing Prestashop 8.01 not 1.8.

Prestashop 8 is now officially released https://build.prestashop-project.org/news/2022/prestashop-8-0-0-available/

[mawhatt]

I just tried to install v1.7.8.8 and it failed at the same part but gave a different error message.

So it definitly looks like it is an issue with my server but what do I need to ask them/tell to change?

[mawhatt]

I have manged to solve this issue. For anyone else having this issue.

When creating your database change the collation to "utf8mb4_general_ci" this can be done under operations when the database is selected.

[Slava]

Hi! I have the same problem with PS 8.0.2

Unfortunately, the solution above does not work in my case. Does anyone fixed that issue in another way?

[Flitepal]

I am also running in the same issue, checked all php configurations I found on the Internet regarding this error to make sure they are as recommended.

In the error logs I find stuff like this:

 

[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Undefined array key "HTTP_ACCEPT_LANGUAGE" in //public_html/src/PrestaShopBundle/Install/LanguageList.php on line 190
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in //public_html/src/PrestaShopBundle/Install/LanguageList.php on line 190
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Trying to access array offset on value of type bool in //public_html/install/classes/controllerHttp.php on line 150
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Undefined array key "" in //public_html/src/PrestaShopBundle/Install/LanguageList.php on line 126
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Attempt to read property "locale" on null in //public_html/classes/Context.php on line 415
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Undefined array key "HTTP_ACCEPT_LANGUAGE" in //public_html/src/PrestaShopBundle/Install/LanguageList.php on line 190
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Deprecated:  explode(): Passing null to parameter #2 ($string) of type string is deprecated in //public_html/src/PrestaShopBundle/Install/LanguageList.php on line 190
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  Trying to access array offset on value of type bool in //public_html/install/classes/controllerHttp.php on line 150
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Warning:  include(): Failed opening '//public_html/var/cache/prod/translations/catalogue.en-US.NXhscRe.php' for inclusion (include_path='//public_html/vendor/pear/pear_exception://public_html/vendor/pear/console_getopt://public_html/vendor/pear/pear-core-minimal/src://public_html/vendor/pear/archive_tar:.:/opt/cpanel/ea-php82/root/usr/share/pear') in //public_html/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php on line 357
[27-Mar-2023 21:08:37 Europe/Sofia] PHP Fatal error:  Uncaught Error: Call to a member function getLocale() on bool in //public_html/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php:224


Stack trace:
#0 //public_html/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php(70): Symfony\Component\Translation\Translator->trans('Welcome to the ...', Array, 'Install', NULL)
#1 //public_html/install/theme/views/welcome.php(39): PrestaShopBundle\Translation\TranslatorComponent->trans('Welcome to the ...', Array, 'Install')
#2 //public_html/install/classes/controllerHttp.php(487): include('//p...')
#3 //public_html/install/classes/controllerHttp.php(420): InstallControllerHttp->renderTemplate('//p...', 'welcome')
#4 //public_html/install/classes/controllerHttp.php(469): InstallControllerHttp->getTemplate('welcome')
#5 //public_html/install/controllers/http/welcome.php(74): InstallControllerHttp->displayContent('welcome')
#6 //public_html/install/classes/controllerHttp.php(278): InstallControllerHttpWelcome->display()
#7 //public_html/install/index.php(53): InstallControllerHttp::execute()
#8 {main}
  thrown in //public_html/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php on line 224


[28-Mar-2023 00:19:04 Europe/Sofia] PHP Warning:  include(): Failed opening '//public_html/var/cache/prod/translations/catalogue.en-US.NXhscRe.php' for inclusion (include_path='//public_html/vendor/pear/pear_exception://public_html/vendor/pear/console_getopt://public_html/vendor/pear/pear-core-minimal/src://public_html/vendor/pear/archive_tar:.:/opt/cpanel/ea-php81/root/usr/share/pear') in //public_html/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php on line 357

 

The above solution DID NOT WORK unfortunately. Help would be appreciated.

Here's the php info file - https://flitepal.com/phpnfo.php

Edited March 27, 2023 by Flitepal (see edit history)

[miguellol]

On 1/18/2023 at 10:54 PM, mawhatt said:

I have manged to solve this issue. For anyone else having this issue.

When creating your database change the collation to "utf8mb4_general_ci" this can be done under operations when the database is selected.

https://105fm.pt/portuguese-casino/betway

Thanks for the solution!

Edited August 9, 2023 by miguellol (see edit history)