安装时自动创建数据表出问题 - - Powered by Discuz!NT Archiver

PageAdmin网站内容管理系统(CMS)交流论坛

virus007 - 2019/10/12 12:26:48

sql:CREATE TABLE [dbo].[product_thumbnail]( [id] [int] IDENTITY(1,1) NOT NULL, [parentId] [int] NULL, [parentGuid] [varchar](50) NULL, [name] [nvarchar](50) NULL, [path] [nvarchar](100) NULL, [thumbnail] [nvarchar](100) NULL, [username] [nvarchar](50) NULL, [uid] [int] NULL, [state] [smallint] NULL, [thedate] [datetime] NULL, [xuhao] [int] NULL, [size] [decimal](12, 2) NULL ) ON [PRIMARY],error：SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

复制代码

xiyou - 2019/10/12 15:06:24

sql哪个版本？

virus007 - 2019/10/12 15:44:26

sql哪个版本？
xiyou 发表于 2019/10/12 15:06:24

数据库版本是Microsoft SQL Server 2008 R2

virus007 - 2019/10/12 15:45:15

回复 2楼xiyou的帖子

数据库版本是Microsoft SQL Server 2008 R2

xiyou - 2019/10/12 15:56:22

如果运行不了，直接复制/app_code/install.sql里面的内容在sql的查询分析器里面运行试试

virus007 - 2019/10/14 8:24:30

回复 5楼xiyou的帖子

试过了，报错更多。

xiyou - 2019/10/14 9:39:55

试试用sa用户运行，估计是你数据库用户权限不够