Gossamer Forum
Home : Products : DBMan SQL : Discussion :

UserID (Can't be Blank)

Quote Reply
UserID (Can't be Blank)
I had this working perfectly as reg. DBMan - now moving to mysql; I can't seem to solve this error "UserID (Can't be Blank)" when adding a record - I have checked and re-checked the forms and they seem correct;

<input type=hidden name="db" value="db">
<input type=hidden name="uid" value="testuser.4804">

<TABLE WIDTH="450" CELLPADDING=0 CELLSPACING=0 BORDER=1 BGCOLOR="#FFFFCC">
<input type="hidden" NAME="UserID" VALUE="">
<input type="hidden" NAME="ID" VALUE="">

The script is at:
http://cspweb.net/cgi-bin/test/db.cgi login:testuser pw: testuser

Any direction would be appreciated.

Thanks!

Jim

Quote Reply
Re: UserID (Can't be Blank) In reply to
You are confusing fields....uid is for logging in. Userid is what they fill in the form.

Do you have codes for automatically filling in the Userid field from the user table?

Regards,

Eliot Lee
Quote Reply
Re: UserID (Can't be Blank) In reply to
Thanks for your reply Eliot, it is appreciated. The $db_supply_key = 1; was set to "0" and upon changing it the issue was resolved. However, things are still pretty funky - I have a lot of mods with the original version - I'll keep plugging away, thanks again.

Jim

Quote Reply
Re: UserID (Can't be Blank) In reply to
Right...and as mentioned in a number of Threads...any Mod that accesses the .db file for the original version will have to be re-written to access the DBI:MySQL (or whatever DBI you are using) tables.

Good luck!

Wink

Regards,

Eliot Lee