[Give 2.0] MySQL error after updating on Email Preview

[mathetos]

Issue Overview

After updating to Give 2.0 and running DB updates in multiple environments, I get the following MySQL errors displayed in the Email Preview screen:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1530494977' at line 1]
SELECT wp_posts.post_status, COUNT(wp_posts.ID) FROM wp_posts WHERE wp_posts.post_type = 'give_payment' AND wp_posts.post_status IN ('abandoned','cancelled','failed','pending','preapproval','processing','publish','refunded','revoked') AND wp_posts.post_parent=0 GROUP BY wp_posts.post_status ORDER BY wp_posts.ID DESC LIMIT 0,-1530494977;

I've reproduced this in two different installs, though the same environment with Desktop Server. I experimented with changing the Database tables from InnoDB to MyISAM and running the MySQL repair and optimize functions, but without any affect at all.

Happy to provide a DB dump for anyone who wants to test.

WordPress Environment

``` ### WordPress Environment ###

Home URL: http://giveplugin.dev.cc
Site URL: http://giveplugin.dev.cc
WP Version: 4.9.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
Permalink Structure: /%category%/%postname%/
Show on Front: posts
Table Prefix Length: 3
Table Prefix Status: Acceptable
Admin AJAX: Accessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, refunded, failed, revoked, cancelled, abandoned, processing, preapproval, give_subscription

Server Environment

Hosting Provider: DBH: 127.0.0.1, SRV: giveplugin.dev.cc
TLS Connection: Connection uses TLS 1.2
TLS Connection: Probably Okay
Server Info: Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.5.24
PHP Version: ❌ 5.5.24 - We recommend a minimum PHP version of 5.6. See: PHP Requirements in Give
PHP Post Max Size: 512 MB
PHP Time Limit: 600
PHP Max Input Vars: 5000
PHP Max Upload Size: 512 MB
cURL Version: 7.40.0, OpenSSL/1.0.1l
SUHOSIN Installed: –
MySQL Version: 5.6.24
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
gzip: ✔
GD Graphics Library: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

Give Configuration

Give Version: 2.0.0
Give Cache: Enabled
Database Updates: All DB Updates Completed.
Give Cache: Enabled
Give Cache: ✔New Donation✔Donation Receipt✔New Offline Donation✔Offline Donation Instructions✔New User Registration✔User Registration Information✔Email access
Upgraded From: –
Test Mode: Enabled
Currency Code: USD
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: http://giveplugin.dev.cc/donation-confirmation/
Failure Page: http://giveplugin.dev.cc/donation-failed/
Donation History Page: http://giveplugin.dev.cc/donation-history/
Give Forms Slug: /donations/
Enabled Payment Gateways: Test Donation, Offline Donation
Default Payment Gateway: Test Donation
PayPal IPN Verification: Disabled
PayPal IPN Notifications: N/A
Donor Email Access: Enabled

Session Configuration

Give Use Sessions: Enabled
Session: Disabled

Active Give Add-ons

Give - MailChimp: ❌ Unlicensed – by WordImpress – 1.3.6
Give - PDF Receipts: ❌ Unlicensed – by WordImpress – 2.2.4
Give - Recurring Donations: ❌ Unlicensed – by WordImpress – 1.5.4

Other Active Plugins

Email Cop: by Ashfame – 0.1.1
Give - Hook Helper: by Ravinder Kumar – 1.0
Give Snippets: by GiveWP.com –
User Role Editor: by Vladimir Garagulya – 4.39

Inactive Plugins

Adminimize: by Frank Bültge – 1.11.4
Advanced Custom Fields: by Elliot Condon – 4.0.0
Akismet Anti-Spam: by Automattic – 4.0.2
Autoptimize: by Frank Goossens (futtta) – 2.3.1
Debug Bar: by wordpressdotorg – 0.9
Debug Bar Console: by koopersmith – 0.3
Debug Bar Post Meta: by whyisjake – 0.5.4
Give - Authorize.net Gateway: by WordImpress – 1.3.3
Give - CCAvenue Gateway: by WordImpress – 1.0
Give - Fee Recovery: by WordImpress – 1.3.6
Give - Fee Recovery Historical Donations Helper: by GiveWP.com –
Give - Form Field Manager: by WordImpress – 1.2.4
Give - GoCardless Gateway: by WordImpress – 1.0.0
Give - Google Analytics Donation Tracking: by WordImpress – 1.1.1
Give - iATS Payment Solutions: by WordImpress – 1.0.1
Give - Manual Donations: by WordImpress – 1.2.2
Give - PayPal Pro Gateway: by WordImpress – 1.1.4
Give - Per Form Emails: by WordImpress – 1.0.2
Give - Razorpay: by WordImpress – 1.1.0
Give - Stripe Gateway: by WordImpress – 1.5.2
Give - Tributes: by WordImpress – 1.3.2
Give Simple Ticket Incrementer: by GiveWP.com –
Hello Dolly: by Matt Mullenweg – 1.6
Simply Show Hooks: by Stuart O'Brien, cxThemes – 1.2.1
Super Socializer: by Team Heateor – 7.9.7
Toggle Admin Notices: by Tom McFarlin – 0.1.0
User Switching: by John Blackbourn – 1.3.0
WP-Optimize: by David Anderson, Ruhani Rabin, Team Updraft – 2.1.1
WP Rollback: by WordImpress – 1.5
Yoast SEO: by Team Yoast – 5.9.3

Theme

Name: Twenty Seventeen
Version: 1.4
Author URL: https://wordpress.org/
Child Theme: No – If you're modifying Give on a parent theme you didn't build personally, then we recommend using a child theme. See: How to Create a Child Theme

</details>

[emgk]

This issue is related to #2533 and can be reproduced only on Windows OS machine with any local web server like xampp and not with Local by flywheel, if you check the Server Info: of this issue it is Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.5.24 which is same as mentioned in #2533 ( except PHP version)

reduce the number posts_per_page from 999999999999999 to 99999999999 would solve this issue.
https://github.com/WordImpress/Give/blob/master/includes/payments/class-payments-query.php#L847

ref:
https://stackoverflow.com/a/864402