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

  • Resolved 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} (
    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,
    dbDelta( $sql );

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


Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author 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


    Hi Theo,

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

    Thanks again for pointing it out.



    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.