WordPress database error: [Expression #1 of SELECT list is not in GROUP BY…
-
Hi,
I’m running latest PHP + WP and receiving an error:
PHP 7.2.4
WordPress 4.9.5WordPress database error: [Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘your_dbname.h.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
/*NO_SELECT_FOUND_ROWS*/ SELECT SQL_CALC_FOUND_ROWS h.id, h.logger, h.level, h.date, h.message, h.initiator, h.occasionsID, count(t.repeated) AS subsequentOccasions, t.rep, t.repeated, t.occasionsIDType, c1.value AS context_message_key FROM wp_simple_history AS h LEFT OUTER JOIN wp_simple_history_contexts AS c1 ON (c1.history_id = h.id AND c1.key = “_message_key”) INNER JOIN ( SELECT id, IF(@a=occasionsID,@counter:=@counter+1,@counter:=1) AS rep, IF(@counter=1,@groupby:=@groupby+1,@groupby) AS repeated, @a:=occasionsID occasionsIDType FROM wp_simple_history AS h2 # First/inner where WHERE 1 = 1 AND logger IN (“SimpleCommentsLogger”, “SimpleCoreUpdatesLogger”, “SimpleExportLogger”, “SimpleLegacyLogger”, “SimpleLogger”, “SimpleMediaLogger”, “SimpleMenuLogger”, “SimpleOptionsLogger”, “SimplePluginLogger”, “SimplePostLogger”, “SimpleThemeLogger”, “SimpleUserLogger”, “SimpleCategoriesLogger”, “AvailableUpdatesLogger”, “FileEditsLogger”, “PluginUserSwitchingLogger”, “PluginEnableMediaReplaceLogger”, “Plugin_UltimateMembers_Logger”, “Plugin_LimitLoginAttempts”, “Plugin_Redirection”, “Plugin_DuplicatePost”) AND date >= “2018-04-26 00:00:00” ORDER BY id DESC, date DESC ) AS t ON t.id = h.id WHERE # AND DATE >= DATE(NOW()) – INTERVAL 7 DAY # Outer/Second where 1 = 1 GROUP BY repeated ORDER BY id DESC, date DESC LIMIT 0, 1Is this specific to my installation?
Thanks.
- The topic ‘WordPress database error: [Expression #1 of SELECT list is not in GROUP BY…’ is closed to new replies.