Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Cannot add moderators
Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 24, 2014 - 2:19 pm

I am currently using the latest versions of WP and SP. I want to add new moderators however when I enter a specific user, it doesnt appear on the list. I can see other members but not that specific user.

Can you please help?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 24, 2014 - 2:45 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 24, 2014 - 3:28 pm

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?

mod.JPGImage Enlarger

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 24, 2014 - 4:24 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 24, 2014 - 5:21 pm

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

Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 24, 2014 - 6:09 pm

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.

 

ere.JPGImage Enlarger

 

4444.JPGImage Enlarger

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 24, 2014 - 8:26 pm

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...

Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 26, 2014 - 4:11 pm

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

wp-users: 35.070

forum members: 35.050

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 26, 2014 - 4:23 pm

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...

Avatar
Ozge Ozkaya
Member
Free Members
sp_UserOfflineSmall Offline
Jul 26, 2014 - 4:31 pm

When I query the wp_sfmembers table I get the error:

Error
SQL query: Documentation

SELECT *

FROM `wp_sfmembers`

WHERE `display_name` LIKE 'erwan'

LIMIT 0 , 30

MySQL said: Documentation

#1194 - Table 'wp_sfmembers' is marked as crashed and should be repaired
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626