I'm having trouble with the html.pl file.

I started off by installing the dbman demo, everything was fine. Next I modified the .cfg file to match my new database and fields. Everything worked fine with the demo's html.pl (obviously the disply was not correct because I had switched to another database but the forms displayed fine). Additionally if I set the auto generate html on the script will work fine but I want control over the display. I modified the html.pl file, made sure it was ascii with a 644 permission. When I launch the scrip using the new html.pl file I get the infamous internal error. I've checked my fields in the html.pl file but I can't see what I have done wrong. I've put my database, .cfg and html.pl files to the following address as text files

http://www.sabreshistory.com/textfiles/

Any help is greatly appreciated, thanks in advance

I deleted the record subs and typed them back in by hand, everything works fine now. Must have had a hidden character or something in the file.

Thanks for posting your files it really helps.

The only thing I noticed was that the fields within your database do not match your field definitions.


'ID' => [ 0, 'numer', -1, 255, 0, '', \d{1}'],
'FirstName' => [ 1, 'alpha',20,255,0,'-',''],
'LastName' => [ 2, 'alpha', 20,255, 0, '-', ''],
'GP' => [ 3, 'numer', 5,8, 0, '', ''],
'G' => [ 4, 'numer', 5, 8, 0, '', ''],
'A' => [ 5, 'numer',5, 8, 0, '', ''],
'Pts' => [ 6, 'numer', 5, 8, 0, '', ''],
'Pims' => [ 7, 'numer', 5,8, 0, '', ''],
'League' => [ 8, 'alpha', 8, 20, 0, '-', '']

This database entries seems to have the ID # in the wrong position.

William|Bogardis|0|10|7|17|31|1928-29|CPHL

Also coding within a table should be also within table cells such as the following for your hidden field.

<TABLE WIDTH="450" CELLPADDING=0 CELLSPACING=0 BORDER=1 BGCOLOR="#FFFFCC">
<TR><TD colspan=2><input type="hidden" NAME="ID" VALUE="$rec{'ID'}"></TD></TR>

Could you please turn on debugging so that we can see if there is an error being reported?

In your .cfg file set this:

$db_debug = 1;


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

I get the same problem. I have isolated the problem to my html.pl problem. if i add something it will not work, but i only edit the plain text that is printed. I have debugging on but heh, it doesn't say anything other than 'turn on debugging.' The debugging works fine though on working pages or when i restore to my old html.pl.

the html.pl file and default.cfg are both in my directory as .txt files. If anyone could look it over and see what the problem is I would GREATLY appreciate it.

Location of files:
http://blake.prohosting.com/kogas/cgi-bin/dbman/db.cgi
http://blake.prohosting.com/kogas/default.cfg.txt
http://blake.prohosting.com/kogas/html.txt

Thanks-
Koga

The fields in your html.pl file do not match the fields within your .cfg file.

Your best bet would be to visit JPDeni's DBMan Tutorial site and use her configurator to create both your field configurations and also the layouts for your html_record_form and html_record.

http://www.jpdeni.com/cgi-bin/configurator/config.cgi?perms=1

You can then just modify the display to appear as you wish.


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Thanks much.