Database tables order by records issue

  • Resolved Scribit

    (@scribit)


    3 months, 1 week ago

    In the WP Optimize Database page, if I order tables by records number, it order rows considering values in alphabetical (maybe ignoring thousands separator) and not numerical order.

    So for example I see tables
    wp_table1 866 records
    wp_table2 546.895 records
    wp_table3 493 records

    Note that my site has italian language and plugin has 3.4.2 version.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wpmansour

    (@wpmansour)

    I have cross-checked this on my end, and the sorting by the number of records works as expected.

    Could you please share a screenshot or screen recording for further investigation?

    Thread Starter Scribit

    (@scribit)

    I suppose it depends on language decimals/thousands separator. I have dot for thousands.

    The screenshot upload seems bugged for me. Here the link to the screenshot: https://ibb.co/5jzKMpF

    Plugin Support wpmansour

    (@wpmansour)

    The issue might be due to some plugin overwriting the functionality. I suggest disabling your plugins one by one to see if any of them are causing the problem.

    Additionally, please review any custom configurations or code that might be affecting the sorting functionality. Make sure to take a database backup before performing this task.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.