Title: wrong LIMIT end variable
Last modified: October 11, 2017

---

# wrong LIMIT end variable

 *  Resolved [andrewgosali](https://wordpress.org/support/users/andrewgosali/)
 * (@andrewgosali)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/)
 * 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](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](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9576852)
 * Working on a release that fixes this now, watch for 0.7.3 today.
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9577013)
 * It’s out now, thanks again for your post
 *  Thread Starter [andrewgosali](https://wordpress.org/support/users/andrewgosali/)
 * (@andrewgosali)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9578736)
 * Awesome! Thanks a lot for the quick reply. This plugin has been super helpful.
 * Cheers.
 *  [cybersurfer411](https://wordpress.org/support/users/cybersurfer411/)
 * (@cybersurfer411)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9664726)
 * 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
    -  This reply was modified 8 years, 6 months ago by [cybersurfer411](https://wordpress.org/support/users/cybersurfer411/).
 *  [cybersurfer411](https://wordpress.org/support/users/cybersurfer411/)
 * (@cybersurfer411)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9664779)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/exports-and-reports.svg)
 * [Exports and Reports](https://wordpress.org/plugins/exports-and-reports/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/exports-and-reports/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/exports-and-reports/)
 * [Active Topics](https://wordpress.org/support/plugin/exports-and-reports/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/exports-and-reports/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/exports-and-reports/reviews/)

## Tags

 * [limit](https://wordpress.org/support/topic-tag/limit/)

 * 5 replies
 * 3 participants
 * Last reply from: [cybersurfer411](https://wordpress.org/support/users/cybersurfer411/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/wrong-limit-end-variable/#post-9664779)
 * Status: resolved