Automator_DB::mysql_8_auto_increment_fix()

Added this to fix MySQL 8 AUTO_INCREMENT issue with already created tables

Contents

  • Changelog

    • Source Source

    File: src/core/class-automator-db.php

    	public function mysql_8_auto_increment_fix() {
		global $wpdb;
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_recipe_log`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_action_log`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_action_log_meta`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_closure_log`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_closure_log_meta`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_trigger_log`;" );
		$wpdb->query( "ANALYZE TABLE `{$wpdb->prefix}uap_trigger_log_meta`;" );
	}

    Expand full source code Collapse full source code View on Github

    Changelog Changelog

    Changelog
    VersionDescription
    2.9Introduced.