[ postfixadmin-Bugs-2018402 ] error with deleting mailbox or alias
Brought to you by:
christian_boltz,
gingerdog
From: SourceForge.net <no...@so...> - 2008-07-15 04:51:52
|
Bugs item #2018402, was opened at 2008-07-15 04:52 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.2 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: error with deleting mailbox or alias Initial Comment: Hi. When I'm want delete a mailbox or alias I see next error: DEBUG INFORMATION: Invalid query: Duplicate entry '2008-07-15 10:22:30' for key 1 and mysql.log 58241 Query DELETE FROM alias WHERE address='te...@ex...' AND domain='example.ru' 58242 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_alias','te...@ex...') 58243 Query SELECT * FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58244 Query DELETE FROM mailbox WHERE username='te...@ex...' AND domain='example.ru' 58245 Query DELETE FROM vacation WHERE email='te...@ex...' AND domain='example.ru' 58246 Query INSERT INTO log (timestamp,username,domain,action,data) VALUES (NOW(),'an...@ex... (17.7.181.96)','example.ru','delete_mailbox','te...@ex...') In my opinion problem be appear at the time of query insert data on table "log" to MySQL in a unit of time. Fixed this problem I can added in file delete.php function sleep(1); 123 $result = db_query ("DELETE FROM $table_mailbox WHERE username='$fDelete' AND domain='$fDomain'"); 124 sleep (1); 125 $postdel_res=mailbox_postdeletion($fDelete,$fDomain); 126 if ($result['rows'] != 1 || !$postdel_res) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2018402&group_id=191583 |