vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Miscellaneous Hacks - Display OS and Browser Information on Postbit (https://vborg.vbsupport.ru/showthread.php?t=219687)

1320Nation 07-29-2009 04:32 PM

Quote:

Originally Posted by Fighter1405 (Post 1857950)
That just crashed your board? I'm very sorry then, although I have no idea why. The standard uninstall function from the admincp should do it. Is the board giving any particular errors?

The board returned to normal once the uninstall was completed. I can give you more info if needed.

Fighter1405 07-29-2009 04:33 PM

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

1320Nation 07-29-2009 04:44 PM

Quote:

Originally Posted by Fighter1405 (Post 1857954)
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 :

Fighter1405 07-29-2009 04:48 PM

I see the problem, thanks for copying the error :) Are you interested in a fixed version or not? I don't blame you if you aren't after all the problems you've had with it :p

1320Nation 07-29-2009 04:54 PM

Quote:

Originally Posted by Fighter1405 (Post 1857963)
I see the problem, thanks for copying the error :) Are you interested in a fixed version or not? I don't blame you if you aren't after all the problems you've had with it :p

I appreciate your dedication to your support. Yes after all this I would like to use a working version if possible.

Fighter1405 07-29-2009 04:57 PM

Quote:

Originally Posted by psychobike (Post 1857967)
I appreciate your dedication to your support. Yes after all this I would like to use a working version if possible.

Just before I write it can we do one check so I don't break your board again? Can you load up phpmyadmin (or similar) and check that there is no table on the vbulletin database called 'board_browserosinfo'?

SupraGame 07-30-2009 01:42 AM

im using the original xml and i installed it and have the gifs in the useragent folder, but the images arent displaying. theyre just showing up as

windows_xp_2003firefox for example.

is there something wrong in the template? or do i need to use (4) and (5)?

EDIT: it might be a browser issue or from my computer. not sure. some users can see it apparently

bollie 07-30-2009 07:00 AM

1 Attachment(s)
Quote:

Originally Posted by bollie
Work not for me.
Show not icon_(browser/os).gif
Originally Posted by Farman
Not working here even, Please give proper instruction, where to upload!
An example icon name would be "icon_firefox.gif" and that should be in the images/useragent folder, what do you have in that folder?
images/useragent/

Charlie98902 07-30-2009 10:09 AM

IE7 seems to do this according to my moderator that has that installed. But Chrime/Firefix/IE8 has no issues.

1320Nation 07-30-2009 10:39 AM

Quote:

Originally Posted by Fighter1405 (Post 1857968)
Just before I write it can we do one check so I don't break your board again? Can you load up phpmyadmin (or similar) and check that there is no table on the vbulletin database called 'board_browserosinfo'?

After checking there is NO 'board_browserosinfo' table.


All times are GMT. The time now is 03:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01218 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete