Connecting to a database 
Author: Duncan Baker
Visited 3540,
Followers 2,
Shared 0
I am trying to set up automatic registration to access a set of videos on my website. I have built a database and named a table. I have entered that in the advanced settings but I cannot see an automatically generated registration/login page.
If I try to update in access management I get "connection error: it is nt possible to compete the operation".
I have tried to follow the instructions in the help files - but failed.
Grateful fro your help.
Duncan
Posted on the
Strange that you get an error, the setting for automatic login is in step4 acces management, then settings TAB. Did you set it there to automatic registration?
See that the databse adress (host) is correct the FAQ of your serviceprovider should help you with the correct adres. (could be only the text -> localhost <-).
Author
Thanks Andre,
At last I am getting somewhere but not very far!
The registration form comes up OK - http://http://2016.theglobalapproach.co.uk/imlogin.php?loginstatus=-3
but, if I try to register, iot tell me that the selected user is already present - but it's not
If I try to log in with that user name, I get - Wrong username and/or password - and - User already registered
If I try the lost password like, I get - The specified account cannot be found.
I can log in OK using admin and my admin password
Access Management is set to Automatic Registration.
I attach a sreen shot of the Data Management settings which my ISP assure me are correct - the only question they have is where the Server folder with write access should be. I have made a folder "data" in the root of the website and have set chmod to 777 - I have tried this with "data" and "/data". I have also tried with the Host Name "localhost" - but no joy.
I have logged into the database with phpmyadmin but nothing is getting written there.
Grateful for further thoughts from you or from anyone else!
Duncan
Author
Ahhhhh! Sorted!
I had linked to an exisitng table in the database and there must have been a conflict as the fiedls were not the same.
I have now set up a new blank table and let X5 sort out the fields. And it all works.
Sorry to have troubled you Andre, and thanks for your patience.
Duncan
Duncan,
I entered myself -> got a message : Registration successfully completed.
I logged in, got to a site where it says This is to test password access.
So it looks all good, so what happens on your end ?
I think that you logged in but not logged out, in that case you stay logged in, this is done by a cookie on your pc.
What can you do about it? well duh remove cookies..... or set a logoff somewhere, this way the login cookie will be removed. the log off you can create with the html code object. you can set it on the loged in page or in the header footer, I believe it shows only if your logged in but I'm not sure it's a while ago sinds I have been using the automatic logon....
Keep in my the way x5 works with login, once logged in you stay logged in an can acces the hidden page directly also after a few days, unless you logoff or delete cookies.
Hope this helps !
I see you already got there, I shall let this post stand, it can help others as well, glad you sorted it out.