[Boofo]

I need to reverse the queries for this hack until I can get the code changes to get it installed. I can't post or make any new threads. Here is the error I am getting:

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT a.attachmentid
FROM attachment AS a
LEFT JOIN post ON (post.attachmentid = a.attachmentid)
LEFT JOIN privatemessage ON (privatemessage.attachmentid = a.attachmentid)
WHERE postid IS NULL AND privatemessageid IS NULL

mysql error: Column: 'postid' in where clause is ambiguous

mysql error number: 1052

Date: Thursday 01st of May 2003 07:11:40 AM
Script: http://www.bearfacts2.com/forum/foru...ead&forumid=11
Referer: http://www.bearfacts2.com/forum/foru...?s=&forumid=11

Can anyone please tell me how to revert the queries back to what they were before I ran them for this hack for now? These are the queries I think that need to be converted back to the originals until rake can help me with the coding.

ALTER TABLE `post` CHANGE `attachmentid` `attachmentid` VARCHAR( 50 ) DEFAULT '0' NOT NULL;
ALTER TABLE `post` ADD INDEX ( `attachmentid` );
ALTER TABLE `attachment` ADD `postid` INT NOT NULL;
ALTER TABLE `attachment` ADD INDEX ( `postid` );