wrong LIMIT end variable

  • Resolved andrewgosali

    (@andrewgosali)


    6 years, 6 months ago

    Hi Scott Kingsley Clark,

    in the file of /exports-and-reports/wp-admin-ui/Admin.class.php line 1719 (plugin version 0.7.2)

    I reckon that it should just be
    $end = $this->limit;
    instead of
    $end = ($this->page-1)*$this->limit+$this->limit;

    As I believe that the second argument in the LIMIT is not the index of the end, but it should be the range
    https://www.w3schools.com/php/php_mysql_select_limit.asp

    Can you check and confirm this?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    6 years, 6 months ago

    Working on a release that fixes this now, watch for 0.7.3 today.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    6 years, 6 months ago

    It’s out now, thanks again for your post

    Thread Starter andrewgosali

    (@andrewgosali)

    6 years, 6 months ago

    Awesome! Thanks a lot for the quick reply. This plugin has been super helpful.

    Cheers.

    cybersurfer411

    (@cybersurfer411)

    6 years, 5 months ago

    Hi,

    Has this issue been resolved? I installed the most recent version of the Plugin but the query does not return any data for the report. I tried the Debug option and the query’s Limit variable seems to be causing errors in the MySQL IDE.

    ‘My query’ is simple and queries a View and generates data via the IDE without issues.

    My Query: SELECT * FROM wp_test_db.rpt_60_day;

    Debug query generated: SELECT SQL_CALC_FOUND_ROWS * FROM wp_test_db.rpt_60_day; LIMIT 0,25

    cybersurfer411

    (@cybersurfer411)

    6 years, 5 months ago

    I was able to fix it. Please ignore. Thank you!!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘wrong LIMIT end variable’ is closed to new replies.

Tags