ajk
03-13-2005, 04:53 PM
Hi Eveyone,
Can someone give me the quireies to fix this in phpMyAdmin?
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Unable to add cookies, header already sent.
File: /home/ds1/public_html/forums/vbulletin/includes/init.php
Line: 27
Executed 7 queries (3 queries for uncached templates) . (Template Usage) (Explain)
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Connecting to database
Time before: 0.0033509731292725
Time after: 0.0041940212249756
Time taken: 0.00084304809570312
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache', 'eventcache', 'mailqueue')
Time before: 0.0044939517974854
Time after: 0.0057339668273926
Time taken: 0.0012400150299072
table type possible_keys key key_len ref rows Extra
datastore ALL PRIMARY 18 Using where
Parsing functions.php
Time before: 0.009026050567627
Time after: 0.025780916213989
Time taken: 0.016754865646362
Query:
SELECT *
FROM session
WHERE sessionhash = 'f6bec72a28adf49734c2a74fc7c8f786'
AND lastactivity > 1110711026
AND host = '67.81.85.201'
AND idhash = 'a2a4914f34107a2e729d4c5ac4f19df3'
Time before: 0.02819299697876
Time after: 0.028609037399292
Time taken: 0.00041604042053223
table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1
Query:
SELECT languageid,
phrasegroup_holiday AS phrasegroup_holiday,
phrasegroup_global AS phrasegroup_global,
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
Time before: 0.029268026351929
Time after: 0.03008508682251
Time taken: 0.00081706047058105
table type possible_keys key key_len ref rows Extra
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Warning: Cannot modify header information - headers already sent by (output started at /home/ds1/public_html/forums/vbulletin/includes/init.php:481) in /includes/functions.php on line 2853
Processing sessions.php
Time before: 0.026119947433472
End sessions.php processing
Time after: 0.031141996383667
Time taken: 0.0050220489501953
Query:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.ca lendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(1))
ORDER BY displayorder ASC
Time before: 0.032272100448608
Time after: 0.05878210067749
Time taken: 0.026510000228882
table type possible_keys key key_len ref rows Extra
calendar ALL 2 Using temporary; Using filesort
calendarpermission range calendarid,usergroupid usergroupid 2 1 Using where
Query:
SELECT * FROM style
WHERE (styleid = 14 AND userselect = 1)
OR styleid = 14
ORDER BY styleid ASC
LIMIT 1
Time before: 0.059699058532715
Time after: 0.060264110565186
Time taken: 0.0005650520324707
table type possible_keys key key_len ref rows Extra
Query:
SELECT title, template
FROM template
WHERE templateid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0)
Time before: 0.061053991317749
Time after: 0.061602115631104
Time taken: 0.00054812431335449
table type possible_keys key key_len ref rows Extra
template range PRIMARY PRIMARY 4 1 Using where
Query:
SELECT title, html, url, type, status, width, height FROM banners WHERE status = '1' ORDER BY RAND() LIMIT 1
Time before: 0.063222885131836
Time after: 0.064043045043945
Time taken: 0.00082015991210938
table type possible_keys key key_len ref rows Extra
banners ALL 18 Using where; Using temporary; Using filesort
End call of global.php: 0.065215110778809
Query:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1110711026
ORDER BY username ASC
Time before: 0.087371110916138
Time after: 0.088779926300049
Time taken: 0.0014088153839111
table type possible_keys key key_len ref rows Extra
session ALL 144 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1
Query:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 0.090502977371216
Time after: 0.091150045394897
Time taken: 0.00064706802368164
table type possible_keys key key_len ref rows Extra
forum ALL 12
Page generated in 0.09623 seconds with 9 queries,
spending 0.033815383911133 doing MySQL queries and 0.062414616088867 doing PHP things.
Shutdown Queries:
Query:
UPDATE session
SET useragent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050225 Firefox/1.0.1', lastactivity = 1110720026, location = "/forums/vbulletin/?explain=1", styleid = 0, bypass = 0
,inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f6bec72a28adf49734c2a74fc7c8f786'
Time before: 0.097659111022949
Time after: 0.097951889038086
Time taken: 0.00029277801513672
That's as much debug info as I can come up with.
BOTH user side and admincp are completely down!
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Unable to add cookies, header already sent.
File: /home/ds1/public_html/forums/vbulletin/includes/init.php
Line: 27
Executed 8 queries (3 queries for uncached templates) . (Template Usage) (Explain)
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Thanks in advance!!!!!
Can someone give me the quireies to fix this in phpMyAdmin?
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Unable to add cookies, header already sent.
File: /home/ds1/public_html/forums/vbulletin/includes/init.php
Line: 27
Executed 7 queries (3 queries for uncached templates) . (Template Usage) (Explain)
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Connecting to database
Time before: 0.0033509731292725
Time after: 0.0041940212249756
Time taken: 0.00084304809570312
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache', 'eventcache', 'mailqueue')
Time before: 0.0044939517974854
Time after: 0.0057339668273926
Time taken: 0.0012400150299072
table type possible_keys key key_len ref rows Extra
datastore ALL PRIMARY 18 Using where
Parsing functions.php
Time before: 0.009026050567627
Time after: 0.025780916213989
Time taken: 0.016754865646362
Query:
SELECT *
FROM session
WHERE sessionhash = 'f6bec72a28adf49734c2a74fc7c8f786'
AND lastactivity > 1110711026
AND host = '67.81.85.201'
AND idhash = 'a2a4914f34107a2e729d4c5ac4f19df3'
Time before: 0.02819299697876
Time after: 0.028609037399292
Time taken: 0.00041604042053223
table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1
Query:
SELECT languageid,
phrasegroup_holiday AS phrasegroup_holiday,
phrasegroup_global AS phrasegroup_global,
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
Time before: 0.029268026351929
Time after: 0.03008508682251
Time taken: 0.00081706047058105
table type possible_keys key key_len ref rows Extra
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Warning: Cannot modify header information - headers already sent by (output started at /home/ds1/public_html/forums/vbulletin/includes/init.php:481) in /includes/functions.php on line 2853
Processing sessions.php
Time before: 0.026119947433472
End sessions.php processing
Time after: 0.031141996383667
Time taken: 0.0050220489501953
Query:
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.ca lendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON (calendarpermission.calendarid=calendar.calendarid AND usergroupid IN(1))
ORDER BY displayorder ASC
Time before: 0.032272100448608
Time after: 0.05878210067749
Time taken: 0.026510000228882
table type possible_keys key key_len ref rows Extra
calendar ALL 2 Using temporary; Using filesort
calendarpermission range calendarid,usergroupid usergroupid 2 1 Using where
Query:
SELECT * FROM style
WHERE (styleid = 14 AND userselect = 1)
OR styleid = 14
ORDER BY styleid ASC
LIMIT 1
Time before: 0.059699058532715
Time after: 0.060264110565186
Time taken: 0.0005650520324707
table type possible_keys key key_len ref rows Extra
Query:
SELECT title, template
FROM template
WHERE templateid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0)
Time before: 0.061053991317749
Time after: 0.061602115631104
Time taken: 0.00054812431335449
table type possible_keys key key_len ref rows Extra
template range PRIMARY PRIMARY 4 1 Using where
Query:
SELECT title, html, url, type, status, width, height FROM banners WHERE status = '1' ORDER BY RAND() LIMIT 1
Time before: 0.063222885131836
Time after: 0.064043045043945
Time taken: 0.00082015991210938
table type possible_keys key key_len ref rows Extra
banners ALL 18 Using where; Using temporary; Using filesort
End call of global.php: 0.065215110778809
Query:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1110711026
ORDER BY username ASC
Time before: 0.087371110916138
Time after: 0.088779926300049
Time taken: 0.0014088153839111
table type possible_keys key key_len ref rows Extra
session ALL 144 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1
Query:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 0.090502977371216
Time after: 0.091150045394897
Time taken: 0.00064706802368164
table type possible_keys key key_len ref rows Extra
forum ALL 12
Page generated in 0.09623 seconds with 9 queries,
spending 0.033815383911133 doing MySQL queries and 0.062414616088867 doing PHP things.
Shutdown Queries:
Query:
UPDATE session
SET useragent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050225 Firefox/1.0.1', lastactivity = 1110720026, location = "/forums/vbulletin/?explain=1", styleid = 0, bypass = 0
,inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f6bec72a28adf49734c2a74fc7c8f786'
Time before: 0.097659111022949
Time after: 0.097951889038086
Time taken: 0.00029277801513672
That's as much debug info as I can come up with.
BOTH user side and admincp are completely down!
Warning: Invalid argument supplied for foreach() in /includes/sessions.php on line 271
Unable to add cookies, header already sent.
File: /home/ds1/public_html/forums/vbulletin/includes/init.php
Line: 27
Executed 8 queries (3 queries for uncached templates) . (Template Usage) (Explain)
Template Usage
STANDARD_ERROR (1)
forumjump (1)
navbar (1)
Thanks in advance!!!!!