I am having some issues updating certian userprops. In particular the ao1im field(and I am assuming all the other userprop fields), which lives in userprop. Every time I update it, it just enters a new row instead of updating the row that currently exists. I have tracked this down to this chunk of code in ljlib.pl
if ($db) {
my $vals = join(',', map { "($userid,$_->[0]," . $db->quote($_->[1]) . ")" } @$list);
$db->do("REPLACE INTO $table (userid, upropid, value) VALUES $vals");
}
Now I am not sure if this is just an issue with my mysql instlation, the version I am using (3.23.49 - I can handle upgrading), or the code.
For now I am having my users, remove the userprop, save, then update it and that seems to handle it just fine. Maybe we can change this back to the ghetto format of delte then insert or we can test to see if the prop exists, if so use an update, if not use an insert.