Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

MySQL Duplicate Entry Error

Quote Reply
MySQL Duplicate Entry Error
Hola Gossamer Fans,

Our server was rebooted today, and it appears our databases went out of sync. The error we receive when trying to send from inside GMail is:


GT::SQL::Driver::MYSQL (10856): Preparing query: INSERT INTO femail_msgsearch (msgsearch_body,msgsearch_header,msgsearch_mid,msgsearch_id) VALUES ('\n\n:\nThis message was sent using Sissify FeMail!\nGet your own at http://www.sissify.com\n','Return-Path: pookie@sissify.com\r\nDate: Sun, 15 Sep 2002 00:30:50 -0700\r\nFrom: "pookster" <pookie@sissify.com>\r\nSubject: 123\r\nTo: shanti@earthnow.org\r\nContent-Type: text/plain; charset="US-ASCII"\r\nContent-Transfer-Encoding: quoted-printable\r\nMime-Version: 1.0\r\nReply-To: pookie@sissify.com\r\n','835455',NULL) at /home/femail/public_html/admin/GT/SQL/Driver/MYSQL.pm line 35.

DBD::mysql::st execute failed: Duplicate entry '834705' for key 1 at /home/femail/public_html/admin/GT/SQL/Driver/MYSQL.pm line 113.


So I thought "I'll run /batch/tools/consistency.pl.. but it threw me this error:


GMail (11650): Unknown method 'export_to_level' called at /home/femail/public_html/admin/GMail.pm line 123.
BEGIN failed--compilation aborted at consistency.pl line 16.


How can I resync these databases to get our mail system back up? I have it turned off with about 14k people asking "When is it going to be up again?"

Thanks!

Diversity by Design
Subject Author Views Date
Thread MySQL Duplicate Entry Error diversity 5158 Sep 15, 2002, 12:51 AM
Post Post deleted by diversity
diversity 5056 Sep 15, 2002, 10:08 PM
Thread What about those popbox.bak files?
diversity 5015 Sep 16, 2002, 11:21 AM
Thread Re: [diversity] What about those popbox.bak files?
Alex 5009 Sep 17, 2002, 7:00 PM
Thread Re: [Alex] What about those popbox.bak files?
diversity 5029 Sep 17, 2002, 7:42 PM
Thread Re: [diversity] What about those popbox.bak files?
Alex 5001 Sep 17, 2002, 9:29 PM
Thread Re: [Alex] What about those popbox.bak files?
diversity 4983 Sep 18, 2002, 12:13 AM
Thread Re: [diversity] What about those popbox.bak files?
Alex 5006 Sep 18, 2002, 12:39 AM
Post Re: [Alex] What about those popbox.bak files?
diversity 4970 Sep 18, 2002, 9:28 AM