vb.org Archive - Add-On Releases - Spiders Display on Forumhome and Who's Online for vb4

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Add-On Releases - Spiders Display on Forumhome and Who's Online for vb4 (https://vborg.vbsupport.ru/showthread.php?t=243460)

Quote:

Originally Posted by Boofo (Post 2277870)

You can't uninstall this through myphpadmin. It makes no entries into the db at all. It only reads what is already there. What is your problem? If you don't want to use it, uninstall it through the product manager.

OK.... What I know is I mistakenly turned this on, when it was originally disabled. Kind of got mixed up between tabs... test install and live site.

Upon activating this modification I got the following

Warning: mysqli_query(): (42S22/1054): Unknown column 'language.phrasegroup_global' in 'field list' in [path]/includes/class_core.php on line 1395

The e-mail I get tells me this

Code:

Invalid SQL:



                                       SELECT languageid,

                       phrasegroup_global AS phrasegroup_global,

                       phrasegroup_vbcms AS phrasegroup_vbcms,

                       phrasegroupinfo AS lang_phrasegroupinfo,

                       options AS lang_options,

                       languagecode AS lang_code,

                       charset AS lang_charset,

                       locale AS lang_locale,

                       imagesoverride AS lang_imagesoverride,

                       dateoverride AS lang_dateoverride,

                       timeoverride AS lang_timeoverride,

                       registereddateoverride AS lang_registereddateoverride,

                       calformat1override AS lang_calformat1override,

                       calformat2override AS lang_calformat2override,

                       logdateoverride AS lang_logdateoverride,

                       decimalsep AS lang_decimalsep,

                       thousandsep AS lang_thousandsep

                                       FROM language

                                       WHERE languageid = 1;



MySQL Error   : Unknown column 'phrasegroup_global' in 'field list'

Error Number  : 1054

So yes, I was hoping there was a way to disable this... Since I can not even access my AdminCP at this time.

I didn't mean any disrespect in my inquire and do not understand your "anger" toward my inquire.

My anger comes from the fact that there is no way on earth that this mod is causing anything near what you are experiencing. You have a rogue mod acting up and it will act up later on when you change or install another mod that that causes it to blow up again. You need to find what mod is originally causing that and stop blaming mods that can in no way be the trouble spot.

My advice to you is to look through your mods (you should have them backed up on your HD) and see which ones are for the forum home that write to the db and check those out.

Quote:

Originally Posted by Boofo (Post 2277874)

Again, the only person who I asked help from was you.... This 1x.... If you don't want people asking questions about possible conflicts.... Simply do not submit future modifications.

There is no reason for your hostility.

Do you see the "Not Supported" in the first post? This is exactly why that has been added to my mods. Blaming a mod for problems that it in no way can be a part of does not bode well for coders wanting to write and support mods.

To sum it all up, and again say that this mod is not causing the issue that you're having, the ONLY query this modification executes is this:

Code:

    $spiders = $db->query_read("

        SELECT useragent

        FROM " . TABLE_PREFIX . "session

        WHERE lastactivity > " . intval($datecut) . "

            AND userid = 0

    ");

Nothing about phrasegroup, or language, or anything. It selects from the table session the users useragent. Basically the same as if you were to view the Who's Online page. It reads what's already there, and prints it out on your who's online.

And does NOT write, or add, anything to the db, hence the "db->query_read".

Quote:

Originally Posted by OldSchoolDSL (Post 2277873)

Code:

Invalid SQL:



                                       SELECT languageid,

                       phrasegroup_global AS phrasegroup_global,

                       phrasegroup_vbcms AS phrasegroup_vbcms,

                       phrasegroupinfo AS lang_phrasegroupinfo,

                       options AS lang_options,

                       languagecode AS lang_code,

                       charset AS lang_charset,

                       locale AS lang_locale,

                       imagesoverride AS lang_imagesoverride,

                       dateoverride AS lang_dateoverride,

                       timeoverride AS lang_timeoverride,

                       registereddateoverride AS lang_registereddateoverride,

                       calformat1override AS lang_calformat1override,

                       calformat2override AS lang_calformat2override,

                       logdateoverride AS lang_logdateoverride,

                       decimalsep AS lang_decimalsep,

                       thousandsep AS lang_thousandsep

                                       FROM language

                                       WHERE languageid = 1;



MySQL Error   : Unknown column 'phrasegroup_global' in 'field list'

Error Number  : 1054

Try this next time a issue comes up with accessing your admincp - https://vborg.vbsupport.ru/showthread.php?t=259619

Let's also cheer up in here gosh!

Merry Christmas :D

Nothing to cheer up. He has clicked the uninstall button and apparently uninstalled the mod so all is well in the Spider Display land again.

Quote:

Originally Posted by Boofo (Post 2277920)

He has clicked the uninstall button and apparently uninstalled the mod so all is well in the Spider Display land again.

That may be, but your reactions were rather OTT. Take a deep breath next time. :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01659 seconds Memory Usage 1,756KB 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 (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages: