Forums / Addon Payment Modules / Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Started by ravins on 10 Jan 2013, 10:20 AM · Views: 1,708

Results 1 to 7 of 7
10 Jan 2013, 10:20 AM
#1
ravins avatar

ravins

New Zenner

Join Date:
Feb 2012
Posts:
14
Plugin Contributions:
0

Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Hi,
I am using zencart v151. It has fec1.11,paypal express checkout,Google checkout addons. added a product to cart,clicked buy with google checkout in shopping cart. completed the order in gc. after order is placed code is tried to redirect to zencart checkout success page. It is giving warning message(please refresh again).
Following message is in logs:

[09-Jan-2013 21:50:17 America/New_York] PHP Fatal error: 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 'LIMIT 1' at line 4 :: UPDATE orders
SET checkbox = '0'
WHERE orders_id =
LIMIT 1 in C:\xxxxxx\xxxxxx\includes\classes\db\mysql\query_factory.php on line 120

Any help is appreciated.

Thanks,
Ravi.

10 Jan 2013, 10:34 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Zen Cart doesn't have a 'checkbox' field in the 'orders' table, so the problem isn't part of Zen Cart original code.
The query you quoted shows that the PHP code generating the query isn't properly including an order number, and thus is generating bad SQL queries. So, whatever you've changed/added on your site is bad code.

Best to remove the things you've added/changed.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

10 Jan 2013, 11:05 AM
#3
ravins avatar

ravins

New Zenner

Join Date:
Feb 2012
Posts:
14
Plugin Contributions:
0

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Thank you Drbyte.
my query_factory.php is unchanged. it is the file came in zencartv1.5.1 version.
I followed instructions provided in google checkout addon installation instructions.
You mentioned,code is generating bad sql query. so seems like google checkout code module is generating bad query.
Also I am able to checkout using paypal express checkout.
Please point me towards next step.

10 Jan 2013, 5:26 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

The problem is NOT with the query_factory script. It's only the "messenger" showing the result of the problem you've got.

I agree that it looks like google checkout is your problem. I recommend you remove it until such time as you determine a working solution.
I haven't used or looked at google checkout in many years. Better to use the support thread for that module.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

11 Jan 2013, 10:27 AM
#5
ravins avatar

ravins

New Zenner

Join Date:
Feb 2012
Posts:
14
Plugin Contributions:
0

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Thank you Drbyte.
I am trying to setup store on localhost first. Initially I thought of having paypal and google checkout. May be I should look for alternatives due to following
1.Based on my test,Paypal express works only when shipping address in zencart is matched with the shipping address in paypal(invoice).(in my test i provided one shipping address in zencart and another on in paypal. order is processed with one in paypal)
2.google check out has this 1064 error.
I see some other recommended payment processing services. Which is best among them?
2.Also Can I test payment modules which require SSL on localhost. If so please provide me some pointers.

Thanks,
Ravi.

11 Jan 2013, 11:00 AM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

Essentially what you are asking has nothing (or very little) to do with zencart.

You need to direct questions about technicalities and functions of payment gateways to the payment gateways themselves. How will any of us know if XYZ payment gateway is operable on an insecure machine under your kitchen table?

You need to put your questions to the providers of these services.

20 years a Zencart User

11 Jan 2013, 11:51 AM
#7
ravins avatar

ravins

New Zenner

Join Date:
Feb 2012
Posts:
14
Plugin Contributions:
0

Re: Blank screen on checkout success after order is placed in Google Checkout, 1064 error

I am sorry If I am asked a wrong question.I am a new to ecommerce world.I thought setup something locally(install zencart,add any addons needed, confirm on payment processing modules).Finalize addons/payment processing modules.Test locally and If one order is placed successfully then implement samething in live.
Based on your reply, I understand that not everything can be setup/tested locally.Since paypal/google checkout have sandbox environment, I thought I should be able to place a test order using sandbox.
Any feedback on my approach and suggestions are appreciated which will help me to move forward.

Thanks,
Ravi.