vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Forum completely down (https://vborg.vbsupport.ru/showthread.php?t=78049)

ajk 03-13-2005 04:53 PM
Forum completely down
 
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 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 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_ 03-13-2005 09:39 PM
use SSH to restore it


All times are GMT. The time now is 08:22 AM.

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.00982 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete