Does anyone have a fix for an error:
1364 Field 'return_md5' doesn't have a default value
in:
[INSERT INTO 2checkout (start_time, status, amount, session_id) VALUES
(now(), 'Requested', '21.94', '040sjp9an6gnamrqmmclc6att0')]
with ZC version 1.3.8 with Mysql 5.1 ?!?!?
I've tried reapplying the patch to sql, reinstalling the asp modules, nothing changes the error from occuring.
Curt
Seems like it just doesn't like the there being no default value, I've examined the 2checkout table and the return_md5 is set as TEXT with a Null value.
I tried altering to a VARCHAR(50) with a default value of 0, the error no longer appears, however once zencart takes you over to 2checkout you get a parameter error and the entries for the order are blank, I could really use some help out there guys, this module has been out now for nearly 3 years, someone else has had to have encountered this issue and there must be a resolution for it.
Curt
Hi
Please can someone let me know whichi is the current and best 2checkout module for zen cart and where to download it from?
Are there any problems with this?
I am selling flowers but i dont want to collect a delivery address, only delivery address since it complicates things. I dont want to pass the delivery address to 2checkout.com only the billing address. So i would set my products up as virtual in Zen and have them enter the billing address in the instructions for seller box (or whatever its called) in zen cart.
I currently use PayPal and dont pass the delivery address to PP since they reject orders with different billing and delivery address. Since i sell flower people dont ever send them to themselves
Thanks
I am about to upload my ZC product table (in a .csv file) onto my 2CO account. But I have the following issues to be clarified before I dare to mess about:
The first column of the csv file is "Product ID, i.e. The ID that you use to identify your product". This ID is obviously very important, and I don't want to get it wrong. And linked to this ID, there is product description, "base price", etc.
So my question is ... which ID from ZC do I use? I noticed from Admin area that the first product I created in ZC carries an ID "1". Do I use this?
Related to this ... for every product, I have different "product options" (with different pricing), and I noticed that each product option also has an ID. The two sets of ID's in ZC are not uniquely generated (there are duplications). So which set should I use? I am hoping that it is the "Product Options" ID's, so that each product option can be captured in 2CO as a unique product.
Last question is ... I noticed that, without the product table loaded, the product shown on 2CO order confirmation is always c_prod_1, with "base price" as "0.00". And there is a "Cart ID". And then there are is info shown as follows:
I suppose 2CO used the "Cart ID" to generate some sort of product information for the customer. I hope with properly uploaded product table, this info will ceased to be displayed.Contents of your order :
Cart ID : 29
Vendor Product ID : 29
Product Description : Vendor site cart purchase: Invoice 29 Product Name : Cart Purchase: 29 Quantity : 1 Base Price : 4.79
Hope to get a response from the experienced. Thanks!
Jeff
http://haostaff.com
The key question is ... I suppose ...
Does the 2CO module in Zencart pass "Product ID" or "Product Attribute ID" to 2CO?
I.e. which Zencart ID should I use on 2CO Admin to identify all the products that I "mirror-upload" there?
Through own test, I have found:
- It is the Zencart product ID, not the product attribute ID, that is used to communicate with 2CO.
- Whatever ID is used, 2CO do not show the individual product prices anyway. They only show the total order amount. This module generates a "Cart ID", and it is shown to represent the order.
- I have uploaded my product catalogue to 2CO account using .csv file (spreadsheet), based on 2CO instructions.
With this, let me close my earlier questions.
Jeff
I do not know whether this thread is still "looked after", as I have been talking to myself.
Post it here anyway ... PATCH NEEDED!
In the PayPal Express payment module, there is a very useful function ... auto creation of an accout for the unregistered customers. The customer is sent a Welcome email with the login details.
I am allowing the customers to pay with 2CO (credit cards) without registering an account. It would be nice to duplicate the same auto account creation function from PayPay Express to 2CO module.
I know this is probably viable because 2CO requires the customer to input an email address. Can't ZC request for that email address and create an account with it?
I am not worried if the customer chooses to enter a wrong email address. If he/she just wants to pay for a downloadable product, and does not want to receive anything information after that, then it is fine with me.
Can someone, by any chance, point me to the right direction of how to develop a patch for 2CheckOut Addon Module for above purpose?
This is beyond me as I have zero programming ability, but can follow instructions to amend codes, if someone can kindly provide the instructions.
Thanks in advance.
Jeff
==========================
Attention !!!
I have now posted this at the "Features Wishlist" section with the following thread:
http://www.zen-cart.com/forum/showth...t+creation+2co
Please post your replies there, to avoid double threads on same topic. Thanks !
Last edited by haostaff; 4 Feb 2010 at 04:48 AM. Reason: Note for Attention !!!
im having a problem with the actual shopping cart i cant seem to make it visible on the webpage of my buisness and it is annoying because i have the price etc showing and my customers cannot ''add to cart'' please help ive tried the manual and am really stuck!
Thanks![]()