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,
),
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | Install_fails_on_MS_SQL_Server-1893148-1.patch | 1.14 KB | geigerg |
Comments
Comment #1
ezra-g commentedThanks, geigerg. Can you file these changes as a patch?
Comment #2
geigerg commented1st patch ever ...
Comment #3
ezra-g commentedCongrats, geigerg! Marking as "needs review."
Comment #4
levelos commentedNice work @geigerg. Committed!