Support Forum
Support Forum
Offline
I have my WP admin options and in the Forum Tab I have: Your Admin Options, Plugins Options and Theme Options.
There is no problem for me to access the database and do some changes.
Offline
In the 'usermeta' table for your own 'user_id' you will find a row where the 'meta_key' column contains a value made up of your WP table prefix followed by the term 'capabilities'.
This is stored as a php serialised array and should - at the very least - contain an entry for 'administrator' and any SP capabilities you do have (plugins and themes). Beware - If you have any other WP plugins that add capabilities then you can NOT perform the data change below as you would wipe that capability out.
The full serialised array for retaining WP administrator caps plus all SP caps is:
a:14:{s:13:"administrator";s:1:"1";s:18:"SPF Manage Options";s:1:"1";s:17:"SPF Manage Forums";s:1:"1";s:22:"SPF Manage User Groups";s:1:"1";s:22:"SPF Manage Permissions";s:1:"1";s:21:"SPF Manage Components";s:1:"1";s:15:"SPF Manage Tags";s:1:"1";s:16:"SPF Manage Users";s:1:"1";s:19:"SPF Manage Profiles";s:1:"1";s:17:"SPF Manage Admins";s:1:"1";s:18:"SPF Manage Toolbox";s:1:"1";s:24:"SPF Manage Configuration";s:1:"1";s:18:"SPF Manage Plugins";s:1:"1";s:17:"SPF Manage Themes";s:1:"1";}So replacing what is there now with exactly the above will restore your caps.
 |
