Hi,

there is a install-problem located in registration.install

The datatypes of the datetime-fields are declared for mysql and pgsql. The declaration for sqlsrv and sqlite is missing.

The following changes worked for me.

...
'reminder_date' => array(
'description' => 'Date to send the reminder on.',
'mysql_type' => 'datetime',
'pgsql_type' => 'timestamp',
++ 'sqlite_type' => 'varchar',
++ 'sqlsrv_type' => 'smalldatetime',
'not null' => FALSE,
),
...
'open' => array(
'description' => 'Date to open registrations. Or NULL to open immediately.',
'mysql_type' => 'datetime',
'pgsql_type' => 'timestamp',
++ 'sqlite_type' => 'varchar',
++ 'sqlsrv_type' => 'smalldatetime',
'not null' => FALSE,
),
'close' => array(
'description' => 'Date to close registrations. Or NULL to never close automatically.',
'mysql_type' => 'datetime',
'pgsql_type' => 'timestamp',
++ 'sqlite_type' => 'varchar',
++ 'sqlsrv_type' => 'smalldatetime',
'not null' => FALSE,
),

Comments

ezra-g’s picture

Title: Install fails on sqlsrv » Install fails on MS SQL Server
Status: Active » Needs work

Thanks, geigerg. Can you file these changes as a patch?

geigerg’s picture

1st patch ever ...

ezra-g’s picture

Status: Needs work » Needs review

Congrats, geigerg! Marking as "needs review."

levelos’s picture

Title: Install fails on MS SQL Server » Add native sqlsrv and sqlite definitions for date schema fields
Status: Needs review » Fixed

Nice work @geigerg. Committed!

Status: Fixed » Closed (fixed)

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

  • levelos committed 5ca9017 on 7.x-1.x, panels, any-entity, slots, integrations, hold_state authored by geigerg
    #1893148: Add native sqlsrv and sqlite definitions for date schema...