Okay...everything seems to be working so far. I pull up the DBMan demo and the Logon Screen appears. Hmmp. "Now, which logon/password are they refering to?", Is the question that pops into my mind. I tend to believe that I need a seperate Logon/Password for DBMan but I don't remember establishing anything of the sort when setting up the scripts. So, I try using my server access Logon/password. NOGO. Doesn't work.

Okay....How do we establish Logon permissions?

Thanks!
Justin

LOL Mike! Ended up figuring that out. *s*

When I did, this is what it gave me in response: (Top line only)

unable to open auth file: ./auth/. Reason: Permission denied

So, how do we set permissions?

Try starting with admin/admin.

Can you post your .cfg file in a web-accessible directory (one where you would place html files) and rename it to default_cfg.txt? It would help to be able to see it.


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

Are you still working with netscape? How did you set the permissions on your other files? db.cgi, etc.. My problem was that I forgot to set my auth directory permissions to 777 or drwxrwxrwx That would give you the error you mention

Mike

I had a look at all three you mention and I think ftp voyager will be
the easiest for you to work with. Connect to your site then find and
right click your auth directory, select properties and set the
permissions to 777 or read, write, execute for everyone(user,group, and
world). email me if you need help.

JP, here is what you requested: http://www.apds2000.com/default_cfg.txt
Please see what you can find. If you need to see another file let me know.

mike,...yeah, I'm still using Netscape for FTP but as I said on the other board, it doesn't provide options for setting permissions.

"to 777 or drwxrwxrwx" - Now where would you do this? What file? What ROW?

I'll be sticking my head in and out of here all day to keep up.

Justin

Justin,

If you are going to work with perl you will need an ftp program that allows you to set permissions or else you will need telnet access to your server to 'chmod' your files. There are a lot of good ftp programs available out there. Try http://www.tucows.com and search on ftp client.

Mike

mike, looking at some right now. Hard to tell which one is going to be the one I need.
So far, WebFTP, FTP Express, FTP Voyager, and Ability look to be the best. Got a preference?

BTW...I couldn't find CuteFTP or wsFTP.

[This message has been edited by JustJay (edited June 15, 1999).]

Okay...FTP Voyager set up. Which files do I need to change permissions on?

JP...find anything in the default_cfg?

Justin,

You need to set the permissions on the 'auth' directory itself to 777.

Mike

Okay! Hey, it worked! I also had to change the permissions on the default.log.

"MAIN MENU!" What a wonderful sight!

Time to tinker!

Thanks, Mike!

Your default.cfg file looked just fine. I had forgotten that you hadn't set permissions.


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

Thanks JP. DBMan up and running....now, I just need to modify the Html.pl

Is there a discussion on this taking place right now? I'll be looking for it.

There's discussions all over the place on modifying the html.pl file.

What I would suggest first, though, is that you create the fields you want in your own database.


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

Good idea! Ummmm, how? lol

Man, this is really humbling! lol

I've written the beginnings of a tutorial on setting up DBMan, which includes defining your database fields. You can see it at http://www.jpdeni.com/dbman/tutorial2.html . This should get you through at least setting up your own fields.


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

JP...here's one for ya! heh heh heh

Okay, I'm trying to create a multiple "category" submission using checkboxes. Multiple selections.

Need an idea? Check out this form-->
http://www.oe-online.com/OEOnline/INFOAREA/forms/add_yours.html

The form you will see when you get there is a simple e-mail filler. I want a similar form to load the data directly into the data base.

