Source evidence

404 Redirected SQL Syntax Problem

Redirectioner · support · 2015-03-27T09:01:00+00:00

Redirectioner plugin evidence original source source API

complaintsentiment

mediumseverity

0.87relevance

1replies

Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

5 / 25 rows with source links

20.0% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

20 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support

Craig Hesser unresolved

There is an SQL syntax error caused by the SQL upgrade in WP some time ago. An example: [26-Mar-2015 14:26:00 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘status timestamp <= 1393251960 and id not in (select redirect_id from t8wa4beu6_’ at line 1 for query select id from t8wa4beu6_wbz404_redirects where status = 2 status timestamp <= 1393251960 and id not in (select redirect_id from t8wa4beu6_wbz404_logs) made by do_action_ref_array, call_user_func_array, wbz404_cleaningCron This shows up in the error file. Site in question: http://mobi.susanhesser.com/ https://wordpress.org/plugins/404-redirected/ I can confirm that as well – there is a sql syntax error! Everybody could fix it by yourself (until the author fixes it and releases a new version) following these instructutions: # File /includes/functions.php, row ~402 Search…: //Find unused urls $query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " status "; …and replace the row with: //Find unused urls $query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " and "; In short: you should replace the second match for word status with and . This fixes the error in the logs and also makes the corresponding functionality working as set in the settings page!

Commercial Context

Opportunity

search visibility operations

Redirect search visibility assurance for protecting search visibility and structured data quality

Buyer: site owners, SEO consultants, and agencies

Wedge: monitor redirect drift, schema/indexing failures, and client-readable search-impact fixes

Proof Blocked card complete market

Analysis

heuristic-v1

Summary: 404 Redirected SQL Syntax Problem: users show bugs, compatibility, performance pain that may indicate a product gap.

Evidence quote: 404 Redirected SQL Syntax Problem There is an SQL syntax error caused by the SQL upgrade in WP some time ago.

Affected feature: bugs

bugs compatibility performance missing feature

Plugin

API

Redirectioner

1.0K active installs · 189.8K downloads · rating 78.0

301 302 404 page not found redirect

Comments

1 shown

Minister 2015-12-29T15:25:00+00:00

I can confirm that as well – there is a sql syntax error! Everybody could fix it by yourself (until the author fixes it and releases a new version) following these instructutions: # File /includes/functions.php, row ~402 Search…: //Find unused urls $query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " status "; …and replace the row with: //Find unused urls $query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " and "; In short: you should replace the second match for word status with and . This fixes the error in the logs and also makes the corresponding functionality working as set in the settings page!