When using the installation wizard, I get the following error on step 3:
An error occured: Line 8: Incorrect syntax near '('. Running scripts from file: C:\nopCommerce_1.10\NopCommerce\NopCommerceWeb\install\Scripts\nopCommerce_createDatabase.sql
Thank you for your response. The code is as follows
nopCommerce_createDatabase.sql:
/****** Object: Table [dbo].[Nop_CustomerRole_Discount_Mapping] Script Date: 02/03/2009 15:49:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Nop_CustomerRole_Discount_Mapping]( [CustomerRoleID] [int] NOT NULL, [DiscountID] [int] NOT NULL, CONSTRAINT [PK_Nop_CustomerRole_Discount_Mapping] PRIMARY KEY CLUSTERED ( [CustomerRoleID] ASC, [DiscountID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: StoredProcedure [dbo].[Nop_ShippingMethodDelete] Script Date: 02/03/2009 15:49:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[Nop_ShippingMethodDelete] ( @ShippingMethodID int ) AS BEGIN SET NOCOUNT ON DELETE FROM [Nop_ShippingMethod] WHERE ShippingMethodID = @ShippingMethodID END GO
nopCommerce_createData.sql:
/****** Object: Table [dbo].[Nop_LocaleStringResource] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_LocaleStringResource] GO /****** Object: Table [dbo].[Nop_NewsComment] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_NewsComment] GO /****** Object: Table [dbo].[Nop_News] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_News] GO /****** Object: Table [dbo].[Nop_Customer_CustomerRole_Mapping] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_Customer_CustomerRole_Mapping] GO /****** Object: Table [dbo].[Nop_CustomerAttribute] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_CustomerAttribute] GO /****** Object: Table [dbo].[Nop_Address] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_Address] GO /****** Object: Table [dbo].[Nop_ProductVariantAttributeValue] Script Date: 02/03/2009 15:53:23 ******/ DELETE FROM [dbo].[Nop_ProductVariantAttributeValue]
The error is in all lines "WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)". Some suggests??? Thanks :-)
I am getting that same error she got above running the script from 1.3 database script. I don't want to reinstall sql though. What can I do? It must be a setting in sql setup causing the issue.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Vous avez encore des questions ou avez besoin d'aide?