Step 13 error 1054

[VAN]

Here's the error:

 
 
Invalid SQL: 
 
SELECT post.attachmentid, post.postid, attachment.postid AS attachment_postid
 
FROM post
 
LEFT JOIN attachment ON (attachment.attachmentid = post.attachmentid)
 
WHERE post.attachmentid <> 0
 
ORDER BY post.attachmentid DESC
 
LIMIT 0, 500
 
 
 
mysql error: Unknown column 'post.attachmentid' in 'field list'
 
mysql error number: 1054

I checked the database, and there is no ATTACHMENTID field in the POST table. I havent skipped any steps, so can someone give me the values for this so I can create it manually?

[VAN]

Ok, I just checked the upgrade script and there is no ALTAR TABLE POST command prior to this, therefore POST.ATTACHMENTID wasn't created. I dunno what the deal is. ANy help would be appreciated

[Steve Machol]

Which upgraqde script were you running exactly? And which version were you upgrading from?