CODEWITHSUNDEEP
mysqlperformanceselectmariadb
RICHARD
RICHARD

Reputation: 1

What is the cause of error MariaDB server version for the right syntax to use near

I use latest version wordpress and after save post, admin session end and auto logout from dashboard and cannot login again ...

Error log showing following 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 menu_order ASC' at line 3 SELECT ID FROM wp_posts
                    WHERE post_type = 'attachment'
                    AND ID in ()
                    ORDER BY menu_order ASC quire('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/goodnews/single.php'), mom_single_post_content, mom_single_post_format

Please advise

Thankyou

Upvotes: 0

Views: 638

Answers (1)

Gufus
Gufus

Reputation: 513

The problem is ID IN () You have to specify which values of ID you want to select writing them between brackets (separating them with commas). Otherwise if don't have to put a filter on ID values delete ID IN () from the WHERE.

Upvotes: 1

Related Questions