Check_Process Errors

I upgraded from 1.5.1 to 1.5.3 about 3 months ago, and everything seemed okay until a customer recently called to inform me that he received an error when making his payment. So I logged in to see if I could duplicate the issue and found that the cart is fine, the shipping is added without problems, tax is fine but when customer submits payment via credit card or check/money order it take them to a HTTP 500 Internal Server Error on https://atmospherebooks.com/webstore/index.php?main_page=checkout_process. When the page is refreshed it says: Array ( [0] => This transaction has already been marked as authorized (CartID : 47186) ), what can I do to fix this?

Are there any myDEBUG log files in your /logs folder?

Yes hundreds maybe:blush:, is that a bad thing?

They indicate an error. Are they all the same size? Please the contents of one of them, and indicate which credit card module you are using.

Also note, that page is supposed to be transient - how were you able to "refresh" the page?

Not sure, I started reading some of them and most are rather small but 3 the last 5 are 1,004 bytes each, then the last 2 are only 193 bytes. There is also some zcInstalllogs and zcExceptions.

This is the content of one of the 1,004 bytes:
text/plain myDEBUG-adm-1411154489-923174.log
ASCII text, with very long lines

[19-Sep-2014 14:21:29 America/Chicago] PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/sammirah/public_html/webstore/zcadmin/includes/functions/extra_functions/recaptcha_functions.php:128) in /home/sammirah/public_html/webstore/includes/functions/sessions.php on line 115
[19-Sep-2014 14:21:29 America/Chicago] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/sammirah/public_html/webstore/zcadmin/includes/functions/extra_functions/recaptcha_functions.php:128) in /home/sammirah/public_html/webstore/zcadmin/includes/init_includes/init_templates.php on line 28
[19-Sep-2014 14:21:29 America/Chicago] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/sammirah/public_html/webstore/zcadmin/includes/functions/extra_functions/recaptcha_functions.php:128) in /home/sammirah/public_html/webstore/zcadmin/includes/functions/general.php on line 26

This is the last of the two 192 bytes:
text/x-log myDEBUG-adm-1412801140-603921.log
ASCII text

[08-Oct-2014 15:45:41 America/Chicago] PHP Fatal error: Call to undefined method PHPMailer::SetFrom() in /home/sammirah/public_html/webstore/includes/functions/functions_email.php on line 254

I think I am using the CEON module.

These are admin side logs - which you will still need to resolve - let's stick with fixing your checkout for now. You should have debug logs which do not contain the string "adm" in the filename - can you post one of those?

Ok I will search for them. Could it also be because I have some plugins that need to be updated?

This one is from the day after I upgrade from 1.5.1 to 1.5.3:

text/plain myDEBUG-1406822111-31085.log
ASCII text

[31-Jul-2014 10:55:12 America/Chicago] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
from zen_countries where status != 0 order by countries_name ==> (as called by) /home/sammirah/public_html/webstore/includes/functions/functions_lookups.php on line 47 <== in /home/sammirah/public_html/webstore/includes/classes/db/mysql/query_factory.php on line 155

This one is more recent:
text/x-log myDEBUG-1410822208-280974.log
ASCII text

[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_customer_auth.php on line 30
[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_header.php on line 72
[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_header.php on line 130

[24-Aug-2014 21:36:44 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/functions/functions_lookups.php on line 712

This one shows the most significant change from 215 bytes to 512 bytes:

text/x-log myDEBUG-1410822208-280974.log
ASCII text

[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_customer_auth.php on line 30
[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_header.php on line 72
[15-Sep-2014 18:03:29 America/Chicago] PHP Warning: strstr(): Empty delimiter in /home/sammirah/public_html/webstore/includes/init_includes/init_header.php on line 130

Having similar problem once upgraded to 1.5.3 ...

[10-Nov-2014 12:18:51] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
from vrz_countries where status != 0 order by countries_name ==> (as called by) /home3/XXX/public_html/XXX/includes/functions/functions_lookups.php on line 47 <== in /home3/XXX/public_html/XXX/includes/classes/db/mysql/query_factory.php on line 155

When did you upgrade to v153?

If you check the files, on the server, for:
/includes/configure.php
/your_secret_admin/includes/configure.php

are both using the same database information?

kdwhd:

Having similar problem once upgraded to 1.5.3 ...

[10-Nov-2014 12:18:51] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
from vrz_countries where status != 0 order by countries_name ==> (as called by) /home3/XXX/public_html/XXX/includes/functions/functions_lookups.php on line 47 <== in /home3/XXX/public_html/XXX/includes/classes/db/mysql/query_factory.php on line 155
Zen Cart v1.5.3 was updated to include "Selectable Countries", which added the 'status' column to the Zen Cart "countries" table. It sounds like you didn't run the database upgrade script when you performed the upgrade.

Ajeh:

When did you upgrade to v153?

If you check the files, on the server, for:
/includes/configure.php
/your_secret_admin/includes/configure.php

are both using the same database information?

Yes, they are the same.

1.5.1 was installed about 2 months ago and sat there. No modifications done. I upgraded to 1.5.3 about 1.5 weeks ago.

Doh .....

kdwhd:

Doh .....
What means "Doh"?

It's an exclamation made by an American cartoon character named Homer Simpson. He says it when he realizes he's made a mistake, done something silly or gets frustrated.

swguy:

It's an exclamation made by an American cartoon character named Homer Simpson. He says it when he realizes he's made a mistake, done something silly or gets frustrated.
Yes, I was trying to get to the bottom of the "Doh" -- i.e. what did kdwhd discover.

I upgraded to 1.5.3 on July 30th. Everything seemed to have been ok. But, now how do I fix my check out?

sammirah:

I upgraded to 1.5.3 on July 30th. Everything seemed to have been ok. But, now how do I fix my check out?
You could start by describing what's wrong with your checkout. Do you have any checkout-related plugins installed? Are there myDEBUG log files generated during the checkout process?

I am not sure, I posted all of the debug files I found on the 1st page of this thread. I will do a test order and see if a new one shows up. When customers get to the submit order button it shows a blank Error Page. I posted that in beginning. I am thinking there are some plugins that need updating but haven't gotten around to them. I am not sure if there are plugins connected to that page in general.

So, I tried this to see if it would work. I uploaded my old back up, which shares the same database. I changed the current zen cart to another name and change the old one to the site name. When I logged into make a purchase it processed everything without any issues. My only issue is I have a bunch of new products in the database without the pictures, but most importantly it says that Zen Cart 1.5.1 with Database 1.5.3 and I know that is going to cause problems somewhere along the way. Whereas I can replace the images the images, I can't replace "what works" when it comes to functionality. But I am scare to upgrade to 1.5.3 - how bad is having a zen cart mismatched with the database, and any suggestions on how to upgrade without once again losing functionality?