[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