YELLOW
SWORDFISH
|
Offline
Ok, now I have the full menu for SP. I managed to display the forum with a list of bugs that make me think that the database and the data I have are now incompatible.
The most important is that I cannot Edit nor Create Groups / Forum. I have 2 existing Groups that seem to match previous Forum layout that I cannot change.
I can see that threads are showing empty posts for the "admin" user and as I understand the group high level topics are now all under the same thread (as if the previous groups where showing under the first topic - I cannot confirm as those posts are empty but a succession of posts posted by admin which makes me thinks that there are the description of the sections of my old forum). Again, this seems to be an incompatibility of the data vs the database layout. The "log in" button does not work and few other bugs that you can imagine related to the topics, threads and posts that are no matching the database.
Is there a way to convert mySQL data directly in phpmyadmin by doing a succession of SQL?
I hope that you will understand what I am trying to explain... Thank you. Sebastien
PS: Just in case http://feetonthefield.com/forum-2/ sorry, it is French.
Offline
I don't see a 'list of bugs?' I don't see any data but I don't see any bugs. Can you tell me what the error messages are please?
I suspect that your permissions have become scrambled although not sure why this would be. But I would start by taking a quick look at the database tables. Can we check that the 'sfgroups', sfforums', 'sftopics' and 'sfposts' tables all have data?
And assuming they do then I think we need to perform some basic housekeeping. I would be tempted to start by performing a basic permission reset (From the admin > Permissions menu). This WILL mean that the forum permissions need to be rebuilt but with only 5 forums listed that should be a quick manual task. It is up to you of course...
|
YELLOW
SWORDFISH
|
Offline
I have been playing with the permissions and now I can display posts / topics - thank you for that. Now the problem goes back to not being able to creata / update groups / forums.
sfgroups has data in it - I still cannot add / edit group in the administration panel even after the "Permission Reset":
| group_id | group_name | group_seq | group_desc | group_rss | group_icon | group_view | |||
|---|---|---|---|---|---|---|---|---|---|
| 1 | xxx | 2 | xxx | NULL | NULL | public | |||
| 4 | xxx | 2 | xxx | NULL | NULL | public | |||
sfforums has data in it:
| forum_id | forum_name | group_id | forum_seq | forum_desc | forum_status | forum_slug | forum_rss | forum_icon | post_id | topic_count | forum_rss_private | topic_status_set | post_count | post_ratings | use_tags | forum_view | post_id_held | post_count_held | forum_icon_new | topic_icon | topic_icon_new | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | xxx | 1 | 7 | 0 | xxx | NULL | NULL | 1 | 1 | 1 | 0 | 1 | 0 | 0 | public | 1 | 1 | NULL | NULL | NULL | ||||
| 2 | xxx | 1 | 8 | xxx | 0 | xxx | NULL | NULL | 402 | 35 | 1 | 0 | 324 | 0 | 0 | public | 402 | 324 | NULL | NULL | NULL | |||
| 3 | xxx | 1 | 9 | xxx | 0 | xxx | NULL | NULL | 358 | 6 | 1 | 0 | 40 | 0 | 0 | public | 358 | 40 | NULL | NULL | NULL | |||
| 4 | xxx | 4 | 1 | xxx | 0 | xxx | NULL | NULL | 396 | 3 | 1 | 0 | 17 | 0 | 0 | public | 396 | 17 | NULL | NULL | NULL | |||
| 5 | xxx | 4 | 2 | xxx | 0 | xxx | NULL | NULL | 366 | 7 | 1 | 0 | 14 | 0 | 0 | public | 366 | 14 | NULL | NULL | NULL | |||
sftopics has data in it (example):
| topic_id | topic_name | topic_date | topic_status | forum_id | user_id | topic_pinned | topic_subs | topic_sort | topic_opened | blog_post_id | topic_slug | post_id | post_count | topic_status_flag | topic_watches | post_id_held | post_count_held | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | xxx | xxx | 1 | 1 | 1 | 0 | NULL | NULL | 230 | 0 | xxx | 1 | 1 | 0 | NULL | 1 | 1 | |||
| 3 | xxx | xxx | 0 | 5 | 1 | 0 | NULL | NULL | 206 | 0 | xxx | 5 | 2 | 0 | NULL | 5 | 2 | |||
sfposts has data in it (example):
| post_id | post_content | post_date | topic_id | user_id | forum_id | guest_name | guest_email | post_status | post_pinned | post_index | post_edit | poster_ip | source | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | xxx | xxx | 1 | 1 | 1 | 0 | 0 | 1 | NULL | 0 | ||||||
| 4 | xxx | xxx | 3 | 1 | 5 | 0 | 0 | 1 | NULL | 0 | ||||||
Sorry for posting the tables, but thought you could see anything wrong. Thank you. Sebastien
Offline
I have been playing around a bit and there is something strange with my administration of admins. This may explain some of the issues.
1 - Even if I logged in as WPAdmin and declared as SPAdmin I still appear as Guest on the Forum Page. Same if I log as a contributor. In any case, the SP Login button has no effect, logged in or not.
2 - I can pretty much do what I want on the Forum Administration Panel. Except:
a - create / Edit Groups and Forum
b - manage SPAdmin, expect adding authors as SPAdmins. I have added 2 WPAdmin to my site, but they do not appear in the bottom "WP Admins But Not SPF Admins" and the 2 WPAdmin existing at the SP installation are like frozen and I can edit the rights. The first one seem to be master admin (with a padlock) and the second one only has plugin, theme and use Group - I cannot edit it. There are 2 buttons per option for those 2 admins but not for regulor authors when I add them as admin. See here.
c - I have created another authors / contributor / Admin in my WP in they do not appear in the SPAdmin menu as potential Admin, etc... I see only 2 contributors that were existing before the SP upgrade - on my old version.
I hope this helps you find something. Sebastien
Offline
not sure where Andy was going, but he may not be around until tomorrow...
did you replace the actual names with xxx?
on the admins, those double checkmarks indicate a conflict with some js... doubt its a show stopper... but did you say you could not change that? wort noting that a couple of those are moderators not admins... are you not able to change 'Set'?
in the groups in db, the sequence should be unique - both are 2... make one 1 and the other 2...
Visit Cruise Talk Central and Mr Papa's World
Offline
Yes I did replace values to xxx before submitting to reduce the space on the post.
I cannot change any of the Green Tick boxes for the admins in both Admin and Moderator section of the Manage Admin Section. I added one Moderator that I can update. I still cannot add WP Admin to SP Admin.
I have change the sfgroups - group_seq with "1" to the first one and id not see any change. Note that when I display the forum I have the following message: "No groups have been created yet". I still cannot edit / add groups / forum in my forum administration.
Sebastien
Offline
I am in danger of losing the plot here! Is there a chance you could let us have access to your admin so that we can take a look to see what is going on? And that would need to be an SP Admin account of course.
If that is possibe then please PM credentials to both myself and to 'Mr Papa'. Please include in the PM a link to your site, a link to this thread and brief reminder of the problem. And one of us will take a look for you.
|
YELLOW
SWORDFISH
|
Offline
I suspect your data is not correct in this area.
In the 'sfmembers' table there are two columns. One called 'Admin' and one called 'Moderator'. If either is set to the number 1 then that user is treated in that role. I believe that for the user with your name and for the user called 'admin' BOTH of these columns are set to 1 whereas for these two users the 'Moderator' column should be set to zero.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)