search

boonebgorges / buddypress-docs

GNU General Public License v3.0
106 stars 44 forks source link

Logged-out users cannot access the docs #682

Open ericlucasfr opened 3 years ago

ericlucasfr commented 3 years ago

Hello, thanks a lot for your plugin which will hopefully be very useful for our projects.

Even when I set "Anyone" for "Allow to read", the offline users see a message saying "There are no docs for this view". But with the same setting, if they login they can see it. The problem happens when clicking a BP Docs folder

You can see: https://autistance.org/groups/org-aut_allianceautiste-org_orgintl_onu-cdph/workdocs/

This Doc can be read by: Anyone This Doc can be edited by: Admins and mods of the group AllianceAutiste | OrgIntl | ONU-CDPH Comments are visible to: Anyone Comments can be posted by: Logged-in Users History can be viewed by: Logged-in Users

But if we paste the doc link in the URL bar, then we can see it (with the same settings, and being logged out): https://autistance.org/workdocs/aa_orgintl_onu-cdph-examen-2021-rapport

And when I see that doc and I click the folder name in the BP Docs nav bar, I get that message (in the table) : "There are no docs for this view."

In other words, the "blocking" happens only when browsing the BP Docs folders.

I hope that someone can help. I am not a developer, I just try to make sites with plugins. Thank you very much.

boonebgorges commented 3 years ago

Thanks for the detailed report.

Because you are able to access the document directly via URL, I believe the problem is with the filtering in https://github.com/boonebgorges/buddypress-docs/blob/297a9d11239ca6bd28e6f8959b0d061823e249a3/includes/access-query.php#L304

It would help to narrow down the issue if you were able to tell me what SQL query is taking place on this page when logged out. https://wordpress.org/plugins/query-monitor/ is a good tool for capturing this information. It will be a query of the form SELECT ... FROM wp_posts ... WHERE post_type = 'bp_doc'.... If I can see what this looks like, I might be able to make a guess about what's happening.

ericlucasfr commented 3 years ago

Hello Boone, thanks a lot for your quick and attentive message.

Well, I've installed Query Monitor, and I tried to do what you suggested, by refreshing pages, clicking docs links, with logged out user or even logged in user, but without being able to find what you say.

The only things that I could find with Query Monitor were :

ericlucasfr commented 3 years ago

171 SELECT option_value FROM mod0_options WHERE option_name = 'bp_docs_disable_attachment_notice' LIMIT 1 - get_option() wp-includes/option.php:124 get_blog_option() wp-content/plugins/buddypress/bp-core/bp-core-wpabstraction.php:58 bp_get_option() wp-content/plugins/buddypress/bp-core/bp-core-options.php:247 BP_Docs_Attachments->admin_notice_init() wp-content/plugins/buddypress-docs/includes/attachments.php:755 do_action('admin_init') wp-includes/plugin.php:478 Plugin: buddypress

image

and

GET https://autistance.org/wp-content/uploads/bp-attachments/0/test.html cURL error 28: Connection timed out after 5000 milliseconds-HTTP API Transport: curlDNS Resolution Time: 0.0041Connection Time: 0.0044Transfer Start Time (TTFB): 0.0807Response Size: 235 BResponse Content Type: text/html; charset=iso-8859-1IP Address: 188.165.51.93 -BP_Docs_Attachments->check_is_protected()wp-content/plugins/buddypress-docs/includes/attachments.php:886BP_Docs_Attachments->admin_notice_init()wp-content/plugins/buddypress-docs/includes/attachments.php:760do_action('admin_init')wp-includes/plugin.php:478 Plugin: buddypress-docs

image

If I disable WordFence plugin, that message about HTTP API calls is different : image

If I disable also All In One Security plugin, the problem (with BP Docs) is the same, and I cannot see anything more in Query Monitor........

(I assume that you don't have time to look by yourself in my WP admin, but in case you want, of course you are welcome :-))

Thanks!

ericlucasfr commented 3 years ago

P.S. Two years ago when I first considered your plugin, I did not keep it because I was trying to find something rather similar to G....gle Docs (even more basic), but finally after trying tons of things, I recently reconsidered BP Docs and I found that it is very good and very suitable for our needs (our main activity is letters, but it's difficult to do in collaboration). With the comments (and in particular wpDiscuz inline comments), it's possible for colleagues to contribute to the texts. What I really like with BP Docs is that it is perfectly and nicely integrated with BuddyPress, this is very appreciable. And also I like the fact that the permissions are very clearly explained, and with all the desired "granularity". The breadcrumb system and the folders are very good too (I mean, very decent and more than sufficient, for a free plugin). If we manage to use it like I think, we will do all our letters with it, it will be really nice :-) This is a good example of free work (your plugin) useful for many people (we also work benevolently). Thanks a lot :-)

image

image

dcavins commented 3 years ago

Hi Eric,

When looking at the queries in Query Monitor, the ones we need to help troubleshoot your issue will happen at the main docs directory view (/docs) and have the "caller" of WP_Query->get_posts(). You can select those by choosing WP_Query->get_posts() from the "caller" select: Docs_–_bp-docs-test

The way I tested this was to visit the /docs page as my admin user, set the authentication cookie in Query Monitor, log out, then reload the /docs page as a non-logged-in user to check the Query Monitor output. set-cookie

ericlucasfr commented 3 years ago

Hello @dcavins, thanks a lot for this help, that I tried to follow in vain several times until I understood that I had to to open the main directory and not any page under /workdocs. So after following those steps, now I see :

https://autistance.org/workdocs/

image

image

