[ic] 4.9.3 "ship status update failed" Solved!

[Darren]

>>>>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?
>>
>>   I did have that exact same problem.  The problem is with the
>orderline table write >permission, which doesn't make any sense to me 
>since there is:
>>
>>[flag type=write tables="orderline transactions"]
>>
>>right in the order_status.html page.  Does anyone know if this been
>corrected since 4.9.3?  It >seems like a bug that most people would run

>into. What ended up happening with my catalog was >WRITE_CONTROL 
>statements were added to catalogs/ic493/dbconf/default_db/orderline.dbm
>to make >the table "writable" all the time.  I hope this isn't a 
>security problem.  I would love to know >about a better solution if 
>anyone has one.
>>
>>- Grant
>
>It is not possible for me to upgrade IC.  Can you tell me which 
>statements/line to add to dbconf/default_db/orderline.dbm to make the 
>table "writable" all the time?
>
>
>Darren,
>
>You would probably want that file's contents to look like this:
>
>Database            orderline    orderline.txt     TAB
>Database            orderline    WRITE_CONTROL          1
>Database            orderline    WRITE_ALWAYS           1
>
>Please do keep in mind that this makes the orderline table always
writable. Also, if you're >using the SQL database instead of the default
one, these instructions will need some adjustment.  >Actually, isn't the
SQL database writable all the time?
>
>- Grant

Thanks Grant,

It fixed my problem, no more "Orderline 00000150-1 ship status update
failed."  And now the email is being sent as well.

Darren