jrichter
|
| Posted: 04/14/2002, 12:53 PM |
|
It appears that CC is expecting the user ID field to be numeric, even though the field I indicated in the Properties section is clearly a text field. I get a mysql error (using PHP) when I go to the login page while a user is already signed in. Patching the login.php file to make a "tosql(get_session("UserID"), 'Text') in the User is logged in Section appears to resolve this, but I'd rather not have to patch code every time I generate the site...
Any other solutions (other than adding a new redundant field to my existing databases, considering all my textual user IDs (which are usernames) are unique)?
Jake
|
|
|
 |
Alex Alexapolsky
|
| Posted: 04/15/2002, 2:23 AM |
|
Does your UserID have any special characters in it ?
|
|
|
|
jrichter
|
| Posted: 04/15/2002, 6:35 AM |
|
No. My UserID field is pure alphanumerics (A-z, 0-9) - no punctuation. The error I get is:
Database error: Invalid SQL: SELECT id_user FROM users WHERE id_user=jrichter
MySQL Error: 1054 (Unknown column 'jrichter' in 'where clause')
Session halted.
If I put the UserID (jrichter) in single quotes, everything works fine.
Jake
|
|
|
|
|
