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.
Results 1 to 7 of 7
-
25 Aug 2006, 05:34 PM #1
New Zenner
- Join Date
- Aug 2006
- Posts
- 4
- Plugin Contributions
- 0
problem confirming order with downloadable items
-
25 Aug 2006, 09:32 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,444
- Plugin Contributions
- 279
Re: problem confirming order with downloadable items
What version of Zen Cart, and what version of MySQL?
.
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.
-
25 Aug 2006, 09:37 PM #3
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, 04:07 PM #4
New Zenner
- Join Date
- Aug 2006
- Posts
- 4
- Plugin Contributions
- 0
Re: problem confirming order with downloadable items
problem solved!
-
28 Aug 2006, 04:40 PM #5
Obaa-san
- Join Date
- Jun 2003
- Posts
- 33,721
- Plugin Contributions
- 0
Re: problem confirming order with downloadable items
Perhaps you would let us know how you solved this problem?
-
28 Aug 2006, 04:50 PM #6
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, 10:14 PM #7
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???
Similar Threads
-
Problem Confirming Order
By praiseandplay in forum Addon Payment ModulesReplies: 1Last Post: 18 Aug 2006, 05:53 AM -
payment problem on confirming order
By ritchie111 in forum Built-in Shipping and Payment ModulesReplies: 3Last Post: 3 Jul 2006, 05:18 PM
