search

impress-org / givewp

GiveWP - The #1 Donation Plugin for WordPress. Easily accept donations and fundraise using your WordPress website.
https://givewp.com/
GNU General Public License v3.0
345 stars 191 forks source link

Large queries should not prevent donations #6527

Closed canny[bot] closed 2 years ago

canny[bot] commented 2 years ago

Details

We are seeing a handful of reports of donations failing with a cryptic error (front end) about contacting site administrators. On the back end in the GiveWP logs the error registers an error about a "Database Query"

The problem seems to be related to the new Models introduced in recent GiveWP versions, and certain servers not being able to handle JOINS over a certain size. We're looking into a fix, but for now the workaround is to get your host to increase the MAX_JOIN_SIZE to something large like 20000. We're treating this bug with urgency, but need to be able to reliably reproduce it first. Please comment here with any ways to reproduce it.

https://givewp.canny.io/admin/board/bug-reports/p/large-queries-should-not-prevent-donations

Acceptance Criteria

canny[bot] commented 2 years ago

This issue has been linked to a Canny post: Large queries should not prevent donations :tada: