We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Warning message in 2.7.0 database

    • 22197
    • 40 Posts
    omegerard Reply #1, 5 years, 4 months ago
    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.

      • 54676
      • 1 Posts
      kehoe753 Reply #2, 5 years, 3 months ago
      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?
        facetime for android
        • 22197
        • 40 Posts
        omegerard Reply #3, 5 years, 3 months ago
        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
          Mark Hamstra Reply #4, 5 years, 3 months ago
          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.
            • 22197
            • 40 Posts
            omegerard Reply #5, 5 years, 3 months ago
            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.