The Arcive of Official vBulletin Modifications Site.

ajk · #1 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)

Code:

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)

Code:

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!

Code:

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!!!!!

Marco van Herwaarden · #2 03-13-2005, 05:49 PM

Did you make any edit to your sessions.php file?

Check if there are maybe spaces in the top before "<?php" or in the bottom after "?>"

The error you are getting seem to be pointing at a problem with your language table, any changes made there?

Check if your default language (-1) is still in your language file

ajk · #3 03-13-2005, 08:59 PM

Thank you Marco!

BTW......

phpMyAdmin ONLY has a limit of (Max: 51,200KB).
My backup from January 10 is over 700MB!

What do I do?

eva01_ · #4 03-13-2005, 09:39 PM

use SSH to restore it

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04894 seconds Memory Usage 2,195KB 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!