PM Empty Folder DB's error , 3.5.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ForYou
    Senior Member
    • Nov 2001
    • 126
    • 3.6.x

    PM Empty Folder DB's error , 3.5.1

    Hello ,

    Install VB 3.5.1 ,

    the first problem i find it , when i need to empty the pm folder (Sent) , there is Data Base Error ,



    Database error in vBulletin 3.5.1:
    Invalid SQL:
    SELECT pmid, pmtextid
    FROM pm AS pm
    LEFT JOIN pmtext AS pmtext USING (pmtextid)
    WHERE folderid = -1
    AND userid = 3
    AND dateline < 1130905174;
    MySQL Error : Column 'pmtextid' in field list is ambiguous
    Error Number : 1052
    Date : Wednesday, November 2nd 2005 @ 04:26:18 AM
    Script : http://www.XXXX.net/vb/private.php
    Referrer : http://www.XXXX.net/vb/private.php?d...er&folderid=-1
    IP Address : 83.000.5.103
    Username : ForYou
    Classname : vb_database


    Please Help ,

    Regards
  • ForYou
    Senior Member
    • Nov 2001
    • 126
    • 3.6.x

    #2
    Hello ,

    There is the same problem in http://www.vbulletin.com , I was try now ,

    There seems to have been a problem with the vBulletin Community Forum database.
    Please try again by clicking the Refresh button in your web browser.
    An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
    We apologise for any inconvenience.

    Regards

    Comment

    • Andreas
      Senior Member
      • Feb 2004
      • 2323

      #3
      In file private.php
      FIND
      PHP Code:
          $deletepms = array();
          
      // get pms
          
      $pms $db->query_read("
              SELECT pmid, pmtextid 
      REPLACE that with
      PHP Code:
          $deletepms = array();
          
      // get pms
          
      $pms $db->query_read("
              SELECT pmid 

      Comment

      • ForYou
        Senior Member
        • Nov 2001
        • 126
        • 3.6.x

        #4
        That's good Andreas ,

        Fixed it ,

        thanks
        Regards

        Comment

        • steven s
          Senior Member
          • Jul 2004
          • 3722
          • 3.8.x

          #5
          Is this going to be in the next version?
          ...steven
          www.318ti.org (vB3.8) | www.nccbmwcca.org (vB4.2)
          bmwcca.org/forum | m135i.net
          "I tried to clean this up but this thread is beyond redemption." - Steve Machol

          Comment

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