Thanks again Joe,
Not sure if there's an email problem yet. This should go into a new thread but I'll post it here anyway.
Semi Related:
I thought register might have an email issue but I found the register link seems to go directly to "Your account has been created." with a continue button. I started with the release and have as you know started using the svn trunk. Anyway no exceptions are thrown and no record is created in mp_Users. Creating a user in the admin area works fine.
Completly unrelated
I'm adding paysimple and plugnpay gateways to the store and found in dbcartoffer.cs->Update() the SqlParameterHelper sph is constructed with a number of parmeters = 10 which throws an exception because only 8 parameters are passed
SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ws_CartOffers_Update", 10);
The easy fix is
SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ws_CartOffers_Update", 8);
I opted to go with adding cartGuid to the mix making the number of params =9 in dbcartoffer.cs and updated cartoffer.c->Udate() and the sp ws_CartOffers_Update sp
public static bool Update(
Guid itemGuid,
Guid cartGuid,
Guid offerGuid,
Guid taxClassGuid,
decimal offerPrice,
DateTime addedToCart,
int quantity,
decimal tax,
bool isDonation)
{
SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ws_CartOffers_Update", 9);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@CartGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, cartGuid);
sph.DefineSqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, offerGuid);
sph.DefineSqlParameter("@OfferPrice", SqlDbType.Decimal, ParameterDirection.Input, offerPrice);
sph.DefineSqlParameter("@AddedToCart", SqlDbType.DateTime, ParameterDirection.Input, addedToCart);
sph.DefineSqlParameter("@Quantity", SqlDbType.Int, ParameterDirection.Input, quantity);
sph.DefineSqlParameter("@TaxClassGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, taxClassGuid);
sph.DefineSqlParameter("@Tax", SqlDbType.Decimal, ParameterDirection.Input, tax);
sph.DefineSqlParameter("@IsDonation", SqlDbType.Bit, ParameterDirection.Input, isDonation);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
/// <summary>
/// Updates this instance of CartOffer. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return DBCartOffer.Update(
this.itemGuid,
this.cartGuid,
this.offerGuid,
this.taxClassGuid,
this.offerPrice,
this.addedToCart,
this.quantity,
this.tax,
this.isDonation);
}
USE [MojoPortal]
GO
/****** Object: StoredProcedure [dbo].[ws_CartOffers_Update] Script Date: 03/19/2009 11:01:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ws_CartOffers_Update]
/*
Author: Joe Audette
Created: 2007-03-05
Last Modified: 2009-03-17
*/
@ItemGuid uniqueidentifier,
@CartGuid uniqueidentifier, /* cartGuid added */
@OfferGuid uniqueidentifier,
@OfferPrice decimal(15, 4),
@AddedToCart datetime,
@Quantity int,
@TaxClassGuid uniqueidentifier,
@Tax decimal(15,4),
@IsDonation bit
AS
UPDATE [dbo].[ws_CartOffers]
SET
[OfferGuid] = @OfferGuid,
[OfferPrice] = @OfferPrice,
[AddedToCart] = @AddedToCart,
[Quantity] = @Quantity,
[TaxClassGuid] = @TaxClassGuid,
[Tax] = @Tax,
[IsDonation] = @IsDonation
WHERE
[ItemGuid] = @ItemGuid and
[CartGuid] = @CartGuid