When a visitor registers on our site, they are taken to authorize.net and successfully pay, everything happens properly (successful payment, registration on back end, emails sent successfully), except when the user returns to the website, they encounter an error:
Notice: Constant _JEXEC already defined in [site path]/components/com_dtregister/success.php on line 25
Notice: Constant JPATH_BASE already defined in [site path]/components/com_dtregister/success.php on line 127
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
We've had other issues with visitors returning to the site before and getting strange errors, but the errors have been different than this. We host multiple sites, and only just became aware of this issue (though according to the log files, it's been happening for at least a month). We can't tell when it started, because registrations on the various sites are sporadic, and we only found out because a visitor mentioned it. Otherwise, the registrations are completing properly.
We are running the most current Joomla version as well as the most current dtregister version, and I reinstalled it to see if that helped, which it did not. It is happening on all sites that we use dtregister on on the same server.
Thank you for any help or direction you can provide.
Several people have contacted us because they aren’t sure their transaction has occurred, or been approved, or in this case timing out of the transaction.