Undefined variable... 
Author: Sinisa B.
Visited 1275,
Followers 1,
Shared 0
Hi,
while uploading my site for the first time - the MySQL database check failed.
I have double checked database name, user name, password...everything is correct.
The only thing I suspect that might not be correct is the HOST NAME.
My hosting provider told me to put:
localhost
as my HOST NAME (no other characters -just: localhost)
The error log found on the server:
[26-Jul-2019 11:43:58 Europe/Zagreb] PHP Notice: Undefined variable: imSettings in /home/sblasiccm/public_html/izradawebshopa.eu/demoshop/wsx5-20190726094357-zk9rvfi5.php on line 132
Can anyone knows what might be wrong with the MySQL set-up?
Thank you in advance!
Posted on the
Author
BTW,
sending contact FORMS data is working fine.
Hello Sinisa,
The error message referring to the undefined variable is most likely not the cause of this particular problem, and should not prevent WebSite X5 from operating normally.
If your database is on the same server as your WebSite X5 project files then 'localhost' is indeed the correct hostname entry (and I expect your hosting provider will be well aware of your setup).
When you run the database tests in the online control panel of WebSite X5, does it give you any more detail as to why the connection fails?
https://help.websitex5.com/en/v2019.2/pro/index.html?pannello_controllo.htm
What version of MySQL is on your server? It needs to be a minimum of MySQL version 5.6
Have you given full 'permissions' to the username which is accessing the database from WebSite X5?
Author
Hi Paul,
thank you for replying!
I have given the full permission and localhost should work...
After 30 min. of looking - I have found the following info in the PHPMyAdmin section:
I presume it is the version of installed MySQL?
Author
@ Paul
One more thing - when I go to the admin page on my domain - can not log-in.
The message is: Unable to connect to DB
The link on my admin page is:
www.izradawebshopa.eu/demoshop/admin
BR!
Yes, this looks like the reason for the problem, Sinisa.
Ask your webhost to upgrade your MySQL on the server to at least version 5.6
Then you can run the tests again, and in all probability you will have no more errors.
I believe that you will find you are then able to connect to the online control panel too, assuming that you also have PHP (minimum version 5.6 as well) installed on the server.
WebSite X5 tech specs
Author
@Paul
Thank you!
I have notified my hosting-provider.
Hopefully, MySQL version on the server was the culprit ;)