Apparently there are two rows related to BuddyPress Docs :

SELECT mod0_posts.IDFROM mod0_postsWHERE 1=1AND ( 0 = 1 )AND mod0_posts.post_type = 'post'AND (mod0_posts.post_status = 'publish'OR mod0_posts.post_status = 'closed')GROUP BY mod0_posts.IDORDER BY mod0_posts.post_date DESC +WP_Query->get_posts() Plugin: buddypress-docs 0 0.0008

SELECT SQL_CALC_FOUND_ROWS mod0_posts.IDFROM mod0_postsWHERE 1=1AND ( 0 = 1 )AND mod0_posts.post_type = 'bp_doc'AND (mod0_posts.post_status = 'publish'OR mod0_posts.post_status = 'closed')GROUP BY mod0_posts.IDORDER BY mod0_posts.post_date DESCLIMIT 0, 100

I don't know if it will help to analyse :-)...

As long as someone tells me exactly what to do, I can continue to make tests.

Thank you so much :-)

ericlucasfr commented 3 years ago

Sorry, I forgot to click the "+" sign. Here is the full view:

image

SELECT mod0_posts.IDFROM mod0_postsWHERE 1=1AND ( 0 = 1 )AND mod0_posts.post_type = 'post'AND (mod0_posts.post_status = 'publish'OR mod0_posts.post_status = 'closed')GROUP BY mod0_posts.IDORDER BY mod0_posts.post_date DESC -WP_Query->get_posts()wp-includes/class-wp-query.php:2955WP_Query->query()wp-includes/class-wp-query.php:3448WP_Query->construct()wp-includes/class-wp-query.php:3559BP_Docs_Access_Query->get_restricted_comment_doc_ids()wp-content/plugins/buddypress-docs/includes/access-query.php:228bp_docs_general_comment_protection()wp-content/plugins/buddypress-docs/includes/access-query.php:387do_action_ref_array('pre_get_comments')wp-includes/plugin.php:544WP_Comment_Query->get_comments()wp-includes/class-wp-comment-query.php:374WP_Comment_Query->query()wp-includes/class-wp-comment-query.php:346get_comments()wp-includes/comment.php:244wpDiscuzWidgetsClass->construct()wp-content/plugins/wpdiscuz-widgets/wpdiscuz-widgets-class.php:15WP_Widget_Factory->register()wp-includes/class-wp-widget-factory.php:61register_widget()wp-includes/widgets.php:115wpDiscuzWidgets->registerWpdiscuzWidget()wp-content/plugins/wpdiscuz-widgets/wpDiscuzWidgets.php:94do_action('widgets_init')wp-includes/plugin.php:478wp_widgets_init()wp-includes/widgets.php:1773do_action('init')wp-includes/plugin.php:478

image

SELECT SQL_CALC_FOUND_ROWS mod0_posts.IDFROM mod0_postsWHERE 1=1AND ( 0 = 1 )AND mod0_posts.post_type = 'bp_doc'AND (mod0_posts.post_status = 'publish'OR mod0_posts.post_status = 'closed')GROUP BY mod0_posts.IDORDER BY mod0_posts.post_date DESCLIMIT 0, 100 -WP_Query->get_posts()wp-includes/class-wp-query.php:3016WP_Query->query()wp-includes/class-wp-query.php:3448WP->query_posts()wp-includes/class-wp.php:624WP->main()wp-includes/class-wp.php:747wp()wp-includes/functions.php:1285Main Query
ericlucasfr commented 3 years ago

I really like your system :-) Very useful! image image

ericlucasfr commented 3 years ago

Hello @boonebgorges and @dcavins, thanks for trying to solve my problem, I hope that you will have an occasion to see the information that I posted above and that it will help...

Additionally, I would like to know if you can recommend me a plugin that would allow to share files (not only texts) along with the docs created with BP Documents. I mean that the users would be able to upload files which would not necessarily be linked to docs, but that we could upload to folders created by BP Documents. It would be very useful. Because sometimes people need to share docs for a given problem (in order to create the relevant docs after that), but it's not convenient to have first to create an empty doc just to attach files to it. Some files (like photos of letters) should be at the same "level" as the docs that we create, and not just attachments to a doc created only for attachments. I found many "file managers" but they are not integrated with your plugin. Probably this feature would be very easy to add, maybe with just a button "Add file" (and those files would be easy to attach to the docs). Thanks :-)

boonebgorges commented 3 years ago

Thanks for sharing these screenshots, @ericlucasfr.

The ( 0 = 1 ) clause in the SQL explains why you're getting no results. This clause is generated by WordPress when a post query fails because of a tax_query that matches no items. In BuddyPress Docs queries, there are two main ways in which tax_query is used. One is to filter Docs that belong to a group. The other is to filter based on Doc access settings. Because your bug only arises when you are logged out, it strongly suggests that our problem is with this access-setting tax_query.

Are you able to access your site's database? As a next step, it would be helpful to see whether there are, in fact, any items that are tagged as "anyone" in your database. You've said that the interface says "Anyone" but there could be a disconnect. The format of the query is something like:

select count(*) from wp_1_term_relationships where term_taxonomy_id in ( select wp_1_term_taxonomy.term_taxonomy_id from wp_1_term_taxonomy join wp_1_terms on wp_1_term_taxonomy.term_id = wp_1_terms.term_id where wp_1_term_taxonomy.taxonomy = 'bp_docs_access' and wp_1_terms.slug = 'bp_docs_access_anyone' );

though you will have to change the table names to match your own installation.

ericlucasfr commented 3 years ago

