ZnoteAAC
ZnoteAAC copied to clipboard
IPN Unable to record errors to SQL if error exceeds Varchar 255 limit
The line on Paypal IPN.php file tries to log the error to znote_paypal in the event "something is wrong", however it fails to do so because the varchar(255) limit.
Column should be TEXT or something else that supports a longer string in the event it's required to log.
mysql_insert("INSERT INTO `znote_paypal` VALUES ('0', '$txn_id', 'ERROR: Invalid data. $postdata', '0', '0', '0')"); Eg ALTER TABLE znote_paypal MODIFY email TEXT;