Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#4008 Unable to log back in after session expired

4.1.6
duplicate
None
1
2014-11-21
2013-07-06
Brandon Amaro
No

After I upgraded to the latest version of phpMyAdmin (4.0.4.1), whenever I try to log back in after my session expired, I end up getting this message:

phpMyAdmin - Error

Incorrect format parameter

If it is helpful, my web server is running nginx 1.3.10, php 5.4.10 and mysql 5.5.29. Any help would be greatly appreciated.

Discussion

  • sfBob
    sfBob
    2013-07-30

    Different config, same problem
    phpmyadmin 4.0.4.1
    Apache 2.2.3, PHP 5.2.17, MySQL 5.0.95

     
    Last edit: sfBob 2013-07-30
    • Brandon Amaro
      Brandon Amaro
      2013-07-30

      Upgrading to phpmyadmin 4.0.4.2 didn't solve the problem at all... :(

       
  • I'm getting this as well in 4.0.6.

    You can work around it for now by deleting all the crap out of the URL and logging in there. For example if your PMA installation is at example.com/phpmyadmin/, when you get the session expired message just go back to example.com/phpmyadmin/ and log in.

     
  • Marc Delisle
    Marc Delisle
    2013-11-30

    On which page were you when the timeout occurred?

     
  • Marc Delisle
    Marc Delisle
    2013-12-01

    • status: open --> pending
     
  • This just happened for me after importing a file. (Currently using 4.0.9.) So in other words:

    1. Log into phpmyadmin as normal.
    2. Go to a database, then a table.
    3. Go to the Import page and import something (I was importing a CSV file into an empty table, in case that matters).
    4. Leave phpmyadmin for a while until the session expires.
    5. Click any menu item (e.g. Browse) for another page.
    6. A dialog appears saying "Your session has expired. Please log in again." Click "Log in".
    7. That takes you to the login page, so log in here. (If it helps, my URL here is http://localhost/phpmyadmin/index.php?db=&table=&server=1&target=import.php&token=5e5fefafae78856abf2eb78241fd1734).
    8. This takes you to a page with a large red error box, saying "Incorrect format parameter". Actually, the page also lists all your databases down the side, which seems like a security flaw! The session is invalid (even if the password happens to be correct) so it shouldn't "leak" any information. (My URL here is now http://localhost/phpmyadmin/index.php?target=import.php&token=91baa23ff058e164ee10bd6e74d168ad#PMAURL-0:index.php?db=&table=&server=1&target=import.php&token=91baa23ff058e164ee10bd6e74d168ad)
    9. Click any link again and the session expired dialog appears again.
     
    Last edit: DisgruntledGoat 2013-12-02
  • Brandon Amaro
    Brandon Amaro
    2013-12-09

    This problem is in 4.1.0 as well. I'm getting this error on the SQL page when I run a query after my session expired. I did a little looking in the source code and it appears there's no form field named format in the pop-up edit query window... I think that is what is causing the problem in my case.

     
  • Marc Delisle
    Marc Delisle
    2013-12-10

    • status: pending --> open
     
  • Marc Delisle
    Marc Delisle
    2013-12-10

    Brandon,
    even if there is no "format" form field, import.php should be setting $format to something; however it does not and I think I know why. I just need more details to be able to reproduce the problem, to ensure my fix is correct. Are you opening a pop-up SQL window from the navigation panel? If not, please describe your scenario.

     
    • Brandon Amaro
      Brandon Amaro
      2013-12-10

      I'm using the pop-up SQL window.

       
  • Marc Delisle
    Marc Delisle
    2013-12-10

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-12-10

    Yes, but there are two ways to open it. From where do you open it?

     
    • Brandon Amaro
      Brandon Amaro
      2013-12-10

      I opened it by clicking where it says edit.

       
      Attachments
      • Marc Delisle
        Marc Delisle
        2013-12-10

        Ok, and you can still reproduce this with 4.1.0-rc3 ?

         
  • Marc Delisle
    Marc Delisle
    2013-12-10

    I can reproduce this problem in 4.0.10, but not in 4.1.0-rc3. Marking as resolved until further news.

     
  • Marc Delisle
    Marc Delisle
    2013-12-10

    • summary: Unable to log back in after session expired --> (ok 4.1.0-rc3) Unable to log back in after session expired
    • status: open --> resolved
     
  • Marc Delisle
    Marc Delisle
    2013-12-12

    • Status: resolved --> fixed
     
  • WIZNet
    WIZNet
    2014-02-03

    I'm still having this issue to PMA v4.1.6.

    After leaving pma for a while and returning back with the session expired, I get a message
    "No activity within 3600 seconds; please log in again."

    Hiting log in, inserting username and correct password redirects inside pma but with message "Incorrect format parameter".

    This is not the case for all login attempts, and there are times that after login it redirects to pma database view with no errors.

    PHP Version: 5.4.24
    phpMyAdmin Version information: 4.1.6
    Web Server: nginx/1.4.4
    MySQL Server version: 5.5.36
    Database client version: libmysql - mysqlnd 5.0.10 - 20111026

    PMA url when that happened:
    /phpmyadmin/index.php?target=import.php&token=10c6cea8c0d8332c718df6f13b0fe1a7#PMAURL-0:index.php?db=&table=&server=1&target=import.php&token=10c6cea8c0d8332c718df6f13b0fe1a7

     
  • Marc Delisle
    Marc Delisle
    2014-02-05

    • summary: (ok 4.1.0-rc3) Unable to log back in after session expired --> Unable to log back in after session expired
    • status: fixed --> open
    • assigned_to: Marc Delisle --> nobody
    • Group: 4.0.4 --> 4.1.6
    • Priority: 1 --> 5
     
  • I have same problem.
    Quick Resolving: After logout click on phpMyAdmin sailing boat logo and it will open a new tab and a new session. Login with your credentials and will work.

    Info:
    Database server version: 5.5.35-0ubuntu0.13.10.2 - (Ubuntu)
    Protocol version: 10
    Server charset: UTF-8 Unicode (utf8)
    Apache/2.4.6 (Ubuntu)
    Database client version: libmysql - 5.5.35
    PHP extension: mysqli Documentation

    phpMyAdmin: 4.0.6deb1

     
    Last edit: Leonard Lepadatu 2014-03-10
  • Martin Perez
    Martin Perez
    2014-04-11

    I have the same problem.
    Solution, go to phpmyadmin/index.php page (important clean url) and here login.

     
    • assigned_to: Madhura Jayaratne
     
    • status: open --> duplicate
    • Priority: 5 --> 1