notnull should be not null

Created on 19 October 2010, over 14 years ago
Updated 11 January 2024, over 1 year ago

In both the stable and developmental version the dashboard install script has

        'col' => array(
          'type' => 'int',
          'size' => 'tiny',
          'unsigned' => TRUE,
          'notnull' => TRUE,
        ),

Instead of:

        'col' => array(
          'type' => 'int',
          'size' => 'tiny',
          'unsigned' => TRUE,
          'not null' => TRUE,
        ),

for the dashboard_widget table

This causes problems for databases where the default is not null when this is not specified such as:
Query failed: ERROR: null value in column "conf" violates not-null constraint in ..

πŸ› Bug report
Status

Closed: won't fix

Version

2.1

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States thekevinday

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024