Back to ProEvents Support

afrimax55105
afrimax55105

Fresh install into a new October site. Getting a database error attempting either an event list or calendar:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'paca_oct202.radiantweb_generated_dates.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from radiantweb_generated_dates group by grouped_id, event_id order by event_date asc, sttime asc limit 5 offset 0)

/home/pacapower/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php line 664

Type-     PHP Content
Exception-     Illuminate\Database\QueryException

    }

    // If an exception occurs when attempting to run a query, we'll format the error
    // message to include the bindings with SQL, which will make this exception a
    // lot more helpful to the developer instead of just the database's errors.
    catch (Exception $e) {
        throw new QueryException(
            $query, $this->prepareBindings($bindings), $e
        );
    }

    return $result;
}
afrimax55105
afrimax55105

Is anyone able to answer this? Take a guess?

I paid for a plugin that is not working.

Eoler
Eoler

afrimax55105 said: this is incompatible with sql_mode=only_full_group_by

This plugin probably uses SQL syntax that is not compatible with MySQL 5.7+ (out of the box, fallback is configurable): https://stackoverflow.com/questions/23921117/disable-only-full-group-by

dhuunghia6211
dhuunghia6211

afrimax55105 said:

Fresh install into a new October site. Getting a database error attempting either an event list or calendar:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'paca_oct202.radiantweb_generated_dates.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from radiantweb_generated_dates group by grouped_id, event_id order by event_date asc, sttime asc limit 5 offset 0)

/home/pacapower/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php line 664

Type- PHP Content Exception- Illuminate\Database\QueryException

   }

   // If an exception occurs when attempting to run a query, we'll format the error
   // message to include the bindings with SQL, which will make this exception a
   // lot more helpful to the developer instead of just the database's errors.
   catch (Exception $e) {
       throw new QueryException(
           $query, $this->prepareBindings($bindings), $e
       );
   }

   return $result;

}

You need to change the 'strict' value to false in the database configuration in config/database.php.

'connections' => [ ...

'mysql' => [
...
    'strict' => false,
    ...

],

]

1-4 of 4