Database Error

[sajadkhmz]

Hi guys,

I was installing PrestaShop for the first time with Xamp and when i got to "Store installation" section and in "Create database tables" an error had came up, can u help me?

the following Error:

1: 23:47:30 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign". Message: "An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No such host is known. " ["exception" => Doctrine\DBAL\Exception\ConnectionException { …},"command" => "prestashop:schema:update-without-foreign","message" => "An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No such host is known. "]

thank you

Edited December 16, 2019 by sajadkhmz (see edit history)

[PrestaHeroes USA]

this usually issue with upgrade not native first time install.

I recommend installing on remote host to see if solved issue.

You also did not mention which PS version you are trying to install, if latest then try previous version.

[sajadkhmz]

42 minutes ago, El Patron said:

this usually issue with upgrade not native first time install.

I recommend installing on remote host to see if solved issue.

You also did not mention which PS version you are trying to install, if latest then try previous version.

Hey, thanks for answering

I used the latest version, but i also tested the previous version and didnt work.

What can i do?

Edited December 18, 2019 by sajadkhmz (see edit history)

[selectshop.at]

You are trying with which database connection ? localhost or by IP 127.0....? Try with localhost and check if PDO driver is installed.

[sajadkhmz]

6 hours ago, selectshop.at said:

You are trying with which database connection ? localhost or by IP 127.0....? Try with localhost and check if PDO driver is installed.

Im using localhost, and yes PDO is installed.

[selectshop.at]

Sorry, cannot give you further help on this. I prefer to use VM VirtualBox with fully self configured Operating System. XAMPP/WAMPP is not really good for testing Prestashop.

[sajadkhmz]

52 minutes ago, selectshop.at said:

Sorry, cannot give you further help on this. I prefer to use VM VirtualBox with fully self configured Operating System. XAMPP/WAMPP is not really good for testing Prestashop.

Ok, thanks anyway for your time

[JBW]

I'm running presta on XAMP without issues. Which XAMP and Presta Version are you using?

[ccristian]

 

the same error here with XAMPP running on Windows 10 Pro: 

Link to database cannot be established: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
at line 119 in file classes/db/DbPDO.php

I was working on store translations a few days ago until late at night. In the morning when I turned on the computer and started the XAMPP Control Pannel he didn't manage to connect to database, the MySQL module tries to start but stops automatically as soon as it starts. I have some backup files but there are a lot of work between them and the time the error occurred, and I don't want to loose those changes.

The MySQL 3306 PORT it looks like it hasn't changed, I attached some log informations from the MySQL XMPP logs folder, maybe they will help in some way to solve the problem.

PrestaShop 8.1.2, XAMPP Control Panel v3.3.0 (running on Windows 10 Pro), ApacheFriends XAMPP Version 8.1.25

+ Apache 2.4.58
  + MariaDB 10.4.32
  + PHP 8.1.25 (VS16 X86 64bit thread safe) + PEAR
  + phpMyAdmin 5.2.1
  + OpenSSL 1.1.1p
  + ADOdb 518a
  + Mercury Mail Transport System v4.63 (not included in the portable version)
  + FileZilla FTP Server 0.9.41 (not included in the portable version)
  + Webalizer 2.23-04 (not included in the portable version)
  + Strawberry Perl 5.32.1.1 Portable
  + Tomcat 8.5.96
  + XAMPP Control Panel Version 3.3.0.
  + XAMPP mailToDisk 1.0 (write emails via PHP on local disk in <xampp>\mailoutput. Activated in the php.ini as mail default.)

 

 

[musicmaster]

Your Mysql crashed.

See here or here.

[ccristian]

On 2/5/2024 at 6:08 PM, musicmaster said:

Your Mysql crashed.

See here or here.

Thank you very very much. My issue was solved according to your recommendation from the second link by copying and replacing these files (ibdata1, ib_logfile0 and ib_logfile1 + database content <databasename>/*.frm and <databasename>/*.ibd)  in a fresh instalation of XAMPP. God bless you friend!