[predatorkill]

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!

How can i revert the table back to normal?