Error when editing or deleting a wiki page

A-Rod
Joined: 17 Jul 2008

Error when editing or deleting a wiki page

Posted:20 Dec 2008 (07:03 UTC)
I get emails from the application when editing or deleting ANY wiki page. The error is listed below. Some of the domain info has been edited for privacy reasons. Please help... not sure why it is doing this. This started after the last CVS update. Can someone tell me why this is happening?

Version: bitweaver 2.1.0 RC1

This is the email error:

A message that you sent contained one or more recipient addresses that were incorrectly constructed:

no address given: missing or malformed local part (expected word or "<")

This address has been ignored. There were no other addresses in your message, and so no attempt at delivery was possible.



To: no address given
Subject: Duplicate entry '3766-384' for key 1
Message-Id: E1LDutr-00024W-LQ@krkcslz1.server.com
From: www-data www-data@mail.server.com
From: www-data wiki@server.com
X-rewrote-sender: www-data@mail.server.com
Date: Fri, 19 Dec 2008 22:01:19 -0800

- 2.1.0 RC1 - Fri Dec 19 22:01:19 2008

        1. USER AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
        2. ACCT: ID: 2 - Login: admin - e-mail: aaron@server.com
        3. URL: wiki.server.com/wiki/edit.php
        4. REFERRER: wiki.server.com/wiki/edit.php?page_id=113
        5. HOST: wiki.server.com
        6. IP:
        7. SQL: INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) VALUES ( '3766', '384' )
        8. ERROR CODE: Errno: 1062 Message: Duplicate entry '3766-384' for key 1

}}}}}}}}}}}}} -> bit_error_string(Array 6)
}}}}}}}}}}}}} LINE: 648, /home/csuser/public_html/kernel/BitDbAdodb.php
}}}}}}}}}}}} -> bit_error_handler(mysql, bit_error_handler, 1062, Duplicate entry '3766-384' for key 1, INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) V..., false, Object:ADODB_mysql)
}}}}}}}}}}}} LINE: 226, /home/csuser/public_html/util/adodb/adodb.inc.php
}}}}}}}}}}} -> ADODB_TransMonitor(mysql, EXECUTE, 1062, Duplicate entry '3766-384' for key 1, INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) V..., false, Object:ADODB_mysql)
}}}}}}}}}}} LINE: 916, /home/csuser/public_html/util/adodb/adodb.inc.php
}}}}}}}}}} -> ADOConnection::_Execute(INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) V...)
}}}}}}}}}} LINE: 872, /home/csuser/public_html/util/adodb/adodb.inc.php
}}}}}}}}} -> ADOConnection
ADOConnection
Execute(INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) V..., Array 2)
}}}}}}}}} LINE: 239, /home/csuser/public_html/kernel/BitDbAdodb.php
}}}}}}}} -> ADOConnection
ADOConnection
BitDbAdodb::query(INSERT INTO `pigeonhole_members` ( `parent_id`, `content_id` ) V..., Array 2)
}}}}}}}} LINE: 476, /home/csuser/public_html/kernel/BitDbBase.php
}}}}}}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
associateInsert(pigeonhole_members, Array 2)
}}}}}}} LINE: 790, /home/csuser/public_html/pigeonholes/Pigeonholes.php
}}}}}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes::insertPigeonholeMember(Array 1)
}}}}}} LINE: 1210, /home/csuser/public_html/pigeonholes/Pigeonholes.php
}}}}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes::pigeonholes_content_store(Object:BitPage, Array 43)
}}}}} LINE: 826, /home/csuser/public_html/liberty/LibertyContent.php
}}}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes
LibertyContent
invokeServices(content_store_function, Array 43)
}}}} LINE: 362, /home/csuser/public_html/liberty/LibertyContent.php
}}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes
LibertyContent
LibertyContent::store(Array 43)
}}} LINE: 82, /home/csuser/public_html/liberty/LibertyMime.php
}} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes
LibertyContent
LibertyContent
LibertyMime
store(Array 43)
}} LINE: 129, /home/csuser/public_html/wiki/BitPage.php
} -> ADOConnection
ADOConnection
BitDbAdodb
BitDb
Pigeonholes
LibertyContent
LibertyContent
LibertyMime
BitPage::store(Array 43)
} LINE: 411, /home/csuser/public_html/wiki/edit.php
Bobby Richardson
Joined: 15 Aug 2006

Re: Error when editing or deleting a wiki page

Posted:12 Mar 2009 (06:50 UTC)
No promises, but it looks like you've got an id duplicated somewhere in the pigeonhole_members table.

I'd fire up my database admin app and see what's to be seen in the tables.