PDA

View Full Version : Help with a db query please


bashy
03-25-2007, 02:47 PM
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/attachment.php?attachmentid=3920&d=1174816559
Referrer : http://www.bashys-place.com/forums/showthread.php?t=20049

MarkPW
03-25-2007, 05:30 PM
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
03-25-2007, 05:38 PM
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
03-25-2007, 05:47 PM
Yes, all four (I only had a quick look at the xml file, seeing 2 - sorry). It's safe to remove them too.

bashy
03-25-2007, 06:33 PM
Excellent, thank you very much for your help....