2023-10-11 09:20:47 EDT (INFO): 6526a12ee88c49.08455016: Updating database version from 0.0.0 to 2.33.0 (begin).
2023-10-11 09:20:47 EDT (ERROR): Ugh. SQL query error: Table 'thethsu0_tbt2022_micah.wp_abj404_lookup' doesn't exist, SQL: 
/* ------------------ /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql BEGIN ----- */ 

delete from wp_abj404_lookup
where lkup_value in (
    select * from (
	    SELECT DISTINCT lkup_value 
	    FROM wp_abj404_lookup 
	    group by lkup_value 
	    having count(lkup_value) > 1
    ) a
)

/* ------------------ /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql END ----- */ 
, Execution time: 0.02, DB ver: 5.7.43, Variables: Array
(
    [0] => Array
        (
            [max_join_size] => 1000000000
            [sql_big_selects] => 0
        )

)
, PHP version: 7.4.33, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: https://www.thebigthrill.org/wp-admin/plugin-install.php?s=404%2520Solution&tab=search&type=term, Requested URL: /wp-admin/plugins.php?_wpnonce=c4edb7f1e3&action=activate&plugin=404-solution%2F404-solution.php, 
Stored debug messages: 
, 
Trace: #0 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
#1 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DataAccess.php(450): ABJ_404_Solution_DataAccess->queryAndGetResults('\n/* -----------...')
#2 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(75): ABJ_404_Solution_DataAccess->correctDuplicateLookupValues()
#3 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore()
#4 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true)
#5 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true)
#6 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array)
#7 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array)
#8 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions()
#9 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance()
#10 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init()
#11 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/thethsu0/...')
#12 /home/thethsu0/public_html/thebigthrill/wp-admin/includes/plugin.php(2318): include_once('/home/thethsu0/...')
#13 /home/thethsu0/public_html/thebigthrill/wp-admin/includes/plugin.php(663): plugin_sandbox_scrape('404-solution/40...')
#14 /home/thethsu0/public_html/thebigthrill/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.the...', false)
#15 {main}
2023-10-11 09:20:47 EDT (ERROR): Ugh. SQL query error: Table 'thethsu0_tbt2022_micah.wp_abj404_spelling_cache' doesn't exist, SQL: delete from wp_abj404_spelling_cache where matchdata is null or matchdata = '', Execution time: 0, DB ver: 5.7.43, Variables: Array
(
    [0] => Array
        (
            [max_join_size] => 1000000000
            [sql_big_selects] => 0
        )

)
, PHP version: 7.4.33, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: https://www.thebigthrill.org/wp-admin/plugin-install.php?s=404%2520Solution&tab=search&type=term, Requested URL: /wp-admin/plugins.php?_wpnonce=c4edb7f1e3&action=activate&plugin=404-solution%2F404-solution.php, 
Stored debug messages: 
, 
Trace: #0 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
#1 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(88): ABJ_404_Solution_DataAccess->queryAndGetResults('delete from wp_...')
#2 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(77): ABJ_404_Solution_DatabaseUpgradesEtc->correctMatchData()
#3 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore()
#4 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true)
#5 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true)
#6 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array)
#7 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array)
#8 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions()
#9 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance()
#10 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init()
#11 /home/thethsu0/public_html/thebigthrill/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/thethsu0/...')
#12 /home/thethsu0/public_html/thebigthrill/wp-admin/includes/plugin.php(2318): include_once('/home/thethsu0/...')
#13 /home/thethsu0/public_html/thebigthrill/wp-admin/includes/plugin.php(663): plugin_sandbox_scrape('404-solution/40...')
#14 /home/thethsu0/public_html/thebigthrill/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.the...', false)
#15 {main}
2023-10-11 09:20:47 EDT (INFO): Updating collation from latin1_swedish_ci to utf8mb4_unicode_ci
2023-10-11 09:20:47 EDT (INFO): I succesfully changed the collation of wp_abj404_redirects to utf8mb4_unicode_ci
2023-10-11 09:20:47 EDT (INFO): I succesfully changed the collation of wp_abj404_logsv2 to utf8mb4_unicode_ci
2023-10-11 09:20:48 EDT (INFO): I succesfully changed the collation of wp_abj404_lookup to utf8mb4_unicode_ci
2023-10-11 09:20:48 EDT (INFO): I succesfully changed the collation of wp_abj404_permalink_cache to utf8mb4_unicode_ci
2023-10-11 09:20:48 EDT (INFO): I succesfully changed the collation of wp_abj404_spelling_cache to utf8mb4_unicode_ci
2023-10-11 09:20:48 EDT (INFO): Updating wp_abj404_lookup to InnoDB.
2023-10-11 09:20:48 EDT (INFO): I changed an engine: alter table `wp_abj404_lookup` engine = InnoDB;
2023-10-11 09:20:48 EDT (INFO): Updating wp_abj404_permalink_cache to InnoDB.
2023-10-11 09:20:48 EDT (INFO): I changed an engine: alter table `wp_abj404_permalink_cache` engine = InnoDB;
2023-10-11 09:20:48 EDT (INFO): Updating wp_abj404_redirects to InnoDB.
2023-10-11 09:20:49 EDT (INFO): I changed an engine: alter table `wp_abj404_redirects` engine = InnoDB;
2023-10-11 09:20:49 EDT (INFO): Updating wp_abj404_spelling_cache to InnoDB.
2023-10-11 09:20:49 EDT (INFO): I changed an engine: alter table `wp_abj404_spelling_cache` engine = InnoDB;
2023-10-11 09:20:59 EDT (INFO): 6526a12ee88c49.08455016: Updating database version to 2.33.0 (end).
2023-10-11 09:21:03 EDT (INFO): 6526a12f405be9.11464300: On wp_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
)

