Support » Plugin: Hustle - Email Marketing, Lead Generation, Optins, Popups » Extensive database growth in the hustle_modules_meta table

  • Resolved Autostrada

    (@autostrada)


    Hello!

    I use this plugin to show a pop-up for my visitors and recently noticed that the hustle_modules_meta table in the database grew for 50 megabytes in one month. The Hustle module were shown 171907 times with 6% conversion rate.

    What kind of data the plugin stores in this table and how can I prevent the table from such extensive grow?

    Thank you!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Jonathan – WPMU DEV Support

    (@wpmudev-support9)

    Hello @autostrada

    Hope you’re doing well!

    Would you please send to us a copy of the hustle_modules_meta table so we could have a closer look at it? Please upload it fo DropBox or GoogleDrive and email us directly to contact@wpmudev.org. Please include in a subject “Attn: Nastia” so it gets assigned to me and includes a link to this thread.

    Looking forward to your email.

    Kind regards,
    Nastia

    Hello @autostrada!
    It happens because Hustle stores some data ( ip, request uri, time, etc. ) for each showing or submitting forms when tracking is enabled. If you are interesting only to have information about conversation rate and total count of showing and remove additional data ( ip, request uri, time, etc. ) – you could try adding the following snippet in a MU plugin ( more info about MU plugins is here )

    <?php
    function wpmu_hustle_brief_tracking_data( $data ) {
    	return null;
    }
    
    add_filter('hustle_tracking_data', 'wpmu_hustle_brief_tracking_data');

    The hustle_tracking_data filter will be added in 3.0.7 vesrion of the plugin. Until it’s not there you could add it to inc/hustle-model.php file via FTP to _log function
    $data = apply_filters( 'hustle_tracking_data', $data );
    before this line
    return $this->add_meta( $type, $data );

    Also, if you want to delete already existing tracking data – you could temporary add this snippet to the MU plugin

    function wpmu_hustle_remove_old_tracking_data() {
    	global $wpdb;
    	$wpdb->update( $wpdb->prefix . 'hustle_modules_meta', array( 'meta_value' => null ), array( 'meta_key' => 'popup_view' ) );
    	$wpdb->update( $wpdb->prefix . 'hustle_modules_meta', array( 'meta_value' => null ), array( 'meta_key' => 'popup_conversion' ) );
    }
    
    add_action('init', 'wpmu_hustle_remove_old_tracking_data');

    Then refresh any page on your site and remove this part of the MU plugin. Then you should export and import hustle_modules_meta table (it will decrease your 54Mb table to 11Mb).

    Best regards,
    Ivan.

    Plugin Support Jonathan – WPMU DEV Support

    (@wpmudev-support9)

    Hello @autostrada

    Hope all is well!

    We’ve not heard from you in a while. I’ve marked this ticket as resolved for now, but if you need anything else at all, we’re here for you, please just reopen the ticket or create a new one.

    Have a good day and take care!

    Cheers,
    Nastia

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Extensive database growth in the hustle_modules_meta table’ is closed to new replies.