Orders not displaying in admin

[Nick1973]

I have just upgraded a site to V1.6a, my server is running 7.0 for this site

I have a problem where customers make an order, they pay through paypal, the order reports back and the customers name and address are reported back to the admin but what is in their order is not and their order is received blank.

See attached.

Also the order emails aren't received.



Nothing in the error logs either

[mc12345678]

Which PayPal method? There are three listings in a default install.

[Nick1973]

Which PayPal method? There are three listings in a default install.

PayPal Website Payments Standard

[Nick1973]

Sorry I should have put PHP 7.0 in my first post

[Nick1973]

I just wondered if anybody could help me with this one please?

[DrByte]

Nick, you said you're getting no error logs ... but I'm wondering if this same situation is what's happening for you:
https://www.zen-cart.com/showthread....lue-for-column

[Nick1973]

Nick, you said you're getting no error logs ... but I'm wondering if this same situation is what's happening for you:
https://www.zen-cart.com/showthread....lue-for-column

I've just looked again in the error logs and I am getting this error now.


/index.php?main_page=checkout_process&referer=paypal&amt=39.00&cc=GBP&cm=zenid%3D b3af2dd74e9be42503c969f953a9d012&item_name=All%20the%20items%20in%20your%20shopp ing%20basket%20(see%20details%20in%20the%20store%20and%20on%20your%20store%20rec eipt).&item_number=Rockspex%20Purchase&st=Completed&tx=63P85988UJ429092G, IP address: 00.000.00.000
#1 trigger_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sportsq2/public_html/includes/functions/functions_general.php:952]
#5 zen_db_perform() called at [/home/sportsq2/public_html/includes/classes/order.php:821]
#6 order->create_add_products() called at [/home/sportsq2/public_html/includes/modules/checkout_process.php:93]
#7 require(/home/sportsq2/public_html/includes/modules/checkout_process.php) called at [/home/sportsq2/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/home/sportsq2/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/sportsq2/public_html/index.php:36]
[27-Apr-2019 14:26:27 UTC] PHP Fatal error: 1054:Unknown column 'products_weight' in 'field list' :: INSERT INTO orders_products (orders_id, products_id, products_model, products_name, products_price, final_price, onetime_charges, products_tax, products_quantity, products_priced_by_attribute, product_is_free, products_discount_type, products_discount_type_from, products_prid, products_weight, products_virtual, product_is_always_free_shipping, products_quantity_order_min, products_quantity_order_units, products_quantity_order_max, products_quantity_mixed, products_mixed_discount_quantity) VALUES ('2917', '744', 'Inland equinox', 'Equinox - Safety Glasses - Industrial Glasses', '39.0000', '39', '0', '0', '1', '0', '0', '0', '0', '744:ef51c6e1fb89cedb6c9add20435a9d52', '0.5', '0', '0', '1', '1', '0', '1', '1') ==> (as called by) /home/sportsq2/public_html/includes/functions/functions_general.php on line 952 <== in /home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php on line 171

[lat9]

Are you sure that you ran the zc_install to upgrade that database? Part of the zc156 database update is to add the orders_products::products_weight field ... the one that's missing.

[Nick1973]

I thought I did. Let me try again.

[Nick1973]

I thought I did. Let me try again.

Actually I think I know what has happened here if that is the case. I had to transfer all the order tables from the old database into the new one. So they will now be old and probably won't have that field. So I am guessing a workaround would be to install a virgin Zen Cart 1.5.6a to get that field transferred across.