Gossamer Forum
Home : Products : DBMan : Installation :

Limit to the number of records problem

Quote Reply
Limit to the number of records problem
Hello there. I am not sure if anybody else has come upon this problem. I am trying to enter records and after I enter about 50 records, I get an error message. It won't let me add any more records. I did discover that if I make a new account then I can add another 50 or so before I run into the problem again.

Has anybody else come upon this problem?

Thanks so much for your help.

akasharkbow Pirate
Remember, Elvis dies on the throne...
Quote Reply
Re: [akasharkbow] Limit to the number of records problem In reply to
Not sure if this will solve your problem but it might help.

Search in the FAQ under the section "Admin" for a thread called "Prevent Duplicate ID # due to page Reload"

It could be the script is having problems within sub add_record where it checks for the next available key. It currently is setup to give up after 50 times.

I know others have had this problems, but I'm not sure if this was the solution to fix it or not. I have added over 1,200 posts in the FAQ under one username with that modification and have never had a problem.

What are you using for your key field? If it an ID number?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Limit to the number of records problem In reply to
Hello there. Thnks for your reply. The key field is the first field but for some reason it is useing the Id of the person who edits it and just changes the last letter. For example if you logged in under "john", the first item you entered would have an id of "john". The second recored entered would have "johs" and so on. When it hits the end of the alphabet, it starts again an moves the next letter in up one so it would be "joia" then "joib" and so on.

Is this normal?

akasharkbow Pirate soon to be akasharkbox
Remember, Elvis dies on the throne...
Quote Reply
Re: [akasharkbow] Limit to the number of records problem In reply to
NO that is not normal. Can you post a copy of your .cfg file, or provide a url where it can be viewed?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Limit to the number of records problem In reply to
Hello there. I thought that it was strange. I have posted a .txt config file here. www.campingfellowship.org/config.txt.

Thansk for your help.

akasharkbow Pirate
Remember, Elvis dies on the throne...
Quote Reply
Re: [akasharkbow] Limit to the number of records problem In reply to
I'm getting a 404 error when I use the link you provided :(
Can you upload the file again and test the link.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Limit to the number of records problem In reply to
Sorry, it should be: http://www.campingfellowship.org/default.txt

Thanks
Remember, Elvis dies on the throne...
Quote Reply
Re: [akasharkbow] Limit to the number of records problem In reply to
I do notice that you have:

Userid => [1, 'numer',-2,15,0,'',''],

This should be an alpha field if it hold the username:

Userid => [1, 'alpha',-2,15,0,'',''],

Also the -2 only works if you use autogenerate

and:

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 0;

the userid field is 1 so you should set:

$auth_user_field = 1;

Make those changes and see if that helps. You may have to check over your current database file and correct any problems it may have caused with your prior settings.

Hope this helps

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/