ZnoteAAC icon indicating copy to clipboard operation
ZnoteAAC copied to clipboard

IPN Unable to record errors to SQL if error exceeds Varchar 255 limit

Open tysonstrange opened this issue 2 years ago • 0 comments

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;

tysonstrange avatar Apr 11 '22 22:04 tysonstrange