2023-10-11 09:21:06 EDT (INFO): I updated a column: alter table wp_abj404_permalink_cache change meta `meta` tinytext not null
2023-10-11 09:21:06 EDT (INFO): No more differences found after updating the wp_abj404_permalink_cache table columns. All is well.
2023-10-11 09:21:06 EDT (INFO): 6526a12f405be9.11464300: On wp_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
)

2023-10-11 09:21:06 EDT (INFO): I updated a column: alter table wp_abj404_spelling_cache change matchdata `matchdata` text not null
2023-10-11 09:21:06 EDT (INFO): No more differences found after updating the wp_abj404_spelling_cache table columns. All is well.
2023-10-11 10:18:20 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-11 16:19:26 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-11 16:19:35 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-11 22:54:49 EDT (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.61MB, Duplicate rows deleted: 0, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false
2023-10-12 04:37:27 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=412
2023-10-12 07:10:02 EDT (INFO): Maybe avoided infite redirects to/from: /?w=144
2023-10-12 22:52:12 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-12 22:55:07 EDT (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: 1.54MB, Duplicate rows deleted: 0, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false
2023-10-13 22:54:57 EDT (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: 2.13MB, Duplicate rows deleted: 0, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false
2023-10-14 14:30:32 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-14 14:54:15 EDT (INFO): Maybe avoided infite redirects to/from: /?tag=thbith-20
2023-10-14 22:06:07 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-14 22:55:08 EDT (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: 2.51MB, Duplicate rows deleted: 0, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false
2023-10-15 16:03:50 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-15 19:46:24 EDT (INFO): Maybe avoided infite redirects to/from: /?tag=thbith-20
2023-10-15 20:31:34 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-15 22:54:54 EDT (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: 2.89MB, Duplicate rows deleted: 1, Debug file size limited: false, Admin email notification option turned off., Permlink cache rows updated: 0, User initiated: false
2023-10-16 01:13:24 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273
2023-10-16 02:20:29 EDT (INFO): Maybe avoided infite redirects to/from: /?page_id=26273