Hello @boonebgorges, thank you very much for these detailed explanations (although I can guess only 10% of what it means :-).

I can go to my phpMyAdmin, I made a search in all the database and if gave the following... ("Parcourir" = Browse, "Supprimer" = Delete)

0 correspondance dans mod0_aiowps_events    
0 correspondance dans mod0_aiowps_failed_logins    
0 correspondance dans mod0_aiowps_global_meta    
0 correspondance dans mod0_aiowps_login_activity    
0 correspondance dans mod0_aiowps_login_lockdown    
0 correspondance dans mod0_aiowps_permanent_block    
0 correspondance dans mod0_app_cache    
0 correspondance dans mod0_ap_notifications    
1 correspondance dans mod0_badges Parcourir Supprimer
0 correspondance dans mod0_badge_relationships    
0 correspondance dans mod0_blc_filters    
0 correspondance dans mod0_blc_instances    
0 correspondance dans mod0_blc_links    
0 correspondance dans mod0_blc_synch    
0 correspondance dans mod0_bpges_queued_items    
0 correspondance dans mod0_bpges_subscriptions    
0 correspondance dans mod0_bpic_conversations    
0 correspondance dans mod0_bpic_messages    
0 correspondance dans mod0_bpmts_moderation_categories    
0 correspondance dans mod0_bpmts_moderation_log    
0 correspondance dans mod0_bpmts_moderation_queue    
0 correspondance dans mod0_bpmts_moderation_reports    
0 correspondance dans mod0_bp_activity    
0 correspondance dans mod0_bp_activity_meta    
0 correspondance dans mod0_bp_friends    
0 correspondance dans mod0_bp_groups    
5 correspondances dans mod0_bp_groups_groupmeta Parcourir Supprimer
0 correspondance dans mod0_bp_groups_members    
0 correspondance dans mod0_bp_invitations    
0 correspondance dans mod0_bp_messages_messages    
0 correspondance dans mod0_bp_messages_meta    
0 correspondance dans mod0_bp_messages_notices    
0 correspondance dans mod0_bp_messages_recipients    
0 correspondance dans mod0_bp_mute    
0 correspondance dans mod0_bp_notifications    
0 correspondance dans mod0_bp_notifications_meta    
0 correspondance dans mod0_bp_user_blogs    
0 correspondance dans mod0_bp_user_blogs_blogmeta    
0 correspondance dans mod0_bp_xprofile_data    
1 correspondance dans mod0_bp_xprofile_fields Parcourir Supprimer
0 correspondance dans mod0_bp_xprofile_groups    
0 correspondance dans mod0_bp_xprofile_meta    
1 correspondance dans mod0_commentmeta Parcourir Supprimer
0 correspondance dans mod0_comments    
0 correspondance dans mod0_cpm_file_relationship    
0 correspondance dans mod0_cpm_project_items    
0 correspondance dans mod0_cpm_tasks    
0 correspondance dans mod0_cpm_user_role    
0 correspondance dans mod0_gdpol_votes    
0 correspondance dans mod0_links    
0 correspondance dans mod0_mg2wpforo    
0 correspondance dans mod0_mpp_logs    
0 correspondance dans mod0_ms_snippets    
0 correspondance dans mod0_myCRED_log    
22 correspondances dans mod0_options Parcourir Supprimer
0 correspondance dans mod0_pm_activities    
0 correspondance dans mod0_pm_assignees    
0 correspondance dans mod0_pm_boardables    
0 correspondance dans mod0_pm_boards    
0 correspondance dans mod0_pm_capabilities    
0 correspondance dans mod0_pm_categories    
0 correspondance dans mod0_pm_category_project    
0 correspondance dans mod0_pm_comments    
0 correspondance dans mod0_pm_custom_fields    
0 correspondance dans mod0_pm_files    
0 correspondance dans mod0_pm_gantt_chart_links    
0 correspondance dans mod0_pm_imports    
0 correspondance dans mod0_pm_integrations    
0 correspondance dans mod0_pm_invoice    
0 correspondance dans mod0_pm_meta    
0 correspondance dans mod0_pm_projects    
0 correspondance dans mod0_pm_roles    
0 correspondance dans mod0_pm_role_project    
0 correspondance dans mod0_pm_role_project_capabilities    
0 correspondance dans mod0_pm_role_project_users    
0 correspondance dans mod0_pm_role_user    
0 correspondance dans mod0_pm_settings    
0 correspondance dans mod0_pm_tasks    
0 correspondance dans mod0_pm_task_custom_fields    
0 correspondance dans mod0_pm_task_label    
0 correspondance dans mod0_pm_task_label_task    
0 correspondance dans mod0_pm_task_types    
0 correspondance dans mod0_pm_task_type_task    
0 correspondance dans mod0_pm_time_tracker    
6 correspondances dans mod0_postmeta Parcourir Supprimer
66 correspondances dans mod0_posts Parcourir Supprimer
1 correspondance dans mod0_redirection_404 Parcourir Supprimer
0 correspondance dans mod0_redirection_groups    
0 correspondance dans mod0_redirection_items    
0 correspondance dans mod0_redirection_logs    
0 correspondance dans mod0_reword    
0 correspondance dans mod0_sabai_comment_post    
0 correspondance dans mod0_sabai_comment_vote    
0 correspondance dans mod0_sabai_content_post    
0 correspondance dans mod0_sabai_entity_bundle    
0 correspondance dans mod0_sabai_entity_field    
0 correspondance dans mod0_sabai_entity_fieldcache    
0 correspondance dans mod0_sabai_entity_fieldconfig    
0 correspondance dans mod0_sabai_entity_field_content_activity    
0 correspondance dans mod0_sabai_entity_field_content_body    
0 correspondance dans mod0_sabai_entity_field_content_children_count    
0 correspondance dans mod0_sabai_entity_field_content_featured    
0 correspondance dans mod0_sabai_entity_field_content_guest_author    
0 correspondance dans mod0_sabai_entity_field_content_parent    
0 correspondance dans mod0_sabai_entity_field_content_trashed    
0 correspondance dans mod0_sabai_entity_field_field_test    
0 correspondance dans mod0_sabai_entity_field_questions_answer_accepted    
0 correspondance dans mod0_sabai_entity_field_questions_categories    
0 correspondance dans mod0_sabai_entity_field_questions_closed    
0 correspondance dans mod0_sabai_entity_field_questions_resolved    
0 correspondance dans mod0_sabai_entity_field_questions_tags    
0 correspondance dans mod0_sabai_entity_field_taxonomy_body    
0 correspondance dans mod0_sabai_entity_field_taxonomy_content_count    
0 correspondance dans mod0_sabai_entity_field_voting_favorite    
0 correspondance dans mod0_sabai_entity_field_voting_flag    
0 correspondance dans mod0_sabai_entity_field_voting_updown    
0 correspondance dans mod0_sabai_entity_filter    
0 correspondance dans mod0_sabai_file_file    
0 correspondance dans mod0_sabai_file_token    
0 correspondance dans mod0_sabai_system_addon    
0 correspondance dans mod0_sabai_system_adminroute    
0 correspondance dans mod0_sabai_system_permission    
0 correspondance dans mod0_sabai_system_role    
0 correspondance dans mod0_sabai_system_route    
0 correspondance dans mod0_sabai_taxonomy_term    
0 correspondance dans mod0_sabai_taxonomy_term_tree    
0 correspondance dans mod0_sabai_voting_vote    
0 correspondance dans mod0_signups    
0 correspondance dans mod0_smush_dir_images    
0 correspondance dans mod0_snippets    
0 correspondance dans mod0_super_sticky_notes    
0 correspondance dans mod0_termmeta    
3 correspondances dans mod0_terms Parcourir Supprimer
0 correspondance dans mod0_term_relationships    
2 correspondances dans mod0_term_taxonomy Parcourir Supprimer
0 correspondance dans mod0_tm_taskmeta    
0 correspondance dans mod0_tm_tasks    
0 correspondance dans mod0_tripetto_attachments    
0 correspondance dans mod0_tripetto_entries    
0 correspondance dans mod0_tripetto_forms    
0 correspondance dans mod0_trp_dictionary_en_us_fr_fr    
2 correspondances dans mod0_trp_dictionary_en_us_pt_br Parcourir Supprimer
0 correspondance dans mod0_trp_gettext_fr_fr    
0 correspondance dans mod0_trp_gettext_pt_br    
0 correspondance dans mod0_ulike    
0 correspondance dans mod0_ulike_activities    
0 correspondance dans mod0_ulike_comments    
0 correspondance dans mod0_ulike_forums    
0 correspondance dans mod0_ulike_meta    
0 correspondance dans mod0_usermeta    
0 correspondance dans mod0_users    
0 correspondance dans mod0_wc_avatars_cache    
0 correspondance dans mod0_wc_comments_subscription    
0 correspondance dans mod0_wc_feedback_forms    
0 correspondance dans mod0_wc_follow_users    
0 correspondance dans mod0_wc_phrases    
0 correspondance dans mod0_wc_users_rated    
0 correspondance dans mod0_wc_users_voted    
0 correspondance dans mod0_weforms_entries    
0 correspondance dans mod0_weforms_entrymeta    
0 correspondance dans mod0_wfblockediplog    
0 correspondance dans mod0_wfblocks7    
2 correspondances dans mod0_wfconfig Parcourir Supprimer
0 correspondance dans mod0_wfcrawlers    
0 correspondance dans mod0_wffilechanges    
0 correspondance dans mod0_wffilemods    
0 correspondance dans mod0_wfhits    
0 correspondance dans mod0_wfhoover    
0 correspondance dans mod0_wfissues    
98 correspondances dans mod0_wfknownfilelist Parcourir Supprimer
0 correspondance dans mod0_wflivetraffichuman    
0 correspondance dans mod0_wflocs    
0 correspondance dans mod0_wflogins    
0 correspondance dans mod0_wfls_2fa_secrets    
0 correspondance dans mod0_wfls_settings    
0 correspondance dans mod0_wfnotifications    
0 correspondance dans mod0_wfpendingissues    
0 correspondance dans mod0_wfreversecache    
0 correspondance dans mod0_wfsnipcache    
0 correspondance dans mod0_wfstatus    
0 correspondance dans mod0_wftrafficrates    
0 correspondance dans mod0_wise_chat_actions    
0 correspondance dans mod0_wise_chat_bans    
0 correspondance dans mod0_wise_chat_channels    
0 correspondance dans mod0_wise_chat_channel_users    
0 correspondance dans mod0_wise_chat_kicks    
0 correspondance dans mod0_wise_chat_messages    
0 correspondance dans mod0_wise_chat_pending_chats    
0 correspondance dans mod0_wise_chat_sent_notifications    
0 correspondance dans mod0_wise_chat_users    
0 correspondance dans mod0_wm_maps    
ericlucasfr commented 3 years ago

If I search for "bp_docs", I see:

0 correspondance dans mod0_aiowps_events    
0 correspondance dans mod0_aiowps_failed_logins    
0 correspondance dans mod0_aiowps_global_meta    
0 correspondance dans mod0_aiowps_login_activity    
0 correspondance dans mod0_aiowps_login_lockdown    
0 correspondance dans mod0_aiowps_permanent_block    
0 correspondance dans mod0_app_cache    
0 correspondance dans mod0_ap_notifications    
0 correspondance dans mod0_badges    
0 correspondance dans mod0_badge_relationships    
0 correspondance dans mod0_blc_filters    
0 correspondance dans mod0_blc_instances    
0 correspondance dans mod0_blc_links    
0 correspondance dans mod0_blc_synch    
0 correspondance dans mod0_bpges_queued_items    
0 correspondance dans mod0_bpges_subscriptions    
0 correspondance dans mod0_bpic_conversations    
0 correspondance dans mod0_bpic_messages    
0 correspondance dans mod0_bpmts_moderation_categories    
0 correspondance dans mod0_bpmts_moderation_log    
0 correspondance dans mod0_bpmts_moderation_queue    
0 correspondance dans mod0_bpmts_moderation_reports    
0 correspondance dans mod0_bp_activity    
0 correspondance dans mod0_bp_activity_meta    
0 correspondance dans mod0_bp_friends    
0 correspondance dans mod0_bp_groups    
2 correspondances dans mod0_bp_groups_groupmeta Parcourir Supprimer
0 correspondance dans mod0_bp_groups_members    
0 correspondance dans mod0_bp_invitations    
0 correspondance dans mod0_bp_messages_messages    
0 correspondance dans mod0_bp_messages_meta    
0 correspondance dans mod0_bp_messages_notices    
0 correspondance dans mod0_bp_messages_recipients    
0 correspondance dans mod0_bp_mute    
0 correspondance dans mod0_bp_notifications    
0 correspondance dans mod0_bp_notifications_meta    
0 correspondance dans mod0_bp_user_blogs    
0 correspondance dans mod0_bp_user_blogs_blogmeta    
0 correspondance dans mod0_bp_xprofile_data    
0 correspondance dans mod0_bp_xprofile_fields    
0 correspondance dans mod0_bp_xprofile_groups    
0 correspondance dans mod0_bp_xprofile_meta    
0 correspondance dans mod0_commentmeta    
0 correspondance dans mod0_comments    
0 correspondance dans mod0_cpm_file_relationship    
0 correspondance dans mod0_cpm_project_items    
0 correspondance dans mod0_cpm_tasks    
0 correspondance dans mod0_cpm_user_role    
0 correspondance dans mod0_gdpol_votes    
0 correspondance dans mod0_links    
0 correspondance dans mod0_mg2wpforo    
0 correspondance dans mod0_mpp_logs    
0 correspondance dans mod0_ms_snippets    
0 correspondance dans mod0_myCRED_log    
20 correspondances dans mod0_options Parcourir Supprimer
0 correspondance dans mod0_pm_activities    
0 correspondance dans mod0_pm_assignees    
0 correspondance dans mod0_pm_boardables    
0 correspondance dans mod0_pm_boards    
0 correspondance dans mod0_pm_capabilities    
0 correspondance dans mod0_pm_categories    
0 correspondance dans mod0_pm_category_project    
0 correspondance dans mod0_pm_comments    
0 correspondance dans mod0_pm_custom_fields    
0 correspondance dans mod0_pm_files    
0 correspondance dans mod0_pm_gantt_chart_links    
0 correspondance dans mod0_pm_imports    
0 correspondance dans mod0_pm_integrations    
0 correspondance dans mod0_pm_invoice    
0 correspondance dans mod0_pm_meta    
0 correspondance dans mod0_pm_projects    
0 correspondance dans mod0_pm_roles    
0 correspondance dans mod0_pm_role_project    
0 correspondance dans mod0_pm_role_project_capabilities    
0 correspondance dans mod0_pm_role_project_users    
0 correspondance dans mod0_pm_role_user    
0 correspondance dans mod0_pm_settings    
0 correspondance dans mod0_pm_tasks    
0 correspondance dans mod0_pm_task_custom_fields    
0 correspondance dans mod0_pm_task_label    
0 correspondance dans mod0_pm_task_label_task    
0 correspondance dans mod0_pm_task_types    
0 correspondance dans mod0_pm_task_type_task    
0 correspondance dans mod0_pm_time_tracker    
34 correspondances dans mod0_postmeta Parcourir Supprimer
72 correspondances dans mod0_posts Parcourir Supprimer
27 correspondances dans mod0_redirection_404 Parcourir Supprimer
0 correspondance dans mod0_redirection_groups    
0 correspondance dans mod0_redirection_items    
0 correspondance dans mod0_redirection_logs    
0 correspondance dans mod0_reword    
0 correspondance dans mod0_sabai_comment_post    
0 correspondance dans mod0_sabai_comment_vote    
0 correspondance dans mod0_sabai_content_post    
0 correspondance dans mod0_sabai_entity_bundle    
0 correspondance dans mod0_sabai_entity_field    
0 correspondance dans mod0_sabai_entity_fieldcache    
0 correspondance dans mod0_sabai_entity_fieldconfig    
0 correspondance dans mod0_sabai_entity_field_content_activity    
0 correspondance dans mod0_sabai_entity_field_content_body    
0 correspondance dans mod0_sabai_entity_field_content_children_count    
0 correspondance dans mod0_sabai_entity_field_content_featured    
0 correspondance dans mod0_sabai_entity_field_content_guest_author    
0 correspondance dans mod0_sabai_entity_field_content_parent    
0 correspondance dans mod0_sabai_entity_field_content_trashed    
0 correspondance dans mod0_sabai_entity_field_field_test    
0 correspondance dans mod0_sabai_entity_field_questions_answer_accepted    
0 correspondance dans mod0_sabai_entity_field_questions_categories    
0 correspondance dans mod0_sabai_entity_field_questions_closed    
0 correspondance dans mod0_sabai_entity_field_questions_resolved    
0 correspondance dans mod0_sabai_entity_field_questions_tags    
0 correspondance dans mod0_sabai_entity_field_taxonomy_body    
0 correspondance dans mod0_sabai_entity_field_taxonomy_content_count    
0 correspondance dans mod0_sabai_entity_field_voting_favorite    
0 correspondance dans mod0_sabai_entity_field_voting_flag    
0 correspondance dans mod0_sabai_entity_field_voting_updown    
0 correspondance dans mod0_sabai_entity_filter    
0 correspondance dans mod0_sabai_file_file    
0 correspondance dans mod0_sabai_file_token    
0 correspondance dans mod0_sabai_system_addon    
0 correspondance dans mod0_sabai_system_adminroute    
0 correspondance dans mod0_sabai_system_permission    
0 correspondance dans mod0_sabai_system_role    
0 correspondance dans mod0_sabai_system_route    
0 correspondance dans mod0_sabai_taxonomy_term    
0 correspondance dans mod0_sabai_taxonomy_term_tree    
0 correspondance dans mod0_sabai_voting_vote    
0 correspondance dans mod0_signups    
0 correspondance dans mod0_smush_dir_images    
0 correspondance dans mod0_snippets    
0 correspondance dans mod0_super_sticky_notes    
0 correspondance dans mod0_termmeta    
19 correspondances dans mod0_terms Parcourir Supprimer
0 correspondance dans mod0_term_relationships    
34 correspondances dans mod0_term_taxonomy Parcourir Supprimer
0 correspondance dans mod0_tm_taskmeta    
0 correspondance dans mod0_tm_tasks    
0 correspondance dans mod0_tripetto_attachments    
0 correspondance dans mod0_tripetto_entries    
0 correspondance dans mod0_tripetto_forms    
0 correspondance dans mod0_trp_dictionary_en_us_fr_fr    
0 correspondance dans mod0_trp_dictionary_en_us_pt_br    
0 correspondance dans mod0_trp_gettext_fr_fr    
0 correspondance dans mod0_trp_gettext_pt_br    
0 correspondance dans mod0_ulike    
0 correspondance dans mod0_ulike_activities    
0 correspondance dans mod0_ulike_comments    
0 correspondance dans mod0_ulike_forums    
0 correspondance dans mod0_ulike_meta    
3 correspondances dans mod0_usermeta Parcourir Supprimer
0 correspondance dans mod0_users    
0 correspondance dans mod0_wc_avatars_cache    
0 correspondance dans mod0_wc_comments_subscription    
0 correspondance dans mod0_wc_feedback_forms    
0 correspondance dans mod0_wc_follow_users    
0 correspondance dans mod0_wc_phrases    
0 correspondance dans mod0_wc_users_rated    
0 correspondance dans mod0_wc_users_voted    
0 correspondance dans mod0_weforms_entries    
0 correspondance dans mod0_weforms_entrymeta    
0 correspondance dans mod0_wfblockediplog    
0 correspondance dans mod0_wfblocks7    
0 correspondance dans mod0_wfconfig    
0 correspondance dans mod0_wfcrawlers    
0 correspondance dans mod0_wffilechanges    
21 correspondances dans mod0_wffilemods Parcourir Supprimer
0 correspondance dans mod0_wfhits    
0 correspondance dans mod0_wfhoover    
0 correspondance dans mod0_wfissues    
25 correspondances dans mod0_wfknownfilelist Parcourir Supprimer
0 correspondance dans mod0_wflivetraffichuman    
0 correspondance dans mod0_wflocs    
0 correspondance dans mod0_wflogins    
0 correspondance dans mod0_wfls_2fa_secrets    
0 correspondance dans mod0_wfls_settings    
0 correspondance dans mod0_wfnotifications    
0 correspondance dans mod0_wfpendingissues    
0 correspondance dans mod0_wfreversecache    
0 correspondance dans mod0_wfsnipcache    
0 correspondance dans mod0_wfstatus    
0 correspondance dans mod0_wftrafficrates    
0 correspondance dans mod0_wise_chat_actions    
0 correspondance dans mod0_wise_chat_bans    
0 correspondance dans mod0_wise_chat_channels    
0 correspondance dans mod0_wise_chat_channel_users    
0 correspondance dans mod0_wise_chat_kicks    
0 correspondance dans mod0_wise_chat_messages    
0 correspondance dans mod0_wise_chat_pending_chats    
0 correspondance dans mod0_wise_chat_sent_notifications    
0 correspondance dans mod0_wise_chat_users    
0 correspondance dans mod0_wm_maps    
ericlucasfr commented 3 years ago

