Hi, when I activated the module in admin/build/modules, I got this message:

user warning: BLOB/TEXT column 'data' can't have a default value query: CREATE TABLE ticket_files ( `fid` INT unsigned NOT NULL DEFAULT 0, `tid` INT unsigned NOT NULL DEFAULT 0, `eid` INT unsigned NOT NULL DEFAULT 0, `uid` INT unsigned NOT NULL DEFAULT 0, `filename` VARCHAR(255) NOT NULL DEFAULT '', `filemime` VARCHAR(255) NOT NULL DEFAULT '', `filesize` INT unsigned NOT NULL DEFAULT 0, `timestamp` INT unsigned NOT NULL DEFAULT 0, `list` TINYINT unsigned NOT NULL DEFAULT 0, `data` LONGBLOB NOT NULL DEFAULT '', PRIMARY KEY (fid), INDEX ticket (tid, eid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Inetpub\wwwroot\Gnosis\includes\database.inc on line 515.

Thanks

Comments

roczei’s picture

roczei commented
Assigned: Unassigned » roczei

Please modify the ticket_schema part in the ticket.install file.

$schema['ticket_files'] = array(
...

This is the current state:

'data' => array(
'type' => 'blob',
'not null' => TRUE,
'default' => '',
'size' => 'big',
'description' => t('Uploaded file content.'),
),

You need to modify it to this:

'data' => array(
'type' => 'blob',
'not null' => TRUE,
'size' => 'big',
'description' => t('Uploaded file content.'),
),

Please answer to us that this solved your problem.

owen32’s picture

owen32 commented

- got the same error on enabling the module - disabled the module, made the change above and reenabled the module - no error seen - no to play with the ticketing features - THANKS!

mr.york’s picture

mr.york commented
Status: Active » Closed (fixed)

Fixed: 6.x-3.0-rc2