Database Error 📋

PDOException
Toggle Vendor Stack Frames

Error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cmdotonline_app.results.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

        $connection $this->_driver->getConnection();
        try {
            $connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY$this->_bufferResults);
            $result $this->_statement->execute($params);
        } finally {
            $connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERYtrue);
        }

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

Could this be caused by using Auto-Tables?

Some of the Table objects in your application were created by instantiating "Cake\ORM\Table" instead of any other specific subclass.

This could be the cause for this exception. Auto-Tables are created for you under the following circumstances:

  • The class for the specified table does not exist.
  • The Table was created with a typo: $this->getTableLocator()->get('Atricles');
  • The class file has a typo in the name or incorrect namespace: class Atricles extends Table
  • The file containing the class has a typo or incorrect casing: Atricles.php
  • The Table was used using associations but the association has a typo: $this->belongsTo('Atricles')
  • The table class resides in a Plugin but no plugin notation was used in the association definition.

Please try correcting the issue for the following table aliases:

  • markets
  • results
  • starline_markets

If you want to customize this error message, create templates/Error/pdo_error.php