PHP / MySQL Error

Me too. Any update on this, or a fix?

Thanks

Me too, just noticed this in my error_log, once every day.

The error is the SQL lines 401-405 of “404-redirected/includes/functions.php”, reads:

401) //Find unused urls
402) $query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " status ";
403) $query .= "timestamp <= " . $wpdb->escape($then) . " and id not in (";
404) $query .= "select redirect_id from " . $wpdb->prefix . "wbz404_logs";
405) $query .= ")";

that line 402 should read:

$query = "select id from " . $wpdb->prefix . "wbz404_redirects where status = " . $wpdb->escape(WBZ404_AUTO) . " AND ";

I have upgraded to WP 3.5 still get the error(s)

It’s the 404-redirected plugin, we’re running v.1.3.2 which is the latest I think. I just hacked that fix in to the installed copy of the file myself ??

edrandall: implemented your fix – thx. didnt throw an error ??

??

will keep an eye on php logs and report back if problems.

thx ??

Thanks, I’ll give it a try. ??

BTW, I found the line to be changed on line 331 of my functions.php file (Version: 1.2 of the plugin).

Seems to be working, nothing at all in my error_log for 2 days.

The “fix” does seem to prevent errors, but it also removes the 404 Redirected > TOOLS sub-menu in the backend. Any ideas?

Thanks

Edit: I just realized I still had V1.2 installed, therefore the mention above to editing different line numbers. If you apply the suggested fix to V1.3.2, the TOOLS menu doesn’t disappear.

I had the same issue. This fix looks like solved the situation. I will check my error logs in the next days to see if this is finally solved. I’ll be back here if errors come back.
Thank you @edrandall
??