I have installed delete.pl and have tried alsorts to get this script working, Eliot very kindly gave me some other pointers to look but unfortuanatly I'm still at square one, when I call this script from my browser I get a e5oo premature script headers, but I've checked and double checked that I'm uploading in ascii and tried v-edit incase notepad was cocking things up, I just don't know what to try next, has anyone else had any similar problems with this script and have got it sorted, I'd love to hear from you if you have.
Text versions at www.thewebshack.co.uk/delete.txt and script at www.thewebshack.co.uk/cgi-bin/dbman/delete/delete.pl or is it cgi sorry can't remember
Any help would be truly appreciated as I need to get this date deletion thing working as I'm bidding for a contract and they need it, I know it will be a commercial thing so I know I will have to pay but I need to get it working first.

Regards

Rich

I am thinking that it could be a problem with your default.cfg file. Please save your default.cfg file as a text file and post the URL where we can find it.

Thank you.

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

Eliot here are the details you requested:

Script is at:

http://www.thewebshack.co.uk/cgi-bin/dbman/delete/delete.pl

.cfg file is at www.thewebshack.co.uk/jobs.txt

.pl file is www.thewebshack.co.uk/delete.txt

Cheers, Rich

write to you soon

Rich,

I think I know what the problem may be...When you added the new field, RemoveAdd, I think you may have forgotten to add this field into your existing database. What you should do is use my Add Fields into Existing Database Mod, which is located in the Resource Center. Set the default value to the default value that you want Ads to be deleted.

The Server Error is happening because there are no numerical values within the RemoveAdd field for the delete.pl file to calculate and execute.

Hope this helps.

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

Thanks Eliot I'll try that now

Rich

Hi Eliot, I tried that at www.thewebshack.co.uk/cgi-bin/dbman/upgrade.pl and I get e500 from that also. I have put a text version atwww.thewebshack.co.uk/upgrade.txt as I'm not too sure what had to go in the $field_default = ""; field, so left it blank.
I have changed the default to jobs as it's the jobs bit which needs the date remove addon the defaul.cfg is ok.

If you want to see what I'm upto it's at www.thewebshack.co.uk/ydha
it's not secure yet as there isn't really anything in it !) I think I know what this script does does but but I'm sure you will know better than me but when coming accross a similar problem I just emtied the db file and count and tried it again, and it seemed to sort it self out.

Is there anything similar between these two scripts that my end doesn't like or are they totally different. BTW I think DBMAN is absolutly brilliant and I feel quite ok with it now. It's just this little addon that is causing a prpoblem.

Thanks Again

Rich

CHANGE the extension of the files to .cgi as I suggested before!



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

I forgot you said that ! It's kind of a natural thing for me to name them .pl, as I have about 15 different scripts called .pl. So sorry about that. Still getting e500

The way I have the upgrade file configured was that OK ?

Cheers

I promise to buy you a beer when this is sorted out OK !!!

I really don't know what the problem is. The upgrade file is configured correctly, at least in terms of syntax.

There only two possible problems that I can think of:

1) You have the incorrect physical/absolute path to your configuration file.

2) You are not uploading the files in ASCII mode, which is causing syntax error and subsequently an Internal Server Error.

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

Hi Eliot I've checked and double checked those things and all's well, so I also don't know whats wrong, thanks for all your help,if you do have a brainwave, let me know!

Cheers

Rich

Thanks for that Eliot I have put my cfg files back to standard as I could get it to work, I will have another play and do as you request later today.

Thanks

Rich
p.s Sorry for double threading but I noticed that in another thread you mentioned that this area was better for addons the other thread is mainly for dbman installations.

Rich,

Could you please post the error messages you are receiving in your Perl Error Log or when you type in perl -c delete.pl and perl -c upgrade.pl at the command prompt.

This will help us to understand what is happening. Also for the upgrade.pl, you need to assign a numerical value in the default value field. If you do not assign a numerical value, such as 1 - 360, then the delete.cgi file will not work (refer to one of my earlier postings).

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

Sorry Eliot I don't know what you mean commant prompt, I don't get any logs so I have asked my isp for them.

The first potential problem I see is


Delete that and you should be okay. At least, when I took that out, the file compiled correctly.


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

Thanks for that I tried and am still getting the dreaded e500 revised delete.txt now at http://www.thewebshack.co.uk/delete.txt File is at http://www.thewebshack.co.uk/cgi-bin/dbman/delete/delete.pl

Thanks for the advice re:notepad

Rich

The syntax is fine. Are you sure you uploaded the file in ASCII mode?


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

Yes definately, I'm going to try from scratch and see if I've missed anything,can I ask one question about delete.pl which is if I execute it from my browser does it display anything if the fields are not correct, I.E will it e500 from the server or will the script itself generate an error message of it's own.
I don't know if it's of any use but the server software I'm using is Apache/1.2.6 FrontPage/3.0.4.1 and perl version 5.00404

Thanks again and I 'll tell you how I get on.
Rich

I think Eliot will have to answer this. I'm familiar with this mod. I know that I did have a hand in writing it, but that was a long time ago and I didn't like it at the time, so I forgot it as soon as I could!



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

I've tried from from scratch and no luck and also tried it on a completely different server and still got the same error premature of headers, if anybody has the time to try and imitate what I'm trying to do could they try, I.E go to the mod page ,grab it mod it then upload it to see if the script is a bit unfriendly, I'm sure I doing everything OK, and to have the same fault on 2 different servers running 2 differnet versions of perl I can't help wondering, I'm now going to find a nice high ledge to sit on and think whether end it now or continue !!

Thanks for help

Rich

Hi I'm back inside now ! and posted the error log or some of it al least at http://www.thewebshack.co.uk/deletelog.txt

Thanks again

Rich

Well, one of the error entries shows that you have improperly put the path to your configuration file. The Premature Header Error could possibly be related to the wrong Perl Path or possible an unsupported content/type.

I really don't know what to tell you. As I mentioned before the scripts have been tested on the following systems:

1) Apache 1.2.1
2) Apache 1.3.6
3) NT 4.0, IIS 3.0
4) NT 4.0, IIS 4.0
5) O'Reilly WebSite1.1

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

Is there any other way of auto deleting specfic entries?

Thanks

Rich

One thing you might try --

I don't know why some scripts seem to need this and others don't, but try adding

1;

to the very end of your delete.pl file.

Otherwise I don't have any suggestions.


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

Thanks anyway for all you time both yourself and Eliot.

Cheers

Rich