Zen Cart Logo
Forums / General Questions / problem confirming order with downloadable items

problem confirming order with downloadable items

Locked

Views: 1,375

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
25 Aug 2006, 4:34 PM
#1
marko718 avatar

marko718

New Zenner

Join Date:
Aug 2006
Posts:
4
Plugin Contributions:
0

problem confirming order with downloadable items

I get the following error when trying to confirm an order for a virtual product.

1264 Out of range value adjusted for column 'delivery_address_format_id' at row 1

The value for 'delivery_address_format_id' is blank. I think the problem has to do with the download attribute itself, as adding it to an item that previously worked causes that item to return the above error when purchased.

25 Aug 2006, 8:32 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: problem confirming order with downloadable items

What version of Zen Cart, and what version of MySQL?

25 Aug 2006, 8:37 PM
#3
marko718 avatar

marko718

New Zenner

Join Date:
Aug 2006
Posts:
4
Plugin Contributions:
0

Re: problem confirming order with downloadable items

I am using Zen Cart 1.3.0.2 and MySQL 5.0.22-community-nt.

28 Aug 2006, 3:07 PM
#4
marko718 avatar

marko718

New Zenner

Join Date:
Aug 2006
Posts:
4
Plugin Contributions:
0

Re: problem confirming order with downloadable items

problem solved!

28 Aug 2006, 3:40 PM
#5
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

Re: problem confirming order with downloadable items

Perhaps you would let us know how you solved this problem?

28 Aug 2006, 3:50 PM
#6
marko718 avatar

marko718

New Zenner

Join Date:
Aug 2006
Posts:
4
Plugin Contributions:
0

Re: problem confirming order with downloadable items

I turned strict_trans_tables off in mySQL. Which I tried on the basis of this thread, which I didn't find during my initial search.

14 Jan 2007, 9:14 PM
#7
hadog avatar

hadog

New Zenner

Join Date:
Jan 2007
Posts:
3
Plugin Contributions:
0

Re: problem confirming order with downloadable items

Hello
I am having the same problem, how and where do I turn this mysql option off???