Here is my phpMyAdmin:

http://jerak.gotdns.com/phpmyadmin/

If you just go there and click on a few of the links you'll see whats wrong. Try to open a database. Viewing the properties of the resulting webpages will show you for certain that something is wrong.

Any ideas?

Thanks in advance, guys...

  • Jared
    1. Without more information, my guess is that something is messed up in the server config in that URL arguments aren't being passed correctly. For example, "&" might not be the delimiter.

    2. PMA v2.2.0 is very old... try upgrading to a newer version of phpMyAdmin ?

      I have tried the newest version available as well as the oldest version available... I prefer the older versions anyway, so I thought I'd just leave that one there. But both the latest and oldest versions seem to have the same problem.

      As for the config,

      <?php
      /* $Id: config.inc.php,v 1.33 2001/08/28 17:50:53 loic1 Exp $ */
      
      
      /**
       * phpMyAdmin Configuration File
       *
       * All directives are explained in Documentation.html
       */
      
      
      /**
       * Bookmark Table Structure
       *
       * CREATE TABLE bookmark (
       *  id int(11) DEFAULT '0' NOT NULL auto_increment,
       *  dbase varchar(255) NOT NULL,
       *  user varchar(255) NOT NULL,
       *  label varchar(255) NOT NULL,
       *  query text NOT NULL,
       *  PRIMARY KEY (id)
       * );
       *
       */
      
      
      /**
       * Your phpMyAdmin url
       *
       * Complete the variable below with the full url ie
       *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
       */
      $cfgPmaAbsoluteUri = 'http://jerak.gotdns.com/phpmyadmin/';
      
      
      /**
       * Server(s) configuration
       */
      // The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
      // You can disable a server config entry by setting host to ''.
      $cfgServers[1]['host']          = 'localhost'; // MySQL hostname
      $cfgServers[1]['port']          = '';          // MySQL port - leave blank for default port
      $cfgServers[1]['socket']        = '';          // Path to the socket - leave blank for default socket
      $cfgServers[1]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
      $cfgServers[1]['adv_auth']      = FALSE;       // Use advanced authentication?
      $cfgServers[1]['stduser']       = '';          // MySQL standard user (only needed with advanced auth)
      $cfgServers[1]['stdpass']       = '';          // MySQL standard password (only needed with advanced auth)
      $cfgServers[1]['user']          = 'root';      // MySQL user (only needed with basic auth)
      $cfgServers[1]['password']      = '';          // MySQL password (only needed with basic auth)
      $cfgServers[1]['only_db']       = '';          // If set to a db-name, only this db is accessible
                                                     // It may also be an array of db-names
      $cfgServers[1]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
      $cfgServers[1]['bookmarkdb']    = '';          // Bookmark db - leave blank for no bookmark support
      $cfgServers[1]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support
      
      // If you have more than one server configured, you can set $cfgServerDefault
      // to any one of them to autoconnect to that server when phpMyAdmin is started,
      // or set it to 0 to be given a list of servers without logging in
      // If you have only one server configured, $cfgServerDefault *MUST* be
      // set to that server.
      $cfgServerDefault = 1;                         // Default server (0 = no default server)
      $cfgServer        = '';
      unset($cfgServers[0]);
      
      
      /**
       * Other core phpMyAdmin settings
       */
      $cfgConfirm               = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
      $cfgPersistentConnections = FALSE;  // use persistent connections to MySQL database
      $cfgShowBlob              = FALSE;  // display blob field contents in browse mode
      $cfgProtectBlob		      = TRUE;  // disallow editing of blob fields in edit mode
      $cfgAllowUserDropDatabase = FALSE;  // disallow users to delete their own database
      $cfgShowSQL               = TRUE;   // show SQL queries as run
      $cfgSkipLockedTables      = FALSE;  // mark used tables, make possible to show
                                          // locked tables (since MySQL 3.23.30)
      $cfgMaxRows               = 30;     // maximum number of rows to display in browse mode
      $cfgOrder                 = 'ASC';  // default for 'ORDER BY' clause (valid
                                          // values are 'ASC', 'DESC' or 'SMART' -ie
                                          // descending order for fields of type
                                          // TIME, DATE, DATETIME & TIMESTAMP,
                                          // ascending order else-)
      $cfgOBGzip 		          = TRUE;   // GZIP output buffering
      $cfgGZipDump              = TRUE;   // Allow the use of gzip/bzip compression
      $cfgBZipDump              = TRUE;   // for dump files
      
      
      /**
       * Link to the official MySQL documentation
       * Be sure to include no trailing slash on the path
       */
      $cfgManualBase = 'http://www.mysql.com/documentation/mysql/bychapter';
      
      
      /**
       * Language settings
       */
      // Default language to use, if not browser-defined or user-defined
      $cfgDefaultLang = 'en';
      // Force: always use this language - must be defined in select_lang.inc.php
      // $cfgLang     = 'en';
      // Loads language file
      require('./select_lang.inc.php');
      
      
      /**
       * Customization & design
       */
      $cfgBorder              = 0;            // border width on tables
      $cfgThBgcolor           = '#D3DCE3';    // table header row colour
      $cfgBgcolorOne          = '#CCCCCC';    // table data row colour
      $cfgBgcolorTwo          = '#DDDDDD';    // table data row colour, alternate
      $cfgTextareaCols        = 40;           // textarea size (columns) in edit mode
      $cfgTextareaRows        = 7;            // textarea size (rows) in edit mode
      $cfgLimitChars          = 50;           // max field data length in browse mode
      $cfgModifyDeleteAtLeft  = TRUE;         // show edit/delete links on left side of browse
      $cfgModifyDeleteAtRight = FALSE;        // show edit/delete links on right side of browse
      $cfgLeftWidth           = 150;          // left frame width
      
      
      /**
       * MySQL settings
       */
      // Column types
      $cfgColumnTypes = array(
         'TINYINT',
         'SMALLINT',
         'MEDIUMINT',
         'INT',
         'BIGINT',
         'FLOAT',
         'DOUBLE',
         'DECIMAL',
         'DATE',
         'DATETIME',
         'TIMESTAMP',
         'TIME',
         'YEAR',
         'CHAR',
         'VARCHAR',
         'TINYBLOB',
         'TINYTEXT',
         'TEXT',
         'BLOB',
         'MEDIUMBLOB',
         'MEDIUMTEXT',
         'LONGBLOB',
         'LONGTEXT',
         'ENUM',
         'SET'
      );
      
      // Atributes
      $cfgAttributeTypes = array(
         '',
         'BINARY',
         'UNSIGNED',
         'UNSIGNED ZEROFILL'
      );
      
      // Available functions
      $cfgFunctions = array(
         'ASCII',
         'CHAR',
         'SOUNDEX',
         'ENCRYPT',
         'LCASE',
         'UCASE',
         'NOW',
         'PASSWORD',
         'ENCODE',
         'DECODE',
         'MD5',
         'RAND',
         'LAST_INSERT_ID',
         'COUNT',
         'AVG',
         'SUM',
         'CURDATE',
         'CURTIME',
         'FROM_DAYS',
         'FROM_UNIXTIME',
         'PERIOD_ADD',
         'PERIOD_DIFF',
         'TO_DAYS',
         'UNIX_TIMESTAMP',
         'USER',
         'WEEKDAY'
      );
      
      
      /**
       * Unset magic_quotes_runtime - do not change!
       */
      set_magic_quotes_runtime(0);
      ?>

        Any chance you can upload a php file that has nothing but:

        <?php
        phpinfo();
        ?>

        and post (or PM if you don't want to give out a link) a URL to it?

          Out of curiosity, can you place a .php file inside the /phpmyadmin/ directory that looks like this:

          <?php
          
          if(empty($_POST) && empty($_GET)) {
          
          echo '<form action="' . $_SERVER['PHP_SELF'] . '?get_test=PASS" method="POST">
          <input type="hidden" name="post_test" value="PASS">
          <input type="submit" value="Test">
          </form>';
          
          } else {
          
          print_r($_POST);
          print_r($_GET);
          
          }
          
          ?>

          and post the URL to it?

            At this point, I'm out of ideas. Without seeing the setup in front of me and playing around with it, I haven't the slightest clue as to what's going on.

            It really looked as if phpMyAdmin wasn't retrieving the variables from the GET/POST data... so I thought perhaps there was a LIMIT directive causing Apache/whatever to not pass the GET/POST data on to PHP (I know if you're not careful in setting up PHP w/ IIS, this can happen). But if a test .php script in that same directory can work fine, this must not be the case.

            Sorry... I'm out of ideas!

              Thanks for your help!!!

              Actually to be perfectly honest I just got it. One of the first things I tried to do when I put up phpMyAdmin was create a database. It didn't work. So now I opened up the db_create.php file, and inside was require('./grab_globals.inc.php');

              So I opened that file, and here's what I saw:

              <?php
              /* $Id: grab_globals.inc.php,v 1.7 2001/08/15 15:48:09 loic1 Exp $ */
              
              
              /**
               * This library grabs the names and values of the variables sent or posted to a
               * script in the '$HTTP_*_VARS' arrays and sets simple globals variables from
               * them
               */
              if (!defined('__LIB_GRAB_GLOBALS__')) {
                  define('__LIB_GRAB_GLOBALS__', 1);
              
              if (!empty($HTTP_GET_VARS)) {
                  extract($HTTP_GET_VARS);
              } // end if
              
              if (!empty($HTTP_POST_VARS)) {
                  extract($HTTP_POST_VARS);
              } // end if
              
              if (!empty($HTTP_POST_FILES)) {
                  while (list($name, $value) = each($HTTP_POST_FILES)) {
                      $$name = $value['tmp_name'];
                  }
              } // end if
              
              } // end __LIB_GRAB_GLOBALS__
              ?>

              Here's what it says now:

              <?php
              /* $Id: grab_globals.inc.php,v 1.7 2001/08/15 15:48:09 loic1 Exp $ */
              
              
              /**
               * This library grabs the names and values of the variables sent or posted to a
               * script in the '$HTTP_*_VARS' arrays and sets simple globals variables from
               * them
               */
              if (!defined('__LIB_GRAB_GLOBALS__')) {
                  define('__LIB_GRAB_GLOBALS__', 1);
              
              if (!empty($_GET)) {
                  extract($_GET);
              } // end if
              
              if (!empty($_POST)) {
                  extract($_POST);
              } // end if
              
              if (!empty($_FILES)) {
                  while (list($name, $value) = each($_FILES)) {
                      $$name = $value['tmp_name'];
                  }
              } // end if
              
              } // end __LIB_GRAB_GLOBALS__
              ?>

              So thanks very much for your help!!!

              • Jared

                This is why I had suggested using a newer version... I'm surprised they didn't work - the newer ones should be more portable and not use those deprecated $HTTPVARS variables... shrug*

                Glad you got it working!

                  As far as I know even the latest version still uses HTTP_BLAH_VARS.. So I can see your point, that is strange! But oh well, it works now so I'm happy. 😃 Unfortunately now I've got to go to bed, so I haven't gotten any work done today... haha.

                  • Jared
                    Write a Reply...