API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 1st, 2020
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.15 KB | None | 0 0
raw download clone embed print report
  1. Contents of: /home/rentptrititech/public_html/wp-content/plugins/404-solution/temp/abj404_debug.txt:
  2.  
  3. 2020-04-01 11:57:30 EDT (DEBUG): Displaying sub page: abj404_options
  4. 2020-04-01 11:57:34 EDT (DEBUG): Processing 404 for URL: /media/wysiwyg/Vechicle_Operating_Expenses_Web_Save_06.17.2015_1.jpg | Redirect: {"id":0} | is_single(): | is_page(): | is_feed(): | is_trackback(): | is_preview(): | options: auto_redirects: 1, auto_score: 75, auto_cats: 1, auto_tags: 1, dest404page: 0|0, HTTP_USER_AGENT: HubSpot Connect 2.0 (http://dev.hubspot.com/) - contentfilemanagerapiweb-web, REMOTE_ADDR: 54.174.53.186, REQUEST_URI: /media/wysiwyg/Vechicle_Operating_Expenses_Web_Save_06.17.2015_1.jpg
  5. 2020-04-01 11:57:34 EDT (DEBUG): No posts or pages matching slug: Vechicle_Operating_Expenses_Web_Save_06.17.2015_1.jpg
  6. 2020-04-01 11:57:34 EDT (DEBUG): Found 4 likely match IDs.
  7. 2020-04-01 11:57:34 EDT (DEBUG): Logging redirect. Referer: | Current user: | From: /media/wysiwyg/Vechicle_Operating_Expenses_Web_Save_06.17.2015_1.jpg to: 404, Reason: gave up. , Ignore msg(s): , Execution time: 0.24 seconds
  8. 2020-04-01 11:57:39 EDT (DEBUG): Processing request for action: (none)
  9. 2020-04-01 11:57:39 EDT (DEBUG): Displaying sub page: abj404_redirects
  10. 2020-04-01 11:57:39 EDT (DEBUG): maybeUpdateRedirectsForViewHitsTable creating now because the table doesn't exist.
  11. 2020-04-01 11:57:42 EDT (ERROR): Ugh. SQL query error: Table 'wp_abj404_logsv2' is marked as crashed and should be repaired, SQL: create table wp_abj404_logs_hits_temp
  12. (index (requested_url(128)))
  13. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForViewTempTable.sql BEGIN ----- */
  14.  
  15. SELECT requested_url,
  16. MIN(wp_abj404_logsv2.id) AS logsid,
  17. max(wp_abj404_logsv2.timestamp) as last_used,
  18. count(requested_url) as logshits
  19.  
  20. FROM wp_abj404_logsv2
  21.  
  22. inner join wp_abj404_redirects
  23. on wp_abj404_logsv2.requested_url = wp_abj404_redirects.url
  24.  
  25. group by requested_url
  26.  
  27. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForViewTempTable.sql END ----- */
  28. , Execution time: 2.99, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_options&_wpnonce=518c557a47, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects,
  29. Stored debug messages:
  30. ,
  31. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  32. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(855): ABJ_404_Solution_DataAccess->queryAndGetResults('create table wp...', Array)
  33. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  34. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  35. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_redirect...', Array, true, 0, 200)
  36. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1218): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_redirect...', Array)
  37. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1149): ABJ_404_Solution_View->getAdminRedirectsPageTable('abj404_redirect...')
  38. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(106): ABJ_404_Solution_View->echoAdminRedirectsPage()
  39. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_redirect...', '')
  40. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  41. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  42. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  43. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  44. #13 {main}
  45. 2020-04-01 11:57:42 EDT (ERROR): Ugh. SQL query error: Table 'rentptrititech_wp.wp_abj404_logs_hits_temp' doesn't exist, SQL: ALTER TABLE wp_abj404_logs_hits_temp COMMENT '2.988137960434', Execution time: 0, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_options&_wpnonce=518c557a47, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects,
  46. Stored debug messages:
  47. ,
  48. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  49. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(859): ABJ_404_Solution_DataAccess->queryAndGetResults('ALTER TABLE wp_...')
  50. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  51. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  52. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_redirect...', Array, true, 0, 200)
  53. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1218): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_redirect...', Array)
  54. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1149): ABJ_404_Solution_View->getAdminRedirectsPageTable('abj404_redirect...')
  55. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(106): ABJ_404_Solution_View->echoAdminRedirectsPage()
  56. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_redirect...', '')
  57. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  58. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  59. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  60. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  61. #13 {main}
  62. 2020-04-01 11:57:42 EDT (ERROR): Error executing SQL transaction: Table 'rentptrititech_wp.wp_abj404_logs_hits_temp' doesn't exist, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_options&_wpnonce=518c557a47, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects,
  63. Stored debug messages:
  64. ,
  65. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(270): ABJ_404_Solution_Logging->errorMessage('Error executing...')
  66. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(866): ABJ_404_Solution_DataAccess->executeAsTransaction(Array)
  67. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  68. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  69. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_redirect...', Array, true, 0, 200)
  70. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1218): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_redirect...', Array)
  71. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1149): ABJ_404_Solution_View->getAdminRedirectsPageTable('abj404_redirect...')
  72. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(106): ABJ_404_Solution_View->echoAdminRedirectsPage()
  73. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_redirect...', '')
  74. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  75. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  76. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  77. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  78. #13 {main}
  79. 2020-04-01 11:57:42 EDT (ERROR): SQL causing the transaction error: rename table wp_abj404_logs_hits_temp to wp_abj404_logs_hits, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_options&_wpnonce=518c557a47, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects,
  80. Stored debug messages:
  81. ,
  82. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(271): ABJ_404_Solution_Logging->errorMessage('SQL causing the...')
  83. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(866): ABJ_404_Solution_DataAccess->executeAsTransaction(Array)
  84. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  85. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  86. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_redirect...', Array, true, 0, 200)
  87. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1218): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_redirect...', Array)
  88. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1149): ABJ_404_Solution_View->getAdminRedirectsPageTable('abj404_redirect...')
  89. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(106): ABJ_404_Solution_View->echoAdminRedirectsPage()
  90. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_redirect...', '')
  91. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  92. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  93. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  94. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  95. #13 {main}
  96. 2020-04-01 11:57:42 EDT (DEBUG): createRedirectsForViewHitsTable refreshed wp_abj404_logs_hits in 2.988137960434 seconds.
  97. 2020-04-01 11:57:42 EDT (ERROR): Ugh. SQL query error: Table 'rentptrititech_wp.wp_abj404_logs_hits' doesn't exist, SQL: /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql BEGIN ----- */
  98.  
  99. select
  100. wp_abj404_redirects.id,
  101. wp_abj404_redirects.url,
  102. wp_abj404_redirects.status,
  103. (CASE
  104. when wp_abj404_redirects.status = 1 then 'Man'
  105. when wp_abj404_redirects.status = 2 then 'Auto'
  106. when wp_abj404_redirects.status = 6 then 'RegEx'
  107. else 'Unknown'
  108. end) as status_for_view,
  109. wp_abj404_redirects.type,
  110. (CASE
  111. when wp_abj404_redirects.type = 4 then 'External'
  112. when wp_abj404_redirects.type = 2 then 'Category'
  113. when wp_abj404_redirects.type = 3 then 'Tag'
  114. when wp_abj404_redirects.type = 5 then 'Home Page'
  115. when wp_abj404_redirects.type = 1 then
  116. CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
  117. else 'Unknown'
  118. end) as type_for_view,
  119. wp_abj404_redirects.final_dest,
  120. (case
  121. when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
  122. when wp_abj404_redirects.type = 1 then wp_posts.post_title
  123. when wp_abj404_redirects.type = 2 then terms.name
  124. when wp_abj404_redirects.type = 3 then terms.name
  125. when wp_abj404_redirects.type = 5 then wp_options.option_value
  126. else '? Dest Type'
  127. end) as dest_for_view,
  128.  
  129. wp_abj404_redirects.code,
  130. wp_abj404_redirects.timestamp,
  131. wp_posts.id as wp_post_id,
  132.  
  133. logstable.logshits as logshits,
  134. logstable.logsid,
  135. logstable.last_used,
  136.  
  137.  
  138. wp_posts.post_type as wp_post_type
  139.  
  140. from wp_abj404_redirects wp_abj404_redirects
  141.  
  142. LEFT OUTER JOIN wp_posts wp_posts
  143. on wp_abj404_redirects.final_dest = wp_posts.id
  144.  
  145. LEFT OUTER JOIN wp_abj404_logs_hits logstable
  146. on wp_abj404_redirects.url = logstable.requested_url
  147.  
  148.  
  149.  
  150. left outer join wp_terms terms
  151. on wp_abj404_redirects.final_dest = terms.term_id
  152.  
  153. left outer join wp_options wp_options
  154. on wp_options.option_name = 'blogname'
  155.  
  156. where 1 and (status in (1, 2, 6)) and disabled = 0
  157.  
  158. /* no redirects fiter text found
  159. and replace(lower(CONCAT(wp_abj404_redirects.url, '////',
  160. (CASE
  161. when wp_abj404_redirects.status = 1 then 'Man'
  162. when wp_abj404_redirects.status = 2 then 'Auto'
  163. when wp_abj404_redirects.status = 6 then 'RegEx'
  164. else 'Unknown'
  165. end), '////',
  166. (CASE
  167. when wp_abj404_redirects.type = 4 then 'External'
  168. when wp_abj404_redirects.type = 2 then 'Category'
  169. when wp_abj404_redirects.type = 3 then 'Tag'
  170. when wp_abj404_redirects.type = 5 then 'Home Page'
  171. when wp_abj404_redirects.type = 1 then
  172. CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
  173. else 'Unknown'
  174. end), '////',
  175. (case
  176. when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
  177. when wp_abj404_redirects.type = 1 then wp_posts.post_title
  178. when wp_abj404_redirects.type = 2 then terms.name
  179. when wp_abj404_redirects.type = 3 then terms.name
  180. when wp_abj404_redirects.type = 5 then wp_options.option_value
  181. else '? Dest Type'
  182. end), '////',
  183. wp_abj404_redirects.code)
  184. ), ' ', '')
  185. like replace(lower('%%'), ' ', '')
  186. /* */
  187.  
  188. /* no captured 404s filter text found
  189. and replace(lower(wp_abj404_redirects.url), ' ', '') like replace(lower('%%'), ' ', '')
  190. /* */
  191.  
  192. order by last_used DESC
  193.  
  194. limit 0, 200
  195.  
  196. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql END ----- */
  197. , Execution time: 0, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_options&_wpnonce=518c557a47, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects,
  198. Stored debug messages:
  199. ,
  200. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  201. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(675): ABJ_404_Solution_DataAccess->queryAndGetResults('/* ------------...')
  202. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1218): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_redirect...', Array)
  203. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(1149): ABJ_404_Solution_View->getAdminRedirectsPageTable('abj404_redirect...')
  204. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(106): ABJ_404_Solution_View->echoAdminRedirectsPage()
  205. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_redirect...', '')
  206. #6 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  207. #7 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  208. #8 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  209. #9 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  210. #10 {main}
  211. 2020-04-01 11:57:42 EDT (DEBUG): Found 0 rows to display before log data and 0 rows to display after log data for page: abj404_redirects
  212. 2020-04-01 11:57:45 EDT (DEBUG): Processing request for action: (none)
  213. 2020-04-01 11:57:45 EDT (DEBUG): Displaying sub page: abj404_captured
  214. 2020-04-01 11:57:46 EDT (DEBUG): maybeUpdateRedirectsForViewHitsTable creating now because the table doesn't exist.
  215. 2020-04-01 11:57:49 EDT (ERROR): Ugh. SQL query error: Table 'wp_abj404_logsv2' is marked as crashed and should be repaired, SQL: create table wp_abj404_logs_hits_temp
  216. (index (requested_url(128)))
  217. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForViewTempTable.sql BEGIN ----- */
  218.  
  219. SELECT requested_url,
  220. MIN(wp_abj404_logsv2.id) AS logsid,
  221. max(wp_abj404_logsv2.timestamp) as last_used,
  222. count(requested_url) as logshits
  223.  
  224. FROM wp_abj404_logsv2
  225.  
  226. inner join wp_abj404_redirects
  227. on wp_abj404_logsv2.requested_url = wp_abj404_redirects.url
  228.  
  229. group by requested_url
  230.  
  231. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForViewTempTable.sql END ----- */
  232. , Execution time: 3.22, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_captured,
  233. Stored debug messages:
  234. ,
  235. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  236. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(855): ABJ_404_Solution_DataAccess->queryAndGetResults('create table wp...', Array)
  237. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  238. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  239. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_captured', Array, true, 0, 200)
  240. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(934): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_captured', Array)
  241. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(892): ABJ_404_Solution_View->getCapturedURLSPageTable('abj404_captured')
  242. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(108): ABJ_404_Solution_View->echoAdminCapturedURLsPage()
  243. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_captured', '')
  244. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  245. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  246. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  247. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  248. #13 {main}
  249. 2020-04-01 11:57:49 EDT (ERROR): Ugh. SQL query error: Table 'rentptrititech_wp.wp_abj404_logs_hits_temp' doesn't exist, SQL: ALTER TABLE wp_abj404_logs_hits_temp COMMENT '3.2246448993683', Execution time: 0, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_captured,
  250. Stored debug messages:
  251. ,
  252. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  253. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(859): ABJ_404_Solution_DataAccess->queryAndGetResults('ALTER TABLE wp_...')
  254. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  255. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  256. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_captured', Array, true, 0, 200)
  257. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(934): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_captured', Array)
  258. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(892): ABJ_404_Solution_View->getCapturedURLSPageTable('abj404_captured')
  259. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(108): ABJ_404_Solution_View->echoAdminCapturedURLsPage()
  260. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_captured', '')
  261. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  262. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  263. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  264. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  265. #13 {main}
  266. 2020-04-01 11:57:49 EDT (ERROR): Error executing SQL transaction: Table 'rentptrititech_wp.wp_abj404_logs_hits_temp' doesn't exist, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_captured,
  267. Stored debug messages:
  268. ,
  269. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(270): ABJ_404_Solution_Logging->errorMessage('Error executing...')
  270. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(866): ABJ_404_Solution_DataAccess->executeAsTransaction(Array)
  271. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  272. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  273. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_captured', Array, true, 0, 200)
  274. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(934): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_captured', Array)
  275. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(892): ABJ_404_Solution_View->getCapturedURLSPageTable('abj404_captured')
  276. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(108): ABJ_404_Solution_View->echoAdminCapturedURLsPage()
  277. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_captured', '')
  278. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  279. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  280. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  281. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  282. #13 {main}
  283. 2020-04-01 11:57:49 EDT (ERROR): SQL causing the transaction error: rename table wp_abj404_logs_hits_temp to wp_abj404_logs_hits, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_captured,
  284. Stored debug messages:
  285. ,
  286. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(271): ABJ_404_Solution_Logging->errorMessage('SQL causing the...')
  287. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(866): ABJ_404_Solution_DataAccess->executeAsTransaction(Array)
  288. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(838): ABJ_404_Solution_DataAccess->createRedirectsForViewHitsTable()
  289. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(725): ABJ_404_Solution_DataAccess->maybeUpdateRedirectsForViewHitsTable()
  290. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(671): ABJ_404_Solution_DataAccess->getRedirectsForViewQuery('abj404_captured', Array, true, 0, 200)
  291. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(934): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_captured', Array)
  292. #6 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(892): ABJ_404_Solution_View->getCapturedURLSPageTable('abj404_captured')
  293. #7 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(108): ABJ_404_Solution_View->echoAdminCapturedURLsPage()
  294. #8 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_captured', '')
  295. #9 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  296. #10 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  297. #11 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  298. #12 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  299. #13 {main}
  300. 2020-04-01 11:57:49 EDT (DEBUG): createRedirectsForViewHitsTable refreshed wp_abj404_logs_hits in 3.2246448993683 seconds.
  301. 2020-04-01 11:57:49 EDT (ERROR): Ugh. SQL query error: Table 'rentptrititech_wp.wp_abj404_logs_hits' doesn't exist, SQL: /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql BEGIN ----- */
  302.  
  303. select
  304. wp_abj404_redirects.id,
  305. wp_abj404_redirects.url,
  306. wp_abj404_redirects.status,
  307. (CASE
  308. when wp_abj404_redirects.status = 1 then 'Man'
  309. when wp_abj404_redirects.status = 2 then 'Auto'
  310. when wp_abj404_redirects.status = 6 then 'RegEx'
  311. else 'Unknown'
  312. end) as status_for_view,
  313. wp_abj404_redirects.type,
  314. (CASE
  315. when wp_abj404_redirects.type = 4 then 'External'
  316. when wp_abj404_redirects.type = 2 then 'Category'
  317. when wp_abj404_redirects.type = 3 then 'Tag'
  318. when wp_abj404_redirects.type = 5 then 'Home Page'
  319. when wp_abj404_redirects.type = 1 then
  320. CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
  321. else 'Unknown'
  322. end) as type_for_view,
  323. wp_abj404_redirects.final_dest,
  324. (case
  325. when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
  326. when wp_abj404_redirects.type = 1 then wp_posts.post_title
  327. when wp_abj404_redirects.type = 2 then terms.name
  328. when wp_abj404_redirects.type = 3 then terms.name
  329. when wp_abj404_redirects.type = 5 then wp_options.option_value
  330. else '? Dest Type'
  331. end) as dest_for_view,
  332.  
  333. wp_abj404_redirects.code,
  334. wp_abj404_redirects.timestamp,
  335. wp_posts.id as wp_post_id,
  336.  
  337. logstable.logshits as logshits,
  338. logstable.logsid,
  339. logstable.last_used,
  340.  
  341.  
  342. wp_posts.post_type as wp_post_type
  343.  
  344. from wp_abj404_redirects wp_abj404_redirects
  345.  
  346. LEFT OUTER JOIN wp_posts wp_posts
  347. on wp_abj404_redirects.final_dest = wp_posts.id
  348.  
  349. LEFT OUTER JOIN wp_abj404_logs_hits logstable
  350. on wp_abj404_redirects.url = logstable.requested_url
  351.  
  352.  
  353.  
  354. left outer join wp_terms terms
  355. on wp_abj404_redirects.final_dest = terms.term_id
  356.  
  357. left outer join wp_options wp_options
  358. on wp_options.option_name = 'blogname'
  359.  
  360. where 1 and (status in (3)) and disabled = 0
  361.  
  362. /* no redirects fiter text found
  363. and replace(lower(CONCAT(wp_abj404_redirects.url, '////',
  364. (CASE
  365. when wp_abj404_redirects.status = 1 then 'Man'
  366. when wp_abj404_redirects.status = 2 then 'Auto'
  367. when wp_abj404_redirects.status = 6 then 'RegEx'
  368. else 'Unknown'
  369. end), '////',
  370. (CASE
  371. when wp_abj404_redirects.type = 4 then 'External'
  372. when wp_abj404_redirects.type = 2 then 'Category'
  373. when wp_abj404_redirects.type = 3 then 'Tag'
  374. when wp_abj404_redirects.type = 5 then 'Home Page'
  375. when wp_abj404_redirects.type = 1 then
  376. CONCAT(UCASE(LEFT(wp_posts.post_type, 1)), LCASE(SUBSTRING(wp_posts.post_type, 2)))
  377. else 'Unknown'
  378. end), '////',
  379. (case
  380. when wp_abj404_redirects.type = 4 then wp_abj404_redirects.final_dest
  381. when wp_abj404_redirects.type = 1 then wp_posts.post_title
  382. when wp_abj404_redirects.type = 2 then terms.name
  383. when wp_abj404_redirects.type = 3 then terms.name
  384. when wp_abj404_redirects.type = 5 then wp_options.option_value
  385. else '? Dest Type'
  386. end), '////',
  387. wp_abj404_redirects.code)
  388. ), ' ', '')
  389. like replace(lower('%%'), ' ', '')
  390. /* */
  391.  
  392. /* no captured 404s filter text found
  393. and replace(lower(wp_abj404_redirects.url), ' ', '') like replace(lower('%%'), ' ', '')
  394. /* */
  395.  
  396. order by logshits DESC
  397.  
  398. limit 0, 200
  399.  
  400. /* ------------------ /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/sql/getRedirectsForView.sql END ----- */
  401. , Execution time: 0, PHP version: 7.2.29, WP ver: 5.4, Plugin ver: 2.22.5, Referrer: https://rentptr.com/wp-admin/admin.php?page=abj404_solution&subpage=abj404_redirects, Requested URL: /wp-admin/admin.php?page=abj404_solution&subpage=abj404_captured,
  402. Stored debug messages:
  403. ,
  404. Trace: #0 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(194): ABJ_404_Solution_Logging->errorMessage('Ugh. SQL query ...')
  405. #1 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/DataAccess.php(675): ABJ_404_Solution_DataAccess->queryAndGetResults('/* ------------...')
  406. #2 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(934): ABJ_404_Solution_DataAccess->getRedirectsForView('abj404_captured', Array)
  407. #3 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(892): ABJ_404_Solution_View->getCapturedURLSPageTable('abj404_captured')
  408. #4 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(108): ABJ_404_Solution_View->echoAdminCapturedURLsPage()
  409. #5 /home/rentptrititech/public_html/wp-content/plugins/404-solution/includes/View.php(71): ABJ_404_Solution_View->echoChosenAdminTab(NULL, 'abj404_captured', '')
  410. #6 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(287): ABJ_404_Solution_View::handleMainAdminPageActionAndDisplay('')
  411. #7 /home/rentptrititech/public_html/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters('', Array)
  412. #8 /home/rentptrititech/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
  413. #9 /home/rentptrititech/public_html/wp-admin/admin.php(254): do_action('toplevel_page_a...')
  414. #10 {main}
  415. 2020-04-01 11:57:49 EDT (DEBUG): Found 0 rows to display before log data and 0 rows to display after log data for page: abj404_captured
  416. 2020-04-01 11:58:00 EDT (DEBUG): Processing request for action: (none)
  417. 2020-04-01 11:58:00 EDT (DEBUG): Displaying sub page: abj404_options
  418. 2020-04-01 11:58:05 EDT (DEBUG): Processing request for action: (none)
  419. 2020-04-01 11:58:05 EDT (DEBUG): Displaying sub page: abj404_debugfile
  420.  
  421. Contents of: /home/rentptrititech/public_html/wp-content/plugins/404-solution/temp/abj404_debug.txt_old.txt:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!