Developer forum

Forum » Development » error when creating the shipping method

error when creating the shipping method

E-mail notifications

Reply
Posted on 09/06/2008 12:17:32

 

Whenever I try to create a new shipping method I get the “Server error in ‘/’ Application” error. Please guide me on how to rectify it. The description of the error is as below.
 
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[ArgumentException: Column 'ShippingFreeFeeAmount' does not belong to table Table.]
   System.Data.DataRow.GetDataColumn(String columnName) +1962843
   System.Data.DataRow.set_Item(String columnName, Object value) +14
   Dynamicweb.eCommerce.Orders.Shipping.Save(String IDStr) +559
   Dynamicweb.Admin.EcomShipping_Edit.SaveButton_Click(Object sender, EventArgs e) +254
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746


Replies

 
Nicolai Høeg Pedersen
Posted on 09/06/2008 12:21:42
Reply
syed.shahram@valderas.se wrote:

 

Whenever I try to create a new shipping method I get the “Server error in ‘/’ Application” error. Please guide me on how to rectify it.


 

Could you possibly add some more information about  the error? I.e. the entire error.

 

Where have you installed - locally, here or elsewhere? Do you have a URL?

 
Posted on 09/06/2008 13:01:00
Reply

Well, the text between "Server Error..." and "Description" that contains the precise exteption details together with the Stack trace that contains information about, where the exception occurs would be useful.

 
Posted on 09/06/2008 13:31:54
Reply

This error occurs because there's a difference between the database and file version. The database needs to be updated using this approach:

 

 - Open /Files/update.xml in notepad, change the number to 200 and save it.

 - Open UpdateVersion_ecom.xml in notepad, change the number to 40 and save it.

 - Rebuild the solution by hitting Ctrl+Shift+B, running IISRESET or by making a change in the commented area in the top of web.config.

 
Posted on 09/06/2008 16:02:52
Reply
Sorensen wrote:

This error occurs because there's a difference between the database and file version. The database needs to be updated using this approach:

 

 - Open /Files/update.xml in notepad, change the number to 200 and save it.

 - Open UpdateVersion_ecom.xml in notepad, change the number to 40 and save it.

 - Rebuild the solution by hitting Ctrl+Shift+B, running IISRESET or by making a change in the commented area in the top of web.config.


 

 

Hi,
 
It did not solve the problem. I have updated the files update.xml with 200 and UpdateVersion_ecom.xml with 40. I have tried to rebuild the solution by both iisreset command and also by making a change in the commented are at the top of the web.config file. Unfortunately, it did not fix the problem.
 
I don’t know what you meant by "Rebuild the solution by hitting Ctrl+Shift+B". I also want to know why I have to rebuild and what exactly to rebuild and how and where? However I have tried to open the Dynamicweb installation directory in Visual Studio and tried to rebuild which resulted in further errors and also confusions.
 
I would also like to highlight that I am not using the CostumeModulesC#.zip file but I am using the Application.zip. I mean I am not customizing anything for now and the installation is not actually performed to do that so why there is a need to rebuild anything using the Visual Studio.
 
 
 
 
Posted on 09/06/2008 21:08:31
Reply

I'm sorry, you should go back to at least 30 in in /Files/UpdateVersion_ecom.xml. My bad.

 

During the training session I had with you, I told you to use Ctrl+Shift+B to compile. I don't know if you remember, but we also talked about the web.config trick. Anyway, the thing is that Dynamicweb re-runs updates when the application starts, like when web.config changes. Changing the commented text in web.config is a quick to force rebuild when you only have FTP access to solutions.

 

But when you're running a standard solution, IISRESET will do the trick.

 
Posted on 10/06/2008 10:40:58
Reply

Now I have tried the value 30 in /Files/UpdateVersion_ecom.xml, have also made changes at top of the commented area in the web.config file to rebuild the solution. I can say for sure that the rebuild is happening as on client side I get logged out. I am accessing the files through a share so I think the web.config trick is the best and quickest way to rebuild. Have also performed the IISRESET command on the server. However all this did not solve the problem for me. I hope the next solution to this will not be using the value 20 or may be less than that. I still remember about opening the solution in Visual Studio to rebuild it but that was only for the customised modules as per my understanding. I have also tried to rebuild the Applications folder containing the admin and bin folder but doing so always bring up another error. I know you have told us about it but there is no harm in explaining it here again for the sake of solving the problem and everyone else's knowledge. The installation is on server (just to remind you).


 

 
Posted on 10/06/2008 10:46:52
Reply

This field was added in update 30 (see /Admin/Update/ecom.xml), and thus should be added when you run the update from 30.

 

