Errors after upgrade

[kellyandmark04]

Well I deleted vbSEO and now I can get into the forums and threads but if I try to create a new thread or click go advance on a post I get the error below also I still can't get into private messages. New posts don't show up in search either.



Invalid SQL:

SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
WHERE
a.posthash = '23b3b203006579550653d6ee2396eadb'
AND
a.userid IN (1)
AND
a.contenttypeid =

ORDER BY a.contentid, a.displayorder;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY a.contentid, a.displayorder' at line 15

Here is the error from trying to access my inbox


Invalid SQL:
();

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1


and no ticket support unfortunately and no suspect files. Thanks for all your help this has me completely lost as to why this is happening.

--------------- Added [DATE]1316218746[/DATE] at [TIME]1316218746[/TIME] ---------------

MySQL Version 5.0.92-community