Go Back   vb.org Archive > Community Discussions > Forum and Server Management
  #1  
Old 12-07-2008, 09:09 PM
6oct 6oct is offline
 
Join Date: Mar 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default massive attacks in vbulletin 3.7.4 !!!!!!!

facing a massive database connecetion causing my server to be down !!
WHT vulnerability the vbulletin came with this time!!
version 3.7.4


Server load reached 90!!!!!!!!
Code:
UHyyuh    localhost    jarabhar_vb    Query    43    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('1268') )
70523    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    159    Copying to tmp table    SELECT COUNT(post.dateline) AS postcount, post.userid, user.username \n\t\t\tFROM post AS post \n\t\t\tLEFT
70517    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    104    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=88758', inthr
70516    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    90    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=57861&pag
70590    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    106    Locked    UPDATE user\n\t\t\t\t\t\tSET lastactivity = 1228678815\n\t\t\t\t\t\tWHERE userid = 11122713
70611    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678818, location = '/forum/showthread.php?t=67507', inthr
70650    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    54    Locked    SELECT userid, username FROM user\n\t\t\tWHERE userid != 0\n\t\t\tAND\n\t\t\t(\n\t\t\t\tusername = 'king78'\n\t\t\t\tOR\n\t\t
70655    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    85    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678826, location = '/forum/showthread.php?t=103933', logg
70662    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid,
70674    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678829, location = '/forum/showthread.php?t=88702', inthr
70681    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678829, location = '/forum/showthread.php?t=88702', inthr
70684    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    94    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678830, location = '/forum/forumdisplay.php?f=46', inthre
70688    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678831, location = '/forum/showthread.php?t=88702', inthr
70694    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=88702', inthr
70700    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=88702', inthr
70699    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=42181', infor
70738    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    102    Locked    INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid,
70740    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('159100') )
70753    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678839, location = '/forum/showthread.php?t=86882', incal
70766    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    98    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678840, location = '/forum/forumdisplay.php?f=14', inforu
70778    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786
70780    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
70788    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
70789    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70790    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786
70794    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    67    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70796    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    93    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678845, inforum = 0, inthread = 0, incalendar = 0, badloc
70806    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    97    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70807    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    95    Locked    SELECT post.pagetext AS preview,\n\t\t\t\tthread.threadid, thread.threadid AS postid, thread.title AS thr
70810    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    95    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70821    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    94    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70824    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
70831    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70833    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    104    Locked    SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup
70836    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70838    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70842    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    SELECT\n\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70844    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    97    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70846    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    94    Locked    SELECT userid AS primarykey, lastpost AS readcolumn\n\t\t\tFROM user AS user\n\t\t\tWHERE userid = 145377\n\t\t
70847    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    SELECT\n\t\t\tuser.username, (user.options & 512) AS invisible, user.usergroupid,\n\t\t\tsession.userid, ses
70869    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    89    Locked    SELECT post.pagetext AS preview,\n\t\t\t\tthread.threadid, thread.threadid AS postid, thread.title AS thr
70871    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    100    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70875    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    102    Locked    INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid,
70876    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70879    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    97    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70888    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
70890    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70893    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786
70896    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    99    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70898    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678874, location = '/forum/showthread.php?t=88702', inthr
70903    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
70904    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    104    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70905    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    104    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70913    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    69    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70917    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup
70926    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup
70931    animal2    localhost    animal2_vb2    Query    15    closing tables    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678879, location = '/showthread.php?t=2366', inforum = 52
70940    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Sorting result    SELECT post.postid\n\t\t\tFROM post AS post\n\t\t\t\n\t\t\tWHERE post.threadid = 57861\n\t\t\t\tAND post.visible = 1\n
70941    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786
70945    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    105    Locked    ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786
70947    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678884, location = '/forum/search.php?do=finduser&use
70948    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    106    Locked    SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.
70950    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    99    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70952    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    69    Locked    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70958    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    102    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = 'e422f3326c9e04e4db3b4fc80bc6ed65'\n\t\t\t\t\tAND lastac
70962    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '74.6.8.91'\n\t\t\t\t\tAND idhash = '8391e2
70963    animal2    localhost    animal2_vb2    Query    12    Opening tables    SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
70964    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    103    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '94.98.101.212'\n\t\t\t\t\tAND idhash = '64
70966    hakarrr    localhost    hakarrr_vb2    Query    90    Sorting result    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las
70967    hakarrr    localhost    hakarrr_vb2    Query    13    Opening tables    SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
70968    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    101    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '61.247.222.53'\n\t\t\t\t\tAND idhash = 'a9
70974    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    98    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.214.131.149'\n\t\t\t\t\tAND idhash = 'c
70976    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    98    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.235.61.127'\n\t\t\t\t\tAND idhash = '6d
70975    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    98    Locked    select userid from user where username like "cassaei cacaea" limit 1
70977    animal2    localhost    animal2_vb2    Query    11    Writing to net    SELECT title, template\n\t\t\tFROM template\n\t\t\tWHERE templateid IN (3796,3657,3882,3883,3886,3887,3888,3
70978    hakarrr    localhost    hakarrr_vb2    Query    13    Opening tables    UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678894, incalendar = 0, badlocation = 0\n\t\t\t\t\tWHERE sessio
70979    animal2    localhost    animal2_vb2    Query    17    closing tables    SELECT *\n\t\tFROM style\n\t\tWHERE (styleid = 22 AND userselect = 1)\n\t\t\tOR styleid = 22\n\t\tORDER BY stylei
70980    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    98    Locked    SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.
70971    animal2    localhost    animal2_vb2    Query    12    Sorting result    SELECT userid, usergroupid, displaygroupid, username, posts \n\t\t\t\t\t\tFROM user AS user \n\t\t\t\t\t\tWHERE po
70982    animal2    localhost    animal2_vb2    Query    97    closing tables    SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.
70983    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    97    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '82.114.174.57'\n\t\t\t\t\tAND idhash = 'f1
70984    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    96    Locked    select userid from user where username like "oin cauiae" limit 1
70985    animal2    localhost    animal2_vb2    Query    11    Opening tables    SELECT *\n\t\tFROM style\n\t\tWHERE (styleid = 22 AND userselect = 1)\n\t\t\tOR styleid = 22\n\t\tORDER BY stylei
70986    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    95    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.235.61.127'\n\t\t\t\t\tAND idhash = '6d
70994    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    94    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '13181b98c8b8b18f2b6adfcc64b63a03'\n\t\t\t\t\tAND lastac
70995    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    93    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = 'b0ce577d5f9a5507975229eb7489ac37'\n\t\t\t\t\tAND lastac
70998    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    93    Locked    select userid from user where username like "thewizard0" limit 1
70996    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    93    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '91.144.0.100'\n\t\t\t\t\tAND idhash = '1d0
71000    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    93    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '07ca51b433a2306341efb9467a4a7b98'\n\t\t\t\t\tAND lastac
71003    s7aba_vb    localhost    s7aba_vb    Query    13    Opening tables    SELECT userselect_tag, opentag_user, closetag_user \n\t\tFROM user AS user \n\t\tWHERE username = '???
71005    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    92    Locked    select userid from user where username like "tech\\_admin" limit 1
71009    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    92    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '65.111.177.102'\n\t\t\t\t\tAND idhash = '8
71010    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    91    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '8ef6de648114e052ab55edaa5313b2e9'\n\t\t\t\t\tAND lastac
71011    s7aba_vb    localhost    s7aba_vb    Query    12    Sorting result    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las
71012    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    91    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '87.230.141.175'\n\t\t\t\t\tAND idhash = '2
71013    hakarrr    localhost    hakarrr_vb2    Query    90    Sorting result    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las
71015    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    91    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.232.198.251'\n\t\t\t\t\tAND idhash = '8
71017    qwaihco_vbuser    localhost    qwaihco_vb35    Query    3    Opening tables    SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=214
71022    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    84    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '57f70d252d4b446441774e31304af94b'\n\t\t\t\t\tAND lastac
71024    animal2    localhost    animal2_vb2    Query    11    Opening tables    SELECT userid, usergroupid, displaygroupid, username, posts \n\t\t\t\t\t\tFROM user AS user \n\t\t\t\t\t\tWHERE po
71026    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    81    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '57f70d252d4b446441774e31304af94b'\n\t\t\t\t\tAND lastac
71033    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    64    Locked    SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.233.230.191'\n\t\t\t\t\tAND idhash = '2
71035    jarabhar_JUHyyuh    localhost    jarabhar_vb    Query    15    Opening tables    REPLACE INTO datastore\n\t\t\t\t(title, data, unserialize)\n\t\t\tVALUES\n\t\t\t\t('cron', '1228679100', 0)
--------------- Added [DATE]1228691408[/DATE] at [TIME]1228691408[/TIME] ---------------

there is much more logs from the mysql processlist
but the forum cant accept more char !
Reply With Quote
  #2  
Old 12-08-2008, 08:12 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
70523 jarabhar_JUHyyuh localhost jarabhar_vb Query 159 Copying to tmp table SELECT COUNT(post.dateline) AS postcount, post.userid, user.username \n\t\t\tFROM post AS post \n\t\t\tLEFT
This is the first issue you will need to resolve. I doubt this is caused by a default vB query. So first start by disabling and or removing your modifications and see if that helps.
Reply With Quote
  #3  
Old 12-08-2008, 08:19 AM
6oct 6oct is offline
 
Join Date: Mar 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i didnt made any modification and have disabled all the addons and hacks...
this is a fresh vbulletin copy 3.7.4 installed and using vbSEO
Reply With Quote
  #4  
Old 12-08-2008, 08:23 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vBSEO is a modification.
Reply With Quote
  #5  
Old 12-08-2008, 08:45 AM
6oct 6oct is offline
 
Join Date: Mar 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok i'll disable it...
Reply With Quote
  #6  
Old 12-09-2008, 02:54 AM
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Location: Netherlands
Posts: 3,537
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you getting vb database error emails, about connections?
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 07:47 PM.


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.04067 seconds
  • Memory Usage 2,237KB
  • Queries Executed 13 (?)
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
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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