[1320Nation]

Originally Posted by Fighter1405

If you could that would be great, I'd like to figure out why it happened. Do you remember what error you were getting?

Here was the common error:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, '' AS field9, '' AS field11
, gcache.ids as gcacheids, gcache.dateline as gcachedateline, browserosinfo.browser AS browser, browserosinfo.OS as OS
FROM board_post AS post
LEFT JOIN board_user AS user ON(user.userid = post.userid)
LEFT JOIN board_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN board_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN board_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN board_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN board_customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN board_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN board_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)
LEFT JOIN board_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)
LEFT JOIN board_sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN board_gal_cache as gcache ON (post.postid = gcache.postid)LEFT JOIN board_browserosinfo AS postinfo ON (post.postid=browserosinfo.postid)
WHERE post.postid IN (0,263014,263123,263177,263763,263821)
ORDER BY post.dateline;

MySQL Error : Unknown column 'browserosinfo.browser' in 'field list'
Error Number : 1054
Request Date : Wednesday, July 29th 2009 @ 02:22:43 PM
Error Date : Wednesday, July 29th 2009 @ 02:22:43 PM
Script : http://******/forums/garage-sale/255...1-150-tyd.html
Referrer : http://******/forums/garage-sale/
IP Address : *******
Username : slo poke
Classname : vB_Database
MySQL Version :