SQL Error when trying to empty PM box

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ted S
    Senior Member
    • Dec 2003
    • 332
    • 3.5.x

    SQL Error when trying to empty PM box

    The following error is occuring on 3.5.1 with no code modifications when a user tries to access /private.php?do=emptyfolder&folderid=0


    Invalid SQL:
    SELECT pmid, pmtextid
    FROM pm AS pm
    LEFT JOIN pmtext AS pmtext USING (pmtextid)
    WHERE folderid = 0
    AND userid = 20271
    AND dateline < 1132714983;
    MySQL Error : Column: 'pmtextid' in field list is ambiguous Error Number : 1052



    Ted & the Giftery.me Team

    New features released for Product Review Forums 1.3 (4.0)
    Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Try this fix:

    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 &lt;
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Ted S
      Senior Member
      • Dec 2003
      • 332
      • 3.5.x

      #3
      Thanks Steve
      Ted & the Giftery.me Team

      New features released for Product Review Forums 1.3 (4.0)
      Helpful Answers (3.8) (4.0) | Limited Guest Viewing (3.8) (4.0)

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