[ic] 4.9.3 "ship status update failed"

Ed LaFrance interchange-users@icdevgroup.org
Mon Jan 6 09:55:01 2003


At 05:20 PM 1/5/2003 -0500, you wrote:
> >>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?

It depends upon where you are initiating the 'ship orders' action, but the 
pages I would check would be admin/order and admin/order_status. You won't 
find these pages in your pages/admin directory unless you have put them 
there; they are normally located in VENDROOT/lib/UI/pages/admin.

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