Are you sure that you've checked ddl_admin in the mapping of the SQL user? That would explain why the field is not created when running the update.

 
Posted on 10/06/2008 12:11:15
Reply
Sorensen wrote:

This field was added in update 30 (see /Admin/Update/ecom.xml), and thus should be added when you run the update from 30.

 

Are you sure that you've checked ddl_admin in the mapping of the SQL user? That would explain why the field is not created when running the update.

I have checked the ddl_admin and it is checked for the dynamicweb SQL user I created. I think I should paste the /Admin/Update/ecom.xml here for you so you can see for yourself the contents and then can guide me towards the solution to this problem. I am also posting the contents of the /Files/updatelog.html
 

 

 

 

following are the contents of /Admin/Update/ecom.xml

 

 

<?xml version="1.0" encoding="UTF-8" ?>
<updates>
    <current version="245" releasedate="30-04-2008" internalversion="18.14.1.0" /> 

    <package version="245" date="30-04-2008" internalversion="18.14.1.0">
    <database file="Dynamic.mdb">
      <Module>
        <sql conditional="">CREATE INDEX NewsCategory_IDX001 ON NewsCategory (NewsCategoryAccess)</sql>
      </Module>
    </database>
  </package>

.

.

.

.

 <package version="30" date="22-01-2004" internalversion="18.7.3.0">
    <database file="Access.mdb">
      <AccessUser>
        <sql conditional="">ALTER TABLE AccessUser ADD AccessUserRead  BIT</sql>
      </AccessUser>
    </database>
  </package>

.

.

.

.

.

.

 

 

 

and the contents of the /Files/updatelog.html are

 

2008-06-10 11:51:34

Updates initialized
2008-06-10 11:51:34 Package 31 from ecom.xml
2008-06-10 11:51:34 Conditional present - excaping.
2008-06-10 11:51:34 Upgrade license set to 18.13.0.0
2008-06-10 11:51:34 Package 32 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomVariantsOptions] ADD [VariantOptionSortOrder] INT DEFAULT 0
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'VariantOptionSortOrder' in table 'EcomVariantsOptions' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.UPDATE [EcomVariantsOptions] SET VariantOptionSortOrder = 0 WHERE VariantOptionSortOrder IS NULL
2008-06-10 11:51:34 Upgrade license set to 18.13.0.0
2008-06-10 11:51:34 Package 33 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomProductsRelatedGroups] ADD [RelatedGroupSortOrder] INT DEFAULT 0
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'RelatedGroupSortOrder' in table 'EcomProductsRelatedGroups' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomProductsRelated] ADD [ProductRelatedSortOrder] INT DEFAULT 0
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'ProductRelatedSortOrder' in table 'EcomProductsRelated' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 34 from ecom.xml
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComAddFavorite.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComAddToCart.jpg' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComCopy.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComDelete.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComExportExcel.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComFilter.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComMailOrder.gif' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Filer\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Filer\CustomerCareCenter\eComPrint.gif' already exists.
2008-06-10 11:51:34 Upgrade license set to 18.11.1.0
2008-06-10 11:51:34 Package 35 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomPayments] ADD [PaymentIconOrderList] NVARCHAR(255) NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'PaymentIconOrderList' in table 'EcomPayments' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 36 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleDataBase = 'Ecom.mdb', ModuleTable = 'EcomShops', ModuleFieldID = 'ShopID', ModuleFieldName = 'ShopName' WHERE ModuleSystemName = 'eCom_Catalog'
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 37 from ecom.xml
2008-06-10 11:51:34 Conditional empty - Standard SQL applied.INSERT INTO [Module] (ModuleSystemName, ModuleName, ModuleAccess, ModuleStandard, ModuleParagraph, ModuleHiddenMode, ModuleEcomNotInstalledAccess, ModuleIsBeta) VALUES ('eCom_CustomerCareCenter', 'CustomerCareCenter', 0, 0, 1, 0, 0, 0)
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.EcomCustomersSettings (SettingID INT IDENTITY(1,1) PRIMARY KEY, AccessUserID INT NOT NULL, PaymentMethodID NVARCHAR (50) NOT NULL, ShippingMethodID NVARCHAR(50) NOT NULL, CurrencyCode NVARCHAR(10) NOT NULL )
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomCustomersSettings' in the database.
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.EcomCustomerFavoriteLists (ID INT IDENTITY(1,1) PRIMARY KEY, AccessUserID INT NOT NULL, [Name] NVARCHAR(255) NOT NULL )
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomCustomerFavoriteLists' in the database.
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.EcomCustomerFavoriteProducts (FavoriteListID INT NOT NULL, ProductID NVARCHAR(30) NOT NULL, ProductLanguageID NVARCHAR(50) NOT NULL, ProductVariantID NVARCHAR(255) NOT NULL, [Note] NTEXT NULL, ProductReferenceUrl NTEXT NULL, PRIMARY KEY(FavoriteListID, ProductID, ProductLanguageID, ProductVariantID))
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomCustomerFavoriteProducts' in the database.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomCustomersSettings] ADD CONSTRAINT EcomCustomersSettings_FK00 FOREIGN KEY (AccessUserID) REFERENCES AccessUser (AccessUserID) ON DELETE CASCADE
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomCustomersSettings_FK00' in the database. Could not create constraint. See previous errors.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomCustomerFavoriteProducts] ADD CONSTRAINT FK_EcomCustomerFavoriteProducts_EcomCustomerFavoriteLists FOREIGN KEY (FavoriteListID) REFERENCES EcomCustomerFavoriteLists (ID) ON DELETE CASCADE
2008-06-10 11:51:34 - error: 5 - There is already an object named 'FK_EcomCustomerFavoriteProducts_EcomCustomerFavoriteLists' in the database. Could not create constraint. See previous errors.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomCustomerFavoriteProducts] ADD CONSTRAINT FK_EcomCustomerFavoriteProducts_EcomProducts FOREIGN KEY (ProductID, ProductLanguageID, ProductVariantID) REFERENCES EcomProducts (ProductID, ProductLanguageID, ProductVariantID) ON DELETE CASCADE
2008-06-10 11:51:34 - error: 5 - There is already an object named 'FK_EcomCustomerFavoriteProducts_EcomProducts' in the database. Could not create constraint. See previous errors.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomCustomerFavoriteLists] ADD CONSTRAINT FK_EcomCustomerFavoriteLists_AccessUser FOREIGN KEY (AccessUserID) REFERENCES AccessUser (AccessUserID) ON DELETE CASCADE
2008-06-10 11:51:34 - error: 5 - There is already an object named 'FK_EcomCustomerFavoriteLists_AccessUser' in the database. Could not create constraint. See previous errors.
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.EcomAccessUser (EcomAccessUserID INT)
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomAccessUser' in the database.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE EcomAccessUser ADD FOREIGN KEY (EcomAccessUserID) REFERENCES AccessUser(AccessUserID) ON DELETE CASCADE
2008-06-10 11:51:34 - error: 5 - Introducing FOREIGN KEY constraint 'FK__EcomAcces__EcomA__67352964' on table 'EcomAccessUser' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint. See previous errors.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\CustomerCareCenter.css' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\CustomerCareCenter.js' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\EditFavoriteList.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\EditFavoriteProduct.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\EmailForgottenPassword.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\EmailNotification.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\FavoriteLists.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\FavoriteProducts.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\ForgottenPassword.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\Login.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\MailOrder.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\Navigation.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\OrderDetails.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\OrdersList.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\PrintFavoriteProducts.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\PrintOrder.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\ProductsList.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\Profile.html' already exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter - The file 'F:\Dynamicweb\Files\Templates\eCom\CustomerCareCenter\ValidatorMessages.html' already exists.
2008-06-10 11:51:34 Upgrade license set to 18.12.1.0
2008-06-10 11:51:34 Package 38 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleScript = 'Integration/Frame.aspx', ModuleName = 'Integration', ModuleSystemName = 'Integration', ModuleEcomNotInstalledAccess = NULL, ModuleEcomStandardAccess = NULL, ModuleEcomExtendedAccess = NULL WHERE ModuleSystemName = 'eCom_ImportExport'
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleScript = 'Integration/Frame.aspx', ModuleName = 'Import/eksport', ModuleSystemName = 'DW_Integration_ImportExport', ModuleEcomNotInstalledAccess = NULL, ModuleEcomStandardAccess = NULL, ModuleEcomExtendedAccess = NULL WHERE ModuleSystemName = 'Integration'
2008-06-10 11:51:34 Standard SQL applied.UPDATE [EcomTree] SET TreeHasAccessModuleSystemName = 'Integration' WHERE TreeHasAccessModuleSystemName = 'eCom_ImportExport' AND TreeChildPopulate = 'IMPEXP'
2008-06-10 11:51:34 Standard SQL applied.UPDATE [EcomTree] SET TreeHasAccessModuleSystemName = 'DW_Integration_ImportExport' WHERE TreeHasAccessModuleSystemName = 'Integration' AND TreeChildPopulate = 'IMPEXP'
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 39 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE EcomSalesDiscount ADD SalesDiscountProductsAndGroups NVARCHAR(MAX) NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'SalesDiscountProductsAndGroups' in table 'EcomSalesDiscount' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 40 from ecom.xml
2008-06-10 11:51:34 Conditional present - excaping.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 41 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleIsBeta = 1 WHERE ModuleSystemName='eCom_CustomerCareCenter'
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 42 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomOrderLines] ADD OrderLineDiscountID NVARCHAR(255) NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'OrderLineDiscountID' in table 'EcomOrderLines' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 43 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.[EcomUserPermission]([UserPermissionTypeGUID] [uniqueidentifier] NOT NULL, [UserPermissionUserId] [int] NOT NULL, [UserPermissionRights] [int] NOT NULL, CONSTRAINT [PK_EcomUserPermission] PRIMARY KEY CLUSTERED ( [UserPermissionTypeGUID] ASC, [UserPermissionUserId] ASC ) )
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomUserPermission' in the database.
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.[EcomUserPermissionType]( [UserPermissionType] [int] NOT NULL, [UserPermissionTypeID] [varchar](255), [UserPermissionTypeGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_EcomUserPermissionType_UserPermissionTypeGUID] DEFAULT (newid()), CONSTRAINT [PK_EcomUserPermissionType] PRIMARY KEY CLUSTERED ([UserPermissionType] ASC, [UserPermissionTypeID] ASC ) )
2008-06-10 11:51:34 - error: 5 - There is already an object named 'EcomUserPermissionType' in the database.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 44 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [EcomOrders] ADD OrderTransactionMailSend BIT NOT NULL DEFAULT 0
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'OrderTransactionMailSend' in table 'EcomOrders' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 45 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE EcomUserPermissionType DROP COLUMN CONSTRAINT DF_EcomUserPermissionType_UserPermissionTypeGUID
2008-06-10 11:51:34 - error: 5 - Incorrect syntax near the keyword 'CONSTRAINT'.
2008-06-10 11:51:34 Standard SQL applied.CREATE TABLE dbo.Tmp_EcomUserPermissionType(UserPermissionType nvarchar(50) NOT NULL, UserPermissionTypeID NVARCHAR(255) NOT NULL, UserPermissionTypeGUID uniqueidentifier NOT NULL)
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE Tmp_EcomUserPermissionType ADD CONSTRAINT DF_EcomUserPermissionType_UserPermissionTypeGUID DEFAULT (newid()) FOR UserPermissionTypeGUID
2008-06-10 11:51:34 - error: 5 - There is already an object named 'DF_EcomUserPermissionType_UserPermissionTypeGUID' in the database. Could not create constraint. See previous errors.
2008-06-10 11:51:34 Standard SQL applied.IF EXISTS(SELECT * FROM EcomUserPermissionType) EXEC('INSERT INTO Tmp_EcomUserPermissionType (UserPermissionType, UserPermissionTypeID, UserPermissionTypeGUID) SELECT CONVERT(nvarchar(50), UserPermissionType), UserPermissionTypeID, UserPermissionTypeGUID FROM EcomUserPermissionType WITH (HOLDLOCK TABLOCKX)')
2008-06-10 11:51:34 Standard SQL applied.DROP TABLE EcomUserPermissionType
2008-06-10 11:51:34 Standard SQL applied.EXECUTE sp_rename N'Tmp_EcomUserPermissionType', N'EcomUserPermissionType', 'OBJECT'
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE EcomUserPermissionType ADD CONSTRAINT PK_EcomUserPermissionType PRIMARY KEY CLUSTERED (UserPermissionType, UserPermissionTypeID) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 46 from ecom.xml
2008-06-10 11:51:34 file F:\Dynamicweb\Files\templates\ecom\order\PrintOrder.html allready exists.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 47 from ecom.xml
2008-06-10 11:51:34 file !! Source does not exist - F:\Dynamicweb\Application\Admin\Update\Files\Filer\Integration\eCommerce\\Pages_Import_from_XML.pipe
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 48 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE EcomTree ADD ContextMenuName nvarchar(20) NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'ContextMenuName' in table 'EcomTree' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'ROOT' WHERE id = 1
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'SHOPS' WHERE id = 2
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'GROUPS' WHERE id = 3
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'ORDERS' WHERE id = 6
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'SETTINGS' WHERE id = 13
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'LANGUAGES' WHERE id = 14
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'CONFIGURATION' WHERE id = 15
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'REPORTS' WHERE id = 16
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'STATISTICS' WHERE id = 17
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'CURRENCY' WHERE id = 19
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'UNITS' WHERE id = 20
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'CAMPAIGNS' WHERE id = 21
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'AUTONUMBERS' WHERE id = 25
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'MANUFACTURERS' WHERE id = 27
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'VARIANTGROUPS' WHERE id = 28
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'COUNTRIES' WHERE id = 29
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'PAYMENTS' WHERE id = 30
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'SHIPPING' WHERE id = 31
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'DISCOUNTS' WHERE id = 32
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'IMPORTEXPORT' WHERE id = 33
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'STOCKSTATUS' WHERE id = 35
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'ROUNDING' WHERE id = 36
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'TAXRATES' WHERE id = 37
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'RELATEDITEMS' WHERE id = 38
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'ORDERSTATUS' WHERE id = 40
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'PRODUCTFIELDS' WHERE id = 41
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'GROUPFIELDS' WHERE id = 45
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'ORDERFIELDS' WHERE id = 46
2008-06-10 11:51:34 Standard SQL applied.UPDATE EcomTree SET ContextMenuName = 'PRODUCTGROUPFIELDS' WHERE id = 47
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 49 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.DELETE FROM [Module] WHERE ModuleSystemName='eCom_CustomerCareCenter'
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 50 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [AccessUser] ADD AccessUserCartID NVARCHAR(50) NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'AccessUserCartID' in table 'AccessUser' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0
2008-06-10 11:51:34 Package 51 from ecom.xml
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleEcomNotInstalledAccess = NULL WHERE ModuleSystemName='NavIntegration'
2008-06-10 11:51:34 Standard SQL applied.UPDATE [Module] SET ModuleEcomNotInstalledAccess = NULL WHERE ModuleSystemName='UrlPath'
2008-06-10 11:51:34 Upgrade license set to 18.14.1.0

 

 