Can it be done? (Wasn't in the tutorial)

Justin

Just as you have a name for each of the checkboxes on your existing form, you need to have a field for each of the checkboxes in your database. You would have something like:


(I just used some of them for examples. You'll need to change the field numbers and fill in the rest, of course.)

The 50 field length above is arbitrary. You can set it to pretty much whatever you want, so long as it is at least the length of the value which will be put in the field.

A couple of things to watch out for -- with the ones that have spaces, &s or /s in them, it's better to use underlines in the field name. You can use the other characters when you define the checkbox fields. There might be a problem with the / character even then. I'm not sure.

When you define your checkbox fields, use


On your list at the moment, I didn't see anything with an apostrophe, but if you should need to use one, you need to put a \ before it like




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

Okay...Edited the default.cfg and ran DBMan. The following was the result. I looked at line 120 in the cfg but couldn't find anything. Could it that there are too many "categories"? I doubt it...


Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: Bad name after alpha' at default.cfg line 120.

Got any ideas?

It's doubtful there are too many categories. Your problem is probably the result of an extra or missing single quote in the line above line 120.

If you would like me to check it for you, post lines 110 - 120 here and I'll find the problem.


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

JP, I checked out the script and found a couple of missing single quotes and one missing comma. This resolved the problem I was having.

I also found out that you cannot leave a space between words in the...
%db_checkbox_fields = (

Such as:

Chats_Bulletin_Boards =>'Chats/Bulletin Boards',

Slashes do work in the later half.

The .cfg working properly now.

BUT! Instead of checkboxes, I get very short fill-in fields.

Did you set the field length to 0 for all of your checkbox fields? Are you using autogenerate?


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

JP

Yes, all of the Form-Lengths are set to 0 for the checkboxes.

About the autogenerate...I was about to ask you about it. How can you tell if you are set for autogeneration?

Okay...found the autogeneration thing. I had it set to "1".

Has anyone run into problems with the Html.pl file getting so large that you cannot add any more text? I am having this problem on two different servers and on the home PC. Keeps saying that the file is too large or not enough memory. What's the fix for this?

Justin

It could be the number of input fields you have on your form. I ran into that one other time when I tried to have more than about 150 fields in a form.


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

JP....I was thinking along those lines myself.

Might have to figure something else.

Okay....here's what's happening: (Both related)

Okay...I reduced the number of Input Fields and set autogenerate to "0". I assume this allows the default.cfg to create the pages rather than the html.pl, correct? In any case, the resultant "Add" page is displayed with short fill-in fields for each category selection. I want checkboxes. This should be correctable in the .cfg but I haven't found it.

With "autogenerate" set to "1", I again assume that this allows the html.pl to create the pages. However, the pages have a few flaws since it is trying to use information in the cfg to complete the page generation and the information is conflicting. I haven't changed the html.pl very much at all and now it seems to have reach a maximum capacity...will not let me add any more scripting. I need to add more scripting in order to create the page I want.

Question#1: Is it possible to create an HTML based form and direct the data to DBMan? I already have a form that is working, is it possible to redirect the data to DBMan?

Question#2: Is it possible to delete portions of the html.pl file and still get the darn thing to work. I am assuming that all rows of text preceded with an "#" may be deleted. Sounds dangerous, but am I correct?


:::Puzzled:::



[This message has been edited by JustJay (edited June 17, 1999).]

 
No. Setting $db_auto_generate to "0" means that you have edited the html.pl file to create your own forms and displays.

Setting $db_auto_generate to "1" means that the script will create the forms and displays based on your .cfg file.


Set $db_auto_generate to "1" and make sure that your form length for you checkboxes is set to "0" in the field definition. You will see checkboxes.


As I said earlier, you have it backwards. The flaws that you see on the pages are probably due to mistakes in setting up your fields. Would you go into more detail about the flaws on the pages?


There is no maximum capacity to the html.pl file. (I suppose if you made it really huge, it would overpower your computer's memory, but I've never seen one over 20K in size.) There is another problem going on here.

How will it "not let you add any more scripting"? What happens when you try? (Actually, until you have made sure your fields are set up correctly, you ought not to be worrying about the html.pl file anyway.)


Yes. You will not be able to require login for people to add, though.


Yes, there are comment lines that can "legally" be removed, but I really think your assessment of the problem is incorrect.

Forget messing with html.pl right now. Set $db_autogenerate to "1" and see what happens. If you have problems, let me know what they are. Exactly. Copy any error messages you get and write down what you did when you got them.

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

JP....

Okay, default.cfg is set as follows:

# Auto generate the html forms (1 = Yes, 0 = No).
$db_auto_generate = 1;

Result:..Follow this address (temporary)
http://www.apds2000.com/cgi-bin/db/db.cgi?db=default&uid=admin.92967665476906&add_form=1

I got an "unable to locate server" error when I tried your URL. I'll try again later, in case it's just down or really busy right now.



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

JP....Yep, it is correct. I haven't been able to get access either.

I finally got through and I see what's happening. You have defined all of the checkbox fields in the %db_checkbox_fields section of the .cfg file, right?

This is something I have never seen before.

May I take a look at your .cfg file?

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







[This message has been edited by JPDeni (edited June 18, 1999).]

I still can't access your server. Are you sure the URL is right?


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

JP...here is the location of the file:

http://www.apds2000.com/cfg.txt

Enjoy! Drove me nuts last night!

Justin,

You have %db_check_box_fields defined twice so I would assume the second one negates the first.
Your Code:

# Checkbox fields. Field name => 'Category Checkbox Field each characterized by their own field'.
%db_checkbox_fields = (
Archery =>'Archery',
Art =>'Art',
Bowhunting =>'Bowhunting',
Biking =>'Biking',
Birding =>'Birding',
Boating =>'Boating',
Camping =>'Camping',
Canoeing =>'Canoeing',
Climbing =>'Climbing',
Collecting =>'Collecting',
Conservation =>'Conservation',
Crafts =>'Crafts',
Diving =>'Diving',
Firearms =>'Firearms',
Fishing_Fly =>'Fishing-Fly',
Fishing_General =>'Fishing-General',
Fishing_Ice =>'Fishing-Ice',
Fishing_Saltwater =>'Fishing-Saltwater',
Gun_Dogs =>'Dogs',
Hiking_Backpacking =>'Hiking & Backpacking',
Horse_Packing =>'Horse Packing',
Hunting =>'Hunting',
Kayaking =>'Kayaking',
Miscellaneous =>'Miscellaneous',
Mountaineering =>'Mountaineering',
Muzzle_Loading =>'Muzzle Loading',
Paddling =>'Paddling',
Painting =>'Painting',
Photography =>'Photography',
Rafting =>'Rafting',
RVing =>'RVing',
Shooting =>'Shooting',
Skiing =>'Skiing',
Snorkling =>'Snorkling',
Snowboarding =>'Snowboarding',
Snowmobiling =>'Snowmobiling',
Snowshoeing =>'Snowshoeing',
Taxidermy =>'Taxidermy',
Travel =>'Travel',
Watercraft =>'Watercraft',
Wildlife =>'Wildlife',
);

# Radio fields. Field name => comma seperated list of radio buttons.
%db_radio_fields = ( Validated => 'Yes,No' );

# Checkbox fields. Field name => Checkbox value.
%db_checkbox_fields = ( Popular => 'Yes' ); REMOVE THIS LINE AND YOUR PROBLEM SHOULD BE SOLVED!

Also you realize that each check box selected will have the value of the category name as you have entered it. Each category is a seperate field and as a check box can only have one of two values checked or not checked the values you have defined means that the field 'Archery' will have a value of 'Archery' when checked.

Mike



[This message has been edited by mike1 (edited June 18, 1999).]

JP....

Will this delete the "Popular" field?
%db_checkbox_fields = ( Popular => 'Yes' );

------------------
So, would it be better to write it as:
Snowshoeing =>'Yes',

rather than defining it as "snowshoeing"?

If you want to keep the 'popular' field just add it to the end of your first defenition of the checkboxes. It probably makes no difference but it is probably easier if you change the check values to 'yes'.

Mike

The advantage to having the checkboxes set up like

Archery => 'Archery'

is that, when you make your own html file, you won't need to label the boxes. They'll be labeled automatically.

So you can have either


or


It's purely a matter of personal preference.

Thanks, Mike, for finding the problem. I'm in the midst of learning how to make graphics and I was creating piles of buttons this afternoon.

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