Posting to MYSQL Database
Autore: Paul S.
Visite 1453,
Followers 1,
Condiviso 0
I have a MySQL database hosted on an ISP for the website www.northerndiv.nz
Although I have verified the database exisits on the host I cannot post to it using the mail Contact Form.
Postato il
Hello Paul
Have you checked that your setting in X5 of the database connection is Ok.
Check this post : https://helpcenter.websitex5.com/it/post/198983
You make the connection in : 1 settings / advanced - data connection
You can find some information here : http://help.websitex5.com/en/v16/pro/index.html?gestione_dati.htm&utm_source=software&utm_medium=Professional_16
Hello Guys,
You will find here a nice tool to test your hosted database connectivity before to "play" with WSX5 db connection !
https://wsx5.afsoftware.fr/viewforum.php?f=14
Enjoy!
Hope this helps
Regards
https://wsx5.afsoftware.fr
Autore
I can connect with the database using the tool from afsoftware and see that the table exists, but my website entries using the Contact Form do not update the database and I do not get a confirming email.
hello Paul
If you can be connected with my tool, so the issue is really from the software configuration and not from your provider or db parameters.
It's a good new to see this tool is useful for you. thanks
Just one question. Does your db user has right to do modifications into the db ?
Also ask to the provider to check the logs to see if their is some reject or something like that.
For emails issues, on the admin page of your web site (www.youwebsite.com/admin) you can test email sending
Hope this helps
Regards
https://wsx5.afsoftware.fr
Autore
Thanks for you comments.
I have checked, and the user has full rights on the database.
I have asked the ISP to check for rejected posts as you suggest.
I have used X5 for email sends from other sites using this ISP and they work OK.