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)
  • Plugin Author nuggetsol

    (@nuggetsol)

    Hi Theo,

    Thanks for pointing it out. We will take care of this with our next release.

    Thank you and great work on the plugin, by the way. Might come back with a few minor suggestions at some point.

    Plugin Author nuggetsol

    (@nuggetsol)

    Hi Theo,

    We have pushed a new version of the plugin which fixes the above issue.

    Thanks again for pointing it out.

    theo38

    (@theo38)

    Great, thanks for letting me know.

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