Database/Login

[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.