DB Error- Directory Table doesn’t exist

@umeshsingla,

Rapid response = great support- unfortunately, ‘Network Deactivating’, then Reactivating, and even making a few changes to Smush configurations in one or two of the affected sites did NOT seem to work, as the debug log shows the exact same errors.

Did I miss something? What else could I try?

@umeshsingla,
I had previously done a bulk smash on some sites, and manual on others.

I finally attempted to Network Deactivate Smushit before deleting it, but it still remained active all the sites individually! I tried again to Network reactivate/deactivate, then finally just deleted it from cPanel. Next, I reinstalled the plugin and Network Activated it, but checking the debug.log, I now see the error repeated but just on the main site of the network:

WordPress database error Table 'mysite.mydb_smush_dir_images' doesn't exist for query SELECT count(id) FROM mydb_smush_dir_images made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('settings_page_wp-smush'), WP_Hook->do_action, WP_Hook->apply_filters, WpSmushBulkUi->ui, WpSmushBulkUi->smush_page_header, WpSmushitAdmin->setup_global_stats, WpSmushDir->total_stats
[25-Feb-2018 01:12:41 UTC] WordPress database error Table 'mysite.mydb_smush_dir_images' doesn't exist for query SELECT path, image_size, orig_size FROM mydb_smush_dir_images WHERE image_size IS NOT NULL  ORDER BY <code>id</code> LIMIT 0, 1000 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('settings_page_wp-smush'), WP_Hook->do_action, WP_Hook->apply_filters, WpSmushBulkUi->ui, WpSmushBulkUi->smush_page_header, WpSmushitAdmin->setup_global_stats, WpSmushDir->total_stats
[25-Feb-2018 01:12:55 UTC] WordPress database error Can't create table 'mysite.mydb_smush_dir_images' (errno: -1) for query CREATE TABLE mydb_smush_dir_images (
				id mediumint(9) NOT NULL AUTO_INCREMENT,
				path text NOT NULL,
				resize varchar(55),
				lossy varchar(55),
				error varchar(55) DEFAULT NULL,
				image_size int(10) unsigned,
				orig_size int(10) unsigned,
				file_time int(10) unsigned,
				last_scan timestamp DEFAULT '0000-00-00 00:00:00',
				meta text,
				UNIQUE KEY id (id),
				UNIQUE KEY path (path(191)),
				KEY image_size (image_size)
			) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, WpSmush->admin_init, WpSmushDir->create_table, dbDelta

@umeshsingla,

Thanks for asking, had to learn how to first! So I used the plugin Query Monitor and came up with..pretty much the same as above, plus error codes
1146 -Table ‘mysite_mydb_smush_dir_images’ doesn’t exist
& 1005 – Can’t create table ‘,ysite_mydb_smush_dir_images’ (errno: -1).

It also showed the specific queries being run by Smushit as:

17 SELECT meta_value
FROM mmdb_sitemeta
WHERE meta_key = ‘wp-smush-networkwide’
AND site_id = 1

get_network_option()
wp-includes/option.php:1162

Plugin: wp-smushit 1 0.0004
18 SELECT meta_value
FROM mydb_sitemeta
WHERE meta_key = ‘wp-smush-last_settings’
AND site_id = 1

get_network_option()
wp-includes/option.php:1162

Plugin: wp-smushit 1 0.0003
19 SELECT meta_value
FROM mydb_sitemeta
WHERE meta_key = ‘wdev-frash’
AND site_id = 1

get_network_option()
wp-includes/option.php:1162

Plugin: wp-smushit

Any of this help you at all?

Thanks @umeshsingla,

Running SQL Query on CREATE TABLE in phpMyAdmin gets me this in the console window:
—————————————-
SQL query:

CREATE TABLE mydb_smush_dir_images ( id mediumint(9) NOT NULL AUTO_INCREMENT, path text NOT NULL, resize varchar(55), lossy varchar(55), error varchar(55) DEFAULT NULL, image_size int(10) unsigned, orig_size int(10) unsigned, file_time int(10) unsigned, last_scan timestamp DEFAULT ‘0000-00-00 00:00:00’, meta text, UNIQUE KEY id (id), UNIQUE KEY path (path(191)), KEY image_size (image_size) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

MySQL said: Documentation
#1005 – Can’t create table ‘mysite.mydb_smush_dir_images’ (errno: -1) (Details…)
—————————————————————-

Unfortunately, there is no option to expand the ‘(Details…)’ message!!!

However… REquerying the same result from within the console gets me a QUERY FAILED and an ERROR popup with this message:
—————————————-
Static analysis:

2 errors were found during analysis.

Variable name was expected. (near ” ” at position 10)
Unrecognized statement type. (near “SQL” at position 0)

SQL query:

SQL query: CREATE TABLE mydb_smush_dir_images ( id mediumint(9) NOT NULL AUTO_INCREMENT, path text NOT NULL, resize varchar(55), lossy varchar(55), error varchar(55) DEFAULT NULL, image_size int(10) unsigned, orig_size int(10) unsigned, file_time int(10) unsigned, last_scan timestamp DEFAULT ‘0000-00-00 00:00:00’, meta text, UNIQUE KEY id (id), UNIQUE KEY path (path(191)), KEY image_size (image_size) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci MySQL said: Documentation #1005 – Can’t create table ‘mysite.mydb_smush_dir_images’ (errno: -1) (Details…)

MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SQL query:

CREATE TABLE mydb_smush_dir_images ( id mediumint(9) NOT NULL A’ at line 1
Switch to visual builder
Column:
Alias:
————————————–

OK, I got it worked out finally…sorry I should have started my own thread at first, but deeper investigation showed there was already a ghost table- that the db listed as there, but also said it wasnt. So it would not let me create new table…
After I could finally drop the ghost table, in whatever subdomain was giving me the error/problem, then I was able to create it anew.

Yippeee, SMUSH MULTiSITE ACTIVATED!