including these results, for term_taxonomy:

446 446 bp_docs_folder_in_group   0 4 Supprimer Copier Éditer  
447 447 bp_docs_associated_item Docs associated with the group AllianceAutiste | O... 0 2 Supprimer Copier Éditer  
448 448 bp_docs_access   0 0 Supprimer Copier Éditer  
449 449 bp_docs_comment_access   0 0 Supprimer Copier Éditer  
450 450 bp_docs_doc_in_folder   0 0 Supprimer Copier Éditer  
456 456 bp_docs_doc_in_folder   0 0 Supprimer Copier Éditer  
457 457 bp_docs_tag   0 0 Supprimer Copier Éditer  
458 458 bp_docs_tag   0 1 Supprimer Copier Éditer  
459 459 bp_docs_tag   0 1 Supprimer Copier Éditer  
460 460 bp_docs_tag   0 0 Supprimer Copier Éditer  
461 461 bp_docs_doc_in_folder   0 0 Supprimer Copier Éditer  
463 463 bp_docs_access   0 1 Supprimer Copier Éditer  
464 464 bp_docs_comment_access   0 1 Supprimer Copier Éditer  
1005 1005 bp_docs_associated_item Docs associated with the group AllianceAutiste | S... 0 5 Supprimer Copier Éditer  
1006 1006 bp_docs_folder_in_group   0 1 Supprimer Copier Éditer  
1007 1007 bp_docs_doc_in_folder   0 5 Supprimer Copier Éditer  
1008 1008 bp_docs_access   0 0 Supprimer Copier Éditer  
1009 1009 bp_docs_comment_access   0 0 Supprimer Copier Éditer  
1011 1011 bp_docs_doc_in_folder   0 0 Supprimer Copier Éditer  
1012 1012 bp_docs_tag   0 5 Supprimer Copier Éditer  
1013 1013 bp_docs_tag   0 3 Supprimer Copier Éditer  
1014 1014 bp_docs_tag   0 2 Supprimer Copier Éditer  
1015 1015 bp_docs_tag   0 5 Supprimer Copier Éditer  
1016 1016 bp_docs_access   0 6 Supprimer Copier Éditer  
1017 1017 bp_docs_comment_access   0 6 Supprimer Copier Éditer  
1018 1018 bp_docs_tag   0 0 Supprimer Copier Éditer  
1019 1019 bp_docs_tag   0 2 Supprimer Copier Éditer  
1020 1020 bp_docs_tag   0 2 Supprimer Copier Éditer  
1023 1023 bp_docs_doc_in_folder   0 1 Supprimer Copier Éditer  
1024 1024 bp_docs_doc_in_folder   0 1 Supprimer Copier Éditer  
1025 1025 bp_docs_tag   0 1 Supprimer Copier Éditer  
1026 1026 bp_docs_tag   0 1 Supprimer Copier Éditer  
1027 1027 bp_docs_tag   0 1 Supprimer Copier Éditer  
1028 1028 bp_docs_tag   0 1
ericlucasfr commented 3 years ago

