Support Forum
Support Forum
Offline
It seems to be accessing the right table, because I show 440 posts that can't be accessed.
Here's what I'm seeing on the public forum beta page itself:
Most Users Ever Online: 47
Member Stats:
Members: 23
Moderators: 0
Admins: 2
Groups: 1
Forums: 4
Topics: 117
Posts: 440
The above might indicate a settings issue, but I can't find the fix.
Offline
Start row: 0; Number of rows: 30; Headers every 100 rows. That's all I can find.
Offline
below that, what does it say?? seem image for example...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
below that, what does it say?? seem image for example...
There is no data or table below. It's just blank between the "rows" information above and the options below.
My host keeps daily backups. But rather than revert to the original SP 4.3 version, then to 4.5.1, and finally to the current version, would it work if I just copied the SP tables (any or all) that seem empty? I'm confused and not familiar with how this process would work with SP and WordPress.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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.
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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.
Offline
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?
Visit Cruise Talk Central and Mr Papa's World
All RSS