Jason that didn't work but could this be part of the problem?
"Warning: require_once(/public_html/pear/Log/mail.php) [function.require-once]: failed to open stream: No such file or directory in /home1/barrelr2/public_html/webassist/email/PEAR_Mail_using_SMTP_php.php on line 113
Fatal error: require_once() [function.require]: Failed opening required '/public_html/pear/Log/mail.php' (include_path='.:/usr/lib64/php:/usr/lib/php:/usr/share/pear') in /home1/barrelr2/public_html/webassist/email/PEAR_Mail_using_SMTP_php.php on line 113"
Could it be due to an error on the emailing receipt which causes it to not send the receipt nor the info to the database due to the database inclusion is after the emailing? However, the credit card is being processed.
So, to sum it up I guess I have two problems; the database one and an emailing one.
Attached is a zip of the confirm page