API tools faq
paste
Advertisement
Guest User

404 Solution Debug Log

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