Well, never mind I figured it out.... After poking around db_prefs.php and echoing out the $query which ended up being a REPLACE statement I notice my table structure wasn't going to allow the REPLACE to work because my PRIMARY KEY was missing. All is working now.
Mike -----Original Message----- From: Michael Shuler [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 11:02 AM To: 'p dont think'; '[EMAIL PROTECTED]' Subject: RE: [SM-USERS] MySQL User Preferences Is Duplicating Entries I disabled all plugins and as you can see it still duplicated entries **** Initial Login mysql> select * from UserPrefs where user="[EMAIL PROTECTED]"; +--------------------+---------------+---------+ | user | prefkey | prefval | +--------------------+---------------+---------+ | [EMAIL PROTECTED] | javascript_on | 1 | | [EMAIL PROTECTED] | hililist | a:0:{} | +--------------------+---------------+---------+ 2 rows in set (0.00 sec) **** Put in my name mysql> select * from UserPrefs where user="[EMAIL PROTECTED]"; +--------------------+---------------+----------------+ | user | prefkey | prefval | +--------------------+---------------+----------------+ | [EMAIL PROTECTED] | prefix_sig | 0 | | [EMAIL PROTECTED] | full_name | Michael Shuler | | [EMAIL PROTECTED] | javascript_on | 1 | | [EMAIL PROTECTED] | hililist | a:0:{} | +--------------------+---------------+----------------+ 4 rows in set (0.00 sec) **** Took my last name off mysql> select * from UserPrefs where user="[EMAIL PROTECTED]"; +--------------------+---------------+----------------+ | user | prefkey | prefval | +--------------------+---------------+----------------+ | [EMAIL PROTECTED] | full_name | Michael | | [EMAIL PROTECTED] | prefix_sig | 0 | | [EMAIL PROTECTED] | full_name | Michael Shuler | | [EMAIL PROTECTED] | javascript_on | 1 | | [EMAIL PROTECTED] | hililist | a:0:{} | +--------------------+---------------+----------------+ 5 rows in set (0.00 sec) -----Original Message----- From: p dont think [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 3:13 PM To: 'Michael Shuler'; [EMAIL PROTECTED] Subject: RE: [SM-USERS] MySQL User Preferences Is Duplicating Entries > I'm setting up Squirrel Mail 1.4.0 and so far it seems to work quite > nicely except for one thing. I have notice something that I think > might be a bug > or perhaps I have something configured incorrectly. It seems to insert > entries into the MySQL UserPrefs table rather than updating them. Here's > what I did to get it to duplicate entries: > > 1 -> Logged in as [EMAIL PROTECTED] which created the first 4 lines. > Then I did a select on the table, everything seemed ok except it > created 2 mailfetch_newlog entries, the first one being on and the > second one being > off. Seemed kind of strange so I tried some more stuff. > 2 -> Selected Options/Personal Information and then filled out simple info. > Looked at the table and everything looked OK with the exception of line 4 > still (the mailfetch_newlog off). > 3 -> Then I went back in under Options/Personal Information and turned off > my signature and changed it too. As you can see it left the old > ___signature___ and use_signature entries still in there. > > Here is a dump of the table after all of the above: > mysql> select * from UserPrefs; > +--------------------+------------------+---------------------------+ > | user | prefkey | prefval | > +--------------------+------------------+---------------------------+ > | [EMAIL PROTECTED] | mailfetch_newlog | on | > | [EMAIL PROTECTED] | javascript_on | 1 | > | [EMAIL PROTECTED] | hililist | a:0:{} | > | [EMAIL PROTECTED] | mailfetch_newlog | off | > | [EMAIL PROTECTED] | full_name | Michael Shuler | > | [EMAIL PROTECTED] | email_address | [EMAIL PROTECTED] | > | [EMAIL PROTECTED] | ___signature___ | Michael B. Shuler, C.E.O. | > | [EMAIL PROTECTED] | use_signature | 1 | > | [EMAIL PROTECTED] | prefix_sig | 1 | > | [EMAIL PROTECTED] | use_signature | 0 | > | [EMAIL PROTECTED] | ___signature___ | Michael B. Shuler | > +--------------------+------------------+---------------------------+ > 11 rows in set (0.00 sec) > > Here is also a list of my plugins just incase: > Installed Plugins > 1. abook_take > 2. squirrelspell > 3. calendar > 4. delete_move_next > 5. listcommands > 6. mail_fetch > 7. message_details > 8. newmail > 9. sent_subfolders > 10. translate > 11. sasql > 12. filters > 13. vlogin > 14. change_mysqlpass Please try disabling all plugins just for fun. Does that help? ------------------------------------------------------- This SF.net email is sponsored by: eBay Get office equipment for less on eBay! http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 -- squirrelmail-users mailing list List Address: [EMAIL PROTECTED] List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id)95 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
