• Resolved Lukasz

    (@wpfed)


    Hi,

    I’m running latest PHP + WP and receiving an error:

    PHP 7.2.4
    WordPress 4.9.5

    WordPress 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, 1

    Is this specific to my installation?

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author P?r Thernstr?m

    (@eskapism)

    Hi!

    I have never seen that error before, and I’ve used Simple History on many sites, that have used both MySQL and MariaDB.

    Do you know what version of MySQL you are using?

    Thread Starter Lukasz

    (@wpfed)

    Hi,

    I’m running MySQL 5.7, you think it’s setup in a strange way or just the DB is corrupt?

    Thanks,

    Plugin Author P?r Thernstr?m

    (@eskapism)

    After some research I think this could be because of MySql 5.7. I will try to install that version and see if I get the same error.

    Plugin Author P?r Thernstr?m

    (@eskapism)

    Hi again,
    I just installed a wordpress version on MySQL 5.7.21 with default settings and Simple History seems to work fine. I can see the log and everything.

    Do you get that message every time you try to view the log or do you for example filter or search the log for anything? Any modifications of MySQL that you know you have done?

    Thread Starter Lukasz

    (@wpfed)

    Hi,

    Thanks for all the help, there is something unstable in my DB, investigating further with my host. Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress database error: [Expression #1 of SELECT list is not in GROUP BY…’ is closed to new replies.