[ic] 4.9.3 "ship status update failed"

Darren interchange-users@icdevgroup.org
Sun Jan 5 17:21:01 2003


>>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.

Hi,

I think sendmail is in the right place as email is sent to me and the
customer when the order is placed.  I don't have shell access right now
but I will check the exact location later.
I am not sure where to look in the admin pages for the presence of the
write permission tag.  Can you give me a hint of where to look?

Thanks
Darren