Database errors

  • Resolved Derek Ryans

    (@derekryans)


    8 years, 7 months ago

    I am getting these two errors:

    WordPress database error: [Table ‘database_name.wp_ewwwio_images’ doesn’t exist]
    DELETE FROM wp_ewwwio_images WHERE image_size > orig_size

    WordPress database error: [Table ‘database_name.wp_ewwwio_images’ doesn’t exist]
    SELECT SUM(orig_size-image_size) FROM wp_ewwwio_images

    I appreciate any help I can get, thanks!

    https://wordpress.org/plugins/ewww-image-optimizer-cloud/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author nosilver4u

    (@nosilver4u)

    8 years, 7 months ago

    Somehow the ewwwio_images table did not get created. See if you can trick the plugin into creating it by removing the ewww_image_optimizer_version record from the wp_options table in your database.

    Thread Starter Derek Ryans

    (@derekryans)

    8 years, 7 months ago

    I went into PHPMyAdmin to look at the database and I actually don’t see ewww_image_optimizer_version in wp_options

    Plugin Author nosilver4u

    (@nosilver4u)

    8 years, 7 months ago

    That’s extra strange then, it is what tells the plugin whether it needs to updated the table schema (or install it in the first place.

    Try deactivating, and reactivating the plugin, and see if it shows up.

    Thread Starter Derek Ryans

    (@derekryans)

    8 years, 7 months ago

    Nope…not there. I have a stupid question…was I suppose to install both the EWWW Image Optimizer AND the Cloud plugin?

    Plugin Author nosilver4u

    (@nosilver4u)

    8 years, 7 months ago

    nope, it will throw a fatal error if you try to activate both. You only need one of them.

    Plugin Author nosilver4u

    (@nosilver4u)

    8 years, 6 months ago

    Check and see if your database has anything in need of repair. That is definitely not normal to be missing both the version option, and the ewwwio table.

    Thread Starter Derek Ryans

    (@derekryans)

    8 years, 6 months ago

    I deleted the plugin and re-installed it. Looks like that fixed the problem. Thanks for all the troubleshooting tips.

    Plugin Author nosilver4u

    (@nosilver4u)

    8 years, 6 months ago

    Glad to hear it!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Database errors’ is closed to new replies.

Tags