if customer chooses another shipping option, other than defaulted selection, and than chooses confirm the order, before waiting for the new totals to refresh it will send the defaulted selection to the payment option.
How to fix this?
jimmie
Printable View
if customer chooses another shipping option, other than defaulted selection, and than chooses confirm the order, before waiting for the new totals to refresh it will send the defaulted selection to the payment option.
How to fix this?
jimmie
Edited for errors
I got some error with paypal and the "one page checkout" set to true. Maybe it's related to this.Quote:
Originally Posted by jimmie
I've this HUGE debug error:
It should be related to this:HTML Code:[26-May-2015 09:59:00] #1 trigger_error(1054:Unknown column 'COWOA_order' in 'field list' :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1') ==> (as called by) /var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php on line 965 <==, 256) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:155]
#2 queryFactory->show_error() called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:132]
#3 queryFactory->set_error(1054, Unknown column 'COWOA_order' in 'field list', 1) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php:262]
#4 queryFactory->Execute(INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1')) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php:965]
#5 zen_db_perform(orders, Array ([customers_id] => 1692,[customers_name] => Sergio RICCIO,[customers_company] => ,[customers_street_address] => Trav. Fiume Savuto, 9,[customers_suburb] => ,[customers_city] => CATANZARO,[customers_postcode] => 88100,[customers_state] => Catanzaro,[customers_country] => Italy,[customers_telephone] => 3286486400,[customers_email_address] => [email protected],[customers_address_format_id] => 5,[delivery_name] => Sergio RICCIO,[delivery_company] => ,[delivery_street_address] => Trav. Fiume Savuto, 9,[delivery_suburb] => ,[delivery_city] => CATANZARO,[delivery_postcode] => 88100,[delivery_state] => Catanzaro,[delivery_country] => Italy,[delivery_address_format_id] => 5,[billing_name] => Sergio RICCIO,[billing_company] => ,[billing_vat] => ,[billing_cf] => ,[billing_street_address] => Trav. Fiume Savuto, 9,[billing_suburb] => ,[billing_city] => CATANZARO,[billing_postcode] => 88100,[billing_state] => Catanzaro,[billing_country] => Italy,[billing_address_format_id] => 5,[payment_method] => Contrassegno,[payment_module_code] => cod,[shipping_method] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.),[shipping_module_code] => tnt,[coupon_code] => ,[cc_type] => ,[cc_owner] => ,[cc_number] => ,[cc_expires] => ,[date_purchased] => now(),[orders_status] => 1,[order_total] => 51.5,[order_tax] => 0,[currency] => EUR,[currency_value] => 1.00000000,[ip_address] => 79.56.112.118 - 79.56.112.118,[COWOA_order] => 1)) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/order.php:796]
#6 order->create(Array ([0] => Array ([code] => ot_subtotal,[title] => Totale parziale:,[text] => €41.00,[value] => 41,[sort_order] => 100),[1] => Array ([code] => ot_shipping,[title] => Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.):,[text] => €10.50,[value] => 10.5,[sort_order] => 200),[2] => Array ([code] => ot_total,[title] => Totale:,[text] => €51.50,[value] => 51.5,[sort_order] => 999),[3] => Array ([code] => ot_reward_points_display,[title] => Punti guadagnati:,[text] => 20,[value] => 0,[sort_order] => 1000)), 2) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php:86]
#7 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/checkout_process.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/var/www/vhosts/laviadellincenso.it/httpdocs/includes/modules/pages/checkout_process/header_php.php) called at [/var/www/vhosts/laviadellincenso.it/httpdocs/index.php:36]
[26-May-2015 09:59:00] PHP Fatal error: 1054:Unknown column 'COWOA_order' in 'field list' :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_vat, billing_cf, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address, COWOA_order) VALUES ('1692', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '3286486400', '[email protected]', '5', 'Sergio RICCIO', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Sergio RICCIO', '', '', '', 'Trav. Fiume Savuto, 9', '', 'CATANZARO', '88100', 'Catanzaro', 'Italy', '5', 'Contrassegno', 'cod', 'Corriere espresso (2.86kg.) (Consegna 24/48 ore, sabato e festivi esclusi.)', 'tnt', '', '', '', '', '', now(), '1', '51.5', '0', 'EUR', '1.00000000', '79.56.112.118 - 79.56.112.118', '1') ==> (as called by) /var/www/vhosts/laviadellincenso.it/httpdocs/includes/functions/functions_general.php on line 965 <== in /var/www/vhosts/laviadellincenso.it/httpdocs/includes/classes/db/mysql/query_factory.php on line 155
I've seen tha on Numix site there is a 2.0 version availabe, i haven't test it yet so i don't know if it address some of this problemsHTML Code:015-05-26 01:34:42
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
[0] => Content-Type: text/namevalue
[1] => X-VPS-Timeout: 90
[2] => X-VPS-VIT-Client-Type: PHP/cURL
[3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/NVP
[4] => X-VPS-VIT-Integration-Version: 1.5.4
)
Request Parameters: {DoExpressCheckoutPayment}
Array
(
[AMT] => 26.30
[ITEMAMT] => 16.80
[SHIPPINGAMT] => 9.50
[L_NUMBER0] => ICPBA93210000
[L_NAME0] => Bastoncini Palo Santo [210] Confezione: Semplice 30g
[L_QTY0] => 1
[L_AMT0] => 5.00
[L_NUMBER1] => ICPBA98214000
[L_NAME1] => Bastoncini Pino [214] Confezione: Semplice 30g
[L_QTY1] => 1
[L_AMT1] => 5.00
[L_NUMBER2] => INCPIN3180000
[L_NAME2] => Pino Resina Grezzo(Pinus pinaster) [117] QuantitÃ##: 50 grammi
[L_QTY2] => 1
[L_AMT2] => 3.30
[L_NUMBER3] => INCOLI2490000
[L_NAME3] => Olibano D'Etiopia (Boswellia rivae) [16] QuantitÃ##: 50 grammi
[L_QTY3] => 1
[L_AMT3] => 3.50
[SHIPTONAME] => giulio yary piccarreta
[SHIPTOSTREET] => caldopiano,42
[SHIPTOCITY] => Roma
[SHIPTOSTATE] => RM
[SHIPTOZIP] => 00118
[SHIPTOCOUNTRYCODE] => IT
[BUTTONSOURCE] => IT_zencart-ECS
[RETURNFMFDETAILS] => 0
[CUSTOM] => EC-1623-1432640078
[INVNUM] => 1623-1432640078-[LaViadellincenso]
[TOKEN] => EC-2J485786GW343062M
[PAYERID] => ME5VBKSUHGADJ
[PAYMENTACTION] => Authorization
[NOTIFYURL] => http://www.laviadellincenso.it/ipn_main_handler.php
[METHOD] => DoExpressCheckoutPayment
[CURRENCYCODE] => EUR
[USER] => *****
[PWD] => ****************
[VERSION] => 61.0
[SIGNATURE] => ****************************************************we-0
)
Response:
Array
(
[TIMESTAMP] => 2015-05-26T11:34:42Z
[CORRELATIONID] => 50d0908b5e644
[ACK] => Failure
[VERSION] => 61.0
[BUILD] => 16751317
[L_ERRORCODE0] => 10486
[L_SHORTMESSAGE0] => This transaction couldn't be completed.
[L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
[L_SEVERITYCODE0] => Error
[CURL_ERRORS] =>
)
DoExpressCheckoutPayment, Elapsed: 3492ms -- Failure
TIMESTAMP=2015%2d05%2d26T11%3a34%3a42Z&CORRELATIONID=50d0908b5e644&ACK=Failure&VERSION=61%2e0&BUILD=16751317&L_ERRORCODE0=10486&L_SHORTMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e&L_LONGMESSAGE0=This%20transaction%20couldn%27t%20be%20completed%2e%20Please%20redirect%20your%20customer%20to%20PayPal%2e&L_SEVERITYCODE0=Error&CURL_ERRORS=
i get no errors, orders will go through, it is related to the cheapest (whatever, local pickup, check or money order, anything like that) being selected as default. the only time i get paypal errors are when customers bank doesnt authorize transaction or they put in a wrong address.
**Removed some of the quote to make reply shorter, and added bold to most important part**Quote:
Originally Posted by izar74
There is an issue because you are missing "COWOA_order" in the orders table. The "best" solution as I suspect there are other issues is to leave the files in place however in the tools->install SQL patches run the uninstall.sql from the module. That will uninstall the DB changes in the module, and then upon next admin page load re-install the module. I suspect that somehow that column was missed, however the $sniffer class allows it to check the column and add if needed.
Sorry bislew i've made e quite stupid VERY LONG reply, just addint that bold line would be enough.
Your suggestion make sense but i've checked the uninstall that is as follow:
From what i see it completly ignore the order table. I've also checked the installation and there is no modification to the Order table either.PHP Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
Does it have any meaning after seeing this to do as You suggested?
The last thing you wrote "the $sniffer class allows it to check the column and add if needed" how should i use this suggestion? :P
Ok, let's step back you should be using Fast & easy Check version 1.16.8.
in there the uninstall.sql should look like
And in the YOUR_ADMIN/includes/installers/fec/1_12_0.php there is a snippet:PHP Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FEAC_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id <> 0;
So, upgrade the module. THEN run the uninstall.sql that looks like the one above. Then load the admin, and it should resolve the issue.PHP Code:global $sniffer;
if (!$sniffer->field_exists(TABLE_CUSTOMERS, 'COWOA_account')) $db->Execute("ALTER TABLE " . TABLE_CUSTOMERS . " ADD COWOA_account tinyint(1) NOT NULL default 0;");
if (!$sniffer->field_exists(TABLE_ORDERS, 'COWOA_order')) $db->Execute("ALTER TABLE " . TABLE_ORDERS . " ADD COWOA_order tinyint(1) NOT NULL default 0;");
The uninstall.sql doesn't touch the TABLE_ORDERS however the installer for version 1.12.0 does. And it uses the sniffer class to make sure the column is there.
Ohhh my my... i've litterally lost the compass... where the 1.16.8 came from?Quote:
Originally Posted by bislewl
on the plugin it is at 1.15.3 (https://www.zen-cart.com/downloads.php?do=file&id=594)
and on the Numix site it goes from 1.15.3 to 2.0 directly.. this last one would do fine? (https://www.numinix.com/downloads/ze...-easy-checkout)
Hi again,
thanks to bislewl help i was able to fix the problem, at least i hope so. I used the plugin from numix site.
Now i'm trying to add a little modification, i would like to have add a column in the order page in admin, after status, thas swow if a order is COWOA.
The simpliest way i thought is to add some line to the /admin/orders.php, first i followed the instruction in the readme where it state: 8. OPTIONAL TO SEE IF AN ORDER WAS PLACED BY GUEST. It add some lines but not to diplay if the order is placed by guest (like the X shown in the customer page).
So i added this line:
around line 845 after the <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
I added also the define for the TABLE_ORDER_HEADING_COWOAPHP Code:<td class="dataTableHeadingContent" align="center"><?php echo TABLE_ORDER_HEADING_COWOA; ?></td>
around line 969 after <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>
The problem is that it doesn't work :PPHP Code:<td class="dataTableContent" align="center"><?php echo ($orders->fields['COWOA_order'] == 1 ? 'x' : ''); ?></td>
What did i fortget? :D
I did IT!! :P
First you need not to edit any ../class/order.php file, simply find the lines in /admin/orders.php:
and add the field you need to be searched at the end, for me it is:PHP Code:// eof: search orders or orders_products
$new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address ";
:DPHP Code:// eof: search orders or orders_products
$new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address, o.COWOA_order ";