Gossamer Forum
Home : Products : DBMan : Discussions :

Unable to Modify

Quote Reply
Unable to Modify
I am having trouble modifying records. Everything else seems fine. I have read through several posts but not yet found the solution to my problem. I am able to list the records in my data set, then click on one record to modify it. The data is pulled into the modify form alright, but when I change the data and click modify, I get the famous error

"Unable to Modify Record.....Can't find requested Record"

I have posted my data files into
www.authorsvenue.com/journeyconf.cfg.txt
www.authorsvenue.com/journeyconf.pl.txt

Any help would be greatly appreciated

Thanks
Quote Reply
Re: [Fedman] Unable to Modify In reply to
In the cfg file the first field should have "0" as the position, not 1.

Also, the last field-

Total => [46, 'alpha', 10, 40, 0, '', ''],

Remove the comma...

Total => [46, 'alpha', 10, 40, 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 = 9;

In your case Email- current position 4, or 3 when you redo field position.

$db_key = 'Email';
$db_user = 'conf'; <=== what's this?
_______________________________________________________
Lem Motlow, Proprietor Lynchburg (pop 361), Tenn.
Quote Reply
Re: [Lem Motlow] Unable to Modify In reply to
In Reply To:
In the cfg file the first field should have "0" as the position, not 1.

OK, Fixed that.....

Also, the last field-

Total => [46, 'alpha', 10, 40, 0, '', ''],

Remove the comma...


Total => [46, 'alpha', 10, 40, 0, '', '']


OK, Fixed That


# 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 = 9;

OK, set to -1

In your case Email- current position 4, or 3 when you redo field position.

$db_key = 'Email';
$db_user = 'conf'; <=== what's this?
I was using the program to track data from more than one conf...but to simplify things I got rid of it completely

Still no improvement. Getting the same error...thanks for looking so quickly...any other ideas?


Quote Reply
Re: [Fedman] Unable to Modify In reply to
That did the trick....I changed one more line in the pl file and everything works like a charm....thanks for the quick response.
Quote Reply
Re: [Fedman] Unable to Modify In reply to
Backup the database and try with a new, empty .db file. Possible it's a corrupted db, but don't know for sure. Sometimes when you mess with the field positions the script appears to do strange things.
_______________________________________________________
Lem Motlow, Proprietor Lynchburg (pop 361), Tenn.