Re: [SM-USERS] Userprefs in MySQL aren't changed but added - SOLVED

2005-03-29 Thread Jonathan Angliss
Hello Vincent, On Friday, March 25, 2005, Vincent Verhagen wrote... > Problem seemed to be table definition; I guess I got the primary keys > wrong which woudl confuse the MySQL REPLACE. Recreated the table from > scratch with cut-and-paste from ../doc/db-backend.txt; problem gone! > --

[SM-USERS] Userprefs in MySQL aren't changed but added - SOLVED

2005-03-25 Thread Vincent Verhagen
Problem seemed to be table definition; I guess I got the primary keys wrong which woudl confuse the MySQL REPLACE. Recreated the table from scratch with cut-and-paste from ../doc/db-backend.txt; problem gone! -- I've started experimenting with a MySQL backend to store userprefs. Created

[SM-USERS] Userprefs in MySQL aren't changed but added

2005-03-25 Thread Vincent Verhagen
I've started experimenting with a MySQL backend to store userprefs. Created db as recommended in ../doc/db-backend.txt and everything works fine, but... Whenever a user changes a preference, the old preference record isn't changed or deleted, but a new preference record is simply added to the t