Mail delivery failed: returning message to sender

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • canarybreeder
    Member
    • Oct 2007
    • 80
    • 3.6.x

    [Forum] Mail delivery failed: returning message to sender

    Its been now a lot of days that i am receiving daily uo to 30 e-mails per day as below

    This message was created automatically by mail delivery software.

    A message that you sent could not be delivered to one or more of its
    recipients. This is a permanent error. The following address(es) failed:

    [email protected]
    "Sorry, you are sending to/from an address that has been blacklisted"

    ------ This is a copy of the message, including all the headers. ------

    Return-path: <[email protected]>
    Received: from canarybr by gator1251.hostgator.com with local (Exim 4.69)
    (envelope-from <[email protected]>)
    id 1PddXQ-0004KS-DS
    for [email protected]; Fri, 14 Jan 2011 00:53:32 -0600
    To: [email protected]
    Subject: vBulletin Database Error!
    X-PHP-Script: canarybreeder.net/up/forum/staff.php for 66.249.72.133
    From: "[email protected]" <[email protected]>
    Message-ID: <[email protected]>
    MIME-Version: 1.0
    Content-Type: text/plain; charset="ISO-8859-7"
    Content-Transfer-Encoding: 8bit
    X-Priority: 3
    X-Mailer: vBulletin Mail via PHP
    Date: Fri, 14 Jan 2011 00:53:32 -0600

    Database error in vBulletin 4.0.8:

    Invalid SQL:

    SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff,
    COUNT(user.userid) AS membercount
    FROM fnewusergroup AS usergroup
    LEFT JOIN fnewuser AS user ON (user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
    WHERE usergroup.isstaff = '1'
    GROUP BY usergroup.usergroupid
    ORDER BY usergroup.title ASC;

    MySQL Error : Unknown column 'usergroup.isstaff' in 'field list'
    Error Number : 1054
    Request Date : Friday, January 14th 2011 @ 12:53:32 AM
    Error Date : Friday, January 14th 2011 @ 12:53:32 AM
    Script : http://canarybreeder.net/up/forum/st...=V&language=pt
    Referrer :
    IP Address : 66.249.72.133
    Username : Μη εγγεγραμμένος
    Classname : vB_Database
    MySQL Version :

    I have contacted my proviodor and they told me that its not their problem.
    Please can someone help me to fix this ,and stop sending this messages.

    Please also note that all messages arre coming to the webmail ONLY. On the outlook are not shown,

    Thanks
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    There is no field called isstaff in the usergroup table in default vbulletin. That error is from a modification you installed. You will need to find it and disable/uninstall it in order to get rid of the error.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment

    • Bram
      Senior Member
      • May 2007
      • 216

      #3
      Since a few weeks we are having the same. Did you find out what caused this error?

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24325
        • 5.7.X

        #4
        Could be this mod:

        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • Bram
          Senior Member
          • May 2007
          • 216

          #5
          We havent installed this modification on our forums. Problems are still there and only seems to get worse. 99% of the people that request their lost password never get their email

          Comment

          • Maurd
            Senior Member
            • Jun 2011
            • 672
            • 4.1.x

            #6
            Originally posted by Bram
            99% of the people that request their lost password never get their email
            Your problem isn't related to the OP's problem. The OP's problem is that he never changed the database error email address in the config file (notice: [email protected]) and now every time an database error is sent, it bounces since the address is invalid.

            Are you getting bounce notifications too? It could very well be that the members' email accounts are no longer valid. Go to your Admin CP and into the Diagnostics menu, send an email test to your own email address. If you get the email then nothing is wrong server-side.
            - Maurice Workin' in the Jira mine, goin' down, down, down

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...