Jason (squeaky19) wrote in lj_dev,

Problem with userprops

I think this is a bug. If someone can confirm that this isn't just a site problem, I'll submit it to bugzilla.

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.

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded