Login tools MySQL issues

Issues related to the Login tools of WYSIWYG Web Builder.
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/login_basics.html
http://www.wysiwygwebbuilder.com/login_tools.html

TIP:
A lot of information about the login tools can be found in the help/manual.
Also checkout the demo template that is include with the software.
Post Reply
Opus20
 
 
Posts: 2
Joined: Fri Jul 10, 2020 1:19 am

Login tools MySQL issues

Post by Opus20 »

Just need a bit of help with setup. Not sure what the problem might be but I am sure it is a simple fix.
Used the sample Login tool with a local file and it works as advertised. My problem started when I switched to the MySQL database.

I am using a localhost setup as follows:
Wampserver64 ver 3.2.0,
Apache 2.4.41,
PHP 7.3.12, (maybe using the wrong version?)
MySQL 8.0.18 (the MySQL setup is using port 3308)

I set up the login tool as follows:
Behavior
Admin Password: ********
Database
MySQL Database Name: 'opus20' (with all privileges turned on)
MySQL Password: '********' (tried with and without)
MySQL Server: 'localhost:3308' (also used 'localhost' by itself to no avail)
MySQL Table Name: 'users'
MySQL Username: 'opus20net'

Publishing the Login tools to Wampserver www folder (login) with all pages with the PHP file extension selected and document type as HTML 5 (also tried HTML 4.01 Transitional).
Accessing the site (localhost/login) (Microsoft Edge) everything seems to work until I access the "User Administrator" page. No errors are reported (no database connection fails) but the "User Administrator" Login box is missing. So I cannot log in and/or add any users. Added a user to the database manually, with no changes to the website's behavior. Tried login in using that user and received a "Fatal error: Uncaught Error: Call to undefined mysql_connect() in E:..." so this tells me is not connecting to the database but it does not show any fails in the 'User Administration' page. When publishing the same website to my server (actual website server) I get the same behavior. Seems to connect to the database but something is missing.
No code was altered, just following the tutorial as is.
I know is something very obvious but I can't seem to narrow it down.
Any help will be greatly appreciated.
Thank you in advance.
User avatar
Pablo
 
Posts: 21569
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Login tools MySQL issues

Post by Pablo »

It looks like the PHP version in Page Properties->Advanced is not set correctly.
Please make sure "PHP5 - PHP7" is selected.
User avatar
mfirlotte
 
 
Posts: 141
Joined: Tue May 12, 2020 5:09 pm
Location: Quebec, Canada

Re: Login tools MySQL issues

Post by mfirlotte »

Hi Pablo...a sidebar question please as you make note above to setting PHP 5 - PHP 7.

I need to upgrade my version of PHP on my hosting service from 5.5 to 7.0 or better. It's easy as I just pick the version I need from a picklist.
Everything works just fine across the site where I have PHP code except for my Contact us form. I get the following error message: "SMTP Error: Could not connect to SMTP host."

When I flip it back to PHP 5.5, it works as expected and sends the email and uploads the attached file to the server.

I checked what you mention above and the page is set properly for PHP 5-7.

Any ideas.
====
Mitch
====
User avatar
Pablo
 
Posts: 21569
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: Login tools MySQL issues

Post by Pablo »

I get the following error message: "SMTP Error: Could not connect to SMTP host."
This means that there is a server configuration issue related to SMTP.
Unfortunately, I cannot help you with the server configuration.
User avatar
mfirlotte
 
 
Posts: 141
Joined: Tue May 12, 2020 5:09 pm
Location: Quebec, Canada

Re: Login tools MySQL issues

Post by mfirlotte »

OK thanks Pablo. I'll check with the hosting service.
====
Mitch
====
Post Reply