2023-07-07 10:55:37 PDT (INFO): 64a8519915e701.61567492: Updating database version from 0.0.0 to 2.32.2 (begin). 2023-07-07 10:55:38 PDT (ERROR): Ugh. SQL query error: Table 'watanser_rr.wp_abj404_lookup' doesn't exist, SQL: /* ------------------ /home/watanser/public_html/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/watanser/public_html/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql END ----- */ , Execution time: 0, DB ver: 10.3.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 8.0.29, WP ver: 6.2.2, Plugin ver: 2.32.2, Referrer: https://www.watanserb.com/wp-admin/plugins.php?plugin_status=all&paged=1&s, Requested URL: /wp-admin/plugins.php?action=activate&plugin=404-solution%2F404-solution.php&plugin_status=all&paged=1&s&_wpnonce=86844ca69c, Stored debug messages: , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(450): ABJ_404_Solution_DataAccess->queryAndGetResults('\n/* -----------...') #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(75): ABJ_404_Solution_DataAccess->correctDuplicateLookupValues() #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/watanser/public_html/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/watanser/...') #12 /home/watanser/public_html/wp-admin/includes/plugin.php(2314): include_once('/home/watanser/...') #13 /home/watanser/public_html/wp-admin/includes/plugin.php(661): plugin_sandbox_scrape('404-solution/40...') #14 /home/watanser/public_html/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.wat...', false) #15 {main} 2023-07-07 10:55:38 PDT (ERROR): Ugh. SQL query error: Table 'watanser_rr.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: 10.3.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 8.0.29, WP ver: 6.2.2, Plugin ver: 2.32.2, Referrer: https://www.watanserb.com/wp-admin/plugins.php?plugin_status=all&paged=1&s, Requested URL: /wp-admin/plugins.php?action=activate&plugin=404-solution%2F404-solution.php&plugin_status=all&paged=1&s&_wpnonce=86844ca69c, Stored debug messages: , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(88): ABJ_404_Solution_DataAccess->queryAndGetResults('delete from wp_...') #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(77): ABJ_404_Solution_DatabaseUpgradesEtc->correctMatchData() #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/watanser/public_html/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/watanser/...') #12 /home/watanser/public_html/wp-admin/includes/plugin.php(2314): include_once('/home/watanser/...') #13 /home/watanser/public_html/wp-admin/includes/plugin.php(661): plugin_sandbox_scrape('404-solution/40...') #14 /home/watanser/public_html/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.wat...', false) #15 {main} 2023-07-07 10:56:09 PDT (INFO): 64a8519915e701.61567492: Updating database version to 2.32.2 (end). 2023-10-05 10:52:49 PDT (INFO): 651ef7f10272d2.46675796: Updating database version from 2.32.2 to 2.33.0 (begin). 2023-10-05 10:52:49 PDT (ERROR): Ugh. SQL query error: Table 'watanser_rr19bkp.wp_abj404_lookup' doesn't exist, SQL: /* ------------------ /home/watanser/public_html/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/watanser/public_html/wp-content/plugins/404-solution/includes/sql/correctLookupTableIssue.sql END ----- */ , Execution time: 0, DB ver: 10.3.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: https://www.watanserb.com/wp-admin/plugin-install.php?s=404&tab=search&type=term, Requested URL: /wp-admin/plugins.php?_wpnonce=e7159d35c4&action=activate&plugin=404-solution%2F404-solution.php, Stored debug messages: , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(450): ABJ_404_Solution_DataAccess->queryAndGetResults('\n/* -----------...') #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(75): ABJ_404_Solution_DataAccess->correctDuplicateLookupValues() #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/watanser/public_html/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/watanser/...') #12 /home/watanser/public_html/wp-admin/includes/plugin.php(2318): include_once('/home/watanser/...') #13 /home/watanser/public_html/wp-admin/includes/plugin.php(663): plugin_sandbox_scrape('404-solution/40...') #14 /home/watanser/public_html/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.wat...', false) #15 {main} 2023-10-05 10:52:49 PDT (ERROR): Ugh. SQL query error: Table 'watanser_rr19bkp.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: 10.3.39, Variables: Array ( [0] => Array ( [max_join_size] => 18446744073709551615 [sql_big_selects] => 1 ) ) , PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: https://www.watanserb.com/wp-admin/plugin-install.php?s=404&tab=search&type=term, Requested URL: /wp-admin/plugins.php?_wpnonce=e7159d35c4&action=activate&plugin=404-solution%2F404-solution.php, Stored debug messages: , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(243): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(88): ABJ_404_Solution_DataAccess->queryAndGetResults('delete from wp_...') #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(77): ABJ_404_Solution_DatabaseUpgradesEtc->correctMatchData() #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(51): ABJ_404_Solution_DatabaseUpgradesEtc->correctIssuesBefore() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DatabaseUpgradesEtc.php(41): ABJ_404_Solution_DatabaseUpgradesEtc->reallyCreateDatabaseTables(true) #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(497): ABJ_404_Solution_DatabaseUpgradesEtc->createDatabaseTables(true) #6 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(457): ABJ_404_Solution_PluginLogic->updateToNewVersionAction(Array) #7 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PluginLogic.php(427): ABJ_404_Solution_PluginLogic->updateToNewVersion(Array) #8 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(27): ABJ_404_Solution_PluginLogic->getOptions() #9 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(43): ABJ_404_Solution_SpellChecker::getInstance() #10 /home/watanser/public_html/wp-content/plugins/404-solution/includes/Loader.php(51): ABJ_404_Solution_SpellChecker::init() #11 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(76): require_once('/home/watanser/...') #12 /home/watanser/public_html/wp-admin/includes/plugin.php(2318): include_once('/home/watanser/...') #13 /home/watanser/public_html/wp-admin/includes/plugin.php(663): plugin_sandbox_scrape('404-solution/40...') #14 /home/watanser/public_html/wp-admin/plugins.php(58): activate_plugin('404-solution/40...', 'https://www.wat...', false) #15 {main} 2023-10-05 10:52:52 PDT (INFO): Updating collation from latin1_swedish_ci to utf8mb4_unicode_ci 2023-10-05 10:52:53 PDT (INFO): I succesfully changed the collation of wp_abj404_redirects to utf8mb4_unicode_ci 2023-10-05 10:52:53 PDT (INFO): I succesfully changed the collation of wp_abj404_logsv2 to utf8mb4_unicode_ci 2023-10-05 10:52:54 PDT (INFO): I succesfully changed the collation of wp_abj404_lookup to utf8mb4_unicode_ci 2023-10-05 10:52:55 PDT (INFO): I succesfully changed the collation of wp_abj404_permalink_cache to utf8mb4_unicode_ci 2023-10-05 10:52:55 PDT (INFO): I succesfully changed the collation of wp_abj404_spelling_cache to utf8mb4_unicode_ci 2023-10-05 10:53:10 PDT (INFO): 651ef7f10272d2.46675796: Updating database version to 2.33.0 (end). 2023-10-05 10:53:17 PDT (INFO): 651ef7f1654725.43403624: 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-05 10:53:25 PDT (INFO): I updated a column: alter table wp_abj404_permalink_cache change meta `meta` tinytext not null 2023-10-05 10:53:25 PDT (INFO): No more differences found after updating the wp_abj404_permalink_cache table columns. All is well. 2023-10-05 10:53:25 PDT (INFO): 651ef7f1654725.43403624: 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-05 10:53:26 PDT (INFO): I updated a column: alter table wp_abj404_spelling_cache change matchdata `matchdata` text not null 2023-10-05 10:53:26 PDT (INFO): No more differences found after updating the wp_abj404_spelling_cache table columns. All is well. 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('story_type/\xD9\x82\xD8\xB5...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('story_type/\xD9\x82\xD8\xB5...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: "Cleared after regex pattern to ignore.", mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /story_type/%d9%82%d8%b5%d8%b5-%d8%a5%d8%ae%d8%a8%d8%a7%d8%b1%d9%8a%d8%a9/feed/, Stored debug messages: 2023-10-05 10:57:18 PDT (DEBUG): Processing 404 for URL: /story_type/قصص-إخبارية/feed/ | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: https://www.watanserb.com/|4, HTTP_USER_AGENT: UniversalFeedParser/5.2.1 +https://code.google.com/p/feedparser/, REMOTE_ADDR: 2001:1470:ff80:3uq8dg9g6ss0, REQUEST_URI: /story_type/قصص-إخبارية/feed/ 2023-10-05 10:57:18 PDT (DEBUG): No posts or pages matching slug: feed 2023-10-05 10:58:25 PDT (DEBUG): Slow query (66.81 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('2019/11/23/\xD8\xA3\xD9\x86...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('2019/11/23/\xD8\xA3\xD9\x86...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: "Cleared after regex pattern to ignore.", mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /2019/11/23/%D8%A3%D9%86%D9%88%D8%B1-%D9%82%D8%B1%D9%82%D8%A7%D8%B4-%D8%A8%D8%A8%D8%BA%D8%A7%D8%A1-%D8%A7%D8%A8%D9%86-%D8%B2%D8%A7%D9%8A%D8%AF-%D9%8A%D8%B3%D8%AA%D9%86%D9%81%D8%B1-%D8%AF%D9%81%D8%A7%D8%B9/pgdz168.net, Stored debug messages: 2023-10-05 10:57:11 PDT (DEBUG): Processing 404 for URL: /2019/11/23/أنور-قرقاش-ببغاء-ابن-زايد-يستنفر-دفاع/pgdz168.net | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: https://www.watanserb.com/|4, HTTP_USER_AGENT: Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html), REMOTE_ADDR: 185.191.171.v1ouqr6cggc0, REQUEST_URI: /2019/11/23/أنور-قرقاش-ببغاء-ابن-زايد-يستنفر-دفاع/pgdz168.net 2023-10-05 10:57:11 PDT (DEBUG): No posts or pages matching slug: pgdz168.net 2023-10-05 10:58:25 PDT (DEBUG): Slow query (74.32 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('2022/07/07/\xD9\x85\xD9\x81...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('2022/07/07/\xD9\x85\xD9\x81...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: "Cleared after regex pattern to ignore.", mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /2022/07/07/%D9%85%D9%81%D8%A7%D8%AC%D8%A3%D8%A9-%D8%BA%D9%8A%D8%B1-%D9%85%D8%AA%D9%88%D9%82%D8%B9%D8%A9-%D8%A3%D9%83%D8%A8%D8%B1-%D8%A7%D9%86%D8%AE%D9%81%D8%A7%D8%B6/ag-zhenren.org, Stored debug messages: 2023-10-05 10:56:16 PDT (DEBUG): Processing 404 for URL: /2022/07/07/مفاجأة-غير-متوقعة-أكبر-انخفاض/ag-zhenren.org | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: https://www.watanserb.com/|4, HTTP_USER_AGENT: Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html), REMOTE_ADDR: 185.191.171.7cpf47siqss0, REQUEST_URI: /2022/07/07/مفاجأة-غير-متوقعة-أكبر-انخفاض/ag-zhenren.org 2023-10-05 10:56:16 PDT (DEBUG): No posts or pages matching slug: ag-zhenren.org 2023-10-05 10:58:25 PDT (DEBUG): Slow query (128.77 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('2022/07/07/\xD9\x85\xD9\x81...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('2022/07/07/\xD9\x85\xD9\x81...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: (none), mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /2022/07/07/%D9%85%D9%81%D8%A7%D8%AC%D8%A3%D8%A9-%D8%BA%D9%8A%D8%B1-%D9%85%D8%AA%D9%88%D9%82%D8%B9%D8%A9-%D8%A3%D9%83%D8%A8%D8%B1-%D8%A7%D9%86%D8%AE%D9%81%D8%A7%D8%B6/ag-zhenren.org, Stored debug messages: 2023-10-05 10:55:25 PDT (DEBUG): Processing 404 for URL: /2022/07/07/مفاجأة-غير-متوقعة-أكبر-انخفاض/ag-zhenren.org | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: 0|0, HTTP_USER_AGENT: Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html), REMOTE_ADDR: 185.191.171.7cpf47siqss0, REQUEST_URI: /2022/07/07/مفاجأة-غير-متوقعة-أكبر-انخفاض/ag-zhenren.org 2023-10-05 10:55:25 PDT (DEBUG): No posts or pages matching slug: ag-zhenren.org 2023-10-05 10:58:25 PDT (DEBUG): Slow query (180.15 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('\xD8\xA7\xD9\x84\xD8\xA3\xD8\xAD\xD8\xAF\xD8\xAB.fe...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('\xD8\xA7\xD9\x84\xD8\xA3\xD8\xAD\xD8\xAF\xD8\xAB.fe...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: "Cleared after regex pattern to ignore.", mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /%D8%A7%D9%84%D8%A3%D8%AD%D8%AF%D8%AB.feed, Stored debug messages: 2023-10-05 10:56:06 PDT (DEBUG): Processing 404 for URL: /الأحدث.feed | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: https://www.watanserb.com/|4, HTTP_USER_AGENT: UniversalFeedParser/5.2.1 +https://code.google.com/p/feedparser/, REMOTE_ADDR: 2001:1470:ff80:3uq8dg9g6ss0, REQUEST_URI: /الأحدث.feed 2023-10-05 10:56:06 PDT (DEBUG): No posts or pages matching slug: الأحدث.feed 2023-10-05 10:58:25 PDT (DEBUG): Slow query (138.77 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('2017/06/11/\xD8\xAE\xD8\xAF...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('2017/06/11/\xD8\xAE\xD8\xAF...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: (none), mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /2017/06/11/%D8%AE%D8%AF%D9%8A%D8%AC%D8%A9-%D8%A8%D9%86-%D9%82%D9%86%D8%A9-%D8%AA%D9%8F%D8%AD%D8%B1%D8%AC-%D8%AF%D8%A7%D8%B9%D9%8A%D8%A9-%D8%A3%D8%A8%D9%86%D8%A7%D8%A1-%D8%B2%D8%A7%D9%8A%D8%AF-%D9%88%D8%B3/agzr.org, Stored debug messages: 2023-10-05 10:53:42 PDT (DEBUG): Processing 404 for URL: /2017/06/11/خديجة-بن-قنة-تُحرج-داعية-أبناء-زايد-وس/agzr.org | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: 0|0, HTTP_USER_AGENT: Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html), REMOTE_ADDR: 85.208.96.44r7n49p2ns0, REQUEST_URI: /2017/06/11/خديجة-بن-قنة-تُحرج-داعية-أبناء-زايد-وس/agzr.org 2023-10-05 10:53:42 PDT (DEBUG): No posts or pages matching slug: agzr.org 2023-10-05 10:58:25 PDT (DEBUG): Slow query (282.99 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main} 2023-10-05 10:58:25 PDT (ERROR): ABJ404-SOLUTION Fatal error handler: {"type":1,"message":"Uncaught Exception: Error: Can't find file: /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCacheParentPages.sql in /home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php:400 Stack trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(2022): ABJ_404_Solution_Functions::readFileContents('/home/watanser/...') #1 /home/watanser/public_html/wp-content/plugins/404-solution/includes/PermalinkCache.php(74): ABJ_404_Solution_DataAccess->updatePermalinkCacheParentPages() #2 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(635): ABJ_404_Solution_PermalinkCache->updatePermalinkCache(1) #3 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(396): ABJ_404_Solution_SpellChecker->initializePublishedPostsProvider() #4 /home/watanser/public_html/wp-content/plugins/404-solution/includes/SpellChecker.php(310): ABJ_404_Solution_SpellChecker->findMatchingPosts('2017/06/11/\xD8\xAE\xD8\xAF...', '1', '1') #5 /home/watanser/public_html/wp-content/plugins/404-solution/includes/WordPress_Connector.php(277): ABJ_404_Solution_SpellChecker->getPermalinkUsingSpelling('2017/06/11/\xD8\xAE\xD8\xAF...') #6 /home/watanser/public_html/wp-content/plugins/404-solution/404-solution.php(138): ABJ_404_Solution_WordPress_Connector->process404() #7 /home/watanser/public_html/wp-includes/class-wp-hook.php(310): abj404_404listener('') #8 /home/watanser/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters(NULL, Array) #9 /home/watanser/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/watanser/public_html/wp-includes/template-loader.php(13): do_action('template_redire...') #11 /home/watanser/public_html/wp-blog-header.php(19): require_once('/home/watanser/...') #12 /home/watanser/public_html/index.php(17): require('/home/watanser/...') #13 {main} thrown","file":"/home/watanser/public_html/wp-content/plugins/404-solution/includes/Functions.php","line":400}, Additional info: (none), mbstring: true, PHP version: 8.0.30, WP ver: 6.3.1, Plugin ver: 2.33.0, Referrer: , Requested URL: /2017/06/11/%D8%AE%D8%AF%D9%8A%D8%AC%D8%A9-%D8%A8%D9%86-%D9%82%D9%86%D8%A9-%D8%AA%D9%8F%D8%AD%D8%B1%D8%AC-%D8%AF%D8%A7%D8%B9%D9%8A%D8%A9-%D8%A3%D8%A8%D9%86%D8%A7%D8%A1-%D8%B2%D8%A7%D9%8A%D8%AF-%D9%88%D8%B3/agzr.org, Stored debug messages: 2023-10-05 10:54:32 PDT (DEBUG): Processing 404 for URL: /2017/06/11/خديجة-بن-قنة-تُحرج-داعية-أبناء-زايد-وس/agzr.org | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 90, auto_cats: 1, auto_tags: 1, dest404page: 0|0, HTTP_USER_AGENT: Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html), REMOTE_ADDR: 85.208.96.44r7n49p2ns0, REQUEST_URI: /2017/06/11/خديجة-بن-قنة-تُحرج-داعية-أبناء-زايد-وس/agzr.org 2023-10-05 10:54:32 PDT (DEBUG): No posts or pages matching slug: agzr.org 2023-10-05 10:58:25 PDT (DEBUG): Slow query (232.93 seconds): /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql BEGIN ----- */ insert ignore into wp_abj404_permalink_cache (id, url, meta, post_parent, url_length) /* This selects the permalink for a page ID. */ select subTable.*, length(subTable.url) from ( select wpp.id as id, case when wpp.post_type = 'post' then concat(/* wpo_su.option_value, */ replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( wpo_pls.option_value, '%year%', date_format(wpp.post_date, '%Y')), '%monthnum%', date_format(wpp.post_date, '%m')), '%day%', date_format(wpp.post_date, '%d')), '%hour%', date_format(wpp.post_date, '%HH')), '%minute%', date_format(wpp.post_date, '%i')), '%second%', date_format(wpp.post_date, '%ss')), '%postname%', wpp.post_name), '%pagename%', wpp.post_name), '%post_id%', wpp.id), '%category%', coalesce(category_table.category, '')), '%author%', coalesce(author_table.user_nicename, '')) ) /* pages don't use the permalink structure. */ else concat(concat('/', wpp.post_name), '/') end as url, concat(concat(concat(concat('s:', wpp.post_status), ',t:'), wpp.post_type), ',') as meta, wpp.post_parent as post_parent from wp_posts wpp inner join wp_options wpo_pls on wpo_pls.option_name = 'permalink_structure' inner join wp_options wpo_su on wpo_su.option_name = 'siteurl' /* select the author of a post. */ left outer join ( select wpusers.id, wpusers.user_nicename from wp_users wpusers inner join wp_options wpo on wpo.option_name = 'permalink_structure' /* Only include this subselect if the author is necessary. */ where instr(wpo.option_value, '%author%') > 0 ) author_table on wpp.post_author = author_table.ID /* select the category of a post. */ left outer join ( select wtr.object_id ID, min(wpt.slug) category from wp_term_relationships wtr inner join wp_options wpo on wpo.option_name = 'permalink_structure' inner join wp_term_taxonomy wtt on wtt.term_taxonomy_id = wtr.term_taxonomy_id and wtt.taxonomy = 'category' inner join wp_terms wpt on wpt.term_id = wtt.term_id /* Only include this subselect if the category is necessary. This speeds up the query from .2 to .001 when the category is not used in the permalink structure. */ where instr(wpo.option_value, '%category%') > 0 group by wtr.object_id ) category_table on wpp.ID = category_table.ID where /* only published posts. */ wpp.post_status in ('publish', 'published') ) subTable /* ------------------ /home/watanser/public_html/wp-content/plugins/404-solution/includes/sql/updatePermalinkCache.sql END ----- */ , Trace: #0 /home/watanser/public_html/wp-content/plugins/404-solution/includes/ErrorHandler.php(147): ABJ_404_Solution_Logging->errorMessage('ABJ404-SOLUTION...') #1 [internal function]: ABJ_404_Solution_ErrorHandler::FatalErrorHandler() #2 {main}