Announcement

Collapse
No announcement yet.

db error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • db error

    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

  • #2
    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
    Last edited by plebobo; Wed 21 Sep '05, 3:59am.

    Comment


    • #3
      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
      Last edited by plebobo; Wed 21 Sep '05, 5:30am.

      Comment


      • #4
        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

        Comment

        Related Topics

        Collapse

        Working...
        X