Database/Login

[Keith Hughes]

Hi I'm trying to set up registration and login to a page on my site. Firstly I had a lot of problems setting up and accessing MySQL database. That seems to be ok now.
I can now enter the information for registering and go to a success page, I get the confirmation email but I can't find the information it does not seem to be stored in my database!!!

Can anyone help?

[Pablo]

Are you sure all your database settings are OK?
Are there any errors in the PHP error log on the server?

Note that this can only be a configuration issue. But, I can only help you with this if I know exactly what goes wrong.

[Keith Hughes]

Hi the only thing I can think of is that I'm not connecting to the server properly, I did have an error with the server but I thought I'd sorted that out.

[Pablo]

It is very difficult to help you with this without knowing the exact configuration of your web pages and the server.

[Keith Hughes]

Hi things still aren't uploading to the server. do I need to setup the registration, login, and admin in a certain way, do I need to set up a database for each section. The usersdb.php file is in the database on my server but with no data!

Regards Keith

[Pablo]

The usersdb.php file is in the database on my server but with no data!

This file has nothing to do with MySQL. It's a flat database.

Are you using MySQL or a flat database?
What are your settings?
What is the URL of the page?
Are there any errors in the PHP server log?

Note that the software has thousands of options and millions of possible combinations.
So, you will need to be more specific.

[Keith Hughes]

My website with the registration is www.how-to-learn-english.online/Register.php a screenshot of MySQL database is also at www.how-to-learn-english.online/2021-11-16.png

Regards Keith

[Pablo]

The database seems to be ok.

What are your settings?
Are there any errors in the PHP server log?

[Keith Hughes]

There are no errors on the server, it's a shame there are no detailed instructions into setting up this type of database what is the protect page and how does that work? Should I create a database for each section and upload it to the MySQL database?

[Keith Hughes]

I'm getting very frustrated now, I'm connecting with the MySQL but nothing is saving to the database, I can enter data and the page progresses to the destination page, but non of the data is saved to the database!!!

[Pablo]

This can only be a configuration issue.
I can only help you with this, if I know all your settings. There is nothing I can for you if I do not have all the information.

If something is wrong then there should be an entry in the server PHP log.

[Keith Hughes]

I'm trying to find the php log all I can see is this

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 seconds.)

[Keith Hughes]

