[TikiWiki-commits] [Git][tikiwiki/tiki][27.x] [FIX] tikilib: use a single atomic upsert instead of separate delete and...

Merci Jacob pushed to branch 27.x at Tiki Wiki CMS Groupware / Tiki


Commits:
68223715 by Merci Jacob at 2026-05-13T15:35:11+00:00
[FIX] tikilib: use a single atomic upsert instead of separate delete and insert when setting a user preference, preventing duplicate-key races on simultaneous AJAX requests
---
* [FIX] tikilib: use a single atomic upsert instead of separate delete and insert when setting a user preference, preventing duplicate-key races on simultaneous AJAX requests

See merge request tikiwiki/tiki!10175


(cherry picked from commit e457557290300516386598222dc9577c9ddc6ee6)

9e5f8f14 [FIX] tikilib: use a single atomic upsert instead of separate delete and...

Co-authored-by: Merci Jacob <[email protected]>
- - - - -


1 changed file:

- lib/tikilib.php


Changes:

=====================================
lib/tikilib.php
=====================================
@@ -4664,8 +4664,10 @@ class TikiLib extends TikiDb_Bridge
             }
 
             $userPreferences = $this->table('tiki_user_preferences', false);
-            $userPreferences->delete(['user' => $my_user, 'prefName' => $name]);
-            $result = $userPreferences->insert(['user' => $my_user, 'prefName' => $name,    'value' => $value]);
+            $result = $userPreferences->insertOrUpdate(
+                ['value' => $value],
+                ['user' => $my_user, 'prefName' => $name]
+            );
 
             $user_preferences[$my_user][$name] = $value;
 



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/68223715a67b16bd7ff101783d63711bf9a5f12f

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/68223715a67b16bd7ff101783d63711bf9a5f12f
You're receiving this email because of your account on gitlab.com. Manage all notifications: https://gitlab.com/-/profile/notifications | Help: https://gitlab.com/help

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs