Announcement

Collapse
No announcement yet.

blank pages in admin and on main board

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • blank pages in admin and on main board

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

  • #2
    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 have emotional vices and they can be far more paralyzing than drugs or alcohol."
    -Sandra Bullock


    Sandra Bullock Central Message Board / Chris' Famous Sandra Bullock Page / Sandra Bullock News (Deutsch)

    Comment


    • #3
      Originally posted by 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
      I'm sure, the author DID say the two were intertwined.

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

      Thanks
      Andy Knifel

      Comment


      • #4
        Debug message

        Here is the debug message if this helps:

        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.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!
        Andy Knifel

        Comment


        • #5
          More Info

          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)
          Andy Knifel

          Comment


          • #6
            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.

            Comment


            • #7
              vBMS
              Andy Knifel

              Comment


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

                What do I do?
                Andy Knifel

                Comment


                • #9
                  Do you have SSH or Telnet access?

                  Comment


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

                    Comment


                    • #11
                      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.

                      Comment


                      • #12
                        Originally posted by 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.
                        Hi Dennis,

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

                        Comment


                        • #13
                          Are you using VBAdvanced Portal for your index page?
                          So Cal Sportbike forum - So Cal Moto - Kawasaki Ninja 250R Forum - Custom vinyl decals - Southern California camping forum

                          Comment


                          • #14
                            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.
                            Andy Knifel

                            Comment


                            • #15
                              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.
                              Andy Knifel

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X