Originally Posted by psychobike (Post 1857959)

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 :

Originally Posted by synseal (Post 1858678)

Hi thanks for this mod, one problem I'm having so far is I'm using windows 7 and my posts show as windows 98_nt_2000 http://www.techkings.org/images/user...98_nt_2000.gif

Originally Posted by bollie (Post 1858341)

images/useragent/

Originally Posted by bollie (Post 1858972)

Helpppp