Gossamer Forum: Products: DBMan: Installation: Database Problems

Jul 7, 2002, 6:15 AM

Matt_NZ

New User (2 posts)

Jul 7, 2002, 6:15 AM

Post #1 of 3

Shortcut

Database Problems

Hi,

Trying to set up a new database with DBman, but after creating my config file, I get an error Frown

. Here's link to my script http://eqf.maddocmatt.com/cgi-bin/dbman/db.cgi

Here's the code from my database:

Code:



%db_def = ( 
            Owner       => [0, 'alpha',     40,  255,  1,  '',          ''], 
            email       => [1, 'alpha',     40,  255,  1,  '',          ''], 
            Horse       => [2, 'alpha',     40,  255,  1,  '',          ''], 
            Breed       => [3, 'alpha',     40,  255,  1,  '',          ''], 
            Age         => [4, 'numer',      2,    2,  1,  '',          ''], 
            Gender      => [5, 'alpha',      0,  255,  1,  '',          ''], 
            Height (hh) => [6, 'numer',     40,    2,  1,  '',          ''], 
            Color       => [7, 'alpha',     40,  255,  1,  '',          ''], 
            Markings    => [8, 'alpha',     40,  255,  1,  '',          ''], 
            Sire        => [9, 'alpha',     40,  255,  1,  '',          ''], 
            Dam         => [10,'alpha',     40,  255,  1,  '',          ''] 
        ); 

    $db_key         = 'Horse'; 
    $db_key_track   = 1; 
# Radio fields. Field name => comma seperated list of radio buttons. 
    %db_radio_fields    = ( Gender => 'Male,Female' ); 


    $auth_user_field    = 9;

Any help greatly appreciated Smile

Last edited by:

LoisC: Jul 7, 2002, 12:04 PM

Jul 7, 2002, 12:00 PM

LoisC

Veteran / Moderator (3034 posts)

Jul 7, 2002, 12:00 PM

Post #2 of 3

Shortcut

Re: [Matt_NZ] Database Problems In reply to

Please don't include your whole .cfg file but rather provide a link to where it can be viewed.
It's also useful to state the error message you received :)

When calling the script use:

http://eqf.maddocmatt.com/cgi-bin/dbman/db.cgi?db=default&uid=default

Change:

Height (hh) => [6, 'numer', 40, 2, 1, '', ''],

to: (since it has more than 1 word)

'Height (hh)' => [6, 'numer', 40, 2, 1, '', ''],

Since you are using:

$db_key = 'Horse';

Then turn off tracking as that would be used for a numeric field. $db_key_track = 0;

Set: $auth_user_field = 9;
To: $auth_user_field = -1;

since you don't have a userid field defined.

Unoffical DBMan FAQ

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

Jul 7, 2002, 6:25 PM

Matt_NZ

New User (2 posts)

Jul 7, 2002, 6:25 PM

Post #3 of 3

Shortcut

Re: [LoisC] Database Problems In reply to

Thanks for the help, that worked Smile

. Sorry about posting the un-needed post, wasn't sure if you needed or not.