Hi folks!

Ok... I thought that I understood how to do multiple databases. But I guess I really don't understand what I read.

I want to have 3 databases running. One is for a fanclub, one is for a nightclub database and another is for a potential client to show how well DBMan will work for them. So far this is my setup:

coastal (the potential client) is up and running fine. Doing just what I want it to with the exception of sending email to 2 addresses, instead of 1. All pertinent files reflect coastal in their name.

coastal.cfg
coastal.db
coastal.pass
coastal.log
coastal.count
coastalhtml.pl

club (the nightclub database) keeps giving me an internal error message and requests me to enable debugging. But it does not appear to see that I have enabled it. I duplicated my efforts on the various files and their names, reflecting club. Of course the cfg file is different.

club.cfg
club.db
club.pass
club.log
club.count
clubhtml.pl

and I have not tried to get the fanclub database setup as yet. I am trying to figure out the club database first.

I have the files (club.cfg and clubhtml.pl) avaiable for download at www.starkiller.com/club.cfg and clubhtml.pl.

Any and all help would be greatly appreciated!!!

Peace
ZigZag Starkiller


Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen

I wonder if you have an error in you club.html ???

your club.cfg at a quick glance looks ok ...

just for a check try using your costalhtml.pl as a check reference ....

hmmmm .... interesting.

good luck

---

openoffice + gimp + sketch ...

One thing to note that I forgot to mention, is that my cfg file and the html coding came from JPDeni's Configurator (Oh what a wonderful thing JPD has created in the Configurator). I used it for the Coastal and Club cfgs and html.pl code additions.

Thanks again, for any and all help!

ZigZag Starkiller


Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen

In clubhtml.pl under

sub html_record {

You have a bunch of closing brackets "}" that don't seem to have corresponding opening brackets "{"

example:

}
print qq|
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="20%"><$font_color>ClubURL:</FONT></TD>
<TD WIDTH="80%">&nbsp;<$font><a href="$url{'ClubURL'}">$rec{'ClubURL'}</a>
|;

take out the brackets above every print qq| and that should help. I don't understand what you were trying to achieve with them... Were you trying to do some kind of conditional (if/then) statement?

Remember brackets have to be in pairs { .... } but can be nested

{ something { something else } something more }

Hope this helps - Mike.

Actually, I wasn't trying anything. That was the way it came out when I used JPDeni's Configurator. I will try removing those } from the pl file and let everyone know! =)

Thanks for the advice!
Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen

Ok folks... I am starting to pull out some hair. I have tried everything, including starting from scratch. I have one database working great... but the other will not get past this internal error. And it won't accept the debugging switch turned on. Plus, when I tried to just open a default demo db, it gives me the error. But the Coastal database works fine.

Any and all help will be appreciated by my scalp!!!

ZigZag Starkiller


Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen

My personal experience has been if I don't get any debug info or environment variables when an error occurs, that usually means I a problem in html.pl

Check out this part of the FAQ: http://webmagic.hypermart.net/dbman/trouble.htm and the first topic will tell you how to get more useful error information.

I've found that tracking down these kinds of problems is usually a process of elimination.

If all else fails, dump all of your files (for the db that doesn't work) to a directory on the public portion of your website and I'll try to look at them later today, if no one else gets to it first. You don't appear to have made a bunch of MOD's so tracking down the problem shouldn't be too hard, then again...

Good Luck, - Mike.

Hi Mike

Thanks for the offer. The cfg file and html.pl files are available at

http://www.starkiller.com/club.cfg
and
http://www.starkiller.com/clubhtml.pl

Usually, I have no problems getting this to work... which is why I am getting so frustrated with this.

Thanks again!

ZigZag Starkiller
Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen

Okay, it works...

http://www.watts-internet.com/cgibin/club/db.cgi

took out the extra brackets and messed around with the file permissions and it started working. Only made one change you'll need to change back (site url).

I'll email the files to you. I'd advise putting them into a separate directory (ie, newclub) and remember to:
upload in ASCII Mode
chmod club.cfg, clubhtml.pl, auth.pl to rw-r-r (644)
chmod db.cgi to rwx-rx-rx (755)
chmod club.count, club.pass, club.db, club.log to rw-rw-rw (666)
chmod your club (auth) directory to rwx-rwx-rwx (777)
chmod your newclub (main) directory to rwx-rx-rx (755)

Mike, I don't know how to thank you. I am not sure how the extra brackets got there, but I appreciate the fix. If you need an acoustic duo anytime, let me know... I will make ya a sweetheart of a deal!! <G>

Thanks again!

ZigZag Starkiller


Visit the GRUMPY OLD MEN website!
G R U M P Y O L D M E N
Acoustic Blues, Light Rock and Original Music
http://www.starkiller.com/grumpyoldmen