AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: tajrean on April 16, 2019, 07:37:53 AM

Title: checkout problem
Post by: tajrean on April 16, 2019, 07:37:53 AM

when trying to checkout problem occurs. see the picture

Title: Re: checkout problem
Post by: Basara on April 16, 2019, 08:00:49 AM

Hello.
Please check Invoice Start No and Invoice Prefix settings in Admin > System > Settings > Checkout

Title: Re: checkout problem
Post by: tajrean on April 16, 2019, 08:07:02 AM

that was already set but still problem. how to fix?

Title: Re: checkout problem
Post by: Basara on April 16, 2019, 09:10:33 AM

Hi. Does this problem appear on new installation? What is your AbanteCart and PHP version?

Title: Re: checkout problem
Post by: tajrean on April 16, 2019, 09:29:50 AM

yesterday i installed and today i see problem. AbanteCart version is 1.2.14  php 7.1

Title: Re: checkout problem
Post by: tajrean on April 16, 2019, 03:54:58 PM

I tried installing AbanteCart thrice to check if checkout works. But still the same problem persists. Can this ever be fixed?

Title: Re: checkout problem
Post by: Basara on April 17, 2019, 01:13:16 AM

Hello.

Try to install latest code https://github.com/abantecart/abantecart-src/archive/1.2.15.zip
or apply patch released yesterday by dev team https://github.com/abantecart/abantecart-src/commit/d2c21069e551e7d25c4c85946729643f5ca98a97?w=1

Title: Re: checkout problem
Post by: tajrean on April 17, 2019, 04:25:41 AM

after installing latest version following errors occured

There has been a critical error processing your request
SQL Error: Field 'payment_method_data' doesn't have a default value
Error No: 1364
SQL: INSERT INTO `abc_orders` SET store_id = '0', store_name = 'Web Store Name', store_url = 'https://buyonline69.000webhostapp.com/', customer_id = '0', customer_group_id = '1', firstname = 'Sulav', lastname = 'Kolakshyapati', email = 'info@buyonline.com.np', telephone = '9860890341', fax = '', total = '21', language_id = '1', currency = 'USD', currency_id = '1', value = '1', coupon_id = '0', ip = '27.34.26.193', shipping_firstname = 'Sulav', shipping_lastname = 'Kolakshyapati', shipping_company = 'buyonline import export pvt ltd', shipping_address_1 = 'gopikrishna', shipping_address_2 = 'chabahil', shipping_city = 'kathmandu', shipping_postcode = '00977', shipping_zone = 'Sagarmatha', shipping_zone_id = '2327', shipping_country = 'Nepal', shipping_country_id = '149', shipping_address_format = '', shipping_method = 'Flat Shipping Rate', shipping_method_key = 'default_flat_rate_shipping.default_flat_rate_shipping', payment_firstname = 'Sulav', payment_lastname = 'Kolakshyapati', payment_company = 'buyonline import export pvt ltd', payment_address_1 = 'gopikrishna', payment_address_2 = 'chabahil', payment_city = 'kathmandu', payment_postcode = '00977', payment_zone = 'Sagarmatha', payment_zone_id = '2327', payment_country = 'Nepal', payment_country_id = '149', payment_address_format = '', payment_method = 'Cash On Delivery', payment_method_key = 'default_cod', comment = '', date_modified = NOW(), date_added = NOW() in /storage/ssd3/180/9315180/public_html/core/database/amysqli.php on line 114



I'm tired of trying it over and over. Everytime different problem pops up. Isnt there a permanent and quick solution to this? But the same thing works perfect in localhost. Why not in webhost?

Title: Re: checkout problem
Post by: Basara on April 17, 2019, 06:32:39 AM

looks like your webhost mysql is in strict mode

Title: Re: checkout problem
Post by: Basara on April 18, 2019, 06:05:21 AM

In your sql manager (PHPmyadmin) run

Code: [Select]

SHOW VARIABLES LIKE 'sql_mode';