Title: Database Error Last modified: August 31, 2016 --- # Database Error * Resolved [TKList](https://wordpress.org/support/users/tklist/) * (@tklist) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/) * [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](http://tklist.us) * [https://wordpress.org/plugins/ewww-image-optimizer/](https://wordpress.org/plugins/ewww-image-optimizer/) Viewing 7 replies - 1 through 7 (of 7 total) * Thread Starter [TKList](https://wordpress.org/support/users/tklist/) * (@tklist) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944721) * 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](http://tklist.us) site url: [http://tklist.us](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](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](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944850) * 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). * [alordiel](https://wordpress.org/support/users/alordiel/) * (@alordiel) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944892) * 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 EXISTS`wp_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](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944902) * 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](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944911) * 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](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944913) * 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. * Thread Starter [TKList](https://wordpress.org/support/users/tklist/) * (@tklist) * [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944914) * Thanks, update fixed it. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Database Error’ is closed to new replies. * ![](https://ps.w.org/ewww-image-optimizer/assets/icon-256x256.png?rev=1582276) * [EWWW Image Optimizer](https://wordpress.org/plugins/ewww-image-optimizer/) * [Frequently Asked Questions](https://wordpress.org/plugins/ewww-image-optimizer/#faq) * [Support Threads](https://wordpress.org/support/plugin/ewww-image-optimizer/) * [Active Topics](https://wordpress.org/support/plugin/ewww-image-optimizer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/ewww-image-optimizer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/ewww-image-optimizer/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * 7 replies * 3 participants * Last reply from: [TKList](https://wordpress.org/support/users/tklist/) * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/database-error-204/#post-6944914) * Status: resolved