Hi
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
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.company, 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
or is it this
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:
shipment_id shipping_id tracking_number carrier timestamp comments status
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';