WebSite X5Help Center

 
Atom S.
Atom S.
User

Mysql in onlineshop  en

Autor: Atom S.
Visited 2100, Followers 1, Udostępniony 0  

Hi All,

How do it upload to MySql in my onlineshop, because my Web site operator told me: The database can only be accessed from an internal network: 

I do not upload in website x5.

Greets,

Atomprof

Posted on the
9 ODPOWIEDZI - 5 USEFUL - 1 PRAWIDłOWA ODPOWIEDź
Andre E
Andre E
Moderator
Najlepszy Użytkownik miesiąca EN

Website x5 does this for you, when uploading to server.

But why do you want to know?

Czytaj więcej
Posted on the from Andre E
Atom S.
Atom S.
User
Autor

I set my product count and i press the update button. pls see the picture

Czytaj więcej
Posted on the from Atom S.
Atom S.
Atom S.
User
Autor

I set MySql

Czytaj więcej
Posted on the from Atom S.
Andre E
Andre E
Moderator
Najlepszy Użytkownik miesiąca EN

One of the items is probably wrong, are your sure about all settings?

Is the hostname correct? be aware of words with capitals

try localhost as host name.

Czytaj więcej
Posted on the from Andre E
Dieter D.
Dieter D.
User

The settings are ok. But your provider doesn't allow direct database access, only from the webserver...

If you change the product quantities on stock "locally on your pc" and want to push them to the database, this doesn't work (PC -> Database).

You can only export your data in CSV, edit the quantities, reimport the data and upload your website as you would have changed stuff.

So this is not the fault of X5, it is very strict settings from your provider. Many providers do that unfortunately. I specifically loof at that setting when choosing a provider.

You could post as an idea that X5 includes stock updates over the /admin utility (as there you can see low stock items already an stock edit function there would be a logical thing).

Czytaj więcej
Posted on the from Dieter D.
Andre E
Andre E
Moderator
Najlepszy Użytkownik miesiąca EN

Thanks Dieter,

Shame that more and more providers close doors, mainly because there are safety issues from people that like to mess things up.

Czytaj więcej
Posted on the from Andre E
Atom S.
Atom S.
User
Autor

Thank you very much!

I understand, but then how do it?

Greets,

Czytaj więcej
Posted on the from Atom S.
Dieter D.
Dieter D.
User

Well, unfortunately only two good options. First is to switch to a provider who allows outside DB access, second would be the product export / update stock in CSV file / import.

Another option: If you are a experienced PHP programmer you could create a protected page in X5 where you add some custome code. This code could fetch your articles from the DB and hold a form where you can update the stock quantities.
I would suggest you only do this if you really know what you do as this is a possible security hole if not programmed well.

Czytaj więcej
Posted on the from Dieter D.
John S.
John S.
User

A funny thing :

The one year free hosting for new customers is at one.com.

This is one of the ISP's that do NOT allow outside access.

Czytaj więcej
Posted on the from John S.