Can't complete checkout ERROR 500

[vinruud]

Hi everyone!

 

I have a problem with the final step of the checkout; I get an error 500.

 

I debug the error changing from false to true the PS_MODE_DEV in config/defines.inc.php and I get this type of error. (see attached the screenshot)

 

 

I'm going mad, please help me!

 

Thanks

 

P.S. I'm using Prestashop 1.6

[vekia]

you removed some oreded states (statuses) from back office ?

[vinruud]

you removed some oreded states (statuses) from back office ?

 Hi vekia!

 

See attached what Isee in Order statu. I didnt touch anything except for the translation of "pending confirmation" from italian to english

 

[vekia]

and where are statuses from above?

 

 

im affraid that your shop doesnt have statuses 

 

run this sql query

INSERT INTO `ps_order_state` (`id_order_state`, `invoice`, `send_email`, `module_name`, `color`, `unremovable`, `hidden`, `logable`, `delivery`, `shipped`, `paid`, `deleted`) VALUES
	(1, 0, 1, 'cheque', '#4169E1', 1, 0, 0, 0, 0, 0, 0),
	(2, 1, 1, '', '#32CD32', 1, 0, 1, 0, 0, 1, 0),
	(3, 1, 1, '', '#FF8C00', 1, 0, 1, 1, 0, 1, 0),
	(4, 1, 1, '', '#8A2BE2', 1, 0, 1, 1, 1, 1, 0),
	(5, 1, 0, '', '#108510', 1, 0, 1, 1, 1, 1, 0),
	(6, 0, 1, '', '#DC143C', 1, 0, 0, 0, 0, 0, 0),
	(7, 1, 1, '', '#ec2e15', 1, 0, 0, 0, 0, 0, 0),
	(8, 0, 1, '', '#8f0621', 1, 0, 0, 0, 0, 0, 0),
	(9, 1, 1, '', '#FF69B4', 1, 0, 0, 0, 0, 1, 0),
	(10, 0, 1, 'bankwire', '#4169E1', 1, 0, 0, 0, 0, 0, 0),
	(11, 0, 0, '', '#4169E1', 1, 0, 0, 0, 0, 0, 0),
	(12, 1, 1, '', '#32CD32', 1, 0, 1, 0, 0, 1, 0);

and translations

INSERT INTO `ps_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) VALUES
	(1, 1, 'Awaiting cheque payment', 'cheque'),
	(1, 2, 'Awaiting cheque payment', 'cheque'),
	(2, 1, 'Payment accepted', 'payment'),
	(2, 2, 'Payment accepted', 'payment'),
	(3, 1, 'Preparation in progress', 'preparation'),
	(3, 2, 'Preparation in progress', 'preparation'),
	(4, 1, 'Shipped', 'shipped'),
	(4, 2, 'Shipped', 'shipped'),
	(5, 1, 'Delivered', ''),
	(5, 2, 'Delivered', ''),
	(6, 1, 'Canceled', 'order_canceled'),
	(6, 2, 'Canceled', 'order_canceled'),
	(7, 1, 'Refund', 'refund'),
	(7, 2, 'Refund', 'refund'),
	(8, 1, 'Payment error', 'payment_error'),
	(8, 2, 'Payment error', 'payment_error'),
	(9, 1, 'On backorder', 'outofstock'),
	(9, 2, 'On backorder', 'outofstock'),
	(10, 1, 'Awaiting bank wire payment', 'bankwire'),
	(10, 2, 'Awaiting bank wire payment', 'bankwire'),
	(11, 1, 'Awaiting PayPal payment', ''),
	(11, 2, 'Awaiting PayPal payment', ''),
	(12, 1, 'Remote payment accepted', 'payment'),
	(12, 2, 'Remote payment accepted', 'payment');

1 - english

2- italian

[daviderojas]

Hi there, please I got the same problem (my mistake) I deleted all order status ( I thought it can be deleted) to create a new ones in spanish (my language) and use only what I need, bad... to bad.... after this I tried to make an order and got error 500 after select payment method, please any body can help me, my another mistake was I did it on my online store directly... too bad...

 

Anybody can help me and restore default status but in spanish? is urgent....please thanks a lot

 

I use 1.6.0.8 PS

 

David

[vekia]

what is an ID number of languages available in your store?

[daviderojas]

Thanks for your interest, I readed your posts and I found on my database the tables of order state and language, I replaced them with my backup and that could help me.  Thanks a lot for your support. 

 

Greetings from Guayaquil Ecuador

[buteofalcone]

Hi, I have a similar problem.
When I checkout a cart with a sum of >$0 – everything goes smoothly.
But when I try to checkout the cart of $0 (free products) – I got an Error 500.

 

 

Any suggestions please? 

 

 

[NemoPS]

That's a core bug.
See the fourth line of the stack? Reach that core business file at that line, then after

 

$stockAvailable->id_product = (int)$product->id;

 

add this

$stockAvailable->id_product_attribute = (int)$id_product_attribute;

[buteofalcone]

Wow, Nemo, you're a genius! How did you detected an error so precisely in such a big report?

You fixed my shop!

[NemoPS]

I cheated. I came across it many times already

[Jayasilen]

I tried investigating the error log in FTP and also turned on the developer mode to re-created the error. Both returned the following error message:

 

>>>>

Warning:

require_once(/home/alternic/public_html/modules/avalaratax/sdk/classes/AvaCert2Svc/LeoFrameworkHelper.class.php):

failed to open stream: No such file or directory in /home/alternic/public_html/modules/avalaratax/sdk/AvaTax.php

on line 22

 

Fatal error: require_once(): Failed opening required

'/home/alternic/public_html/modules/avalaratax/sdk/classes/AvaCert2Svc/LeoFrameworkHelper.class.php'

(include_path='/home/alternic/public_html/tools/htmlpurifier/standalone:.:/usr/lib/php:/usr/local/lib/php') in

/home/alternic/public_html/modules/avalaratax/sdk/AvaTax.php on line 22

>>>>

 

This reminds me that I had an issue whereby my whole website was almost inaccessible intermittently and the hosting company told me that the error was due to a missing module called AvalaraTax.

 

I remember we were testing this module for our cross border shipping but it was not suitable. We then removed the module and the problem seem to start from there.

 

When we re-installed the module, the website was accessible as usual but the problem with the cart seems to be persistent and based on the error log, there is a missing file that causing the problem.

 

Appreciate if you can let me know how do we go about it.

Thanks.