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`;" );
    	}
    

    Changelog Changelog

    Changelog
    Version Description
    2.9 Introduced.