Support » Plugin: LifterLMS - WordPress LMS Plugin » deleting lifter from database

  • Resolved blueoaks

    (@blueoaks)


    I recently tried Lifter and later decided it wasnt what I needed. I deleted the plugin from my site but upon inspection of my database I see it has left behind nearly 1000 tables in wp_postmeta.

    I tried deleting everything that starts with _llms but this broke my site (my main menu specifically)

    The Advanced Database Cleaner plugin shows these as ‘options’ in the db but I am a bit afraid to delete this way as I have already had to restore my db once. WP-Optimize doesnt see them.

    Is there a tool or any good way to *completely* remove Lifter from my db?

    • This topic was modified 5 years ago by blueoaks.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Thomas Patrick Levy

    (@thomasplevy)

    @blueoaks,

    I regret to note that I have been very slowly adding things to our uninstall script. This is the kind of thing that our dedicated users do not care about and, therefore, I have a hard time justifying as a “new feature” — I do almost all the development on my own as well as the majority of our support and this is a bit inexcusable but it’s the truth: I do not have a 1-click “cleanse of LifterLMS stuff” for you…

    That said, if you add the following to your wp-config.php file and then deactivate LifterLMS — most options and some content created by LifterLMS will be deleted upon plugin deactivating:

    define( 'LLMS_REMOVE_ALL_DATA', true );

    After deactivating you can then remove that from your config file.

    As far as deleting other content:

    1) Delete custom posts from your wp_posts table: course, lesson, llms_quiz, llms_question, llms_membership, llms_access_plan

    2) Delete custom tables — anything that starts with “wp_lifterlms_” can be safely deleted

    3) Theres is a ton of postmeta data that will be left behind. I wish there was a foolproof way to do this (part of the reason why I don’t have a great uninstall script yet is it is a bit difficult to idenfity)…

    Anything with the meta_key starting with _llms can be deleted. I’m not sure why your menu would have broken. I’m sorry I can’t explain that.

    Hope that helps,

    Thread Starter blueoaks

    (@blueoaks)

    I believe this will be helpful and I appreciate the response.

    What about the wp_options table? I see several hundred lifterlms rows there. Many begin with _wp_session and _wp_session_expires_ <- are these also Lifterlms related? They seem to be mixed in with the rows that are clearly from Lifter.

    Cheers

    Plugin Author Thomas Patrick Levy

    (@thomasplevy)

    @blueoaks,

    I cannot guarantee that the session related fields are definetly from LifterLMS — we use a very commonly used session library (https://github.com/ericmann/wp-session-manager) and I can’t promise that another plugin you have installed isn’t also using that (and therefore adding session records).

    Luckily it’s self cleaning so they go away after a while. You can clear them if you like but I don’t promise you that they’re definetly generated by LifterLMS.

    The constant to your wp-config.php file will remove all LifterLMS generated options during plugin deactivation.

    Theses are all the ones with llms_ or lifterlms_ prefixes

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘deleting lifter from database’ is closed to new replies.