blank pages in admin and on main board

[ajk57]

Hi Everyone,

I removed a hack through the search function in phpMyAdmin.
After I took out all the entries from the hack, the BBS stopped running.

All the database info appears to be there.
The board is just dead.

Any help would be appreciated.


THANK YOU!!!!

[Chrissicom]

I am pretty sure you deleted some necessary stuff from your database, it's very likely that some part of vB itself was called the same as in your Hack

[ajk57]

I am pretty sure you deleted some necessary stuff from your database, it's very likely that some part of vB itself was called the same as in your Hack

I'm sure, the author DID say the two were intertwined.

So what do you think I have to fix in phpMyAdmin?

Thanks

[ajk57]

Debug message

Here is the debug message if this helps:

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.calendarid,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

THANKS!

[ajk57]

More Info

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)

[WhiteOx]

What was the hack you removed?

I'd restore the database.
To remove the hack I'd undo the edits to the php files and then do the same with any edited templates.
Only remove tables from your db if you are certain what they are for.

Try setting vB up on your home pc and practice on that first before touching your live forum.

[ajk57]

vBMS

[ajk57]

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

What do I do?

[WhiteOx]

Do you have SSH or Telnet access?

[WhiteOx]

vBMS??? Do you mean the VBCMPS portal?
If so try re-installing it with the install script.

[Dennis Olson]

Reinstall all your PHP files from your vB ZIP file. The reload all templates (I forget the name of the XML file, but someone here will know.

Leave your database entirely alone at the present time.

[ajk57]

Reinstall all your PHP files from your vB ZIP file. The reload all templates (I forget the name of the XML file, but someone here will know.

Leave your database entirely alone at the present time.

Hi Dennis,

I reuploaded in ASCII all the files. I still get the same error messages.

[Vtec44]

Are you using VBAdvanced Portal for your index page?

[ajk57]

No, the only working hack I installed was Banner Ads by ATC.

The vBMS install was left over from the old 2.x vB database.
I forgot to remove them at the time.

[ajk57]

More Info

When I run admincp/tools.php and style xml.
I get an error message that says invalid entry () for each on line 2002.