esszach's Replies | ww.wp.xz.cn

Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

Forum: Plugins
In reply to: [W3 Total Cache] Disable OPcache within W3TC

Thread Starter esszach
(@esszach)

3 years, 6 months ago

Hi Marko,

Thank you for looking into this and creating the ticket. I appreciate it!

Forum: Plugins
In reply to: [Redirection] Cannot activate Redirection

Thread Starter esszach
(@esszach)

7 years ago

Thank you very much, John! This seems to have fixed it.

Much appreciated,
Zach

Forum: Plugins
In reply to: [Redirection] Cannot activate Redirection
Thread Starter esszach
(@esszach)

7 years, 1 month ago
This seems related –
If I run the CREATE TABLE command in MySQL for the redirection_items table, the regex ‘regex’ is described by the create statement:

regexint(11) unsigned NOT NULL DEFAULT 0,

As this is not set up to allow null values, I’d image this is why I can only add redirects if I include the ‘Regex’ option. Is the create statement I provided correct for the current version of Redirection, or is my DB creating the table improperly?

Thanks,
Zach
- This reply was modified 7 years, 1 month ago by esszach.
Forum: Plugins
In reply to: [Redirection] Cannot activate Redirection
Thread Starter esszach
(@esszach)

7 years, 1 month ago
Hi John,

Thank you for this information. I found where the DB_COLLATE was being changed and modified the file so that the proper value was being used. This fixed my issue upgrading the Redirection database, but has not fixed my issue adding new redirects. Interestingly, I am able to add redirects if I use the “Regex” option, but not otherwise.

The error:
Unable to add new redirect (41): Incorrect integer value: '' for column 'regex' at row 1
```
Plugin: 4.2.3
WordPress: 5.1.1 (multi)
PHP: 7.2.17
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36
JavaScript: https://website.com/wp-content/plugins/redirection/redirection.js
REST API: https://website.com/wp-json/

Error: Unable to add new redirect (41): Incorrect integer value: '' for column 'regex' at row 1
Action: redirection/v1/redirect/ POST
Params: {"id":0,"url":"/testit","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":5,"action_code":301,"action_data":{"url":"http://www.google.com"}}
Code: 400 Bad Request
Raw: {"code":"redirect","message":"Unable to add new redirect","data":{"status":400,"error_code":41,"wpdb":"Incorrect integer value: '' for column 'regex' at row 1"}}
```
I have tried completely removing Redirection, dropping all tables, re-installing it and disabling all other plugins, and it still will not work. Any additional assistance would be much appreciated.

Thanks,
Zach
Forum: Plugins
In reply to: [Redirection] Cannot activate Redirection

Thread Starter esszach
(@esszach)

7 years, 1 month ago

Hi John, thanks for the reply.

Based on your reply, it sounds like I will need to convert my DB to the proper charset. Before I do so – I have another site running on a different server where Redirection is working properly. Their wp-config.php files have the same DB_CHARSET and DB_COLLATE settings, however one server is running MariaDB 5.5 and the other is running MariaDB 10.3. Do you know why I am not having this problem on the MariaDB 5.5 server? If Redirection is causing the Character Set problem, wouldn’t I have the issue on both servers?

Much thanks,
Zach

Forum: Plugins
In reply to: [Redirection] Redirect not working (Expected 301, found 200)
Thread Starter esszach
(@esszach)

7 years, 8 months ago
Fixed… Apparently clearing your cache from the toolbar does not work, had to clear in Settings from WP Dashboard (Using W3TC).
- This reply was modified 7 years, 8 months ago by esszach.

Viewing 6 replies - 1 through 6 (of 6 total)