• Resolved oriver

    (@oriver)


    Hi,

    I’m currently conducting a clean up of the SQL database and was deleting old remnants of a previous plugin; Smush that we used before yourselves, however I’m aware that WPOptimize uses resmush.it. Therefore I just wanted to check before continuing if you use the following:

    meta-key:
    smush-complete
    smush-info
    smush-marked
    smush-stats
    wp-smpro-smush-data

    wp-smush-resize_sizes

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Venkat Raj

    (@webulous)

    Hi @oriver

    Thanks for using our plugin.
    Yes, we use following meta key to store compression data in postmeta table.
    smush-complete
    smush-info
    smush-marked
    smush-stats

    Following are not used:
    wp-smpro-smush-data
    wp-smush-resize_sizes

    Meta value for smush-info always ends with using WP-Optimize

    Meta value for smush-stats will have something like a:5:{s:12:"smushed-with";s:11:"re-smush-it";s:13:"original-size";i:117556;s:12:"smushed-size";i:72925;s:15:"savings-percent";d:37.97;s:10:"sizes-info";a:6:{s:4:"full";a:2:{s:8:"original";i:117556;s:10:"compressed";i:72925;}s:6:"medium";a:2:{s:8:"original";i:9648;s:10:"compressed";i:8275;}s:5:"large";a:2:{s:8:"original";i:47706;s:10:"compressed";i:41647;}s:9:"thumbnail";a:2:{s:8:"original";i:4795;s:10:"compressed";i:4004;}s:12:"medium_large";a:2:{s:8:"original";i:32330;s:10:"compressed";i:28448;}s:9:"1536x1536";a:2:{s:8:"original";i:82451;s:10:"compressed";i:70608;}}}

    Thread Starter oriver

    (@oriver)

    Hi @webulous

    That’s great thank you so much.

    It seems we’re missing “wp-optimize-show_smush_metabox” & “wp-optimize-autosmush” & “skip-smush-setup” which could have been from a previous developer tidying up for us. It seems to all be working, but if this is needed or other rows have been deleted, if we deactivate, delete and reinstall the plugin would it reinstall any missing rows?

    @oriver Yes re-installing the plugin will re-install the missing tables,

    Thread Starter oriver

    (@oriver)

    @bornforphp That’s fantastic, thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL Database Tidy – Smush’ is closed to new replies.