Can you elaborate a bit more. Are you just saying that new members do not appear in the new members list at the bottom in the stats area? This has nothing to do with whether they are designated as moderators or not…

If this IS what you are saying then remember that the new members list along with other statistics is cached and set – by default – to recalc – once an hour. If they do not appear after the recalc time is up then that would suggest that your WP Cron is not working properly. You can test this by creating a blog post set to be published in the future by  a few minutes and then see if it gets published as expected.

If it does then perhaps the forum Cron tasks are not scheduled and you can reschedule them by simply deactivating the Simple:Press plugin (NOT uninstall) and then reactivating.

I mean adding moderator from the admin panel. Under Manage User Groups, When I click on Add New, the user list is empty so how can so add moderators?

I suppose the first and obvious question has to be – does your site actually have existing members?

If it does – and they do not show up in the eligible members listing then it could be that you have the option turned on to limit users to membership of a single user group (forum admin > User Groups > Ma USers to user Groups Panel) in which case you would need to move them from their current user group into your user group designated for moderators.

I have over 30.000 members, and still the eligible user list is empty even though the limit user membership is turned off.

Also when I click Members tab on the forum front page, it pops up an error saying ‘Invalid Database Query’. On top of that, at the admin panel, i cannot find any user from the Search Member function of the forum. This might be related to my issue on the previous posts.

first, that panel you just pictured has nothing to do with adding moderators – wrong place…  that said, your users should show up there…

begs the question are your users really part of WP?  or do you have some plugin for membership or users that keeps them external to wp?  such as DAP…

quick check is to see how many users in the wp_users table (your prefix might be other than wp_)… and then see how many users in wp_sfmembers table…

also, you can get more info on that invalid db query on the error log panel…  forum – toolbox – error log…

I dont have any membership plugins. They are all wp users.

wp-users: 35.070

forum members: 35.050

not sure why the difference, but wouldnt account for what you are seeing…

so need to check for errors in your php error log…

so the image had nothing to do with usergroups and moderators, but was just a member list… shouldnt be empty so lets start there…   load up that panel at forum – users – member information…  when it fails to load (as your image indicates), is the rest of the page loaded?  do you have a proper wp admin footer at bottom?  check forum – toolbox – error log and see if any errors reported…  also, check the php error log on your server…

was the image actual search results or just what you see when the panel loads? 

as mentioned previously you can get more on the invalid db query from forum – toolbox – error log… need to know what it says there.. red errors please…

When I query the wp_sfmembers table I get the error:

Error
SQL query:

SELECT *

FROM `wp_sfmembers`

WHERE `display_name` LIKE ‘erwan’

LIMIT 0 , 30

MySQL said:

well, thats fairly straight forward.. you mysql db is corrupted…  go repair the db… you can do it with db tool such as phpmyadmin… certainly you control panel from your host has a db too… 

should get you back…

After the repair, everything starts working again as it is supposed to. Thank you

Good to hear!  Thanks for the update…