This version of MySQL doesn't yet support

  • Resolved Mihail D

    (@memberremember)


    9 years, 6 months ago

    Your MySQL connection id is 199582
    Server version: 5.5.38-0+wheezy1-log (Debian)

    [error] [client 127.0.0.1] WordPress database error This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' for query DELETE FROM prefix_wsal_metadata WHERE occurrence_id IN (SELECT occurrence_id FROM prefix_wsal_occurrences WHERE created_on < 1410670814 ORDER BY created_on ASC LIMIT 2) made by do_action_ref_array, call_user_func_array, WpSecurityAuditLog->CleanUp, call_user_func, WSAL_Loggers_Database->CleanUp, WSAL_DB_OccurrenceQuery->Delete, call_user_func, WSAL_DB_ActiveRecord::DeleteQuery

    What is the minimum MySQL requirements ?

    https://wordpress.org/plugins/wp-security-audit-log/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support robertabela

    (@robert681)

    9 years, 6 months ago

    HI Mihail D,

    We are not sure what this issue is exactly, considering you are running a recent version of MySQL.

    Are you hosting WordPress on a dedicated server or you’re using shared hosting? Can you please give us more information about your setup?

    Looking forward to hearing from you.

    Thread Starter Mihail D

    (@memberremember)

    9 years, 6 months ago

    Dedicated server

    Server version: Apache/2.2.22 (Debian)

    mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.2

    mysqld Ver 5.5.38-0+wheezy1-log for debian-linux-gnu on x86_64 ((Debian))

    previous errors appeared in error logs file each hours after update plugin version. After truncate plugin .._wsal_occurrences + .._wsal_meta tables errors not shown.

    Plugin Support robertabela

    (@robert681)

    9 years, 6 months ago

    HI Mihail,

    Sorry but did not understand your last message.

    Do you mean you no longer get the error after removing the “old” data from the tables? As in is the plugin now working fine?

    Looking forward to hearing from you.

    Thread Starter Mihail D

    (@memberremember)

    9 years, 6 months ago

    robert681, yes – after removing all ‘old’ data errors not appeared and plugin working correctly

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 6 months ago

    OK good to know. Will troubleshoot further the upgrade process. Thank you for all information and glad you are able to use the plugin properly.

    Plugin Author WPWhiteSecurity

    (@wpwhitesecurity)

    9 years, 6 months ago

    Hi Mihail D,

    Please note that this issue has been resolved with the release of version 1.2.9 of this plugin.

    Thanks a lot for reporting the issue and for supporting us.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘This version of MySQL doesn't yet support’ is closed to new replies.

Tags