Announcement

Collapse
No announcement yet.

Accidently set Cookietimeout to 0

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

  • Accidently set Cookietimeout to 0

    One of my admins set the cookie timeout to 0 in the Admin control panel options. Now no one can login to even fix the problem. I have speant an hour or so searching code, and the best thing I can find is this variable $cookeitimeout, but I cant find where it is declared. Does anyone know? Or possibly know a way for me to fix my problem? Thanks!

  • #2
    you can edit the mysql database directly using phpmyadmin
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      Okay, where and how exactly do I do this? Is it in the mysql database, or is it a variable set in one of the .php files?

      Comment


      • #4
        Originally posted by Naka
        Okay, where and how exactly do I do this? Is it in the mysql database, or is it a variable set in one of the .php files?
        yes it's in the database

        using phpmyadmin run this query

        Code:
        UPDATE setting SET value='900' WHERE settingid='41';
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment


        • #5
          Okay, I am sorry, I am really new at all this, how exactly do I access phpmyadmin?

          Comment


          • #6
            Originally posted by Naka
            Okay, I am sorry, I am really new at all this, how exactly do I access phpmyadmin?
            http://www.vbulletin.com/forum/showt...threadid=18558

            1. Look to your left frame, and you'll see the name of your mysql databases.
            2. Click on the database name and you'll see the right frame change, showing your databases' tables, how many records, table type (MyISAM) and table size and total database size.
            3. Scroll down further in right frame and you'll see a few functions such as

            - a text area box titled "Run SQL query/queries on database YOURDATABASENAME"
            - 'Or Location of the textfile' with the Browse and GO button
            - View dump (schema) of database which lists the table names in the database in a box and to the right of the box is a few functions labeled as, 'Structure only', 'Structure and data' and 'Data only'
            - below these labels are check boxes with one of them closest to the GO button being, 'Save as file'

            4. enter the above query into the "Run SQL query/queries on database YOURDATABASENAME" text area box and hit the submit button
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment


            • #7
              Okay I did what you said, this is what shows at the top:
              Database vb225 running on 127.0.0.1
              Affected rows: 1

              SQL-query :
              UPDATE setting SET value='900' WHERE settingid='41'


              But it still doesnt appear to be working. Is there something I need to reset after this?

              Comment


              • #8
                can you log in to the normal forums area ?

                try changing to browse using sessions...

                if you can't you can run another query to change to sessions

                Code:
                UPDATE user SET nosessionhash=0 WHERE userid='XX'
                where XX is the userid of your admin a/c
                :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                :: Nginx SPDY SSL - World Flags Demo [video results]
                :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                Comment


                • #9
                  also have you tried cleaning the cookies from your pc, closing all browser windows and trying to log in again ?

                  DO this before you run the above query/change to browse using sessions
                  :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                  :: Nginx SPDY SSL - World Flags Demo [video results]
                  :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                  Comment


                  • #10
                    Affected rows: 0

                    SQL-query :
                    UPDATE user SET nosessionhash=0 WHERE userid='Naka'


                    Nope didnt work. I cleaned the cookies right before, then ran the query. Tried to login as Naka on the regular forum, and no go...

                    Comment


                    • #11
                      Originally posted by Naka
                      Affected rows: 0

                      SQL-query :
                      UPDATE user SET nosessionhash=0 WHERE userid='Naka'


                      Nope didnt work. I cleaned the cookies right before, then ran the query. Tried to login as Naka on the regular forum, and no go...
                      userid is a number not a name
                      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                      :: Nginx SPDY SSL - World Flags Demo [video results]
                      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                      Comment


                      • #12
                        Originally posted by Naka
                        Affected rows: 0

                        SQL-query :
                        UPDATE user SET nosessionhash=0 WHERE userid='Naka'


                        Nope didnt work. I cleaned the cookies right before, then ran the query. Tried to login as Naka on the regular forum, and no go...
                        how did you clean cookies, go to windows/cookies folder find all referenced cookies to your forum and delete them,

                        did you close all browser windows before you cleaned cookies ?
                        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                        :: Nginx SPDY SSL - World Flags Demo [video results]
                        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                        Comment


                        • #13
                          That is how I cleaned them, but no, I didnt close all browser winwdows, does that make a difference?

                          Comment


                          • #14
                            Affected rows: 1

                            SQL-query :
                            UPDATE user SET nosessionhash=0 WHERE userid='1'


                            With cookies gone, still no luck loggin into the forum...

                            Comment


                            • #15
                              Originally posted by Naka
                              That is how I cleaned them, but no, I didnt close all browser winwdows, does that make a difference?
                              yes it does as the browser window still holds a cookie until closed
                              :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                              :: Nginx SPDY SSL - World Flags Demo [video results]
                              :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                              Comment

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