Forum

Thread tagged as: Problem, Error, FoxyCart

Shop(FoxyCart) OrderItems not showing up in orders

This does not work locally on my production server or on the deployed server.

When viewing orders it shows the name, and addresses, and totals, and number of items fine, but it does not show anything for the actual items. I tried to dig into the code and error_log() the actual xml that gets sent to foxy_cart_callback and it seems to have the data in it when coming from FoxyCart. However when it gets to my database all I get is (for example):

{"transaction_detail":[{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}},{"product_name":{},"product_price":{},"product_quantity":{},"product_weight":{},"product_code":{},"image":{},"url":{},"length":{},"width":{},"height":{},"downloadable_url":{},"sub_token_url":{},"subscription_frequency":{},"subscription_startdate":{},"subscription_nextdate":{},"subscription_enddate":{},"is_future_line_item":{},"shipto":{},"category_description":{},"category_code":{},"product_delivery_type":{},"transaction_detail_options":{}}]}

When I then view the order, it accurately creates 9 table rows, but they are completely blank. It also then generates a PHP warning for each cell in each of these rows (PHP Warning: htmlspecialchars() expects parameter 1 to be string, object given in /home/[...]/admin/core/lib/PerchUtil.class.php on line 79) since it is trying to call that on something that it is not expecting to be there I guess.

Aaron Newcomer

Aaron Newcomer 0 points

  • 7 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, we'll look into it, thanks.