2. PHPRunner General questions
  3. Login using Database tables
This topic is locked

Login using Database tables

 		8/1/2013 17:20:25
PHPRunner General questions
K
 kenny_robb author

This is weird one and I can't explain it.
I am using the database security function to allow users to login with userid and password.
I have a field varchar(25) utf8_general_ci Null No Default (blank) that I use for the password field which does not work
I have another field which is defined the same way as the above field which does work (only difference is that it is called something different)
I can't really use the second one as it contain the email address.
Any thoughts?
N
 		nohope4you 8/3/2013



This is weird one and I can't explain it.
I am using the database security function to allow users to login with userid and password.
I have a field varchar(25) utf8_general_ci Null No Default (blank) that I use for the password field which does not work
I have another field which is defined the same way as the above field which does work (only difference is that it is called something different)
I can't really use the second one as it contain the email address.
Any thoughts?


I would try:

  1. renaming the original table... if it was called tableA name it tableAold
  2. making a copy with no records and naming it the original name tableA
  3. re-syncing your phprunner project tables with the database, then doing a full output of new php files
  4. Add one record to your new tableA
  5. test that record
  6. if that doesn't work go directly to your database and check for trailing spaces in the new table.
G
 		gdude66 8/5/2013

I had the same problem. In query designer for the table the password is in select the password field as part of the default query. In view fields mode make the password not visible on all pages then it will work.