Gossamer Forum
Home : Products : DBMan : Customization :

Unable to Add to Database

Quote Reply
Unable to Add to Database
I have my database setup and I am able to login with the admin account; however, I am unable to add anything to the database. I have checked my permissions--they are all setup correctly, I've checked my paths to PERL, and I have made sure that I uploaded all files as ASCII. Can someone please give me some suggestions on what else to look for? Please let me know if you need me to upload files somewhere for you look. I've pasted part of my config file below...

Thanks!
Kelly Cotton

%db_def = (
'CommID' => [ 0, 'numer', -1, 255, 0, '', ''],
'Community' => [ 1, 'alpha', 20, 255, 1, '', ''],
'Address' => [ 2, 'alpha', 20, 255, 0, '', ''],
'Type' => [ 3, 'alpha', 0, 17, 0, '', ''],
'Location' => [ 4, 'alpha', 0, 8, 0, '', ''],
'Price' => [ 5, 'numer', 0, 11, 0, '', ''],
'Bedroom' => [ 6, 'numer', 0, 15, 0, '', ''],
'Bath' => [ 7, 'numer', 0, 12, 0, '', ''],
'SqFt' => [ 8, 'numer', 0, 11, 0, '', ''],
'Garage' => [ 9, 'alpha', 0, 6, 0, '', ''],
'Pool' => [10, 'alpha', 0, 3, 0, '', ''],
'Clubhouse' => [11, 'alpha', 0, 3, 0, '', ''],
'Style' => [12, 'alpha', 0, 11, 0, '', ''],
'1FloorMaster' => [13, 'alpha', 0, 3, 0, '', ''],
'Description' => [14, 'alpha', '40x5', 1000, 0, '', ''],
'VirtualTour' => [15, 'alpha', 20, 255, 0, '', ''],
'URL' => [16, 'alpha', 20, 255, 0, '', '^http://'],
'Photo' => [17, 'alpha', 20, 255, 0, '', '']
);

# Allow a default user? This means you can specify a user via the URL
# and skip the logon process. Use this to allow people to search without
# logging on, but require log in if they want to add/modify/remove etc.
# (1 = "yes", 0 = "no")
$auth_allow_default = 1;

# Default permissions used if there is no authentication, or for a default
# user. (View, Add, Delete, Modify, Admin), 1 = enable, 0 = disable.
@auth_default_permissions = (1,0,0,1,0);

# Allow people to sign up for their own userid/passwords? They will
# recieve default permissions.
$auth_signup = 1;

# Permissions a new signup should get.
@auth_signup_permissions = (1,1,1,1,0);
# Registered users: can modify/delete _only_ own records. For this to make
# sense you should set default off or to 1,0,0,0.
$auth_modify_own = 1;

# Registered users: can view _only_ own records. For this to make sense
# you should turn off default permissions.
$auth_view_own = 0;

# Auth user field. This is the field position in the database used for storing
# the userid who owns the record. Set to -1 if not used.
$auth_user_field = 1;

# URL to send user if they chose log off. Leave blank and the script will return to
# the logon prompt (although this only makes sense if you are using authentication).
$auth_logoff = "";


Quote Reply
Re: Unable to Add to Database In reply to
What exactly is happening when you try and add a record?

Are you getting a 500 message? Internal error? And at what stage of the addition process does this happen?

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: Unable to Add to Database In reply to
It's a 500 Internal Server Error. I am able to get the Add Record screen. The error occurs after I enter in all of my data and hit the SUBMIT button.

Thanks, Kelly