Znote / ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server.
MIT License
143 stars 127 forks source link

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

Open tysonstrange opened 2 years ago

tysonstrange commented 2 years ago

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;