Insert into PS Order Detail - error right after checkout

[weaselbringer]

just ugpraded to the very latest version of prestashop 1.2.1.0 (from 1.1)

it hung a little bit on the very last step, just kept loading, but it seemed to finish and work okay, got everything working great but when you go to check out and select payment (either paypal or authorize.net - which is also installed) they both complete but then generate this error

Unknown column 'product_quantity_in_stock' in 'field list'

INSERT INTO `ps_order_detail`
(`id_order`, `product_id`, `product_attribute_id`, `product_name`, `product_quantity`, `product_quantity_in_stock`, `product_price`, `product_quantity_discount`, `product_ean13`, `product_reference`, `product_supplier_reference`, `product_weight`, `tax_name`, `tax_rate`, `ecotax`, `download_deadline`, `download_hash`)
VALUES (616,
165,
0,
'Eternity: A Romantic Collection',
1,
0,
12.98,
0,
NULL,
'RM3214',
NULL,
1,
'',
9,
0,
'0000-00-00 00:00:00',
'')

[stevebob]

I have the same error, but also a "pay by check" order does not show up under orders, it does appear in the customer cart as "awaiting wire transfer payment". Paypal also shows up only in the customer cart as "awaiting wire transfer payment", changing this to "payment accepted" will move it to the orders screen. Item detail is not showing on the order.

[CYTechnologies]

Hello,

weaselbringer - Do you have the ability to access your database using a tool such as phpMyAdmin?

[stevebob]

Yes, what should I be looking for?

[CYTechnologies]

Go to where you can enter in a small line of SQL and enter this:

ALTER TABLE `ps_order_detail` ADD `product_quantity_in_stock` INT( 10 ) NOT NULL DEFAULT '0';

That should do the trick for you :-)

[stevebob]

That seems to have done the trick! Thank you very much!

Steve

[CYTechnologies]

Glad it worked

[beads]

Thanks, solved the problem of PS_Order_Detail not updating in 1.2.2.

Symptoms were: order showing with no product details, nor error messages during customer / cart process.