The issue seems to be that the AdwordsPublish column in the ac_products table was not deleted as mentioned in the upgrade documentation. Other changes to the database were successfully changed such as the ExcludedDestination column in the ac_products table. I have confirmed that the correct AddProduct.aspx has been added as part of the RC5 upgrade.
Is there a way to re-run the script to update the database? I don't want to make manual changes to the database unless I absolutely have to.
Has someone else also reported this problem or is it just me again?
Thanks!
Code: Select all
GenericADOException
could not insert: [CommerceBuilder.Products.Product][SQL: INSERT INTO ac_Products (RowVersion, StoreId, Name, Price, CostOfGoods, MSRP, Weight, Length, Width, Height, ManufacturerId, Sku, ModelNumber, WebpageId, TaxCodeId, ShippableId, WarehouseId, InventoryModeId, InStock, AvailabilityDate, InStockWarningLevel, ThumbnailUrl, ThumbnailAltText, ImageUrl, ImageAltText, Summary, Description, ExtendedDescription, VendorId, CreatedDate, LastModifiedDate, IsFeatured, IsProhibited, AllowReviews, AllowBackorder, WrapGroupId, ExcludeFromFeed, DisablePurchase, MinQuantity, MaxQuantity, VisibilityId, IconUrl, IconAltText, IsGiftCertificate, UseVariablePrice, MinimumPrice, MaximumPrice, HidePrice, Title, MetaDescription, MetaKeywords, SearchKeywords, HtmlHead, GTIN, GoogleCategory, Condition, Gender, AgeGroup, Color, Size, AdwordsGrouping, AdwordsLabels, ExcludedDestination, AdwordsRedirect, PublishFeedAsVariants, OrderBy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()] at CommerceBuilder.DomainModel.EntityWithTypedId`1.Save() at AbleCommerce.Admin.Products.AddProduct.SaveProduct() at AbleCommerce.Admin.Products.AddProduct.SaveButton_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Cannot insert the value NULL into column 'AdwordsPublish', table 'aerodevgold.dbo.ac_Products'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Id.IdentityGenerator.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
http://dev.aerobed.com/Admin/Products/AddProduct.aspx?CategoryId=5
/Admin/Products/AddProduct.aspx