Help with a db query please

[bashy]

Hi

I had the PM Attachments installed but as it never worked i have decided to uninstall it.
No since doing this i am geting db errors, such as below

When i installed the hack i had to run the following queries

ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);

Now in the instructions there is no advice as to uninstalling the hack nor removing the said queries, it looks like my db error is something to do with the said queries as well.

Can anyone advise on how to undo what the queries did please?

  Database error in vBulletin 3.6.4:
   
  Invalid SQL:
   
        SELECT userid,itemid,usedin
        FROM attachment AS attachment
        WHERE attachmentid = 3920;
   
  MySQL Error  : Unknown column 'itemid' in 'field list'
  Error Number : 1054
  Date         : Sunday, March 25th 2007 @ 04:41:36 PM
  Script       : http://www.bashys-place.com/forums/a...0&d=1174816559
  Referrer     : http://www.bashys-place.com/forums/s...ad.php?t=20049

[MarkPW]

It looks as though you haven't disable the plug-ins.

Disable/remove the plugin-in, "private attachments - can view the attachment" and "private attachments - get posthash and allow attachments".

[bashy]

I uninstalled the product.... thats how this has happened
Looking at the plugins, it looks as though they are still there....

private attachments - can view the attachment attachment_start
private attachments - get & show attachments postbit_display_start
private attachments - get posthash and allow attachments private_newpm_start
private attachments - update attachment info private_insertpm_complete

are these what i need to remove?

Just disabled them and the issue as gone away, so i take it i am safe to remove these now?

[MarkPW]

Yes, all four (I only had a quick look at the xml file, seeing 2 - sorry). It's safe to remove them too.

[bashy]

Excellent, thank you very much for your help....