i'm trying find item , update if exists, or create new 1 if not exist. however, reason seems trying create new object instead of updating in event that exists in database.
$object = objectitem::firstornew(array('object_item_id'=>$usereditedobject['object_item_id'], 'object_id'=>$object_id)); $object->setfields($usereditedobject); if($object->save()){ return true; } else { return false; } that code appears producing error
"sqlstate[23000]: integrity constraint violation: 1062 duplicate entry '113' key 'primary'
this strange, because have used before , worked okay -- seems in particular case.
it means array $usereditedobject contains duplicate value primary key, "id".
you $object , try edit primary key other row exists same primary key causing failure.
see field primary key application , make sure not creating duplicates.
