Database Error

Debug info:

tklist5
EWWW IO version: 256.0
WP version: 4.4.1
PHP version: 50531
ewww_image_optimizer_preinit()
ewww_image_optimizer_gallery_support()
ewww_image_optimizer_admin_init()
ewww_image_optimizer_init()
ewww_image_optimizer_cloud_init()
ewww_image_optimizer_exec_init()
ewww_image_optimizer_cron_setup()
ewww_image_optimizer_cron_setup()
ewww_image_optimizer_tool_init()
ewww_image_optimizer_install_tools()
Checking/Installing tools in /home/tklist5/public_html/TKList.us/wp-content/ewww/
wp-content/ewww permissions: 0755
ewww_image_optimizer_install_paths()
CPU architecture: x86_64
generated paths:
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/jpegtran-linux64
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/optipng-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/gifsicle-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/pngquant-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/cwebp-linux864
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
/home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
/home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
/home/tklist5/public_html/TKList.us/wp-content/ewww/pngquant
/home/tklist5/public_html/TKList.us/wp-content/ewww/cwebp
64-bit linux detected while installing tools
ewww_image_optimizer_md5check()
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran-alt: 8e4a09bb04ba001f5f16651ae8594f7f
md5sum verified, binary is intact
ewww_image_optimizer_md5check()
/home/tklist5/public_html/TKList.us/wp-content/ewww/cwebp-alt: 85f681c1ced4e1726b0d4e69c222186d
md5sum verified, binary is intact
Linux/UNIX style OS, checking permissions
ewww_image_optimizer_check_permissions()
permissions for /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran: 0755
permissions ok
ewww_image_optimizer_check_permissions()
permissions for /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle: 0755
permissions ok
ewww_image_optimizer_check_permissions()
permissions for /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng: 0755
permissions ok
ewww_image_optimizer_check_permissions()
permissions for /home/tklist5/public_html/TKList.us/wp-content/ewww/pngquant: 0755
permissions ok
ewww_image_optimizer_check_permissions()
permissions for /home/tklist5/public_html/TKList.us/wp-content/ewww/cwebp: 0755
permissions ok
ewww_image_optimizer_settings_script()
ewww_image_optimizer_bulk_script()
ewww_image_optimizer_aux_images_script()
ewww_image_optimizer_webp_script()
ewww_image_optimizer_notice_utils()
ewww_image_optimizer_exec_check()
disable_functions:
suhosin_blacklist:
ewww_image_optimizer_safemode_check()
safe_mode =
ewww_image_optimizer_path_check()
found /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran, testing…
ewww_image_optimizer_md5check()
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran: 47c39feae0712f2996c61e5ae639b706
md5sum verified, binary is intact
ewww_image_optimizer_mimetype()
testing mimetype: /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: f at file
file: magic file from /etc/magic:/usr/share/misc/magic
file binary found
file command: /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
ewww_image_optimizer_tool_found()
testing case: j at /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran: Independent JPEG Group’s JPEGTRAN, version 9a 19-Jan-2014
optimizer found
found /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng, testing…
ewww_image_optimizer_md5check()
/home/tklist5/public_html/TKList.us/wp-content/ewww/optipng: 31698da4f5ca00b35e910c77acae65bb
md5sum verified, binary is intact
ewww_image_optimizer_mimetype()
testing mimetype: /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: f at file
file: magic file from /etc/magic:/usr/share/misc/magic
file binary found
file command: /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), statically linked, for GNU/Linux 2.6.9, not stripped
ewww_image_optimizer_tool_found()
testing case: o at /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
/home/tklist5/public_html/TKList.us/wp-content/ewww/optipng: OptiPNG version 0.7.5
optimizer found
found /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle, testing…
ewww_image_optimizer_md5check()
/home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle: 40ceed9c36838b5b9ccc505ab224d90f
md5sum verified, binary is intact
ewww_image_optimizer_mimetype()
testing mimetype: /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: f at file
file: magic file from /etc/magic:/usr/share/misc/magic
file binary found
file command: /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), statically linked, for GNU/Linux 2.6.9, not stripped
ewww_image_optimizer_tool_found()
testing case: g at /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
/home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle: LCDF Gifsicle 1.87
optimizer found
using: /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
using: /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
using: /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
defining EWWW_IMAGE_OPTIMIZER_JPEGTRAN
defining EWWW_IMAGE_OPTIMIZER_OPTIPNG
defining EWWW_IMAGE_OPTIMIZER_GIFSICLE
defining EWWW_IMAGE_OPTIMIZER_PNGOUT
defining EWWW_IMAGE_OPTIMIZER_PNGQUANT
defining EWWW_IMAGE_OPTIMIZER_WEBP
ewww_image_optimizer_options()
ABSPATH: /home/tklist5/public_html/TKList.us/
home url: https://tklist.us
site url: https://tklist.us
ewww_image_optimizer_savings()
querying savings for single site
query to be performed: SELECT SUM(orig_size-image_size) FROM wp_ewwwio_images
savings found:
ewww_image_optimizer_install_paths()
CPU architecture: x86_64
generated paths:
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/jpegtran-linux64
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/optipng-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/gifsicle-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/pngquant-linux
/home/tklist5/public_html/TKList.us/wp-content/plugins/ewww-image-optimizer/cwebp-linux864
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
/home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
/home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
/home/tklist5/public_html/TKList.us/wp-content/ewww/pngquant
/home/tklist5/public_html/TKList.us/wp-content/ewww/cwebp
ewww_image_optimizer_tool_found()
testing case: j at /home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran
/home/tklist5/public_html/TKList.us/wp-content/ewww/jpegtran: Independent JPEG Group’s JPEGTRAN, version 9a 19-Jan-2014
optimizer found
ewww_image_optimizer_tool_found()
testing case: o at /home/tklist5/public_html/TKList.us/wp-content/ewww/optipng
/home/tklist5/public_html/TKList.us/wp-content/ewww/optipng: OptiPNG version 0.7.5
optimizer found
ewww_image_optimizer_tool_found()
testing case: g at /home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle
/home/tklist5/public_html/TKList.us/wp-content/ewww/gifsicle: LCDF Gifsicle 1.87
optimizer found
ewww_image_optimizer_safemode_check()
safe_mode =
ewww_image_optimizer_exec_check()
disable_functions:
suhosin_blacklist:
ewww_image_optimizer_gd_support()
GD found, supports:
GD Version: bundled (2.1.0 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPEG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:
ewww_image_optimizer_gmagick_support()
ewww_image_optimizer_imagick_support()
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: i at convert
convert: Version: ImageMagick 6.7.1-7 2012-08-02 Q16 https://www.imagemagick.org
imagemagick found
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: f at file
file: magic file from /etc/magic:/usr/share/misc/magic
file binary found
ewww_image_optimizer_find_binary()
ewww_image_optimizer_tool_found()
testing case: n at nice
nice: 0
nice found
cloud JPG: off
cloud PNG: off
PNG extra compress: off
cloud GIF: off
cloud fast lossy: off
remove metadata: on
lossy JPG: off
lossy PNG: off
bulk delay: 0
optipng level: 2
pngout level: 2
scheduled optimization: off
deferred optimization: off
disable auto-optimization: off
include media library: off
ewww_image_optimizer_get_image_sizes()
Array ( [thumbnail] => Array ( [width] => 150 [height] => 150 ) [medium] => Array ( [width] => 300 [height] => 300 ) [large] => Array ( [width] => 1024 [height] => 1024 ) [tc-grid-full] => Array ( [width] => 1170 [height] => 350 ) [tc-grid] => Array ( [width] => 570 [height] => 350 ) [tc-thumb] => Array ( [width] => 270 [height] => 250 ) [slider-full] => Array ( [width] => 9999 [height] => 500 ) [slider] => Array ( [width] => 1170 [height] => 500 ) [ngfb-richpin] => Array ( [width] => 300 [height] => 300 ) [ngfb-opengraph] => Array ( [width] => 600 [height] => 315 ) [ngfb-tc-summary] => Array ( [width] => 300 [height] => 300 ) [ngfb-tc-lrgimg] => Array ( [width] => 300 [height] => 300 ) [ngfb-schema] => Array ( [width] => 600 [height] => 315 ) [ngfb-pinterest-button] => Array ( [width] => 300 [height] => 300 ) [ngfb-buffer-button] => Array ( [width] => 300 [height] => 300 ) [ngfb-tumblr-button] => Array ( [width] => 300 [height] => 300 ) )
disabled resizes:
thumbnail: optimization=enabled creation=enabled
medium: optimization=enabled creation=enabled
large: optimization=enabled creation=enabled
tc-grid-full: optimization=enabled creation=enabled
tc-grid: optimization=enabled creation=enabled
tc-thumb: optimization=enabled creation=enabled
slider-full: optimization=enabled creation=enabled
slider: optimization=enabled creation=enabled
ngfb-richpin: optimization=enabled creation=enabled
ngfb-opengraph: optimization=enabled creation=enabled
ngfb-tc-summary: optimization=enabled creation=enabled
ngfb-tc-lrgimg: optimization=enabled creation=enabled
ngfb-schema: optimization=enabled creation=enabled
ngfb-pinterest-button: optimization=enabled creation=enabled
ngfb-buffer-button: optimization=enabled creation=enabled
ngfb-tumblr-button: optimization=enabled creation=enabled
skip images smaller than: 0 bytes
skip PNG images larger than: 0 bytes
exclude originals from lossy: off
exclude originals from metadata removal: off
use system binaries: no
jpegtran disabled: no
optipng disabled: no
pngout disabled: yes
gifsicle disabled: no
webp conversion: off
alt webp rewriting: off
jpg2png: off
ewww_image_optimizer_jpg_background()
ewww_image_optimizer_jpg_background()
ewww_image_optimizer_jpg_quality()
png2jpg: off
gif2png: off
max_execution_time: 600

Ok, so the obvious problem is that the ewwwio_images table did not get created in your database. The bigger question is why? But we’ll try a quick fix first, and go from there.
Do a search in the wp_options table for ‘ewww_image_optimizer_version’ and delete that record, then reload the EWWW settings page, and see if it corrects itself (wouldn’t hurt to also manually check to see if the ewwwio_images table is then created).

Hello,
I have the same problem. The error and debug logs are all empty and no error is thrown. I have tried too reset the version of the plugin(as above) but with no success. The fix I got is to copy the table from another site, to clear the records and start it fresh.

Here is the sql code for import if someone is in hurry:

CREATE TABLE IF NOT EXISTSwp_ewwwio_images` (
id mediumint(9) NOT NULL AUTO_INCREMENT,
path text NOT NULL,
image_md5 varchar(55) DEFAULT NULL,
results varchar(55) NOT NULL,
gallery varchar(30) DEFAULT NULL,
image_size int(10) unsigned DEFAULT NULL,
orig_size int(10) unsigned DEFAULT NULL,
UNIQUE KEY id (id),
KEY path_image_size (path(255),image_size)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
`

Thanks for adding that. I’m going to try and dig into this and another db issue later today and generate the exact sql necessary. I’m not sure that it is necessary to hardcode the ENGINE or AUTO_INCREMENT values.

This is the typical SQL that should be run, as WordPress now defaults to utf8mb4 for the default charset:

CREATE TABLE wp_ewwwio_images (
                id mediumint(9) NOT NULL AUTO_INCREMENT,
                path text NOT NULL,
                image_md5 varchar(55),
                results varchar(55) NOT NULL,
                gallery varchar(30),
                image_size int(10) unsigned,
                orig_size int(10) unsigned,
                UNIQUE KEY id (id),
                KEY path_image_size (path(255),image_size)
        ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Make sure you change the ‘wp’ in ‘wp_ewwwio_images’ to match whatever your table prefix is. So if your options table is wp7941_options, then you want to use wp7941_ewwwio_images in the first line of the SQL above.

I’ve just stumbled across something that seems to tie this thread to the other one I’m working on, and that is the fact that WordPress has changed the default charset for MySQL to utf8mb4. In my SQL above, this line may not work:

KEY path_image_size (path(255),image_size)

It may be necessary to change the 255 to 191 like so:

KEY path_image_size (path(191),image_size)

This is because the max column index size is 767 bytes. With utf8, characters could be up to 3 bytes each, and 3×256 = 768, which is one too many bytes, so we used 255 as our column index size. This changed with utf8mb4, where each character can be up to 4 bytes each. Using similar math, 4×192 = 768, which again is one too many, so we use 191. I’m attempting to detect the default charset so we can avoid these issues in the future.

So you can either run the SQL manually, or wait for the next release.

Thanks, update fixed it.