sajadkhmz Posted December 16, 2019 Share Posted December 16, 2019 (edited) 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) Link to comment Share on other sites More sharing options...
El Patron Posted December 18, 2019 Share Posted December 18, 2019 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. 1 Link to comment Share on other sites More sharing options...
sajadkhmz Posted December 18, 2019 Author Share Posted December 18, 2019 (edited) 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) Link to comment Share on other sites More sharing options...
selectshop.at Posted December 19, 2019 Share Posted December 19, 2019 You are trying with which database connection ? localhost or by IP 127.0....? Try with localhost and check if PDO driver is installed. 1 Link to comment Share on other sites More sharing options...
sajadkhmz Posted December 19, 2019 Author Share Posted December 19, 2019 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. Link to comment Share on other sites More sharing options...
selectshop.at Posted December 19, 2019 Share Posted December 19, 2019 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. 1 Link to comment Share on other sites More sharing options...
sajadkhmz Posted December 19, 2019 Author Share Posted December 19, 2019 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 Link to comment Share on other sites More sharing options...
JBW Posted December 20, 2019 Share Posted December 20, 2019 I'm running presta on XAMP without issues. Which XAMP and Presta Version are you using? Link to comment Share on other sites More sharing options...
ccristian Posted February 4 Share Posted February 4 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.) Link to comment Share on other sites More sharing options...
musicmaster Posted February 5 Share Posted February 5 Your Mysql crashed. See here or here. Link to comment Share on other sites More sharing options...
ccristian Posted February 13 Share Posted February 13 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! 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now