Getting errors if "ref" column is NULL

Hello janus20,

Thanks for notifying this. Will fix this soon.

same here, just fyi.

We’re getting this issue too. Had our Liquid Web tech people look and it’s an issue with the plugin for sure.

Hi everyone,

Until Mr. Joel will fix this here is a ‘patch’ to it. I am not and do not pretend to be a php coder and do not know if it is ok as from a php programmer perspective but it works for me just fine.

Here are the steps:
1. open wp-content/plugins/404-to-301/public/class-404-to-301-public.php file for editing. Either download file via FTP and edit localy with Notepad++ or look for seqvence of code below if you open it with default text editor from your ftp program.

2. move to line #143 where is following code
$data[‘ref’] = $_SERVER[‘HTTP_REFERER’];

3. modify/edit line of original code from step 2 with following:

// $data['ref'] = $_SERVER['HTTP_REFERER'];
if (!empty($_SERVER['HTTP_REFERER'])) {
	$data['ref'] = $_SERVER['HTTP_REFERER'];
} else {
// if referer value is empty flag it with some custom text in
// order to avoid db insert errors as 'ref' column is declared
// as not NULL.
$data['ref'] = 'N/A - empty referer';
}

*NOte: // means that content of that line will be treat as comment.

I hope that helps.

Wow, thank you so much for taking the time to find a workaround. My errors have stopped now, and there doesn’t appear to be any adverse effects:)

For anyone not understanding this, just replace that one line of code wiht what Janus20 has discovered. That will take care of those pesky server errors until the plugin gets updated.

Always appreciate people like you!

Hi janus20,

Thank you for your solution. That should work perfectly! Sorry for being late to release a fix. It will be fixed within this weekend along with few other improvements.

I appreciate your patience.

These errors are now getting thrown by the server for this plugin.

“WordPress database error Column ‘ua’ cannot be null for query INSERT INTO wp_404_to_301 (date, url, ip, ref, ua) VALUES (‘2015-12-17 15:02:33’, ‘/?author=1’, ‘193.201.227.43’, ‘N/A – empty referer’, NULL) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, _404_To_301_Public->i4t3_redirect_404
[17-Dec-2015 22:14:55 UTC] WordPress database error Column ‘ua’ cannot be null for query INSERT INTO wp_404_to_301 (date, url, ip, ref, ua) VALUES (‘2015-12-17 16:14:55’, ‘173.45.72.98’, ‘N/A – empty referer’, NULL) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array, _404_To_301_Public->i4t3_redirect_404″

Hi gooma2,

Yeah… i have seen it into my side too. You have to do the same for ‘ua’ column as we/you did for ‘ref’ column. Here is the catch:

1. open wp-content/plugins/404-to-301/public/class-404-to-301-public.php file for editing. Either download file via FTP and edit localy with Notepad++ or look for seqvence of code below if you open it with default text editor from your ftp program.

2. move to line #150 where is following code
$data[‘ua’] = $_SERVER[‘HTTP_USER_AGENT’];

3. modify/edit line of original code from step 2 with following:

// $data['ua'] = $_SERVER['HTTP_USER_AGENT'];
if (!empty($_SERVER['HTTP_USER_AGENT'])) {
	$data['ua'] = $_SERVER['HTTP_USER_AGENT'];
} else {
	$data['ua'] = 'N/A - empty user agent! wtf!';
}

kind regards

Thanks again for this!

It’s been enough trying to get AMP’d up for Google News.:)

Hi all,

Sorry for the delay. Could you please update to latest version now and check? Please let me know the feedback. I have fixed few other issues too.

Hi,

I can confirm that it is working on my side. Thank you very much. ( ua, ref and clear logs too )

kind regards