You have an error in your SQL syntax

Hello

Thank you for the report. Please can you tell me your MariaDB version? I’ll try to make it compatible.

Regards.

Hello,

MariaDB version is:
MariaDB-server-10.0.33-1.el6.x86_64

—–

It is possible to hook or modify, so this plugin load the post/page directly (with modify header status code to 200) instead of redirect?

Thankyou ??

Hello,

Can you try this quick fix?

In the file /plugins/wp-404-auto-redirect-to-similar-post/wp-404-auto-redirect-similar-post.php Line: 491

Find ORDER BY score DESC, post_modified DESC LIMIT 1";

Replace to: ORDER BY score DESC LIMIT 1";

Let me know if it works for you!

Regards.

Hello, still error

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘ORDER BY score DESC LIMIT 1’ at line 4]
SELECT p.ID, if(INSTR(LCASE(p.post_name), ‘windows’), 1, 0) + 0 as score FROM wp_posts AS p WHERE p.post_status = ‘publish’ AND ORDER BY score DESC LIMIT 1

??

Hello,

Okay I’ll setup a MariaDB and see how to fix it!

Thanks for your help!

Regards.

Hello,

I found the fix!

In the plugin file: wp-404-auto-redirect-similar-post.php

Line 467
Find: WHERE p.post_status = 'publish' AND ";
Replace to: WHERE p.post_status = 'publish' ";

Line 470
Find: $sql .= "
Replace to: $sql .= "AND

Line 480
Find: $sql .= '(' . implode(' OR ', $post_types) . ')';
Replace to: $sql .= 'AND (' . implode(' OR ', $post_types) . ')';

I’ll publish the official update soon. Let me know if it works ??

Regards.