Comment to 'Database query error when trying to see profiles'
Comment to Database query error when trying to see profiles

  • Hey, and thank you :-).

    This is what it says:

    Query:

    WHERE 1

    Mysql error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 1' at line 1

    Location:

    The error was found in _getDataSqlCounter function in the file /home/eronexue/public_html/inc/classes/BxDolGrid.php at line 419.

    collation_connection:

    utf8mb4_unicode_ci

    Line 419 in the mentioned file says      "$this->_iTotalCount = $this->_getDataSqlCounter($sQuery, $sFilter);"