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...eckout_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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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 .....

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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?

So I just upgraded to v1.5.4 in order to fix the PayPal Express Checkout problems and now my checkout-process is not working again. To fix this issue in the pass I had to rollback zen cart to v1.5.1 while keep the 1.5.3 database, but now that will not work as the PayPal issues will return. Someone please help! Is there something which has changed between ZC checkout_process between the upgrades between v1.5.1 and v1.5.3 and beyond and how do I fix it? Also I have noticed that there are no order confirmation emails being received following the test orders although they show up in the ZC admin.:frusty:

When logged to do a test order I get the following once the order is confirmed:

Attachment 14855

When that error message appeared, you were completing payment for an order. Can you please explain exactly which payment method had been selected for payment of that order? And which specific payment module handles payments for that method?

... because that error message does not come from any of the built-in modules that come with Zen Cart, including PayPal.

It appears that what you posted today comes also from the same payment module you were having problems with from before the upgrade, so I've merged today's post with the previous discussion, above.

Quote:

---

Originally Posted by DrByte

When that error message appeared, you were completing payment for an order. Can you please explain exactly which payment method had been selected for payment of that order? And which specific payment module handles payments for that method?

... because that error message does not come from any of the built-in modules that come with Zen Cart, including PayPal.

---

Usually when I do test payments I choose payment by check/money order. I have also completed a payment using Paypal and it gave the error upon returning to the site or it sends the customer to a blank page.