Announcement

Collapse
No announcement yet.

MySQL errors with attachments!!Please help!

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

  • MySQL errors with attachments!!Please help!

    I ve run this query:

    ALTER TABLE xxxx_attachment add usedin varchar(30) not null;

    AND

    I get the following mysql error:

    Database error in vBulletin 3.5.0:

    Invalid SQL:

    SELECT attachmentid
    FROM xxxx_attachment AS attachment
    LEFT JOIN xxxx_pmtext AS pmtext ON attachment.usedin='pmtextid' AND attachment.itemid=pmtext.pmtextid
    WHERE
    pmtext.pmtextid IS NULL
    AND usedin<>''
    AND itemid<>'';

    MySQL Error : Unknown column 'usedin' in 'where clause'
    Error Number : 1054


    any solutions?Thanks in advance!

  • #2
    This sounds liek a problem from the 'Attachments in PM' hack. Please ask your question in the support thread of this hack at vbulletin.org.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment

    Loading...
    Working...
    X