v4.0.1 multisite errors

Is it correct that you only see these errors once?

We use the dbDelta method to create the table for Admin Columns. The message that you see that the table does not exist, is in fact correct. That’s the way the dbDelta method works to check if a table must be created or updated. They suppress the errors so it won’t be in your log normally unless you overwrite this by using a plugin like Query Monitor for example, which does show you this particular issue. So in this case, you can ignore the error since in my opinion, we use the method correctly and as intended, even though I agree that a table check should be in place and part of the dbDelta method.

About the user meta error, that is indeed not correct. Did you also have this message once during installation/update? Or do you see this message on every request? If so, can you pinpoint in which file this goes wrong so we can check it in our codebase?

Yes it could be that the errors are shown once, we have a lot of blogs though so it becomes quite a long list in the logs (over 4000 lines of errors). We are not using a log-monitoring plugin of some sort, the errors are displayed in the regular server logs.

The full error text per blog is as below:

2020/02/19 11:24:01 [error] 9870#9870: *60496275 FastCGI sent in stderr: "PHP message: WordPress database error Table 'vm2.vm2_183_usermeta' doesn't exist for query SELECT meta_value FROM vm2_183_usermeta WHERE meta_key = 'vm2_183_ac_preferences_layout_order' AND meta_value != '' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, AC\Plugin->install, AC\Plugin->run_updater, AC\Plugin\Updater->parse_updates, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->apply_update, AC\Plugin\Update\V4000->migrate_list_screen_order" while reading response header from upstream, client: 127.0.0.1, server: <server>, request: "POST /wp-admin/admin-ajax.php HTTP/1.0", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "<domain>", referrer: "https://<domain>/wp-admin/edit.php?s=back&post_status=all&post_type=class&action=-1&m=0&paged=1&action2=-1"

and:

2020/02/18 18:35:06 [error] 9870#9870: *60321352 FastCGI sent in stderr: "PHP message: WordPress databas error Table 'vm2_9_admin_columns' already exists for query
                CREATE TABLE vm2_9_admin_columns (
                        id bigint(20) unsigned NOT NULL auto_increment,
                        list_id varchar(20) NOT NULL default '',
                        list_key varchar(100) NOT NULL default '',
                        title varchar(255) NOT NULL default '',
                        columns mediumtext,
                        settings mediumtext,
                        date_created datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
                        date_modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
                        PRIMARY KEY (id),
                        UNIQUE KEY <code>list_id</code> (<code>list_id</code>)
                ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci gemaakt door require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, AC\Plugin->install, AC\Plugin\Installer->install, AC\Plugin\Installer->create_database, dbDelta" while reading response header from upstream, client: 127.0.0.1, server: <server>, request: "POST /wp-admin/admin-ajax.php HTTP/1.0", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "<domain>", referrer: "<referrer>"