WebSite X5Help Center

 
Atilla J.
Atilla J.
User

Data tables open in a database, but still  en

Autor: Atilla J.
Visitado 689, Followers 1, Compartido 0  


Data tables open in a database, but still: "Unable to connect to DB"
I want to finally arm my webshop page, but there is no database connection or it doesn't work well.

Symptoms:
The page loads, but the webshop does not (http://shop.pannonmajor.hu)
Message from the admin interface: "Unable to connect to DB"

Could this be related to the following?

My service provider only allows internal access. Thus, when setting up access, the server name is localhost.

Specifying this in my project:

Upload (export to internet): OK
If I change the localhost to cl18.webspacecontrol.com
then the upload indicates a database access bridge.

Publicado en
8 RESPUESTAS - 2 úTIL
Andre E
Andre E
Moderator

Do you get an databse error at the moment you upload?

check with the hosting company if PHP is set to 7.1 at least but better higher best is = 8.0

Leer más
Publicado en de Andre E
Axel  
Axel  
User

Hello Atilla,

Check your web URL. Needs to be https and also during export (step 5) check if the URL is the same as your web server URL:

In your DB parameters try to change localhost by the IP (DB hosted) provides by your provider. Take care about some possible space/blank  if you have configured the DB by copy/paste action

Enjoy!
Axel

Leer más
Publicado en de Axel  
Atilla J.
Atilla J.
User
Autor

Well then I put it differently:
Relative database access: localhost
Symptoms:
Then there is no error message at the time of upload.
But the webshop does not load only the page.
The PHP and SQL versions are of course the same, because we are talking about the same database:

And compare what I described to changing the localhost setting to 'cl18.webspacecontrol.com'

There is already an error uploading, although the version numbers are OK.
Like I said: the same database

Leer más
Publicado en de Atilla J.
Axel  
Axel  
User

Often, localhost is forbidden by any provider for evident security reason...because it's a generic name which can authorize easy access.

Try to get the provider IP of cl18.webspacecontrol.com. Ask to your provider.

And again test with his IP

And you do a mistake: PHp & MysQL cannot be same versions. It's 2 different tools undecided

Leer más
Publicado en de Axel  
Atilla J.
Atilla J.
User
Autor

Sorry, of course not the same.
I mean, in both cases we're talking about the same server environment. that is, I refer to the same thing differently in both ways.
Configuring one case (Websitx5 - database configuration): localhost / 127.0.0.1
Another case: cl18.webspacecontrol.com

I understand what you're writing about localhost.
However, I know that the service provider only allows internal access. External access. And when websiteX5 uploads and checks the version number online, etc., does the service provider disable it?

Can't make the websiteX5 upload so it doesn't work when in the database: cl18.webspacecontrol.com?
With the localhost database option: upload works, but the database connection does not.

Leer más
Publicado en de Atilla J.
Axel  
Axel  
User

Not sure to understand well your needs.

To work locally or with your hosted provider ?

In any case, you cannot use your DB hosted to your provider from your local machine.
It cannot works with WSX5. Impossible.
Because your hosted DB is not reachable from external, again for security reasons if your provider has protected this action !
I hope .... for you, and your data....

Leer más
Publicado en de Axel  
Atilla J.
Atilla J.
User
Autor

Dear Axel,
Thanks. I think that's solved.
Others may be interested in which Hostgator this hosting provider is.
If someone has a websiteX5 database on their site, please indicate how you solved it! Because then I'm guided. I am not in contact with the hostgator, but a third party.

Leer más
Publicado en de Atilla J.
Axel  
Axel  
User

Hello Atilla,

And how to ?

to help other users on this forum ?

Enjoy!
Axel

Leer más
Publicado en de Axel