After running quip install, I get this error:
Console running...
Attempting to install package with signature: quip-2.0.2-pl
Package found...now preparing to install.
Grabbing package workspace...
Workspace environment initiated, now installing package...
Could not create table [modx_quip_threads] SQL: CREATE TABLE [modx_quip_threads] ([name] NVARCHAR(255) NOT NULL DEFAULT ’’, [createdon] DATETIME NOT NULL, [moderated] BIT unsigned NOT NULL DEFAULT 1, [moderator_group] NVARCHAR(255) NOT NULL DEFAULT ’Administrator’, [moderators] NVARCHAR(max) NULL DEFAULT ’’, [notify_emails] NVARCHAR(max) NULL DEFAULT ’’, [resource] INT unsigned NOT NULL DEFAULT 0, [idprefix] NVARCHAR(255) NOT NULL DEFAULT ’qcom’, [existing_params] NVARCHAR(max) NULL DEFAULT ’{}’, [quip_call_params] NVARCHAR(max) NULL DEFAULT ’[]’, [quipreply_call_params] NVARCHAR(max) NULL DEFAULT ’[]’, PRIMARY KEY ([name]), CONSTRAINT [quipThread_moderated] UNIQUE ([moderated]), CONSTRAINT [quipThread_moderator_group] UNIQUE ([moderator_group]), CONSTRAINT [quipThread_resource] UNIQUE ([resource])) ERROR: Array ( [0] => 42000 [1] => 102 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ’unsigned’. )
Could not create table [modx_quip_comments] SQL: CREATE TABLE [modx_quip_comments] ([id] INTEGER IDENTITY PRIMARY KEY, [thread] NVARCHAR(255) NOT NULL DEFAULT ’’, [parent] INTEGER(10) unsigned NOT NULL DEFAULT ’0’, [rank] NVARCHAR(512) NULL, [author] INTEGER(10) unsigned NOT NULL DEFAULT ’0’, [body] NVARCHAR(max) NOT NULL DEFAULT ’’, [createdon] DATETIME NOT NULL, [editedon] DATETIME NOT NULL, [approved] BIT unsigned NOT NULL DEFAULT 1, [approvedon] DATETIME NOT NULL, [approvedby] INTEGER(10) unsigned NOT NULL DEFAULT ’0’, [name] NVARCHAR(255) NOT NULL DEFAULT ’’, [email] NVARCHAR(255) NOT NULL DEFAULT ’’, [website] NVARCHAR(255) NOT NULL DEFAULT ’’, [ip] NVARCHAR(255) NOT NULL DEFAULT ’0.0.0.0’, [deleted] BIT unsigned NOT NULL DEFAULT 0, [deletedon] DATETIME NOT NULL, [deletedby] INTEGER(10) unsigned NOT NULL DEFAULT ’0’, [resource] INT unsigned NOT NULL DEFAULT 0, [idprefix] NVARCHAR(255) NOT NULL DEFAULT ’qcom’, [existing_params] NVARCHAR(max) NULL DEFAULT ’[]’, CONSTRAINT [quipComment_thread] UNIQUE ([thread]), CONSTRAINT [quipComment_parent] UNIQUE ([parent]), CONSTRAINT [quipComment_author] UNIQUE ([author]), CONSTRAINT [quipComment_approved] UNIQUE ([approved]), CONSTRAINT [quipComment_approvedby] UNIQUE ([approvedby]), CONSTRAINT [quipComment_deleted] UNIQUE ([deleted]), CONSTRAINT [quipComment_deletedby] UNIQUE ([deletedby]), CONSTRAINT [quipComment_resource] UNIQUE ([resource])) ERROR: Array ( [0] => 42000 [1] => 102 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ’unsigned’. )
Could not create table [modx_quip_comments_closure] SQL: CREATE TABLE [modx_quip_comments_closure] ([ancestor] INT unsigned NOT NULL DEFAULT 0, [descendant] INT unsigned NOT NULL DEFAULT 0, [depth] INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY ([ancestor],[descendant])) ERROR: Array ( [0] => 42000 [1] => 102 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ’unsigned’. )
Error 42S02 executing statement: Array ( [0] => 42S02 [1] => 208 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name ’modx_quip_comments’. )
Error 42S02 executing statement: Array ( [0] => 42S02 [1] => 208 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name ’modx_quip_comments’. )
Successfully installed package quip-2.0.2-pl
My configuration is: MODX Revo 2.1rc4 Traditional, OS is Win Server 2008 R2, IIS 7.5, on SQL Server database 2008 express, PHP is 5.3.6.
