{"id":61566,"date":"2024-02-13T07:40:34","date_gmt":"2024-02-13T12:40:34","guid":{"rendered":"https:\/\/memberpress.com\/docs\/resetting-memberpress-data\/"},"modified":"2024-02-13T17:18:55","modified_gmt":"2024-02-13T22:18:55","slug":"resetting-memberpress-data","status":"publish","type":"ht_kb","link":"https:\/\/memberpress.com\/fr\/docs\/resetting-memberpress-data\/","title":{"rendered":"R\u00e9initialisation des donn\u00e9es du MemberPress"},"content":{"rendered":"

MemberPress ne dispose actuellement pas d'un bouton \u2018 R\u00e9initialiser ' permettant d'effacer toutes les donn\u00e9es contenues dans MemberPress. Cependant, si vous avez besoin de r\u00e9initialiser les donn\u00e9es relatives aux abonnements, aux transactions, aux membres et aux param\u00e8tres, vous pouvez ex\u00e9cuter les requ\u00eates suivantes *<\/strong>:<\/p>

\n\tAvertissement :<\/strong> Cette op\u00e9ration supprimera de mani\u00e8re irr\u00e9versible tous les abonnements, adh\u00e9sions, groupes, r\u00e8gles, rappels, coupons et donn\u00e9es de transaction, ainsi que tous les param\u00e8tres de MemberPress.<\/p>

\n\tNOTE :<\/strong> Il se peut que votre base de donn\u00e9es n'utilise pas la fonction \u201c wp_ \u201d<\/strong> pr\u00e9fixe. Ainsi, si votre base de donn\u00e9es utilise un pr\u00e9fixe diff\u00e9rent, avant d'ex\u00e9cuter les requ\u00eates ci-dessous, veuillez remplacer toutes les occurrences de \u201c wp_ \u201d dans les requ\u00eates afin qu'elles correspondent \u00e0 votre pr\u00e9fixe.<\/p>

TRUNCATE TABLE wp_mepr_subscriptions ;<\/p>
TRUNCATE TABLE wp_mepr_transactions ;<\/p>
TRUNCATE TABLE wp_mepr_events ;<\/p>
TRUNCATE TABLE wp_mepr_members ;<\/p>
TRUNCATE TABLE wp_mepr_jobs ;<\/p>
TRUNCATE TABLE wp_mepr_rule_access_conditions ;<\/p>
TRUNCATE TABLE wp_mepr_tax_rates ;<\/p>
TRUNCATE TABLE wp_mepr_tax_rate_locations ;<\/p><\/pre>
\n\tNOTE :<\/strong> L'ex\u00e9cution de ces scripts ne supprimera pas les utilisateurs de votre site (Tableau de bord > Utilisateurs > Tous les utilisateurs<\/em>). Bien que les comptes WordPress de vos utilisateurs restent intacts, ils ne seront plus consid\u00e9r\u00e9s comme des membres actifs de MemberPress.<\/p>
Ensuite, vous pouvez ex\u00e9cuter les commandes suivantes (elles MUST <\/strong>dans cet ordre) :\u00a0<\/p>
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('memberpresscoupon', 'memberpressgroup', 'memberpressproduct', 'mp-reminder', 'memberpressrule')) ;<\/p>
DELETE FROM wp_posts WHERE post_type IN ('memberpresscoupon', 'memberpressgroup', 'memberpressproduct', 'mp-reminder', 'memberpressrule') ;<\/p>
DELETE FROM wp_options WHERE option_name LIKE '%mepr%' ;<\/p><\/pre>
De plus, si le module compl\u00e9mentaire Comptes d'entreprise est install\u00e9, vous devez ex\u00e9cuter le programme suivant :<\/p>
TRUNCATE TABLE wp_mepr_corporate_accounts ;<\/p><\/pre>
Si vous avez des cours MemberPress, vous devez ex\u00e9cuter la requ\u00eate suivante :<\/p>
TRUNCATE TABLE wp_mpcs_answers ;<\/p>
TRUNCATE TABLE wp_mpcs_attempts ;<\/p>
TRUNCATE TABLE wp_mpcs_questions ;<\/p>
TRUNCATE TABLE wp_mpcs_sections ;<\/p>
TRUNCATE TABLE wp_mpcs_user_progress ;<\/p><\/pre>
puis lancez celui-ci :<\/p>
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('mpcs-course', 'mpcs-lesson', 'mpcs-quiz')) ;<\/p>
DELETE FROM wp_posts WHERE post_type IN ('mpcs-course', 'mpcs-lesson', 'mpcs-quiz') ;<\/p><\/pre>
Pour le module compl\u00e9mentaire PDF Invoices, vous devez ex\u00e9cuter la requ\u00eate suivante :<\/p>
TRUNCATE TABLE wp_mpdf_invoice_numbers ;<\/p>
TRUNCATE TABLE wp_mpdf_credit_notes ;<\/p><\/pre>
Pour le module compl\u00e9mentaire T\u00e9l\u00e9chargements, vous devez ex\u00e9cuter la requ\u00eate suivante :<\/p>
TRUNCATE TABLE wp_mpdl_file_downloads ;<\/p>
TRUNCATE TABLE wp_mpdl_file_stats ;<\/p><\/pre>
\n\tNOTE :<\/strong> Veuillez noter que nous n'ex\u00e9cuterons PAS ces requ\u00eates sur votre site. Vous devrez le faire vous-m\u00eame. Si vous n'\u00eates pas s\u00fbr de savoir comment ex\u00e9cuter ces requ\u00eates, veuillez contacter votre h\u00e9bergeur pour obtenir de l'aide.\u00a0<\/p>","protected":false},"excerpt":{"rendered":"
MemberPress does not currently have a \u2018reset\u2019 button that will erase all data found in MemberPress. However, if you need to\u00a0reset the Subscriptions, Transactions, Members, and settings data you can run the following queries *: TRUNCATE TABLE wp_mepr_subscriptions;TRUNCATE TABLE wp_mepr_transactions;TRUNCATE TABLE wp_mepr_events;TRUNCATE TABLE wp_mepr_members;TRUNCATE TABLE wp_mepr_jobs;TRUNCATE TABLE wp_mepr_rule_access_conditions;TRUNCATE TABLE wp_mepr_tax_rates;TRUNCATE TABLE wp_mepr_tax_rate_locations; Then, you can [\u2026]<\/p>\n","protected":false},"author":62252,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_strive_editorial_status":"not-started","_strive_copy_of":0,"inline_featured_image":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_FSMCFIC_featured_image_caption":"","_FSMCFIC_featured_image_nocaption":"","_FSMCFIC_featured_image_hide":"","_strive_checklists":"\"\"","_strive_active_checklist":"62291e2bb2422","footnotes":""},"ht-kb-category":[1314],"ht-kb-tag":[],"class_list":{"0":"post-61566","1":"ht_kb","2":"type-ht_kb","3":"status-publish","4":"format-standard","6":"ht_kb_category-miscellaneous","7":"entry"},"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t