Merry christmas all!

I run this with my own database records add shared with my friends only. I can access all while my friends can only view, add, modify and delete records. No other access level. I set the following:
$auth_no_authentication = 0;
$auth_logging = 1;
$auth_allow_default = 0;
@auth_default_permissions = (1,0,0,0,0);
$auth_signup = 0;
@auth_signup_permissions = (1,0,0,0,0);
$auth_modify_own = 1;
$auth_view_own = 1;
$auth_user_field = -1;
No IDkey and user field.
But it seem that i (login as admin) can't
modify and delete records. Add record is possible but display blank field information.
Can someone helf me?

Thanks,
George

If you have

$auth_modify_own = 1;
$auth_view_own = 1;

you have to have a user field. Otherwise DBMan doesn't know what records are the user's "own" records to modify and to view.

I'm not sure if that will fix your admin problem, though.



------------------
JPD

Thanks JPD,

But how about only one author and one admin?
only the author post, modify and delete record ?

And my problem is Admin can't modify and delete records.

Best Regards,
George

I'd check two things.

First, make the change to set a the user id field. I'm not sure how that would cause the problems you're having, but it might.

Second, check to make sure that your admin userid really has admin permissions. When you logon as "admin" do you see the "Admin" item in the menu bar at the bottom of the page? Can you add and delete users?


You still need to have a userid set. If the login userids are "author" or "admin" then every record would have either "author" or "admin" in the userid field.


------------------
JPD

I am having a problem deleting records from our database. I am using the following permissions set in the default.cfg file:

$auth_no_authentication = 0;
$auth_time = 21600;
$auth_logging = 1;
$auth_allow_default = 1;
@auth_default_permissions = (1,0,0,0,0);
$auth_signup = 0;
@auth_signup_permissions = (1,1,1,1,0);
$auth_modify_own = 0;
$auth_view_own = 0;
$auth_user_field = -1;

What is happening is that if I type in a keyword in one of the fields in the delete form, I can pull up unique records associated with the keyword. However, when I type in an ID number, I get all records that have that number in the record. For instance, I type in '1' for record one, I get 8 results that have the number '1' in the phone number field.

Anyone have suggestions on how to solve this problem?

TIA

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

I just saw something in George's original post. He said he had "No IDkey and user field." I must have missed that the first time around. You have to have a key field.

Now to Eliot
You'll need to set "Whole words" on your search form.

I just reread what you wrote. Do you have just a keyword field that you're using to search or do you have individual text input fields for each record field?


------------------
JPD

JPDeni

Hello again. What we have for the deletion form is exactly the same as the ADD and MODIFY forms, which have 'individual text input fields for each record field'. (Yes, it does have a ID field.)

But I do not have a userid field. I actually deleted the 'Userid' field, because at this time, I will be the only one administrating the Employee Directory. In the future, we may open the Directory up so that personnel can update their information. The problem with that is that 60% of our personnel are transitory adjunct/associate faculty, so creating batch user accounts that won't even be used that often is waste of my time.

I think that this problem may be related to the ID number posting I left earlier.

Regards,


------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

You say you took out the userid field. Are you sure you started over with a blank database after you took out the field? If some records have a different number of fields than others do, you're going to have problems.

It is a good idea, though, if you're searching by ID number, to check the "Whole Words" box.


------------------
JPD

Thanks for the heads up! Yes, I did not start with a fresh db file after taking out the ID field. That could be part of the problem. I inserted the ID field back in and I am still experiencing problems with adding new records after deleting older records.

Here are links to text versions of the .cgi, .cfg, and .pl files:

Default CFG file:

http://www.coco.cc.az.us/cgi-bin/dbman/dbcfg.txt

Default CGI file:

http://www.coco.cc.az.us/cgi-bin/dbman/dbcgi.txt

HTML PL File:

http://www.coco.cc.az.us/cgi-bin/dbman/htmlpl.txt

If anyone can figure out the problem with these files, let me know. BTW: I have added many new sub-routines and coding, so it may be challenging to find everything.

To see the "working" version of the Employee Directory, visit the following web page:

http://www.coco.cc.az.us/cgi-bin/dbman/db.cgi

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited April 21, 1999).]

What I would suggest is that you start over with a completely blank database and that you set autogenerate to 1 in the .cfg file. In fact, if you have added subroutines to db.cgi or html.pl, I would suggest that you start with the "plain vanilla" db.cgi and html.pl files with your database configuration as you have it now. That will let you know if there are problems with your .cfg file. (I didn't see any, but there could be something I missed.) Add each new thing, one at a time, and test it to be sure it works before you add anything else.

------------------
JPD