Support » Plugin: Oasis Workflow » SQL INT needs to be BIGINT

  • Resolved theo38

    (@theo38)


    Hi there,

    Could you please ensure that within the plugin tables which are setup by the plugin, that they mirror integer sizes of other tables. For example:

    //fc_action_history table
    $table_name = OW_Utility::instance()->get_action_history_table_name();
    if ( $wpdb->get_var( “SHOW TABLES LIKE ‘{$table_name}'” ) != $table_name ) {
    $sql = “CREATE TABLE IF NOT EXISTS {$table_name} (
    ID int(11) NOT NULL AUTO_INCREMENT,
    action_status varchar(20) NOT NULL,
    comment longtext NOT NULL,
    step_id int(11) NOT NULL,
    assign_actor_id int(11) NOT NULL,
    post_id int(11) NOT NULL,
    from_id int(11) NOT NULL,
    due_date date DEFAULT NULL,
    history_meta longtext DEFAULT NULL,
    reminder_date date DEFAULT NULL,
    reminder_date_after date DEFAULT NULL,
    create_datetime datetime NOT NULL,
    PRIMARY KEY (ID)
    ){$charset_collate};”;
    dbDelta( $sql );
    }

    post_id needs to be bigint(20) rather than int(11) to mirror wp_posts table. For both pro and light versions.

    Thanks,
    Theo

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL INT needs to be BIGINT’ is closed to new replies.