10-Oct-2021 16:24:17 UTC] PHP Warning: file_get_contents(): Filename cannot be empty in /home/keithhughes/public_html/how-to-learn-english.online/index.php on line 154
[19-Oct-2021 18:42:01 UTC] PHP Warning: file_get_contents(): Filename cannot be empty in /home/keithhughes/public_html/how-to-learn-english.online/index.php on line 154
[20-Oct-2021 11:55:40 UTC] PHP Warning: file_get_contents(): Filename cannot be empty in /home/keithhughes/public_html/how-to-learn-english.online/index.php on line 154
[12-Nov-2021 06:19:44 UTC] PHP Warning: file_get_contents(): Filename cannot be empty in /home/keithhughes/public_html/how-to-learn-english.online/index.php on line 154
[14-Nov-2021 10:37:21 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keith'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 10:37:21 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 10:38:24 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keith'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 10:38:24 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 10:45:32 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'login'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 10:45:32 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 10:48:58 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keith'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 10:48:58 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 11:01:00 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keithhughes@localhost'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 11:01:00 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 11:12:40 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 11:12:40 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 11:15:04 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 11:15:04 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 11:20:58 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 11:20:58 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 11:39:49 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 11:39:49 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 14:57:12 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 14:57:12 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 15:02:09 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 15:02:09 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 15:03:18 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 192
[14-Nov-2021 15:03:18 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 195
[14-Nov-2021 17:23:05 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keithhug-root'@'185.229.22.191' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 219
[14-Nov-2021 17:23:05 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/EnglishSpeakingGroup.php on line 222
[14-Nov-2021 17:46:08 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:49:00 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:49:07 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:49:30 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:49:33 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:53:56 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:53:59 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:54:00 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[14-Nov-2021 17:54:09 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Login.php on line 202
[15-Nov-2021 12:49:51 UTC] PHP Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 282
[15-Nov-2021 12:49:51 UTC] PHP Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 282
[15-Nov-2021 12:49:51 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 285
[15-Nov-2021 17:07:49 UTC] PHP Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 229
[15-Nov-2021 17:07:49 UTC] PHP Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 229
[15-Nov-2021 17:07:49 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 232
[15-Nov-2021 17:34:30 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 225
[15-Nov-2021 17:34:30 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 228
[17-Nov-2021 11:56:08 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/loginadmin.php on line 69
[17-Nov-2021 11:56:08 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/loginadmin.php on line 75
[17-Nov-2021 11:57:29 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'185.229.22.191' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/loginadmin.php on line 69
[17-Nov-2021 11:57:29 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/loginadmin.php on line 75
[17-Nov-2021 11:58:16 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'185.229.22.191' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 225
[17-Nov-2021 11:58:16 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 228
[17-Nov-2021 16:05:03 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'keithhughes@localhost'@'185.229.22.191' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 225
[17-Nov-2021 16:05:03 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 228
[17-Nov-2021 16:07:09 UTC] PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'localhost'@'185.229.22.191' (using password: YES) in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 225
[17-Nov-2021 16:07:09 UTC] PHP Warning: mysqli_error() expects parameter 1 to be mysqli, bool given in /home/keithhughes/public_html/how-to-learn-english.online/Register.php on line 228

[MGD4me]

Access denied for user 'keith'@'localhost'

You have attempted to login as various users, such as 'keith', 'root', etc, and the above 'Access denied' error is being returned.

This can only mean that either the user in question has not supplied the correct password, or that the user does not have the rights to make any changes to the tables in the database.

[WWBman]

Adding to MGD4me:
When you created the database did you create a user and added the user to the database?
FWIW: My users have format of d_n where d=databasename and n=name.
When creating the user did you give it permissions?

To check the user go to MySQL Databases.

[Keith Hughes]

this is the errors as of today, I'm sure now that everything is OK with the MySQL database. So I'm still at a loss why it won't work.

[17-Nov-2021 18:10:19 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page1.php on line 52
[17-Nov-2021 18:11:34 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page1.php on line 52
[17-Nov-2021 18:14:12 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page2.php on line 26
[17-Nov-2021 18:14:15 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page2.php on line 26
[17-Nov-2021 18:14:16 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page2.php on line 26
[17-Nov-2021 18:14:17 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page2.php on line 26
[17-Nov-2021 18:14:19 UTC] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /home/keithhughes/public_html/how-to-learn-english.online/page2.php on line 26

Line 52 and 26 seem to be an issue!

Regards Keith

[jerryco]

What is on those lines in the files?

[Pablo]

To be able to help you with this, I need to know what the PHP code is.
I need to know the context of the error.

[Keith Hughes]

Hi you can download my wbs file from www.how-to-learn-english.online/English.wbs

[Pablo]

Thanks for the project.
However, the project does not have page1.php or page2.php
Did you share the right project?

[Keith Hughes]

No I removed page1 and page2 because I was trying to make the database work if I installed it on a blank page but it made no difference. The pages with the MySql on are EnglishSpeakingGroup.php is where the admin page is, Login.php is the login page and Register.php

[Pablo]

It is important to know at which line the error occurs.
So, either share the project with the missing pages or else share the new project with 'EnglishSpeakingGroup.php' and the update error log.

[Keith Hughes]

Hi I've come to the conclusion that MySQL databases don't work on WYSIWYG so I'm going to try a flat file database!! Do you have any instructions on how to do that?

[lummis]

I use MySQL databases with my WB website and I have never had a problem that couldn't be resolved. When I have had difficulties it has usually been due to the fields in the database being incorrectly configured. For example have you got a DATESTAMP field in your table as that is often one that is missing but there could be others.

[WWBman]

MySQL databases do work in wwb.
You can find .csv file info in the main wwb menu help.

[BaconFries]

I am sorry but your conclusion is wrong. They work just fine, you should also note that all Databases such as MySql are ran on your server and not within WYSIWYG itself. So it is either a configuration issue or your server may require MySqli rather than MySql to which only your host of can confirm. I would suggest that you check all configurations are correct also check the PHP version required and the correct database use such as MySql or MySqli. But WYSIWYG does allow you to use all of the mentioned aslong as it is configured correctly.

[Keith Hughes]

Hi I've had my server company check everything over and all was fine, all the connection details were correct, so the issue must have been with WYSIWYG. However I've now set up a Flat File system, that is working reasonably well, however I wanted to change the admin password and that does not seem able to do, what is the secret to changing the admin login password?

[Pablo]

I am sure the issues with MySQL are related to your configuration. The error log confirms this.
However, if you do not provide the requested information then it's not possible to help you figure out what is wrong.

You can change the admin password in the properties of the Login Admin object.

[Keith Hughes]

If only that would work, changing the password in the properties simply does not work!!

[Pablo]

Of course it works... There is no way this can fail, if used correctly.
Did you republish the page?
Did you clear your browser cache?

[lummis]

You could watch the video at https://youtu.be/UToDq4UXmyM which might indicate where you have gone wrong. Although it was made 4 years ago the principles are still the same.