Page 1 of 1

Creating MYSQL table on the server

Posted: Thu May 30, 2019 9:54 am
by NarellanProbus
I have some code showing in "Create MYSQL database" when I set up my Login panel for my database. The message tells me to use the listed SQL statement to create the MySQL table on the server - but how do I do that? I would really appreciate some help. Thanks, Sue

Re: Creating MYSQL table on the server

Posted: Thu May 30, 2019 11:35 am
by WWBman
I am assuming your server isn't a Windows one as I have no experience with that type.

First copy the code you have.
Log onto your server and go to the cPanel.
Under database tools click MySQL Databases.
Give the new database a name and click Create database.
Use the Add a New User and Add a User to a Database sections.
Click cPanel.
Under database tools click phpMyAdmin.
Click the database you just created either from the left hand menu or under Databases.
Click SQL and paste the code in the text box and click Go.
This will create the required table in the database for the login system.
I hope I've got that right!

BTW you can use a flat file instead of a MySQL database.

Re: Creating MYSQL table on the server

Posted: Thu Jun 06, 2019 12:15 pm
by NarellanProbus
Thank you responding. I have done this but cant seem to get the information linked to the server. I have been working on this for a few months and have tried many things but only small steps to getting there. It is probably going to be something quite simple that I have failed to do. I had considered a flat file but I need to attach photos to members information on the database eventually and I didnt think I could do that on the flat file. I had a database when I was using webplus and that was so simple to set up but this is so so difficult.
Thanks again,
Sue

Re: Creating MYSQL table on the server

Posted: Thu Jun 06, 2019 1:18 pm
by WWBman
What error do you get?
Have you double checked the entries in the Admin Database section?

Re: Creating MYSQL table on the server

Posted: Sun Jun 09, 2019 8:59 am
by NarellanProbus
Thanks for being willing to help.
I went back to start everything again, watched the video but still have difficulty.

Getting started on demo login site: c) didn’t get location for publishing but presume it is cpanel for my website: www.narellanprobus.org.au
This was on video but didnt come up on the login panel "select where to upload website project"
I didn’t get directories to show where to upload website project to create database (as video stated).
Sign up for new account login panel: it says to change the link to your website (that wasnt an option on the panel)

Message when I upload Login page:
host was successfully parsed.
connecting to ftp….
successfully connected.
Current directory is '/'
setting remote folder to /public_html..
Status: 550 Cant create directory: File exists.

When I publish, then fill in login panel this is what I get. (Note: I have substituted nar..... instead of the actual username)
Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50545 Library:50641 in /home/nar
....../public_html/Members_Login.php on line 26

Warning: mysqli_connect(): (HY000/2005): Unknown MySQL server host 'localhost:3306' (0) in /home/nar......./public_html/Members_Login.php on line 26

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/nar....../public_html/Members_Login.php on line 29

Re: Creating MYSQL table on the server

Posted: Sun Jun 09, 2019 9:50 am
by WWBman
I'm finding it difficult to know what's going on here!
Which video are you looking at?
When I go to User Administrator I get "Failed to connect to database server!".
So have you checked that the Database entries in the Admin object are correct?
Also go to the server's cPanel and phpMyAdmin and check that the database is setup correctly with the correct columns as specified in the SQL code that was generated when you clicked Create Database in the Admin object.

Re: Creating MYSQL table on the server

Posted: Sun Jun 09, 2019 11:40 am
by NarellanProbus
I checked out the WYSIWYG Web Builder Login Tools demonstration site, and http://www.wysiwygwebbuilder.com/login_ ... troduction Video.

I published the Login demo site to see it working and trying to get an understanding of logins and database, then afterwards I reloaded my original website (4 times) but the login demo is still showing. I contacted my hosting company and it could take another couple of hours for my site to show. I sure hope it will. (Ive just saved it again and published again but the demo site is still there.
.

Re: Creating MYSQL table on the server

Posted: Sun Jun 09, 2019 12:43 pm
by WWBman
The video link btw should be http://www.wysiwygwebbuilder.com/login_tools.html
But this just uses the flat file, not a MySQL database.

After publishing, the website should show immediately so I don't understand why the hosting company say that.
Are you sure you are not picking it up from your browser cache?
Try clearing the browser cache and try again.
And make sure you are publishing to the correct folder.