Author Topic: checkout problem  (Read 4259 times)

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
checkout problem
« on: April 16, 2019, 07:37:53 AM »
when trying to checkout problem occurs. see the picture

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: checkout problem
« Reply #1 on: April 16, 2019, 08:00:49 AM »
Hello.
Please check Invoice Start No and Invoice Prefix settings in Admin > System > Settings > Checkout

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: checkout problem
« Reply #2 on: April 16, 2019, 08:07:02 AM »
that was already set but still problem. how to fix?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: checkout problem
« Reply #3 on: April 16, 2019, 09:10:33 AM »
Hi. Does this problem appear on new installation? What is your AbanteCart and PHP version?

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: checkout problem
« Reply #4 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
« Last Edit: April 16, 2019, 09:41:08 AM by tajrean »

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: checkout problem
« Reply #5 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?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: checkout problem
« Reply #6 on: April 17, 2019, 01:13:16 AM »

Offline tajrean

  • Newbie
  • *
  • Posts: 21
  • Karma: +2/-0
    • View Profile
Re: checkout problem
« Reply #7 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?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: checkout problem
« Reply #8 on: April 17, 2019, 06:32:39 AM »
looks like your webhost mysql is in strict mode

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: checkout problem
« Reply #9 on: April 18, 2019, 06:05:21 AM »
In your sql manager (PHPmyadmin) run
Code: [Select]
SHOW VARIABLES LIKE 'sql_mode';

 

Powered by SMFPacks Social Login Mod