[jimsflies]

Here's the error:

			SELECT attachment.*, filedata.* 
			FROM vb_attachment
			LEFT JOIN vb_filedata AS filedata ON (attachment.filedataid = filedata.filedataid)
			WHERE posthash = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';

MySQL Error   : Unknown table 'attachment'

I see there is some discussion about database prefixes, it does have the prefix in the FROM line.