New 4.4.2 Version - Need Some Help


after the cs cart upgrade to 4.4.2 overnight I am unable to access my orders - message comes up service unavailable

On the older versions there was

Allow multiple shipments for a single order: it used to be in the general section

is not available in this new cs cart version I suspect this is why I cannot access my orders
is anyone able to help me today with this problem as I am unable to contact Cs Cart until tonight.
thanking you

Look at the bottom of the page source of the service unavailable page to find out what exactly is causing it.

thanks for your quick reply, sorry - how do you see the page source - is it in the logs section

like this

atabase (error)

Error: Unknown column 'cscart_shipments.status' in 'field list' (1054)
Query: SELECT cscart_shipments.shipment_id, cscart_shipments.timestamp AS shipment_timestamp, cscart_shipments.comments, cscart_shipments.status, cscart_shipment_items.order_id, cscart_orders.timestamp AS order_timestamp, cscart_orders.s_firstname, cscart_orders.s_lastname,, cscart_orders.user_id, cscart_shipments.shipping_id, cscart_shipping_descriptions.shipping AS shipping, cscart_shipments.tracking_number, cscart_shipments.carrier FROM cscart_shipments LEFT JOIN cscart_shipment_items ON (cscart_shipments.shipment_id = cscart_shipment_items.shipment_id) LEFT JOIN cscart_orders ON (cscart_shipment_items.order_id = cscart_orders.order_id) LEFT JOIN cscart_shippings ON (cscart_shipments.shipping_id = cscart_shippings.shipping_id) LEFT JOIN cscart_shipping_descriptions ON (cscart_shippings.shipping_id = cscart_shipping_descriptions.shipping_id AND cscart_shipping_descriptions.lang_code = 'en') WHERE 1 AND cscart_shipment_items.order_id = 10967 GROUP BY cscart_shipments.shipment_id ORDER BY cscart_shipments.shipment_id desc


admin1290.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 456
app/functions/fn.control.php (include): 700
app/controllers/backend/orders.php (fn_get_shipments_info): 342
app/functions/fn.cart.php (db_get_array): 6788
app/functions/fn.database.php (call_user_func_array): 28
app/Tygh/Database/Connection.php (getArray): 229
app/Tygh/Database/Connection.php (query): 488

or is it this

Service unavailable
.bigEntrance{animation-name:bigEntrance;-webkit-animation-name:bigEntrance;animation-duration:1.6s;-webkit-animation-duration:1.6s;animation-timing-function:ease-out;-webkit-animation-timing-function:ease-out;visibility:visible!important}@keyframes bigEntrance{0%{transform:scale(0.3) rotate(6deg) translateX(-30%) translateY(30%);opacity:0.2;}30%{transform:scale(1.03) rotate(-2deg) translateX(2%) translateY(-2%);opacity:1;}45%{transform:scale(0.98) rotate(1deg) translateX(0%) translateY(0%);opacity:1;}60%{transform:scale(1.01) rotate(-1deg) translateX(0%) translateY(0%);opacity:1;}75%{transform:scale(0.99) rotate(1deg) translateX(0%) translateY(0%);opacity:1;}90%{transform:scale(1.01) rotate(0deg) translateX(0%) translateY(0%);opacity:1;}100%{transform:scale(1) rotate(0deg) translateX(0%) translateY(0%);opacity:1;}}@-webkit-keyframes bigEntrance{0%{-webkit-transform:scale(0.3) rotate(6deg) translateX(-30%) translateY(30%);opacity:0.2;}30%{-webkit-transform:scale(1.03) rotate(-2deg) translateX(2%) translateY(-2%);opacity:1;}45%{-webkit-transform:scale(0.98) rotate(1deg) translateX(0%) translateY(0%);opacity:1;}60%{-webkit-transform:scale(1.01) rotate(-1deg) translateX(0%) translateY(0%);opacity:1;}75%{-webkit-transform:scale(0.99) rotate(1deg) translateX(0%) translateY(0%);opacity:1;}90%{-webkit-transform:scale(1.01) rotate(0deg) translateX(0%) translateY(0%);opacity:1;}100%{-webkit-transform:scale(1) rotate(0deg) translateX(0%) translateY(0%);opacity:1;}}body{margin-top:100px;font-family:Tahoma}.banner{background-color:#fe5652;border-radius:24px;color:#fff;font-weight:normal;font-size:68px;padding:10px;text-align:center;margin-left:auto;margin-right:auto;display:inline-block;zoom:1;display*: inline}.banner-inner{border-radius:20px;border:4px solid #fff;padding:30px;text-transform:uppercase;letter-spacing:2px}.container{text-align:center}.message{margin-top:20px;font-size:20px;text-align:center}
Sorry, service is temporarily unavailable.

On the service unavailable page, right click and select page source. However the error you posted will most likely help as well.

Look at your database in the table cscart_shipments and see if the field "status" is there.

sorry to be a pain - can you give me a step by step to get to this table

It's not easy to explain without knowing your server. It's something like phpmyadmin or similar program that you can access your database on the server side.

Ok, thanks for your time, I will just have to get through today, wish CS Cart had 24/7/ support

site ground had a look at the error for me results are below

he error Error: Unknown column 'cscart_shipments.status' states a column (status) on the cscart_shipments table does not exist. If your CS Cart is trying to read data from this column, it may indicate either:

1. this column was added on the new CS Cart version (and the database was not properly updated, i.e.: the field was not added to your database); or
2. this column was removed on the new CS Cart version (and the files that are trying to read this field were not properly updated - or they are from an outdated or incompatible plugin, that still expects to find this field in the database).

The 'status' column in present in the cscart_shipments table on my 4.4.2 development environment. It was an upgraded store so not sure if it's in the standard distribution or not but would assume it should be.

What are the columns (schmea) for your cscart_shipments table. It should be:


If the field "status" is not there then run this query to add it.

ALTER TABLE `cscart_shipments` ADD `status` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'P';