Jump to content

Create Database Tables Error Prestashop 8 Install


Recommended Posts

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.

 

 

Error screen.jpg

PHPini.jpg

Reqs meet.jpg

Edited by mawhatt (see edit history)
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 2 months later...

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

presta_problem.jpg

Edited by Flitepal (see edit history)
Link to comment
Share on other sites

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.

исправить.jpghttps://105fm.pt/portuguese-casino/betway

Thanks for the solution!

Edited by miguellol (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...