Support » Plugin: EWWW Image Optimizer » Database Error

  • Resolved TKList

    (@tklist)


    [14-Jan-2016 19:58:36 UTC] WordPress database error Table ‘tklist5_tklistuswp1.wp_ewwwio_images’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_ewwwio_images made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/customizr/index.php’), do_action(‘__before_main_wrapper’), call_user_func_array, get_header, locate_template, load_template, require_once(‘/themes/customizr/header.php’), do_action(‘__before_body’), call_user_func_array, TC_header_main->tc_head_display, wp_head, do_action(‘wp_head’), call_user_func_array, NgfbHead->add_header, NgfbHead->get_header_html, NgfbHead->get_header_array, NgfbTwittercard->get_array, NgfbMedia->get_post_images, NgfbMedia->get_featured, NgfbMedia->get_attachment_image_src, image_make_intermediate_size, WP_Image_Editor_GD->save, EWWWIO_GD_Editor->_save, ewww_image_optimizer, ewww_image_optimizer_update_table, W3_Db->insert, W3_DbCache->insert, W3_DbCallUnderlying->insert, W3_Db->insert, W3_DbProcessor->insert, W3_Db->default_insert, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    I keep getting this error. Site: http://tklist.us

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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: http://tklist.us
    site url: http://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 http://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

    Plugin Author nosilver4u

    (@nosilver4u)

    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 ;
    `

    Plugin Author nosilver4u

    (@nosilver4u)

    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.

    Plugin Author nosilver4u

    (@nosilver4u)

    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.

    Plugin Author nosilver4u

    (@nosilver4u)

    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.

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