Gossamer Forum
Home : Products : DBMan : Installation :

Error: Unable to Add Record

Quote Reply
Error: Unable to Add Record
Hello,
I've tried for hours to fix the following errors. I've used the site's search engine already. I used the configure utility to create it. I'd appreciate any help on this. The default.cfg and html.pl (in .txt) are at http:// http://sizemoresucks.hypermart.net/Download5/
---------------------------------------------
Error: Unable to Add Record

There were problems with the following fields:
ID (other) (Invalid format)
Name (other) (Invalid format)
Election (other) (Invalid format)
Report (other) (Invalid format)
Code 1 (other) (Invalid format)
Code 2 (other) (Invalid format)
Contribution Date (Invalid format)
Contributor Name (Invalid format)
Additional Name (Invalid format)
Phone (if business) (Invalid format)
Street Address (Invalid format)
City (other) (Invalid format)
Other Location (Invalid format)
Occupation/Employer (Invalid format)
Recorder (Invalid format)
Recorded Date (Invalid format)

Please fix any errors and submit the record again.
------------------------------------------------

Also, I was wondering what this means in default.cfg under Definitions:

# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.
$db_use_flock = 1;

TIA for your help,
Ernie

Quote Reply
Re: Error: Unable to Add Record In reply to
In default.cfg, inside all your field definitions, make sure of two things:

1) The "field_type" (second value) is set to the appropriate format ('alpha', 'numer', or 'date')

2) The "valid_expr" (last value) is set up properly, to either a regular expression, or nothing. If you're not sure how to set up a regular expression, just leave it as ''


In Reply To:
Also, I was wondering what this means in default.cfg under Definitions:

# Use file locking (1 = Yes, 0 = No). Should be used, but won't work on Win95.
$db_use_flock = 1;
File locking is used in perl to temporarily "lock" a file whilst it is writing/reading to/from it, so other processes can not mess with the file whilst it is doing so. This feature is only available to UNIX/LINUX platforms, and will not work in a Windows 9X environment, so turn it off if you are using Windows.

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: Error: Unable to Add Record In reply to
Thank you. The problem was the '^http://'] code under 'valid_expr']. I changed them to ''], Is that going to be OK or should I just make it '' as you wrote? I was going to link those catagories later, but now realize they have to be linked immediately or they get that "unable to add record" error.

Take care, Ernie