and this for posts:

ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count  
1658 1 2019-07-30 22:28:32 2019-07-31 01:28:32   Org-Aut_AllianceAutiste-org   trash closed closed   org-aut_allianceautiste-org_orgintl__trashed     2021-01-02 04:28:05 2021-01-02 07:28:05   0 https://autistance.org/bp_docs_folder/org-aut_alli... 0 bp_docs_folder   0 Supprimer Copier Éditer  
1662 1 2019-07-30 23:15:19 2019-07-31 02:15:19   OrgIntl   trash closed closed   orgintl__trashed     2021-01-02 04:28:05 2021-01-02 07:28:05   1658 https://autistance.org/bp_docs_folder/orgintl/ 0 bp_docs_folder   0 Supprimer Copier Éditer  
1665 1 2019-07-30 23:17:29 2019-07-31 02:17:29   ONU-CDPH Rapport 2020   trash closed closed   onu-cdph-rapport-2020__trashed     2021-01-02 04:28:05 2021-01-02 07:28:05   1662 https://autistance.org/bp_docs_folder/org-aut_alli... 0 bp_docs_folder   0 Supprimer Copier Éditer  
7574 268 2021-01-10 16:00:02 2021-01-10 19:00:02   {Classes de neige}   publish closed closed   classe-de-neige     2021-01-10 16:00:02 2021-01-10 19:00:02   0 https://autistance.org/bp_docs_folder/classe-de-ne... 0 bp_docs_folder   0 Supprimer Copier Éditer  
7614 268 2021-01-03 20:39:20 2021-01-03 23:39:20   {Examen 2021}   publish closed closed   rapport-2021     2021-01-03 20:39:20 2021-01-03 23:39:20   0 https://autistance.org/bp_docs_folder/rapport-2021... 0 bp_docs_folder   0 Supprimer Copier Éditer  
7619 1 2021-01-02 14:24:43 2021-01-02 17:24:43 [do_widget id=thechamplogin-5][do_widget id=wpte... Home (General Dashboard)   publish open closed   home     2021-01-05 17:28:03 2021-01-05 20:28:03   0 https://autistance.org/?page_id=7619 0 page   0 Supprimer Copier Éditer  
7623 1 2021-01-06 01:55:33 2021-01-06 04:55:33 [do_widget id=thechamplogin-5][do_widget id=wptel... Home (General Dashboard)   inherit closed closed   7619-autosave-v1     2021-01-06 01:55:33 2021-01-06 04:55:33   7619 https://autistance.org/7619-autosave-v1/ 0 revision   0 Supprimer Copier Éditer  
7624 1 2021-01-02 21:21:27 2021-01-03 00:21:27 [do_widget id=widget_recent_bp_docs-4]

My Pro...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:21:27 2021-01-03 00:21:27   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7625 1 2021-01-02 21:25:11 2021-01-03 00:25:11

My Projects

<iframe src="https://autista...		 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:25:11 2021-01-03 00:25:11   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7626 1 2021-01-02 21:37:12 2021-01-03 00:37:12 [do_widget id=thechamplogin-5]

Re...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:37:12 2021-01-03 00:37:12   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7627 1 2021-01-02 21:44:00 2021-01-03 00:44:00 [do_widget id=thechamplogin-5]

[b...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:44:00 2021-01-03 00:44:00   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7628 1 2021-01-02 21:50:35 2021-01-03 00:50:35 [do_widget id=thechamplogin-5]

Re...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:50:35 2021-01-03 00:50:35   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7629 1 2021-01-02 21:52:31 2021-01-03 00:52:31 [do_widget id=thechamplogin-5]

Re...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:52:31 2021-01-03 00:52:31   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7630 1 2021-01-02 21:53:54 2021-01-03 00:53:54 [do_widget id=thechamplogin-5]

Re...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 21:53:54 2021-01-03 00:53:54   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7631 1 2021-01-02 22:00:18 2021-01-03 01:00:18 [do_widget id=thechamplogin-5]

Re...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:00:18 2021-01-03 01:00:18   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7632 1 2021-01-02 22:05:58 2021-01-03 01:05:58 [do_widget id=thechamplogin-5]<span style="fon... Home   inherit closed closed   7619-revision-v1     2021-01-02 22:05:58 2021-01-03 01:05:58   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7633 1 2021-01-02 22:07:07 2021-01-03 01:07:07 [do_widget id=thechamplogin-5]<span style="fon... Home   inherit closed closed   7619-revision-v1     2021-01-02 22:07:07 2021-01-03 01:07:07   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7634 1 2021-01-02 22:15:13 2021-01-03 01:15:13 [do_widget id=thechamplogin-5]<span style="fon...     inherit closed closed   7619-revision-v1     2021-01-02 22:15:13 2021-01-03 01:15:13   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7635 1 2021-01-02 22:21:11 2021-01-03 01:21:11 [do_widget id=thechamplogin-5]Questions and An... Home   inherit closed closed   7619-revision-v1     2021-01-02 22:21:11 2021-01-03 01:21:11   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7636 1 2021-01-02 22:23:36 2021-01-03 01:23:36 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:23:36 2021-01-03 01:23:36   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7637 1 2021-01-02 22:29:44 2021-01-03 01:29:44 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:29:44 2021-01-03 01:29:44   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7638 1 2021-01-02 22:34:44 2021-01-03 01:34:44 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:34:44 2021-01-03 01:34:44   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7639 1 2021-01-02 22:44:22 2021-01-03 01:44:22 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:44:22 2021-01-03 01:44:22   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7640 1 2021-01-02 22:44:49 2021-01-03 01:44:49 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:44:49 2021-01-03 01:44:49   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7641 1 2021-01-02 22:46:47 2021-01-03 01:46:47 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:46:47 2021-01-03 01:46:47   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7642 1 2021-01-02 22:47:59 2021-01-03 01:47:59 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:47:59 2021-01-03 01:47:59   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7643 1 2021-01-02 22:59:54 2021-01-03 01:59:54 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 22:59:54 2021-01-03 01:59:54   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7644 1 2021-01-02 23:01:26 2021-01-03 02:01:26 [do_widget id=thechamplogin-5]

Questions and ...

 Home   inherit closed closed   7619-revision-v1     2021-01-02 23:01:26 2021-01-03 02:01:26   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7645 1 2021-01-02 23:16:02 2021-01-03 02:16:02 [do_widget id=thechamplogin-5]<span style="fon... Home   inherit closed closed   7619-revision-v1     2021-01-02 23:16:02 2021-01-03 02:16:02   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
7646 1 2021-01-02 23:18:09 2021-01-03 02:18:09 [do_widget id=thechamplogin-5]<span style="fon... Home   inherit closed closed   7619-revision-v1     2021-01-02 23:18:09 2021-01-03 02:18:09   7619 https://autistance.org/7619-revision-v1/ 0 revision   0 Supprimer Copier Éditer  
ericlucasfr commented 3 years ago

(in the list above, there are only 2 rows relevant for BP Docs, I mean 2 directories with docs inside)

7574 268 2021-01-10 16:00:02 2021-01-10 19:00:02   {Classes de neige}   publish closed closed   classe-de-neige     2021-01-10 16:00:02 2021-01-10 19:00:02   0 https://autistance.org/bp_docs_folder/classe-de-ne... 0 bp_docs_folder   0 Supprimer
7614 268 2021-01-03 20:39:20 2021-01-03 23:39:20   {Examen 2021}  
boonebgorges commented 3 years ago

Thanks for sharing this info. I can see from what you've provided that at least some of the necessary bp_docs_access terms exist. It's still not clear from what you've shown here whether they're in use by the proper docs, though. Try running this kind of query from PHPMyAdmin:

select * from mod0_term_relationships where term_taxonomy_id in ( select mod0_term_taxonomy.term_taxonomy_id from mod0_term_taxonomy join mod0_terms on mod0_term_taxonomy.term_id = mod0_terms.term_id where mod0_term_taxonomy.taxonomy = 'bp_docs_access' and mod0_terms.slug = 'bp_docs_access_anyone' );

ericlucasfr commented 3 years ago

Hello, thanks for trying to help me....

It's very complicated for me and I'm overwhelmed by tons of problems and things to do...

How can I run that query in PHPMyAdmin please ? I can access PHPMyAdmin, but then I don't know what to do...

I have another question : how is it possible to paste (or export) a text made with MS Word, with styles, colors etc., into a BP Doc ? I tried various ways but I could not keep the colors. Which makes the doc almost impossible to understand...

image

image

(this is the "almost good" way that I found, by saving the .docx as .htm and then pasting "not as text". But the colors are missing... (and the styles are not respected)

Thanks !