· 5 years ago · Feb 20, 2020, 10:48 PM
1[gsgatlin@engr-ras-web multisite.eos]$ wp theme update --all
2WordPress database error alter routine command denied to user 'WmultisA'@'%' for routine 'Wmultis.wp_fn_realmedialibrary_childs' for query DROP FUNCTION IF EXISTS wp_fn_realmedialibrary_childs made by require_once('/afs/eos.ncsu.edu/software/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->install, call_user_func, MatthiasWeb\RealMediaLibrary\Activator->createChildQueryFunction
3WordPress database error Access denied for user 'WmultisA'@'%' to database 'Wmultis' for query CREATE FUNCTION wp_fn_realmedialibrary_childs(rootId INT, _useTempChildTableForCheck BOOLEAN) RETURNS varchar(1000) SQL SECURITY INVOKER BEGIN
4 DECLARE sTemp VARCHAR(1000);
5 DECLARE sTempChd VARCHAR(1000);
6 SET sTemp = '$';
7 SET sTempChd = CAST(rootId AS CHAR);
8 SET SESSION group_concat_max_len = 100000;
9 WHILE sTempChd IS NOT NULL DO
10 SET sTemp = CONCAT(sTemp,',',sTempChd);
11 IF _useTempChildTableForCheck IS NULL OR _useTempChildTableForCheck = false THEN
12 SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0;
13 ELSE
14 SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0;
15 END IF;
16 END WHILE;
17 RETURN sTemp;
18 END made by require_once('/afs/eos.ncsu.edu/software/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->install, call_user_func, MatthiasWeb\RealMediaLibrary\Activator->createChildQueryFunction
19WordPress database error execute command denied to user 'WmultisA'@'%' for routine 'Wmultis.wp_fn_realmedialibrary_childs' for query SELECT rmldata.*
20 FROM wp_realmedialibrary_tmp AS rmldata
21 WHERE FIND_IN_SET(id, wp_fn_realmedialibrary_childs(2, true))
22 AND 1=1
23 ORDER BY rmldata.parent, rmldata.ord made by require_once('/afs/eos.ncsu.edu/software/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->install, call_user_func, MatthiasWeb\RealMediaLibrary\Activator->checkChildQuery
24WordPress database error Duplicate key name 'rmlorder' for query ALTER TABLE wp_realmedialibrary_posts ADD UNIQUE KEY `rmlorder` (`attachment`,`isShortcut`) made by require_once('/afs/eos.ncsu.edu/software/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, dbDelta
25Success: Theme already updated.