Hello,<\/p>\n
I am unable to use Redirection due to a couple errors. I believe this started when I updated to WordPress 5.1.1, and updated Redirection to 4.2.3. I was prompted to up upgrade the Redirection database, which upgraded without issue. However, following this, I am unable to add new redirects, receiving the following error when I attempt to do so:<\/p>\n
Unable to add new redirect (41): Incorrect integer value: ” for column ‘regex’ at row 1<\/p>\n
Plugin: 4.2.3
\nWordPress: 5.1.1 (multi)
\nPHP: 7.2.17
\nBrowser: Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:66.0) Gecko\/20100101 Firefox\/66.0
\nJavaScript: https:\/\/www.website.com\/subsite\/wp-content\/plugins\/redirection\/redirection.js
\nREST API: https:\/\/www.website.com\/subsite\/wp-json\/<\/p>\nError: Unable to add new redirect (41): Incorrect integer value: ” for column ‘regex’ at row 1
\nAction: redirection\/v1\/redirect\/ POST
\nParams: {“id”:0,”url”:”\/source”,”title”:””,”match_data”:{“source”:{“flag_regex”:false,”flag_trailing”:false,”flag_case”:false,”flag_query”:”exact”}},”match_type”:”url”,”action_type”:”url”,”position”:0,”group_id”:1,”action_code”:301,”action_data”:{“url”:”https:\/\/www.website.com\/target”}}
\nCode: 400 Bad Request
\nRaw: {“code”:”redirect”,”message”:”Unable to add new redirect”,”data”:{“status”:400,”error_code”:41,”wpdb”:”Incorrect integer value: ” for column ‘regex’ at row 1″}}<\/p><\/blockquote>\nAccompanied by an error in the server log:<\/p>\n
PHP message: WordPress database error Incorrect integer value: ” for column ‘regex’ at row 1 for query INSERT INTO
wp_5_redirection_items<\/code> (regex<\/code>,match_type<\/code>,url<\/code>,match_url<\/code>,title<\/code>,group_id<\/code>,position<\/code>,action_type<\/code>,action_code<\/code>,action_data<\/code>,status<\/code>) VALUES (”, ‘url’, ‘\/source’, ‘\/source’, ”, ‘1’, ‘3’, ‘url’, ‘301’, ‘https:\/\/www.website.com\/target’, ‘enabled’) made by Red_Item::create” while reading response header from upstream, client: 130.111.28.84, server: www.website.com, request: “POST \/subsite\/wp-json\/redirection\/v1\/redirect\/?_wpnonce=3bb5ca08e7 HTTP\/1.1”, upstream: “fastcgi:\/\/unix:\/var\/run\/php-fpm\/php-fpm.sock:”, host: “www.website.com”, referrer: “https:\/\/www.website.com\/subsite\/wp-admin\/tools.php?page=redirection.php”<\/p><\/blockquote>\nIf I try to uninstall and reinstall the plugin, it will prompt me to complete Redirection setup to finish installation. Trying to “Finish Setup” (setup makes it past initial options & REST API check) produces the following error:<\/p>\n
Database problem<\/p>\n
Failed to perform query “CREATE TABLE IF NOT EXISTS
wp_redirection_items<\/code> (id<\/code> int(11) unsigned NOT NULL AUTO_INCREMENT,url<\/code> mediumtext NOT NULL,match_url<\/code> varchar(2000) DEFAULT NULL,match_data<\/code> text,regex<\/code> int(11) unsigned NOT NULL DEFAULT ‘0’,position<\/code> int(11) unsigned NOT NULL DEFAULT ‘0’,last_count<\/code> int(10) unsigned NOT NULL DEFAULT ‘0’,last_access<\/code> datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,group_id<\/code> int(11) NOT NULL DEFAULT ‘0’,status<\/code> enum(‘enabled’,’disabled’) NOT NULL DEFAULT ‘enabled’,action_type<\/code> varchar(20) NOT NULL,action_code<\/code> int(11) unsigned NOT NULL,action_data<\/code> mediumtext,match_type<\/code> varchar(20) NOT NULL,title<\/code> text, PRIMARY KEY (id<\/code>), KEYurl<\/code> (url<\/code>(191)), KEYstatus<\/code> (status<\/code>), KEYregex<\/code> (regex<\/code>), KEYgroup_idpos<\/code> (group_id<\/code>,position<\/code>), KEYgroup<\/code> (group_id<\/code>), KEYmatch_url<\/code> (match_url<\/code>(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE=utf8_general_ci”<\/p><\/blockquote>\nMessage: Failed to perform query “CREATE TABLE IF NOT EXISTS
wp_redirection_items<\/code> (
\nid<\/code> int(11) unsigned NOT NULL AUTO_INCREMENT,
\nurl<\/code> mediumtext NOT NULL,
\nmatch_url<\/code> varchar(2000) DEFAULT NULL,
\nmatch_data<\/code> text,
\nregex<\/code> int(11) unsigned NOT NULL DEFAULT ‘0’,
\nposition<\/code> int(11) unsigned NOT NULL DEFAULT ‘0’,
\nlast_count<\/code> int(10) unsigned NOT NULL DEFAULT ‘0’,
\nlast_access<\/code> datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
\ngroup_id<\/code> int(11) NOT NULL DEFAULT ‘0’,
\nstatus<\/code> enum(‘enabled’,’disabled’) NOT NULL DEFAULT ‘enabled’,
\naction_type<\/code> varchar(20) NOT NULL,
\naction_code<\/code> int(11) unsigned NOT NULL,
\naction_data<\/code> mediumtext,
\nmatch_type<\/code> varchar(20) NOT NULL,
\ntitle<\/code> text,
\nPRIMARY KEY (id<\/code>),
\nKEYurl<\/code> (url<\/code>(191)),
\nKEYstatus<\/code> (status<\/code>),
\nKEYregex<\/code> (regex<\/code>),
\nKEYgroup_idpos<\/code> (group_id<\/code>,position<\/code>),
\nKEYgroup<\/code> (group_id<\/code>),
\nKEYmatch_url<\/code> (match_url<\/code>(191))
\n) DEFAULT CHARACTER SET utf8mb4 COLLATE=utf8_general_ci”
\nInstalled: –
\nNext: 4.1
\nDebug:<\/p>\nCOLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘utf8mb4’
\nTable “wp_redirection_items” is missing
\nTable “wp_redirection_groups” is missing
\nTable “wp_redirection_logs” is missing
\nTable “wp_redirection_404” is missing
\nStage: create_tables<\/p><\/blockquote>\nIf anyone can offer some tips on solving this issue, it would be much appreciated.<\/p>\n
Thanks,
\nZach<\/p>\n","protected":false},"template":"","class_list":["post-11483631","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11483631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11483631\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=11483631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}