-
Notifications
You must be signed in to change notification settings - Fork 46
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Redirection Plugin: Error During Setup #76
Comments
Turns out that plugin showed the following sql statements to run manually:
CREATE TABLE IF NOT EXISTS CREATE TABLE IF NOT EXISTS CREATE TABLE IF NOT EXISTS Of course sqlite doesnt understand it. Using gpt I translated to sqlite sintax, as following:
CREATE TABLE IF NOT EXISTS CREATE TABLE IF NOT EXISTS CREATE TABLE IF NOT EXISTS |
I really like the project. I'm testing it on some business sites, and it works perfectly.
But I am encountering an error while setting up the popular plugin Redirection by John Godley (https://wordpress.org/plugins/redirection/).
The plugin installs and activates without any problems. However, when I proceed with the setup process, I receive the following error message:
Database problem
Failed to perform query "CREATE TABLE IF NOT EXISTS
wp_redirection_items(
idint(11) unsigned NOT NULL AUTO_INCREMENT,
urlmediumtext NOT NULL,
match_urlVARCHAR(2000) DEFAULT NULL,
match_dataTEXT,
regexINT(11) unsigned NOT NULL DEFAULT '0',
positionINT(11) unsigned NOT NULL DEFAULT '0',
last_countINT(10) unsigned NOT NULL DEFAULT '0',
last_accessdatetime NOT NULL DEFAULT '1970-01-01 00:00:00',
group_idINT(11) NOT NULL DEFAULT '0',
statusenum('enabled','disabled') NOT NULL DEFAULT 'enabled',
action_typeVARCHAR(20) NOT NULL,
action_codeINT(11) unsigned NOT NULL,
action_dataMEDIUMTEXT,
match_typeVARCHAR(20) NOT NULL,
titleTEXT, PRIMARY KEY (
id), KEY
url(
url(191)), KEY
status(
status), KEY
regex(
regex), KEY
group_idpos(
group_id,
position), KEY
group(
group_id), KEY
match_url(
match_url(191)) ) DEFAULT CHARACTER SET utf8mb4"
I thought it was a good idea to let you know that while the aim is to make this compatible with all plugins, (apologies if this is already known).
Is there anything I can adjust in my configuration to make this plugin work, or some plugin adjustments is needed?
The text was updated successfully, but these errors were encountered: