Error in Expense Request Package

dlech 2013-01-05 19:24:51 UTC #1

I just downloaded and installed the Expense Request for Non-Inventory Items (v3.8.0) from the Marketplace. When I tried to install it, I got the following error and the package failed to install.
function poreq.transferitems(integer, integer) does not exist

It turns out there is an error in transferitems.sql. The first line reads:
DROP FUNCTION poreq.transferitems(integer, integer) CASCADE;

This does not work for new installations. I had to change it to:

DROP FUNCTION IF EXISTS poreq.transferitems(integer, integer) CASCADE;

I also learned that even though it has the .gz file extension, the file is actual just a tar archive and does not appear to be zipped.

Here are the steps I used to modify the file:
tar -xf extensions_ExpenseRequests.gz cd ExpenseRequests/functions chmod +w transferitems.sql vi transferitems.sql chmod -w transferitems.sql cd ../.. tar -uf extensions_ExpenseRequests.gz ExpenseRequests/

dlech 2013-01-05 20:58:55 UTC #2

Just found another error.

In newpohead.sql, line 44

pohead_shiptoddress_id,

should be

pohead_shiptoaddress_id,

jstandring 2013-01-06 12:55:59 UTC #3

Thanks for the feedback. I have a new package for xTuple 4.0.0 and will submit it via the bug tracker.

http://www.xtuple.org/xtincident/view/bugs/19204