WebSite X5Help Center

 
Mohamed F.
Mohamed F.
User

MySQL settings test failed  en

Author: Mohamed F.
Visited 1948, Followers 1, Shared 0  

I have a new website hosted by Godaddy, and I am used dynamic content in some pages so I create a database file on the server with user that have full authority and add those to my data management and assign on my dynamic object to use that database, this feature was working well on my old host location but with this new one with godaddy I got that message while I am uploading my site.

"The Following test Failed - MySQL Database Settings"

Note that I have

MySQL 5.6.39

PHP5.6
       7.0
       7.1
       7.2 (default)
       7.3

I tried to contact godaddy for this but they couldn't figure out the problem.

so I hope you can help me on that. 

My dynamic page is:

http://www.systemsdesign.tv/partners.php

Posted on the
9 ANSWERS - 1 CORRECT
Paul M.
Paul M.
Moderator

Hello Mohamed,

Log in to your WebSite X5 online control panel located here:

http://www.systemsdesign.tv/admin/login.php

...using the Administrator email and password which you will find in Step 1 Settings > Advanced > Access Management

Once logged in go to the Website Test section and report back the details of any errors displayed under MySQL Database settings.

Kind regards,

Paul

Search the WebSite X5 Help Center

Read more
Posted on the from Paul M.
Mohamed F.
Mohamed F.
User
Author

this is the screen

Read more
Posted on the from Mohamed F.
Paul M.
Paul M.
Moderator

Thank you for the screenshot, Mohamed.

I had hoped there might be a more descriptive error message, but never mind.  We will try and work it out regardless.

Your screenshot shows that you created a third database (Systems trial) which did pass all the necessary tests and thus was correctly configured for use with WebSite X5.  Can you think of any reason why this might be?  What is different about this database compared to the other two?

Are all three databases on the same server?

Are the two problematic databases on the same server as your WebSite X5 project?

Can you double-check your MySQL database access credentials (Host name; Database name; Username; Password) by attempting to log in to the databases using phpMyAdmin?  This free tool can be found on most web servers...  look for it in cPanel if you have it:

https://www.phpmyadmin.net/

If you can log in using phpMyAdmin (or any other third party database tool), and are using exactly the same credentials in WebSite X5, then we can rule out access credentials as the source of the trouble.

Did you create any tables for your databases manually?  WebSite X5 prefers to create the database tables itself.

If you have access to your server logs (again using cPanel or a similar online control panel) then there might well be more detailed information there as to the nature of the failure.  It would be worthwhile looking through the logs for anything related to MySQL, which could give a clue and help to narrow down possible causes.

Read more
Posted on the from Paul M.
Mohamed F.
Mohamed F.
User
Author

Hi Paul,

Are all three databases on the same server?

No the first one which is working on my old server but the others on the godaddy server with my website.

Are the two problematic databases on the same server as your WebSite X5 project?

Yes

If you can log in using phpMyAdmin

Yes I have it and already use with the same user details

Did you create any tables for your databases manually?  WebSite X5 prefers to create the database tables itself.

one of them I import my old data in it according to Godaddy's technical support request and the other was empty but now I have both Empty without any tables

If you have access to your server logs 

Kindly find the attached log file for our ftp and I hope it can help

Read more
Posted on the from Mohamed F.
Paul M.
Paul M.
Moderator
Mohamed F.
Are all three databases on the same server? No the first one which is working on my old server but the others on the godaddy server with my website.

I have a hunch that this might be key.

Can you tell me please what you have entered as the Host Name in Step 1 Settings > Advanced > Data Management > Database for each of the three databases in turn?

Read more
Posted on the from Paul M.
Mohamed F.
Mohamed F.
User
Author

1- egytouch.com

2- systemsdesign.tv

3-systemsdesign.tv

Read more
Posted on the from Mohamed F.
Mohamed F.
Mohamed F.
User
Author

by the way the first one will not be used in the new server I just keep it to keep testing the connection with my old server as it was just a demo version of the site before uploading to systemsdesign.tv

The main target is to let the new data base working on systemsdesign.tv server

Read more
Posted on the from Mohamed F.
Paul M.
Paul M.
Moderator

Please delete systemsdesign.tv from the Host Name field, and enter localhost instead.

Then reupload your project to the server and use the WebSite Test facility in the online control panel to check if connection is now successful.

Read more
Posted on the from Paul M.
Mohamed F.
Mohamed F.
User
Author

Thanks for your support it works :)

Read more
Posted on the from Mohamed F.