Version 2.7.0: Multiple Duplicate Payment emails

[asten77]

Verify the Following
Reporting About the Latest Version? Yes

Searched Issue Reports for Bug? Yes

Reviewed the Good To Know Issue Reports? Yes

BCOE&M Info
Version: 2.7.0
Installation URL: wortapalooza.clubwort.net
Hosted Installation? no

Describe the Bug
We recently reset the installation for a new year (our 2nd!), following the guide on the website. Everything seems to be working, except anyone who pays via paypal is getting multiple duplicate emails. Some people have gotten dozens for one transaction. All have the same PayPal transaction ID. I verified we're only getting one payment. This is using standard php mail(), and worked successfully last competition under pre 2.6.

This installation was originally on a pre 2.6, upgraded to 2.6.2 a few months ago, and upgraded to 2.7.0 today to see if it's still a problem - which it is.

This may or may not be related, but in the error_log, we get lots of these:

[07-May-2024 15:22:01 America/Chicago] PHP Notice: Undefined variable: to_email_formatted in //ppv.php on line 162
[07-May-2024 15:22:01 America/Chicago] PHP Notice: Undefined variable: from_name in //ppv.php on line 176
[07-May-2024 15:22:06 America/Chicago] PHP Fatal error: Uncaught Exception: Table 'bcoem.payments' doesn't exist query: INSERT INTO payments (uid, first_name, last_name, item_name, txn_id, payment_gross, currency_code, payment_status, payment_entries, payment_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) in //site/MysqliDb.php:2014
Stack trace:
#0 //site/MysqliDb.php(1602): MysqliDb->_prepareQuery()
#1 //site/MysqliDb.php(1541): MysqliDb->_buildQuery(NULL, Array)
#2 /site/MysqliDb.php(834): MysqliDb->_buildInsert('payments', Array, 'INSERT')
#3 /ppv.php(252): MysqliDb->insert('payments', Array)
#4 {main}
thrown in //site/MysqliDb.php on line 2014

To Reproduce

1. Pay for an entry with PayPal.
2. Wait for email flood!

Expected Behavior
We'd expect a single email.

Screenshots

Server Environment

• PHP Version: 7.4
• MySQL Version: 10.6.17-MariaDB
• Other Info: [if applicable. Apache, nginx, etc.]

Local Environment
Seems unrelated - multiple remote users

Additional Context
There is certainly no bcoem.payments table in the database. I tried a new install of 2.6.2 and noticed it didn't create a bcoem.payments table either, not sure if this is a gigantic red herring.