db error

[eLsGn]

Database error in vBulletin 3.0.8:

Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(10160, 189633, '',
'zamalkawy', 4, 1127296074,
'الحل هو الجوهري او فينجادا ده راي استاذؤ محسن وراي', 1, 1,
'62.12.118.9', 0, 1, 0)

mysql error: Duplicate entry '189695' for key 1

mysql error number: 1062

Date: Wednesday 21st of September 2005 04:47:54 AM
Script: http://www.zamalek.tv/forum/newreply.php
Referer: http://www.zamalek.tv/forum/showthre...t=10160&page=2
Username: zamalkawy
IP Address: 62.12.118.9

[plebobo]

Same Problem

I am having the same problem. Can anyone help? Seems there is a problem with REPLYING TO PM's with the same error 1062. Actually sending a NEW PM is working. One other Maybe unrelated/ maybe related is a report from a member saying something I am not totally clear on yet: She says: I can log in from email but not from site.

www.projectpcf.com
version 3.0.8

Please advise

Error Info, I get when trying to reply to a member PM:

Database error in vBulletin 3.0.8:

Invalid SQL:
INSERT INTO mailqueue
(dateline, toemail, subject, message, header)
VALUES
(1127296204 , "[email protected]" , "New Private Message at ProjectPCF" ,
"mikeman,

You have received a new private message at ProjectPCF from Admin. Please click
here to log in and read it:

http://www.projectpcf.com/private.php

Thanks,
ProjectPCF team" , "From: \"ProjectPCF Forums\" <[email protected]>
Return-Path: [email protected]
Message-ID: <[email protected]>
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
MIME-Version: 1.0
Content-Type: text/plain; charset=\"ISO-8859-1\"
Content-Transfer-Encoding: 8bit
" )
mysql error: Duplicate entry '551' for key 1

mysql error number: 1062

Date: Wednesday 21st of September 2005 05:50:04 PM
Script: http://www.projectpcf.com/private.php
Referer: https://www.projectpcf.com/private.p...newpm&pmid=813
Username: XXXX
IP Address: XXX.XXX.XXXXXXX

[plebobo]

Found Source and Solved!

I think I have found the source of this challenge. I tried to duplicate this error and what I found is this.

The only time it will duplicate is when the email address of the member is either invalid OR their ISP is rejecting our emails AND the member has their UserCP Options set for email notification of new PM.

eLsGn, could you test this theory on your forum by disabling the members (the one that is creating the error only) email notifications and then replying or sending them a PM or POST, whichever function it is that is causing this error on your froum? Please post here your results. I would like to try to ensure that this is truly the real source of this error for us. Thanks

So bottomline is, this looks like it is not really a database problem to me.

VBsupport please take a look at my assessment and conclusion and advise me as to whether this makes sense to you, technically speaking. I have *no* experience or understanding YET about databases and such technical issues as this. But I am always learning!

Thank You

[plebobo]

Update: Error Still Occuring

Okay, further trouble-shooting is proving I am wrong. Tested this theory with a proven good email address. This error continues when member settings in UserCP is set to send email notifications of either PMs or Posts.

Please advise

Version 3.0.8
www.projectpcf.com