close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Registration process not populating database

Thread began 6/24/2010 5:14 pm by gail.bergan407744 | Last modified 7/08/2010 12:05 pm by gail.bergan407744 | 1215 views | 9 replies |

gail.bergan407744

Registration process not populating database

Hello again,

After getting my password problems resolved, I have a new problem. I uploaded all pages to my site and tried the simple registration page. After hitting Register, I do get the "thank you for registering, please click on the link in your email inbox" page. I click on the link in the email to verify the email address, then get the "thank you for verifying, now please log in" page. When I try to log in, I get the error: "The login information provided is not valid, please try again." Also when checking the database, I see that a user did not get added to the database.

I get this same error whether or not I have a standalone "Users" database (built by executing the .sql script in phpmyadmin) or by going through the same procedure, but adding a "users" table to a preexisting database. When trying the two different databases, I was careful to change the database name in the localhost connections file, and reupload that.

Any ideas? Would it help to look at any of my files? If so I would be happy to attach.

Thanks,
Gail

Sign in to reply to this post

Jimmy Wu

One test that you could try is to manually add the user into the database and then trying to login using that user that you generated. This will help determine if the connection is successfully being made to the database. Also, can you provide a link to the pages so I can try the behavior myself?

Sign in to reply to this post

gail.bergan407744

test worked

Excellent suggestion on manually adding a user (myself) to the database...I did this, then logged in. It successfully pulled up my profile (users_Profile.php). So something is wrong with my registration/verification pages, it would seem. The pages you could test yourself are users_Registration_Simple.php, users_Registration.php, Users_Confirm.php, etc. By the way, I am connecting with my preexisting membership database, with your users table added as a second table (rather than Users as a standalone database).

One question on the verification, registration, and lost_password.php universal email pages provided in the solution pack. I assume I am to move them out of the templates folder and into my main directory (after doing a SaveAs)? Or should the verification process be pointing to WAUE_users_EmailPW_1, WAUE_users_Profile_1, and WAUE_Registration_1 pages? It wasn't clear in the documentation what we were to do with these templates once we customized them.

Sign in to reply to this post

Jimmy Wu

You would want to leave all the pages with the same structure as when you downloaded them, so you shouldn't be moving them around or you will affect some of the paths.

As long as your connection file is pointing to the correct database, you shouldn't have any problem with having any other tables in the database. It looks like the process that is being skipped is the insertion into the database. Is anything getting inserted into the database or is it not getting populated at all?

To check the insert query, find this line of code in the users_Registration_Simple.php file:
$WA_Sql = "INSERT INTO `" . $WA_table . "` (" . $insertParamsObj->WA_tableValues . ") VALUES (" . $insertParamsObj->WA_dbValues . ")";

After this line, add this line:
die($WA_Sql);

Then run through the registration again. Post back with what is displayed on the page.

Sign in to reply to this post

gail.bergan407744

I added the code as you suggested. I still get:

"The login information provided is not valid. Please try again."

Gail

Sign in to reply to this post

gail.bergan407744

As a PS to my previous message, when I try to register a user who is already in the database, I get the message "that email address is already registered." So it seems to be connecting/reading the database OK, it's just not inserting anything new.

Gail

Sign in to reply to this post

Jimmy Wu

That's interesting, the sql statement that is being used isn't being displayed onto the page at all?

When you're registering are you using the users_Registration_Simple.php or just the regular users_Registration.php page?

Sign in to reply to this post

gail.bergan407744

I stated in my original posting that I'm using the simple registration form. I don't understand your question about the sql statement. I'm relaying to you all error messages that I see on the screen.

I'm desperate to get this up and running...have been fighting for 2 weeks with URSP and seem to hit roadblocks at every stage.

Sign in to reply to this post

Jimmy Wu

I'm not sure I see where you stated that you're using the simple registration form. You have both registration forms referenced in the second post you made.

Have you made additional modifications to the page or the database since I last posted? It looks like when I access the simple registration form, I get a sql error now. Here is the error I am getting on your simple registration form:
Unknown column 'UserID' in 'field list'

Could you attach the current code for that page?

Sign in to reply to this post

gail.bergan407744

I've been forced to abandon this product. After two weeks of struggling trying to get it to work, I built a simpler login solution from scratch. My hosting service told me that one issue may be that your fields in your Users table are not all lower-case, but camel-case (i.e., UserID instead of user_id) and that upon transferring to our server, the case issue becomes a problem. Since all your scripts would have to be edited if I changed all fields to lower case, I decided this would cost me an additional amount of time that I just can't invest. They may be right or they may be wrong, but at least I have something that works now.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...