WordPress.org

Ready to get started?Download WordPress

Forums

Optimize Database after Deleting Revisions
[resolved] PHP Error (3 posts)

  1. ljmac
    Member
    Posted 1 year ago #

    Love the functionality of this plug-in, but I'm getting the following PHP error in my logs:

    [20-Feb-2013 01:42:38 UTC] WordPress database error Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause for query
    SELECT engine, SUM(data_length + index_length) AS size, table_rows
    FROM information_schema.TABLES
    WHERE table_schema = [DB NAME REMOVED]
    AND table_name = 'wp_comments'

    I get this error for every table in my database.

    http://wordpress.org/extend/plugins/rvg-optimize-database/

  2. cageehv
    Member
    Plugin Author

    Posted 1 year ago #

    Hey ljmac,

    I fixed the warning (I hope) in version 2.2.5. which I just released.

    Rolf

  3. ljmac
    Member
    Posted 1 year ago #

    Hi Rolf,

    That was quick! I confirm that this is fixed - thanks!

    Favorited.

    Lee

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.