On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • Hi

    As I struggled to solve an http 500 error on the manager login page after upgrading from 2.6.5 to 2.7.0, I went into the database and stumbled upon warning after warning.

    I found the same warning in the database of a fresh 2.7.0 installation.

    Here it is
    Warning in ./libraries/sql.lib.php#613
     count(): Parameter must be an array or an object that implements Countable
    
    Backtrace
    
    ./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
    ./libraries/sql.lib.php#2079: PMA_executeQueryAndGetQueryResponse(
    array,
    boolean true,
    string 'socialworkerlabdb',
    string 'modx_access_category',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `modx_access_category`',
    NULL,
    NULL,
    )
    ./sql.php#221: PMA_executeQueryAndSendQueryResponse(
    array,
    boolean true,
    string 'socialworkerlabdb',
    string 'modx_access_category',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    string '',
    string './themes/pmahomme/img/',
    NULL,
    NULL,
    NULL,
    string 'SELECT * FROM `modx_access_category`',
    NULL,
    NULL,
    )
    


    Has anybody else gotten a similar warning message?

    Very strange, as I have never done anything with themes so far. Is that part of the upcoming 'fred'?

    Kind regards

    Ludo

    This question has been answered by markh. See the first response.

    • Quote from: omegerard at Dec 15, 2018, 11:45 AM
      Hi

      As I struggled to solve an http 500 error on the manager login page after upgrading from 2.6.5 to 2.7.0, I went into the database and stumbled upon warning after warning.

      I found the same warning in the database of a fresh 2.7.0 installation.

      Has anybody else gotten a similar warning message?

      Very strange, as I have never done anything with themes so far. Is that part of the upcoming 'fred'?

      Kind regards

      Ludo


      I’m also having this type warning message. Did either of you have luck fixing it?
      • As a matter of fact, I haven't.

        My sites appear to work as expected.

        What kind of sql database are you using: mariadb or mysql?

        Ludo
        • discuss.answer
          Sorry if I'm being daft, but what warning are you referring to?

          The code snippet you posted looks like it may be from a phpmyadmin log. The warning happens in /libraries/sql.lib.php on line 613, which is not part of MODX. So if I'm reading your post correctly, the warning you're seeing is an issue in phpmyadmin, not MODX.
            Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

            Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.
          • You are right.
            It's a phpmyadmin issue.

            Ludo

            Quote from: markh at Jan 08, 2019, 11:58 AM
            Sorry if I'm being daft, but what warning are you referring to?

            The code snippet you posted looks like it may be from a phpmyadmin log. The warning happens in /libraries/sql.lib.php on line 613, which is not part of MODX. So if I'm reading your post correctly, the warning you're seeing is an issue in phpmyadmin, not MODX.