2008-06-10 11:51:34

Updates initialized
2008-06-10 11:51:34 Package 201 from updates.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [Template] ADD TemplateImageLargeHeight INT NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'TemplateImageLargeHeight' in table 'Template' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [Template] ADD TemplateImageLargeWidth INT NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'TemplateImageLargeWidth' in table 'Template' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [Template] ADD TemplateImageThumbnailHeight INT NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'TemplateImageThumbnailHeight' in table 'Template' is specified more than once.
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE [Template] ADD TemplateImageThumbnailWidth INT NULL
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'TemplateImageThumbnailWidth' in table 'Template' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 202 from updates.xml
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\Weblog\Shared\ListTeam.html allready exists.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 203 from updates.xml
2008-06-10 11:51:34 Standard SQL applied.DELETE FROM [Module] WHERE [ModuleSystemName] = 'RemoteHttp'
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 204 from updates.xml
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\DBPub\Base\MasterList.html allready exists.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 205 from updates.xml
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\Weblog\Articles\ListArticle.html allready exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\Weblog\Articles\ShowArticle.html allready exists.
2008-06-10 11:51:34 file F:\Dynamicweb\Files\Templates\Weblog\Articles\LatestPosts.html allready exists.
2008-06-10 11:51:34 Upgrade license set to 18.13.1.0
2008-06-10 11:51:34 Package 206 from updates.xml
2008-06-10 11:51:34 Standard SQL applied.ALTER TABLE DBPubField ADD DBPubFieldLabel NVARCHAR(255) Null
2008-06-10 11:51:34 - error: 5 - Column names in each table must be unique. Column name 'DBPubFieldLabel' in table 'DBPubField' is specified more than once.
2008-06-10 11:51:34 Upgrade license set to 18.13.2.0
2008-06-10 11:51:34 Package 207 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.UPDATE IpaperLanguageKeys SET DefaultValue = 'Click here to go to the previous page.', FriendlyName = 'Forrige side ikon', Visible = 1 WHERE Name = 'help_zoomPaginLeft'
2008-06-10 11:51:35 Standard SQL applied.UPDATE IpaperLanguageKeys SET DefaultValue = 'Click here to go to the next page.', FriendlyName = 'Næste side ikon', Visible = 1 WHERE Name = 'help_zoomPaginRight'
2008-06-10 11:51:35 Upgrade license set to 18.13.3.0
2008-06-10 11:51:35 Package 208 from updates.xml
2008-06-10 11:51:35 Package 209 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Employee\Search\SearchFields.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\DBPub\Base\MasterList.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 210 from updates.xml
2008-06-10 11:51:35 Package 211 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Weblog\Articles\ShowArticle.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Weblog\Articles\ListArticle.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Weblog\Articles\LatestPosts.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 212 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE Area ADD AreaRobotsTxt NVARCHAR(255) Null, AreaRobotsTxtIncludeSitemap BIT NOT NULL DEFAULT 0
2008-06-10 11:51:35 - error: 5 - Column names in each table must be unique. Column name 'AreaRobotsTxt' in table 'Area' is specified more than once.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 213 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\eCom\Order - The file 'F:\Dynamicweb\Files\Templates\eCom\Order\DefaultOrder.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\eCom\Order - The file 'F:\Dynamicweb\Files\Templates\eCom\Order\PrintOrder.html' already exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 214 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\StatisticsV3\ReportUserAll\ShowSessionReport\DNSName.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\StatisticsV3\ReportUserAll\ShowSessionReport\UserLocalize.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\StatisticsV3\SiteMapEmailLink.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 215 from updates.xml
2008-06-10 11:51:35 file !! Source does not exist - F:\Dynamicweb\Application\Admin\Update\Files\Templates\ExtranetExtended\ValidatorMessages.html
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ExtranetExtended\UserNotification.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ExtranetExtended\UserConfirmation.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ExtranetExtended\Profile.html allready exists.
2008-06-10 11:51:35 file !! Source does not exist - F:\Dynamicweb\Application\Admin\Update\Files\Templates\ExtranetExtended\Login.html
2008-06-10 11:51:35 file !! Source does not exist - F:\Dynamicweb\Application\Admin\Update\Files\Templates\ExtranetExtended\ForgottenPassword.html
2008-06-10 11:51:35 file !! Source does not exist - F:\Dynamicweb\Application\Admin\Update\Files\Templates\ExtranetExtended\EmailForgottenPassword.html
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ExtranetExtended\AdminConfirmation.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 216 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\RSSfeed\RSSList\RSSExt_News2Default_Page.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 217 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Database\Sms.mdb allready exists.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSCampaignType(SMSCampaignTypeID int identity(1,1) primary key NOT NULL,SMSCampaignTypeName NVARCHAR(255) NULL,SMSCampaignTypeDescription ntext NULL,SMSCampaignTypeExtendedOnly BIT NOT NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSCampaignType' in the database.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSKeyword(SMSKeywordID int identity(1,1) primary key NOT NULL, SMSKeywordName NVARCHAR(255) NULL, SMSKeywordChannel NVARCHAR(255) NULL, SMSKeywordDescription ntext NULL, SMSKeywordCreated datetime NULL, SMSKeywordCountry NVARCHAR(255) NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSKeyword' in the database.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSCampaignGroup(SMSCampaignGroupID int identity(1,1) primary key NOT NULL, SMSCampaignGroupName NVARCHAR(255) NULL, SMSCampaignGroupDescription ntext NULL, SMSCampaignGroupCreated datetime NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSCampaignGroup' in the database.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSCampaign(SMSCampaignID int identity(1,1) primary key NOT NULL,SMSCampaignGroupID int NULL,SMSKeywordID int NULL,SMSCampaignOrderCode NVARCHAR(255) NULL,SMSCampaignReturnSMSheader NVARCHAR(255) NULL,SMSCampaignReturnSMStext ntext NULL,SMSCampaignAddToSMSRecipientListID int NULL,SMSCampaignCreated datetime NULL,SMSCampaignForwardToEmail BIT NOT NULL,SMSCampaignForwardToEmailAddress NVARCHAR(255) NULL,SMSCampaignForwardToHTTP BIT NOT NULL,SMSCampaignForwardToHTTPUrl NVARCHAR(255) NULL,SMSCampaignForwardToHTTPOption1 ntext NULL,SMSCampaignForwardToHTTPOption2 ntext NULL,SMSCampaignForwardToHTTPOption3 ntext NULL,SMSCampaignPrice decimal NULL,SMSCampaignDonation BIT NOT NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSCampaign' in the database.
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE [SMSCampaign] ADD FOREIGN KEY([SMSCampaignGroupID]) REFERENCES [SMSCampaignGroup] ([SMSCampaignGroupID])
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE [SMSCampaign] ADD FOREIGN KEY([SMSKeywordID]) REFERENCES [SMSKeyword] ([SMSKeywordID])
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSOrder(SMSOrderID int identity(1,1) primary key NOT NULL, SMSCampaignID int NULL, SMSOrderText ntext NULL, SMSOrderMobile NVARCHAR(255) NULL, SMSOrderCreated datetime NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSOrder' in the database.
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE [SMSOrder] ADD FOREIGN KEY([SMSCampaignID]) REFERENCES [SMSCampaign] ([SMSCampaignID])
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSCountries(CountryID int identity(1,1) primary key NOT NULL, CountryCode SMALLINT NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSCountries' in the database.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSIncomming(SMSIncommingID int identity(1,1) primary key NOT NULL, SMSIncommingText NVARCHAR(255) NULL, SMSIncommingMobile NVARCHAR(255) NULL, SMSIncommingNetwork NVARCHAR(255) NULL, SMSIncommingChannel NVARCHAR(255) NULL, SMSIncommingServiceid NVARCHAR(255) NULL, SMSIncommingCreated datetime NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSIncomming' in the database.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSOutgoing( SMSOutgoingID int identity(1,1) primary key NOT NULL, SMSOutgoingMobile NVARCHAR(255) NULL, SMSOutgoingGatewayMessageID NVARCHAR(255) NULL, SMSOutgoingCreated datetime NULL, SMSOutgoingText ntext NULL, SMSOutgoingStatus int NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSOutgoing' in the database.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSRecipientList( SMSRecipientListID int identity(1,1) primary key NOT NULL, SMSRecipientListName NVARCHAR(255) NULL, SMSRecipientListDescription ntext NULL, SMSRecipientListCreated datetime NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSRecipientList' in the database.
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSRecipient(SMSRecipientID int identity(1,1) primary key NOT NULL,SMSRecipientListID int NULL,SMSRecipientFirstname NVARCHAR(255) NULL,SMSRecipientLastname NVARCHAR(255) NULL,SMSRecipientMobile NVARCHAR(255) NULL,SMSRecipientCreated datetime NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSRecipient' in the database.
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE [SMSRecipient] ADD FOREIGN KEY([SMSRecipientListID]) REFERENCES [SMSRecipientList] ([SMSRecipientListID])
2008-06-10 11:51:35 Standard SQL applied.CREATE TABLE dbo.SMSSetting(SMSSettingID int identity(1,1) primary key NOT NULL, SMSSettingVersionIsExtended BIT NOT NULL, SMSSettingSMSgatewayURL NVARCHAR(255) NULL, SMSSettingSMSgatewayUsername NVARCHAR(255) NULL, SMSSettingSMSgatewayPassword NVARCHAR(255) NULL, SMSSettingSMSgatewayErrorMessageHeader NVARCHAR(255) NULL, SMSSettingSMSgatewayErrorMessage NVARCHAR(255) NULL, SMSSettingSMSgatewayUserID int NULL, SMSSettingSMSgatewayKeyword NVARCHAR(50) NULL)
2008-06-10 11:51:35 - error: 5 - There is already an object named 'SMSSetting' in the database.
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 218 from updates.xml
2008-06-10 11:51:35 Package 219 from updates.xml
2008-06-10 11:51:35 Conditional empty - Standard SQL applied.UPDATE [Module] SET [ModuleControlPanel] = 'NewsV2_cpl.aspx' WHERE [ModuleSystemName] = 'NewsV2'
2008-06-10 11:51:35 - error: 5 - ExecuteScalar: CommandText property has not been initialized
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 220 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.alter table SMSSetting DROP COLUMN SMSSettingSMSgatewayUserID
2008-06-10 11:51:35 - error: 5 - ALTER TABLE DROP COLUMN failed because column 'SMSSettingSMSgatewayUserID' does not exist in table 'SMSSetting'.
2008-06-10 11:51:35 Standard SQL applied.alter table SMSSetting DROP COLUMN SMSSettingSMSgatewayKeyword
2008-06-10 11:51:35 - error: 5 - ALTER TABLE DROP COLUMN failed because column 'SMSSettingSMSgatewayKeyword' does not exist in table 'SMSSetting'.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 221 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE [Trashbin] ADD [TrashbinMasterID] INT NULL
2008-06-10 11:51:35 - error: 5 - Column names in each table must be unique. Column name 'TrashbinMasterID' in table 'Trashbin' is specified more than once.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 222 from updates.xml
2008-06-10 11:51:35 Package 223 from updates.xml
2008-06-10 11:51:35 Conditional empty - Standard SQL applied.ALTER TABLE [NewsLetterV3NewsLetter] ADD NewsletterUnsubscribeRedirectLink NTEXT NULL
2008-06-10 11:51:35 - error: 5 - Column names in each table must be unique. Column name 'NewsletterUnsubscribeRedirectLink' in table 'NewsLetterV3NewsLetter' is specified more than once.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 224 from updates.xml
2008-06-10 11:51:35 Package 225 from updates.xml
2008-06-10 11:51:35 Package 226 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\newsv2.css allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\newsfunctions.js allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 227 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.UPDATE [Module] SET ModuleIsBeta = 0 WHERE ModuleSystemName IN('NewsV2', 'eCom_CustomerCareCenter', 'NewsLetterV3')
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 228 from updates.xml
2008-06-10 11:51:35 Package 229 from updates.xml
2008-06-10 11:51:35 Package 230 from updates.xml
2008-06-10 11:51:35 Package 231 from updates.xml
2008-06-10 11:51:35 Package 232 from updates.xml
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 233 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ExtranetExtended\Profile.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 234 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.DELETE FROM [Module] WHERE [ModuleSystemName] = 'RemoteHttp'
2008-06-10 11:51:35 Conditional empty - Standard SQL applied.INSERT INTO [Module] (ModuleSystemName, ModuleName, ModuleAccess, ModuleStandard, ModuleParagraph, ModuleEcomNotInstalledAccess, ModuleHiddenMode, ModuleIsBeta) VALUES ('RemoteHttp', 'Content integrator', 0, 1, 1, NULL, 0, 1)
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 235 from updates.xml
2008-06-10 11:51:35 Package 236 from updates.xml
2008-06-10 11:51:35 Package 237 from updates.xml
2008-06-10 11:51:35 Package 238 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Archive\ArchiveList.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Archive\ArchiveDetailsList.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Edit\NewsletterRecipientEdit.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Edit\NewsletterRecipientEditQuick.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Edit\NewsLetterRecipientUnSubscribe.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Integration\NewsList.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Login\NewsLetterLogin.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Login\NewsLetterForgotPassword.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Mail\AdminNotificationMail.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsLetterV3\Mail\ConfirmationMail.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 239 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\List - The file 'F:\Dynamicweb\Files\Templates\NewsV2\List\css_list.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\List - The file 'F:\Dynamicweb\Files\Templates\NewsV2\List\List.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\List - The file 'F:\Dynamicweb\Files\Templates\NewsV2\List\Search.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B1-T5.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B11-T11.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B2-T2.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B2-T4.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B3-T3.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B4-T2.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\B5-T1.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\Bx-Tx.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\css_element.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T1-B5.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T11-B11.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T2-B2.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T2-B4.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T3-B3.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T4-B2.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\T5-B1.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Item - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Item\Tx-Bx.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Edit - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Edit\Form.html' already exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\NewsV2\Edit - The file 'F:\Dynamicweb\Files\Templates\NewsV2\Edit\Notify.html' already exists.
2008-06-10 11:51:35 Standard SQL applied. UPDATE [TemplateCategory] SET [TemplateCatgeoryDirectory] = 'NewsV2/Item' WHERE [TemplateCategoryName]='NewsV2'
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 240 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Database\Sms.mdb allready exists.
2008-06-10 11:51:35 Standard SQL applied.UPDATE [Module] SET ModuleAccess = 0 WHERE ModuleSystemName='Sms'
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 241 from updates.xml
2008-06-10 11:51:35 Conditional present - excaping.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 242 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Navigation\Dwdd.css allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Navigation\Dwdd.js allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Navigation\Dwdd.gif allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\Navigation\DwddDropdown.xslt allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.13.1.0
2008-06-10 11:51:35 Package 243 from updates.xml
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ForumV2\Thread\ListThread.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ForumV2\Thread\EditThread.html allready exists.
2008-06-10 11:51:35 file F:\Dynamicweb\Files\Templates\ForumV2\Post\EditPost.html allready exists.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 244 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.ALTER TABLE Page ADD PageTopLogoImageAlt NVARCHAR(255)
2008-06-10 11:51:35 - error: 5 - Column names in each table must be unique. Column name 'PageTopLogoImageAlt' in table 'Page' is specified more than once.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
2008-06-10 11:51:35 Package 245 from updates.xml
2008-06-10 11:51:35 Standard SQL applied.CREATE INDEX NewsCategory_IDX001 ON NewsCategory (NewsCategoryAccess)
2008-06-10 11:51:35 - error: 5 - The operation failed because an index or statistics with name 'NewsCategory_IDX001' already exists on table 'NewsCategory'.
2008-06-10 11:51:35 Upgrade license set to 18.14.1.0
 

 

 
Posted on 10/06/2008 12:25:05
Reply

Your log starts with 2008-06-10 11:51:34 Package 31 from ecom.xml which leads me to believe that package 30 hasn't been run. Have you tried running it from 29?

 
Posted on 10/06/2008 14:31:21
Reply
Sorensen wrote:

Your log starts with 2008-06-10 11:51:34 Package 31 from ecom.xml which leads me to believe that package 30 hasn't been run. Have you tried running it from 29?

Yessssssss. It has solved the problem for me. Thank you very much for your professional and expert help. 

 
Posted on 10/06/2008 14:35:26
Reply

Nobody has called me that for a long time:D

 

No problem, remember, nothing bad happens when running update scripts. This simply copies new templates and and creates new tables and columns. If they already exist, the won't get overwritten, so don't be afraid:)

 

You must be logged in to post in the forum