Mr Papa said
well, if there is no data, it will say so… something like msqyl returned an empty result set (ie zero rows)…no, you cannot copy tables like that… as I said, I suspect you have zero rows of data in sfauths (deleted somehow) but wanted to be sure before proceeding…
Attached is what I’m seeing.
okay, that does show you have data… you have one row of information… eight columns of data… you read off the last column auth_cat which is why that was confusing… 
you should have a bunch more rows… so yes permissions lost… now this is where it gets tricky… we can reset the permissions and get you going… but 5.2.6 has a bug in the permissions reset logic that might impact you and cause other problems…
do you have a db backup from this current point? if so, we can try a reset and restore if there is problems… if not, then I can send you db query to run that should restore it for you… or if a bit uneasy, I can try to do it for you, but would require access to your phpmyadmin…
I already reset the permissions to the most liberal possible for each group, thinking that might be the problem, as the error message on the public forum seemed to point in that direction.
I can follow your instructions or give you access — either way. Your assistance is greatly appreciated.
but since you have essentially no data in your sfauths table, it wont do anything…
okay, lets see what happens… can you delete that one row of data for create_links in the sfauths table?
then click on the SQL button at the top (between structure and top)… remove any content in the input window… paste in the following:
INSERT INTO `spf_sfauths` (`auth_id`, `auth_name`, `auth_desc`, `active`, `ignored`, `enabling`, `admin_negate`, `auth_cat`) VALUES (1, 'view_forum', 'Can view a forum', 1, 0, 0, 0, 2), (2, 'view_forum_lists', 'Can view a list of forums only', 1, 0, 0, 0, 2), (3, 'view_forum_topic_lists', 'Can view a list of forums and list of topics only', 1, 0, 0, 0, 2), (4, 'view_admin_posts', 'Can view posts by an administrator', 1, 0, 0, 0, 2), (5, 'start_topics', 'Can start new topics in a forum', 1, 0, 0, 0, 3), (6, 'reply_topics', 'Can reply to existing topics in a forum', 1, 0, 0, 0, 3), (7, 'edit_own_topic_titles', 'Can edit own topic titles', 1, 0, 0, 0, 4), (8, 'edit_any_topic_titles', 'Can edit any topic title', 1, 0, 0, 0, 4), (9, 'pin_topics', 'Can pin topics in a forum', 1, 0, 0, 0, 7), (10, 'move_topics', 'Can move topics from a forum', 1, 0, 0, 0, 7), (11, 'move_posts', 'Can move posts from a topic', 1, 0, 0, 0, 7), (12, 'lock_topics', 'Can lock topics in a forum', 1, 0, 0, 0, 7), (13, 'delete_topics', 'Can delete topics in forum', 1, 0, 0, 0, 5), (14, 'edit_own_posts_forever', 'Can edit own posts forever', 1, 1, 0, 0, 4), (15, 'edit_own_posts_reply', 'Can edit own posts until there has been a reply', 1, 1, 0, 0, 4), (16, 'edit_any_post', 'Can edit any post', 1, 1, 0, 0, 4), (17, 'delete_own_posts', 'Can delete own posts', 1, 0, 0, 0, 5), (18, 'delete_any_post', 'Can delete any post', 1, 0, 0, 0, 5), (19, 'pin_posts', 'Can pin posts within a topic', 1, 0, 0, 0, 7), (20, 'reassign_posts', 'Can reassign posts to a different user', 1, 0, 0, 0, 7), (21, 'view_email', 'Can view email and IP addresses of members', 1, 0, 0, 0, 2), (22, 'view_profiles', 'Can view profiles of members', 1, 0, 0, 0, 2), (23, 'view_members_list', 'Can view the members lists', 1, 0, 0, 0, 2), (24, 'report_posts', 'Can report a post to administrators', 1, 0, 0, 0, 1), (25, 'bypass_math_question', 'Can bypass the post math question', 1, 0, 0, 0, 6), (26, 'bypass_moderation', 'Can bypass all post moderation', 1, 0, 0, 0, 6), (27, 'bypass_moderation_once', 'Can bypass first post moderation', 1, 0, 0, 0, 6), (28, 'moderate_posts', 'Can moderate pending posts', 1, 0, 0, 0, 6), (29, 'use_spoilers', 'Can use spoilers in posts', 1, 0, 0, 0, 3), (30, 'view_links', 'Can view links within posts', 1, 0, 0, 0, 2), (31, 'upload_images', 'Can upload images in posts', 1, 1, 0, 0, 8), (32, 'upload_media', 'Can upload media in posts', 1, 1, 0, 0, 8), (33, 'upload_files', 'Can upload other files in posts', 1, 1, 0, 0, 8), (34, 'use_signatures', 'Can attach a signature to posts', 1, 1, 0, 0, 3), (35, 'upload_signatures', 'Can upload signature images', 1, 1, 0, 0, 8), (36, 'upload_avatars', 'Can upload avatars', 1, 1, 1, 0, 8), (37, 'subscribe', 'Can subscribe to forums (if enabled) and topics', 1, 1, 0, 0, 1), (38, 'watch', 'Can watch topics within a forum', 1, 1, 0, 0, 1), (39, 'change_topic_status', 'Can change the status of a topic', 1, 1, 0, 0, 7), (40, 'rate_posts', 'Can rate a post', 1, 1, 0, 0, 1), (41, 'use_pm', 'Can use the private messaging system', 1, 1, 1, 0, 1), (42, 'create_linked_topics', 'Can create linked blog post and forum topics', 1, 1, 1, 0, 3), (43, 'break_linked_topics', 'Can break link between blog posts and forum topics', 1, 1, 1, 0, 5), (44, 'view_online_activity', 'Can view the online activity', 1, 0, 0, 0, 2), (45, 'bypass_captcha', 'Can bypass the post captcha check', 1, 0, 0, 0, 6), (47, 'download_attachments', 'Can download other file type attachments', 1, 0, 0, 0, 2), (48, 'post_by_email_reply', 'Can reply to topics using email', 1, 0, 0, 0, 3), (49, 'post_by_email_start', 'Can start new topics using email', 1, 0, 0, 0, 3), (50, 'edit_tags', 'Can edit topic tags', 1, 0, 0, 0, 7), (98, 'vote_poll', 'Can vote in a forum poll within a post', 1, 0, 0, 0, 1), (97, 'create_poll', 'Can create a forum poll within a post', 1, 0, 0, 0, 3), (95, 'reply_own_topics', 'Can only reply to own topics', 1, 1, 0, 1, 3), (96, 'view_own_admin_posts', 'Can view only own posts and admin/mod posts', 1, 0, 0, 1, 2), (99, 'create_links', 'Can create links in posts', 1, 0, 0, 0, 3), (100, 'post_as_user', 'Can create a forum post as different user', 1, 1, 0, 0, 3), (101, 'thank_posts', 'Can thank a user for a post', 1, 1, 0, 0, 1), (102, 'view_private_topics_only', 'Can only view topics by creator and admins', 1, 0, 0, 1, 2), (103, 'blogsearch', 'Can search blog posts and pages', 1, 1, 0, 0, 1);
and hit go button… now there is more than you need there, but dont know which plugins you have active… more wont hurt if they are not used…
after that, what is in the sfauthcats table?
Before I do this, I don’t see any way to individually select the one row for deletion. I checked the only selection box, then delete and got this attached message. Should I click “OK”? I assume so, but I want to double-check with you.
there was in your image… in the at one row, a red button and word delete…
but yes, that will work too… hitting ok is fine…
I tried to run the query and am getting the message:
#1146 – Table ‘pokeron4_wrd1.spf_sfauths’ doesn’t exist
Looks like it found the table with the change you suggested.
However, now I’m getting: “#1062 – Duplicate entry ‘1’ for key 1”
are you sure you emptied the table wp_sfauths first?
this might be easier if you send me via pm some credentials to access phpmyadmin and I can just do it…
Mr Papa said
are you sure you emptied the table wp_sfauths first?this might be easier if you send me via pm some credentials to access phpmyadmin and I can just do it…
I was able to run the query successfully! I now have Start row: 30; Number of rows: 30; Headers every: 100 and data listed.
Everything seems to be working. Thanks!
My next task is to modify the theme or change it to how it was. That’s the easy part.
Great assistance. Appreciated.
np. glad to help. sorry for the upgrade issue in the first place…
you should go to forum – toolbox – housekeeping and reset the auths cache…
and then make sure the permisisons are set up the way you want them…