Closed (fixed)
Project:
FillPDF
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
2 Oct 2012 at 22:03 UTC
Updated:
1 Sep 2015 at 11:24 UTC
Jump to comment: Most recent
MsSQL doesn't support length in Integer Type.
These are the error I got when enable the module.
WD php: PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native [error]
Client 10.0][SQL Server]Column, parameter, or variable #1: Cannot
specify a column width on data type int.: CREATE TABLE
[{fillpdf_forms}] (
[fid] int(10) NOT NULL CHECK (fid >= 0),
[title] nvarchar(255) NOT NULL,
[default_nid] int CHECK (default_nid >= 0),
[url] nvarchar(255) NOT NULL,
[destination_path] nvarchar(255),
[replacements] nvarchar(max),
[destination_redirect] int CHECK (destination_redirect >= 0),
CONSTRAINT {fillpdf_forms}_pkey PRIMARY KEY CLUSTERED ([fid])
); Array
(
)
in db_create_table() (line 2685 of
G:\wwwroot_443\includes\database\database.inc).
Cannot modify header information - headers already sent by (output [warning]
started at C:\ProgramData\Drush\includes\output.inc:37)
bootstrap.inc:1251
PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Se
rver]Column, parameter, or variable #1: Cannot specify a column width on data ty
pe int.: CREATE TABLE [{fillpdf_forms}] (
[fid] int(10) NOT NULL CHECK (fid >= 0),
[title] nvarchar(255) NOT NULL,
[default_nid] int CHECK (default_nid >= 0),
[url] nvarchar(255) NOT NULL,
[destination_path] nvarchar(255),
[replacements] nvarchar(max),
[destination_redirect] int CHECK (destination_redirect >= 0),
CONSTRAINT {fillpdf_forms}_pkey PRIMARY KEY CLUSTERED ([fid])
); Array
(
)
in db_create_table() (line 2685 of G:\wwwroot_443\includes\database\database.in
c).Please consider patch below.
@@ -15,7 +15,6 @@
'fields' => array(
'fid' => array(
'type' => 'int',
- 'length' => 10,
'unsigned' => TRUE,
'not null' => TRUE,
),
@@ -57,7 +56,6 @@
'fields' => array(
'fid' => array(
'type' => 'int',
- 'length' => 10,
'unsigned' => TRUE,
'not null' => TRUE,
),
Comments
Comment #1
wizonesolutionsCan you submit that as a patch? That'll help review this faster. Though it's pretty easy, so will review soon.
Comment #2
wizonesolutionsCommitted, pushed, and credit given. Thank you!
Comment #3
wizonesolutionsActually, this might need backporting to 6.x-1.x. So marking as such.
Comment #7
wizonesolutionsDrupal 8 is around the corner. I'm not going to leave issues that are waiting on a D6 backport open. I don't have time to maintain it anymore. New issues can be opened by people interested in contributing patches.