Can’t Stop Table Sorting Automatically

  • Resolved kja03

    (@kja03)


    5 years, 6 months ago

    I cannot seem to stop the table from sorting the rows out of the order I want. And there doesn’t seem to be a way to turn off the sorting… is it ON by default? How can I stop the table from sorting the rows? When I save the table, the preview does not match how I set up the table as the rows are all jumbled up. Please help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    5 years, 6 months ago

    Hi there,

    Sorry for inconvenience,

    We assume that you create Simple table where this issue can happen in current version of plugin. We aware of it and ii will be fixed in next update which will be very soon.

    In meanwhile, you can fix this issue manually. In file
    wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php around line 1088
    you will find this

    "SELECT data FROM " . $wpdb->prefix . "wpdatatables_rows WHERE table_id = %d", $tableID);

    and you have to replace it with this:

    "SELECT data FROM " . $wpdb->prefix . "wpdatatables_rows WHERE table_id = %d ORDER BY id ASC", $tableID);

    This kind of issues are related with servers that have the MyISAM engine in database. Like I said it will be implemented in a new update and you don’t have to worry about that.

    Once again sorry for trouble,

    Best regards.

    FIT

    (@futureit)

    5 years, 6 months ago

    Thank goodness for this post and fix… I thought I’d just wasted hours!

    I’d literally just installed another plugin when I did one last search for a solution.

    Cheers!

    Plugin Author wpDataTables

    (@wpdatatables)

    5 years, 6 months ago

    Hi FIT,

    You are welcome.

    This will be included in next update, so you don’t have to worry about it.

    Sorry for the trouble,

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Can’t Stop Table Sorting Automatically’ is closed to new replies.