2022-11-07 00:31:38 GMT+0000 (INFO): 636851ea1c4424.30305671: Updating database version from 0.0.0 to 2.31.3 (begin). 2022-11-07 00:31:38 GMT+0000 (ERROR): Ugh. SQL query error: Table 'sunetulp_wp833.wp7f_abj404_lookup' doesn't exist, SQL: /* ------------------ /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql BEGIN ----- */ delete from wp7f_abj404_lookup where lkup_value in ( select * from ( SELECT DISTINCT lkup_value FROM wp7f_abj404_lookup group by lkup_value having count(lkup_value) > 1 ) a ) /* ------------------ /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql END ----- */ , Execution time: 0, DB ver: 5.7.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 7.4.32, WP ver: 6.1, Plugin ver: 2.31.3, Referrer: https://chifusculpture.ro/wp-admin/network/plugins.php?plugin_status=all&paged=1&s, Requested URL: /wp-admin/network/plugins.php?action=activate&plugin=404-solution%2F404-solution.php&plugin_status=all&paged=1&s&_wpnonce=67fd31fab0, Stored debug messages: , Trace: #0 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DataAccess.php(241): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DataAccess.php(448): ABJ_404_Solution_DataAccess->queryAndGetResults('\n/* -----------...') #2 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(75): ABJ_404_Solution_DataAccess->correctDuplicateLookupValues() #3 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(375): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(335): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(305): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/sunetulp/...') #12 /home/sunetulp/chifusculpture.ro/wp-admin/includes/plugin.php(2314): include_once('/home/sunetulp/...') #13 /home/sunetulp/chifusculpture.ro/wp-admin/includes/plugin.php(661): plugin_sandbox_scrape('404-solution/40...') #14 /home/sunetulp/chifusculpture.ro/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://chifusc...', true) #15 /home/sunetulp/chifusculpture.ro/wp-admin/network/plugins.php(13): require('/home/sunetulp/...') #16 {main} 2022-11-07 00:31:38 GMT+0000 (ERROR): Ugh. SQL query error: Table 'sunetulp_wp833.wp7f_abj404_spelling_cache' doesn't exist, SQL: delete from wp7f_abj404_spelling_cache where matchdata is null or matchdata = '', Execution time: 0, DB ver: 5.7.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 7.4.32, WP ver: 6.1, Plugin ver: 2.31.3, Referrer: https://chifusculpture.ro/wp-admin/network/plugins.php?plugin_status=all&paged=1&s, Requested URL: /wp-admin/network/plugins.php?action=activate&plugin=404-solution%2F404-solution.php&plugin_status=all&paged=1&s&_wpnonce=67fd31fab0, Stored debug messages: , Trace: #0 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DataAccess.php(241): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(88): ABJ_404_Solution_DataAccess->queryAndGetResults('delete from wp7...') #2 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(77): ABJ_404_Solution_DatabaseUpgradesEtc->correctMatchData() #3 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(375): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(335): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/PluginLogic.php(305): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/sunetulp/chifusculpture.ro/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/sunetulp/...') #12 /home/sunetulp/chifusculpture.ro/wp-admin/includes/plugin.php(2314): include_once('/home/sunetulp/...') #13 /home/sunetulp/chifusculpture.ro/wp-admin/includes/plugin.php(661): plugin_sandbox_scrape('404-solution/40...') #14 /home/sunetulp/chifusculpture.ro/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://chifusc...', true) #15 /home/sunetulp/chifusculpture.ro/wp-admin/network/plugins.php(13): require('/home/sunetulp/...') #16 {main} 2022-11-07 00:31:38 GMT+0000 (INFO): Updating collation from utf8_unicode_ci to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): I succesfully changed the collation of wp7f_abj404_redirects to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): I succesfully changed the collation of wp7f_abj404_logsv2 to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): I succesfully changed the collation of wp7f_abj404_lookup to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): I succesfully changed the collation of wp7f_abj404_permalink_cache to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): I succesfully changed the collation of wp7f_abj404_spelling_cache to utf8mb4_unicode_520_ci 2022-11-07 00:31:38 GMT+0000 (INFO): Updating wp7f_abj404_lookup to InnoDB. 2022-11-07 00:31:38 GMT+0000 (INFO): I changed an engine: alter table `wp7f_abj404_lookup` engine = InnoDB; 2022-11-07 00:31:38 GMT+0000 (INFO): Updating wp7f_abj404_permalink_cache to InnoDB. 2022-11-07 00:31:38 GMT+0000 (INFO): I changed an engine: alter table `wp7f_abj404_permalink_cache` engine = InnoDB; 2022-11-07 00:31:38 GMT+0000 (INFO): Updating wp7f_abj404_redirects to InnoDB. 2022-11-07 00:31:38 GMT+0000 (INFO): I changed an engine: alter table `wp7f_abj404_redirects` engine = InnoDB; 2022-11-07 00:31:38 GMT+0000 (INFO): Updating wp7f_abj404_spelling_cache to InnoDB. 2022-11-07 00:31:38 GMT+0000 (INFO): I changed an engine: alter table `wp7f_abj404_spelling_cache` engine = InnoDB; 2022-11-07 00:31:38 GMT+0000 (INFO): 636851ea1c4424.30305671: Updating database version to 2.31.3 (end). 2022-11-07 00:31:39 GMT+0000 (INFO): 636851ea675011.35063226: On wp7f_abj404_permalink_cache I'm updating various columns because we want: `Array ( [0] => `id` bigint not null [1] => `url` varchar(2048) not null [2] => `meta` tinytext not null [3] => `url_length` smallint default null [4] => `post_parent` bigint not null ) but we have: Array ( [0] => `id` bigint not null [1] => `url` varchar(2048) not null [2] => `meta` text not null [3] => `url_length` smallint default null [4] => `post_parent` bigint not null ) 2022-11-07 00:31:39 GMT+0000 (INFO): I updated a column: alter table wp7f_abj404_permalink_cache change meta `meta` tinytext not null 2022-11-07 00:31:39 GMT+0000 (INFO): No more differences found after updating the wp7f_abj404_permalink_cache table columns. All is well. 2022-11-07 00:31:39 GMT+0000 (INFO): 636851ea675011.35063226: On wp7f_abj404_spelling_cache I'm updating various columns because we want: `Array ( [0] => `id` bigint not null auto_increment [1] => `url` varchar(2048) not null [2] => `matchdata` text not null ) but we have: Array ( [0] => `id` bigint not null auto_increment [1] => `url` varchar(2048) not null [2] => `matchdata` mediumtext not null ) 2022-11-07 00:31:39 GMT+0000 (INFO): I updated a column: alter table wp7f_abj404_spelling_cache change matchdata `matchdata` text not null 2022-11-07 00:31:39 GMT+0000 (INFO): No more differences found after updating the wp7f_abj404_spelling_cache table columns. All is well. 2022-11-07 00:31:41 GMT+0000 (INFO): deleteOldRedirectsCron. Old captured URLs removed: 0, Old automatic redirects removed: 0, Old manual redirects removed: 0, Old log lines removed: 0, New log size: 0.01MB, Duplicate rows deleted: 0, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false