Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Can't modify my Database Entries

Quote Reply
Can't modify my Database Entries
Hi,

my Boss has buy a Full Version of DBMan SQL. I have now the problem that i can't modify a database entry.

For testing everybody can go to:

http://195.143.115.173/cgi-bin/dbmansql/db.cgi

user: admin
pwd: admin


MfG Sebastian

Quote Reply
Re: Can't modify my Database Entries In reply to
After intalling DBManSQL (as downloaded) I also found that I was unable to modify any records.

The problem seems to be in the db.cgi file (sub add_record and sub modify_record).

*****I changed*****
# Set the userid to the logged in user.
($auth_user_field >= 0) and ($in{$db_cols[$auth_user_field]} = $db_userid);

*****To*****
# Set the userid to the logged in user.
($auth_user_field >= 0) and ($in{$auth_user_field} = $db_userid);

This fixed the problem but I don't know if it is the correct solution.
See if it works for you and I would also contact Gossamer Support and tell them about it.
Simon.



Quote Reply
Re: Can't modify my Database Entries In reply to
I don't see a difference in your code change.

Quote Reply
Re: Can't modify my Database Entries In reply to
Sorry about that.
I pasted the wrong code in the ****Change**** part.
I have Edited the message so it should be correct now.
Simon.

Quote Reply
Re: Can't modify my Database Entries In reply to
Hi jai,

thanks for your help. It works. I think it is the right choice to edit this string.

regards Sebastian

Quote Reply
Re: Can't modify my Database Entries In reply to
Hi!

Can you show me the correct modification again? I tried the one you said you have corrected from the previous message but it didn't work.

Thanks!

Quote Reply
Re: Can't modify my Database Entries In reply to
*****change*****
# Set the userid to the logged in user.
($auth_user_field >= 0) and ($in{$db_cols[$auth_user_field]} = $db_userid);

*****To*****
# Set the userid to the logged in user.
($auth_user_field >= 0) and ($in{$auth_user_field} = $db_userid);