SQLSTATE[HY000] [2002]

[Alexander001]

http://localhost/
http://192.168.0.1/

Trying to install thirtybees locally. However, I do not get further in the installation than step 2. What do I do to move forward?.

Edited April 21, 2023 by Alexander001

[datakick]

You have entered invalid server name for your "database server address"

[Alexander001]

What do you mean with:
You have entered invalid server name for your "database server address" ?.

Here's what I did:  Step by step before error message comes up ....

 

 

I don't get any question about filling in any server address. What am I doing wrong?

1.php

Edited April 21, 2023 by Alexander001

[datakick]

Hard to tell. Do you have existing file /config/settings.inc.php ?

[Alexander001]

...

Edited April 21, 2023 by Alexander001

[Alexander001]

33 minutes ago, datakick said:

Hard to tell. Do you have existing file /config/settings.inc.php ?

There is no "settings.inc.php" in that folder at all?.   : thirtybees-v1.4.0-php7.4

Is that the problem?, missing files in the downloaded file?

[datakick]

7 minutes ago, Alexander001 said:

There is no "settings.inc.php" in that folder at all?.   : thirtybees-v1.4.0-php7.4

Is that the problem?, missing files in the downloaded file?

No, that's correct. There shouldn't be this file. I asked because if this file existed, it might explain your issue.

 

[Alexander001]

14 minutes ago, datakick said:

No, that's correct. There shouldn't be this file. I asked because if this file existed, it might explain your issue.

 

Where is the php file located with the sql data. If I can enter the db name and password in this file directly and see if that helps

[the.rampage.rado]

You receive this error on every installation attempt?

[Alexander001]

6 minutes ago, the.rampage.rado said:

You receive this error on every installation attempt?

Yes I do... every time. What you see in the pictures above is what happens. Already on the first page during the installation,

Can't I just fill in the SQL data for the database directly in the php page, Where is that php file located?.

Edited April 21, 2023 by Alexander001

[the.rampage.rado]

Probably your distro is corrupted - what you use as db server? I see localhost on Win machine? XAMPP? Did you check if all it's services are running correctly?

[Alexander001]

19 minutes ago, the.rampage.rado said:

Probably your distro is corrupted - what you use as db server? I see localhost on Win machine? XAMPP?

Tried different, Now I'm running xampp. But the same result in apache Etc.  I tested Prestashop 17 and 8.3 without problems on this distro. Can you tell me which folder and php file the db settings are stored.

Edited April 21, 2023 by Alexander001

[the.rampage.rado]

The istaller will create the file, there is plenty of stuff that you are unable to input by yourself there.


This guide I found now is pretty old but it outlines the major points. I believe you're stuck and have some problem with the db server.

https://ourcodeworld.com/articles/read/321/how-to-install-and-setup-prestashop-using-xampp-in-windows

In general if you wish to test out TB I would strongly advice to do so on actual server enovirment where you can tweak most of the items easily.

[Alexander001]

5 hours ago, the.rampage.rado said:

The istaller will create the file, there is plenty of stuff that you are unable to input by yourself there.


This guide I found now is pretty old but it outlines the major points. I believe you're stuck and have some problem with the db server.

https://ourcodeworld.com/articles/read/321/how-to-install-and-setup-prestashop-using-xampp-in-windows

In general if you wish to test out TB I would strongly advice to do so on actual server enovirment where you can tweak most of the items easily.

There is no need for any 'how to' in uninstalling scripts. Have no problem installing all other shops or sites, blows through them without problems all day long. It's only the thirtybees that are the problem,here I install PrestaShop again without problems with the same SQL server and distro. the same goes for PrestaShop 8 to 8,2.

The problem is not on my end, but on thirtybees !.

 

[Alexander001]

Well .... Running thirty bees script on a real server doesn't seem to work either. infinityfree.net. throwing out a lot of errors here too.

[datakick]

My guess is that your server raises some warning/error very early because of server misconfiguration -- maybe relate to that tempname() notice that should not be there.

Thirty bees tries to handle the error, and during that error handler tries to access database. This fails, because db connection is not configured yet. The original error is not reported, and instead new error regarding database connection is raised.

If true, it is obviously bug in thirty bees. Unfortunately, I can't reproduce this issue, so I'm not sure what to fix.

@Alexander001 could you assist?  Please edit file 

classes/db/DbPDO.php

Find line

 die(sprintf(Tools::displayError('Link to database cannot be established: %s'), utf8_encode($e->getMessage())));

And replace it with

die("<pre>$e</pre>");

That should tell us the origin of the problem.

4 hours ago, Alexander001 said:

Well .... Running thirty bees script on a real server doesn't seem to work either. infinityfree.net. throwing out a lot of errors here too.

That's not real server, that's a joke. Their free plan severely limit number of concurrent connections to the server. Modern browsers can easily trigger a lot of concurrent requests, and their server just can't (won't) handle it.

[Alexander001]

22 hours ago, datakick said:

My guess is that your server raises some warning/error very early because of server misconfiguration -- maybe relate to that tempname() notice that should not be there.

Thirty bees tries to handle the error, and during that error handler tries to access database. This fails, because db connection is not configured yet. The original error is not reported, and instead new error regarding database connection is raised.

If true, it is obviously bug in thirty bees. Unfortunately, I can't reproduce this issue, so I'm not sure what to fix.

@Alexander001 could you assist?  Please edit file 

classes/db/DbPDO.php

Find line

 die(sprintf(Tools::displayError('Link to database cannot be established: %s'), utf8_encode($e->getMessage())));

And replace it with

die("<pre>$e</pre>");

That should tell us the origin of the problem.

That's not real server, that's a joke. Their free plan severely limit number of concurrent connections to the server. Modern browsers can easily trigger a lot of concurrent requests, and their server just can't (won't) handle it.

That change had some unforeseeable results, to put it mildly ...

[Alexander001]

I really need to get this problem sorted!.

There are literally tons of alternatives to thirty bees as a E-Commerce solution. But ALL of them lack stability and flexibility compared to thirty bee, and are definitely not a complete solution as they all claim. Thirty bees runs much faster on servers, image regeneration works correctly which is not the case in Prestashop. However, why it messes up on local servers is something that needs to be fixed.

[datakick]

This is an issue with TLS12 check. It stopped working due to external changes. In version 1.5 / bleeding edge, this test does not exists anymore. 

Edit file and delete line 130. Original code

    public static function getDefaultTestsOp()
    {
        return [
            'Gz'              => false,
            'Tlsv12'          => false,
        ];
    }

should look like this

    public static function getDefaultTestsOp()
    {
        return [
            'Gz'              => false,
        ];
    }

 

[Alexander001]

42 minutes ago, datakick said:

This is an issue with TLS12 check. It stopped working due to external changes. In version 1.5 / bleeding edge, this test does not exists anymore. 

Edit file and delete line 130. Original code

    public static function getDefaultTestsOp()
    {
        return [
            'Gz'              => false,
            'Tlsv12'          => false,
        ];
    }

should look like this

    public static function getDefaultTestsOp()
    {
        return [
            'Gz'              => false,
        ];
    }

 

That code is not in the classes/db/DbPDO.php

[datakick]

23 minutes ago, Alexander001 said:

That code is not in the classes/db/DbPDO.php

sorry, that's classes/ConfigurationTest.php

[Alexander001]

42 minutes ago, Alexander001 said:

That code is not in the classes/db/DbPDO.php

That worked perfectly. Thank you and to everyone at thirty bees, you are doing an outstanding job with this script.