[Solved] WordPress database error You have an error in your SQL syntax;

Bug Reports

Last Post by copilot 2 years ago

4 Posts

2 Users

2 Reactions

1,303 Views

RSS

Posts: 26

copilot

Topic starter

Mar 20, 2023 5:08 pm

(@copilot)

Eminent Member

Joined: 6 years ago

Hi wpForo team,

When "Show Forum Statistic" (under: /wp-admin/admin.php?page=wpforo-settings&wpf_tab=components)
is enabled, I get the following PHP error:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
                            ORDER BY `userid` DESC LIMIT 1' at line 3 for query SELECT `userid` FROM `wp_wpforo_profiles`
                        WHERE `status` IN ('active')
                          AND `groupid` IN  ()
                            ORDER BY `userid` DESC LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Divi/page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, wpforo\wpforo->{closure}, include('/plugins/wpforo/themes/2022/index.php'), include('/plugins/wpforo/themes/2022/footer.php'), wpforo\wpforo->statistic, wpforo\classes\Members->get_newest_member, QM_DB->query

Web Server	nginx/1.21.4
PHP Version	8.0.19
MySQL Version	5.6.51

Is this a known issue?

Cheers!

Topic Tags

Display on Members List

3 Replies

Posts: 26

copilot

Topic starter

Mar 21, 2023 12:06 pm

(@copilot)

Eminent Member

Joined: 6 years ago

EDIT: The error also shows when the Forum Footer and Forum Statistics are disabled.

Can you make sense of this error? The thing that I do find odd is the missing value ():

 AND `groupid` IN  ()

Posts: 3627

Chris

Mar 21, 2023 1:38 pm

(@chris)

Famed Member

Joined: 3 years ago

Hi @copilot,

The reason, is that you have disabled "Display on Members List" option from the Usergroup options for all the Usergroups, and because of that you get that SQL Syntax Error.

We will fix this for the new update,

Thanks.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.