For those of you having trouble with the installation using 4.0.13.
I missed this SQL command below when I first tried installing this mod and was getting the same error as the posters above. It seems to work now.
Code:
INSERT INTO xcart_modules VALUES (2,'stock_notify','Allows registered users to ask to be notified when a product is back in stock','Y');