for the 'Column 'OrderUserID' cannot be null' error, edit the order table struction and set the OrderUserID column to allow nulls.
For the transaction failure, see the "Debugging eCart transaction failed issues" tutorial on the eCart support page:
ecart/