I ended up doing a search for the error in the db.cgi file and after some trial & error, found out that the error was coming from the sub query routine. I did some searching in the forums and discovered that 2 lines in the query routine needed to be changed and now it seems to work perfectly!
The lines you're looking for are here:
# If we are only allowed to mod/del/view our own records let's make
# sure we don't pull up anyone else's information.
if ((($type eq 'mod' and $auth_modify_own) or
($type eq 'del' and $auth_modify_own) or
($type eq 'view' and $auth_view_own)) and (!$per_admin)) {
$userid_q = $DBH->quote($db_userid);
$where .= qq! ($where) AND
$auth_user_field = $userid_q!;
Replace:
# $where .= qq! ($where) AND
# $auth_user_field = $userid_q!;
With:
$where = qq! ($where) AND
$auth_user_field = $userid_q!;
I found out that I could manaully make the validate work if I modified the record and changed the Validate field on the record to yes. Only problem with that is it doesn't email the person to let them know their record has been validated. The Validate field doesn't show up for anyone other than admin, so no worries about anyone else changing that. Still, it'd be nice if the validate mod worked, or I could figure out what needed to be changed to make it work.
DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)
The lines you're looking for are here:
# If we are only allowed to mod/del/view our own records let's make
# sure we don't pull up anyone else's information.
if ((($type eq 'mod' and $auth_modify_own) or
($type eq 'del' and $auth_modify_own) or
($type eq 'view' and $auth_view_own)) and (!$per_admin)) {
$userid_q = $DBH->quote($db_userid);
$where .= qq! ($where) AND
$auth_user_field = $userid_q!;
Replace:
# $where .= qq! ($where) AND
# $auth_user_field = $userid_q!;
With:
$where = qq! ($where) AND
$auth_user_field = $userid_q!;
I found out that I could manaully make the validate work if I modified the record and changed the Validate field on the record to yes. Only problem with that is it doesn't email the person to let them know their record has been validated. The Validate field doesn't show up for anyone other than admin, so no worries about anyone else changing that. Still, it'd be nice if the validate mod worked, or I could figure out what needed to be changed to make it work.
DBMan SQL Version 1 mods available at:
http://dbmansqlmods.rainbowroomies.com
(Mods based on JPDeni's original mods.)