Gossamer Forum
Home : Products : DBMan : Discussions :

User ID gets placed in counter field

Quote Reply
User ID gets placed in counter field
I have a really strange problem that I can't find a fix for:

I am setting up a new installation of DBMan - everything is working fine, except for this problem. I have a field set up for an ID number to be assigned by DBMan. I used JPDeni's Configurator to get it all set up. The ID field is my primary key and is supposed to be automatically incremented by DBMan.

When the "Add Record" screen comes up, it displays the correct next ID number. But, when I add a new record, DBMan puts the users login in the ID field.

So instead of returning "101", it returns "admin"

When I look in the default.count, it reads only "admin" If I add more records, it increments admin! Then the default.count reads "admio" then "admip" and so on!

I have tried deleting all records and changing default.count to be "101" - didn't help. I tried adding 5 records, going into default.db and manually changing them to 101,102,103,104,105 then setting default.count to 106 - didn't help!

If I log in as "author" I can't add any records because it tells me that my ID is too long (it's limited to 5 characters).

I searched through html.pl and default.cfg for "ID" to see if something was messed up somewhere - everything looked fine. DBMan uses userid for the user login id, so it shouldn't be confused, but somehow it is. Any ideas?

Here is the code from by db files:

From default.cfg
'ID'=> [ 0,'numer',5,5,1,'',''],
$db_key = 'ID';
$db_key_track = 1;

From html.pl
<INPUT TYPE="TEXT" NAME="ID" SIZE="5" VALUE="$rec{'ID'}" MAXLENGTH="5">
Subject Author Views Date
Thread User ID gets placed in counter field bpet 2574 Nov 20, 2002, 2:05 PM
Thread Re: [bpet] User ID gets placed in counter field
bpet 2507 Nov 20, 2002, 3:27 PM
Post Re: [bpet] User ID gets placed in counter field
rdub 1972 May 24, 2005, 3:02 PM