Well, installed the Validation mod, have looked over it several times with no luck in finding what the matter is.

When I go to Validate or Delete a submission, it goes and generates a Script Error 500. However, it DOES add/remove the submission, just doesnt show a "success page" and no emails are sent.

any idea? do i need to post some code? (which part?)

thanks!

Warp.

If no emails are sent or a success page doesn't come up, I'd start looking at those subs, perhaps your email sub isn't set properly. If it is removing the submissions, then you know that part is working to some extent. Follow the steps from the validation sub forward, meaning where does it go next, what is the next thing that happens (sends email?) and see if you have any syntax errors.

Good luck!

oh.. thats got me thinking...

does the Validate mod work with the Secure Password Lookup mod? as Validate setup instructions need an email field to be set, i get a feeling that it isnt actually reading the email address from the password file... but trying to read it from an 'non existent' place (the db)

if that is the case, how do i get the Validate mod to fetch the email addy from the .pass instead of a db?
-OR-
how do i copy the email address from the pass file to the database file when the user submits a form?

thanks,


Warp.

having looked thru it again.. and again and again... i cant see any errors... all i know it fails sending emails and displaying a success page, can someone help please?

thanks.

Warp.

 ok.. i think its this mod causing my problems (mod: Get Email - JPDeni)


ok i have added the get_email sub (i havent shown that here), i have put the

if ($in{'add_form'}) {
$rec{'Email'} = &get_email; }

in the place it is suppose to go....its not inserting the email address into the Email field :(or do i have to have something else on the form for it grab it? url for the mod:http://www.jpdeni.com/...secure_get_email.txt

Edit:
It requires auto generate to be on =(
anyway around that?



Warp.

I have both the MODs installed and working properly in 5 of my databases and I definetly did not have autogenerate on. I think the problem lies somewehere else.
Julian

Well I have tried doing it from scratch, I installed:

Secure password lookup:
Basic Mod
Required html subroutines
Get Email
Change Email
Require html subroutines
Change Email In Records

(I added the basic mod, and get email and tried that, no luck, so i then added change email & change email in records, no luck)

was there any order on how you added the mods? any changes you had to make?

i have, i believe, added each mod according to the instructions.... any further help would be grateful!

Well, the best way to diagnose problems is to create a .txt veersions of your db.cgi and html.pl plus db.cfg files and put them out on your server so that I can view them. I'll try to help you but no prmoise that I can,
Julian

Here is the 'fresh' setup files: (secure lookup, get email mods..)

http://selpaw.com/...asic/default-cfg.txt
http://selpaw.com/cs/basic/html.txt
http://selpaw.com/cs/basic/db.txt

thanks, for any help you can give me! appreciated!

luke



Warp.

Okay, I notice some oddities in your files. Firstly, in db.cgi under sub get_email

the line: return $email; should be return "$email";

That should solve the problem that the email address is not added together with the record.

Secondly, I can't find the subroutine in which you do validation of records. There is a inherent subroutine called sub validate_record. That only will go through the form submitted by the user and see whether it obeys the rules set by you. But it does NOT aloow you to "validate" the record.

Did you forget to include the sub validate_records subroutine in db.cgi? You will need that in order to validate records. If you add that subroutine in you must also add the following lines in the sub main of db.cgi:

elsif ($in{'validate_form'}) { if ($per_admin) { &html_validate_form; } else { &html_unauth; } }
elsif ($in{'validate_records'}) { if ($per_admin) { &validate_records; } else { &html_unauth; } }

Hope this helps.
Julian

problem still exist

files i showed you where a new install...

here are the other files that have the validate mods and that:

http://selpaw.com/cs/recipe/db.txt
http://selpaw.com/...cipe/default-cfg.txt
http://selpaw.com/cs/recipe/html.txt

thanks,

Warp.

Try changing:

if ($in{'add_form'}) {
$rec{'Email'} = &get_email
}

to

if ($in{'add_form'}) {
$rec{'Userid'} = $db_userid;
$rec{'Email'} = &get_email($db_userid);
}
Julian

I noticed in your sub html_record_form you don't have a field defined for your email field. Each field that you have in your .cfg file must have a input field on the add form. It can be a hidden field but it must be there.

Also you would need to be sure you added this extra field to your active database.

I noticed in a few of your forms you have the email field defined as:

name="email"

If this is Email in your .cfg file you need to adjust the form definitions to be the exactly the same. Being case sensitive.

Hope this helpful


Unoffical DBMan FAQ

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

Thank you Thank you Thank you both!

I have now got it working! I made the changes Vampy listed and also the changes/ added input form LoisC

thanks!

Would you like me to add your websites (you list them) to my links database?

thanks for the help, very appreciated.... simple in the end.




Warp.