[ic] 4.9.3 "ship status update failed"

[Ed LaFrance]

At 08:51 PM 1/4/2003 -0500, you wrote:
>Hi All,
>
>I just moved my store from my old server running IC 4.8.5 to a new
>server running IC 4.9.3 and now when I try to update the status of an
>order via "Ship all lines -> Update the order" I get the following
>message in green on the Pending Orders page:
>
>Orderline 00000150-1 ship status update failed.
>
>Here is what is in my log file.
>
>24.103.254.107 nsNTBLSU:24.103.254.107 - [04/January/2003:17:16:09
>-0800] daboy /~daboy/cgi-bin/cart.cgi/admin/order Attempt to set slice
>of 00000150-1 in read-only table orderline
>24.103.254.107 nsNTBLSU:24.103.254.107 - [04/January/2003:17:16:36
>-0800] daboy /~daboy/cgi-bin/cart.cgi/admin/order Attempt to set slice
>of 00000150-1 in read-only table orderline
>24.103.254.107 nsNTBLSU:24.103.254.107 - [04/January/2003:17:16:47
>-0800] daboy /~daboy/cgi-bin/cart.cgi/admin/order Attempt to set
>orderline::status::00000150-1 in read-only table
>24.103.254.107 nsNTBLSU:24.103.254.107 - [04/January/2003:17:16:47
>-0800] daboy /~daboy/cgi-bin/cart.cgi/admin/order Unable to send mail
>using /usr/lib/sendmail
> > Message follows:
>
>
>The status is changed to "shipped" just fine, but no ship_notice email
>is sent.
>My "transactions" table's order status updates to "shipped" just fine,
>but the status for each line item in the "orderline" table remains at
>"pending".
>
>
>I have found this exact problem posted by Grant on Nov. 12th but there
>was not solution.  Can someone please help?

Error messages can sometimes be misleading, but intially it appears there 
may be two problems:
         1. write permissions on the orderline table are not set;
         2. Interchange cannot find your sendmail program.

For 1, check the relevant admin pages for the presence of the tag which 
sets write permission on the orderline table, this is usuall [flag 
type=write tables="table list"] or [tag flag write]table list[/tag]. For 2. 
verify the location of sendmail on the command line using 'which sendmail' 
or 'whereis sendmail'.

- Ed L.


===============================================================
New Media E.M.S.              Technology Solutions for Business
463 Main St., Suite D         eCommerce | Consulting | Hosting
Placerville, CA  95667        edl@newmediaems.com
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
===============================================================