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

wizonesolutions’s picture

Can you submit that as a patch? That'll help review this faster. Though it's pretty easy, so will review soon.

wizonesolutions’s picture

Version: 7.x-1.7 » 7.x-1.x-dev
Status: Needs review » Fixed

Committed, pushed, and credit given. Thank you!

wizonesolutions’s picture

Version: 7.x-1.x-dev » 6.x-1.x-dev
Status: Fixed » Patch (to be ported)

Actually, this might need backporting to 6.x-1.x. So marking as such.

  • Commit e92a49b on 7.x-1.x, 7.x-1.x-ubercartbackporttest authored by supakitk, committed by wizonesolutions:
    Issue #1801478: Fix field definitions for cross-database compatibility.
    

wizonesolutions’s picture

Status: Patch (to be ported) » Fixed

Drupal 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.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.