Install doesn't create db table

Found this here in another issue:

CREATE TABLE IF NOT EXISTS `opengraph_meta` (
`nid` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`image` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`optional` text,
PRIMARY KEY (`nid`)
)

I know its late - maybe this helps....

The problem is that the code that generates the database table contains an error: text columns should not have a default value. The Drupal 7 version is not affected. I have attached a patch to fix this problem.

I am changing this bug to major because the bug prevents people from installing this module.

Fixed in 6.x-1.x dev.

Patched in 6.x-1.x-dev.

Rather strangely this caused a problem for us on production, but not when we installed and tested on dev and staging.

Are there perhaps some DB configurations that would allow the install/create script to work?

Maybe MySQL has some strictness levels that allow the faulty SQL. By the way hiddentao: this bug does not exist in 7.x.

May be worth mentioning that the "faulty mySQL" is longtext with a default value.

Interestingly enough the install script uses a schema DB abstraction object that seems like the right way to do it.
Looks like it's just the description column's 'default' => '', entry, which probably came from a module builder :)

Perhaps someone more familiar with that structure could shed some light on how to do this properly?

function opengraph_meta_schema(){
    $schema[OPENGRAPH_META_TABLE] = array(
      'description' => 'Stores Open Graph meta tag info useful for when sharing nodes on social networking sites, e.g. Facebook.',
      'fields' => array(
        'nid' => array(
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
        ),
        OpenGraphMeta::TITLE => array(
          'type' => 'varchar',
          'length' => 255,
          'not null' => TRUE,
          'default' => ''
        ),
        OpenGraphMeta::DESCRIPTION => array(
          'type' => 'text',
          'not null' => TRUE,
          'size' => 'big',
          'default' => '', // <<< HERE IS THE SILLY PROBLEM.
        ),
        OpenGraphMeta::IMAGE => array(
          'type' => 'varchar',
          'length' => '255',
          'not null' => TRUE,
          'default' => '',
        ),
        OpenGraphMeta::TYPE => array(
          'type' => 'varchar',
          'length' => '255',
          'not null' => TRUE,
          'default' => '',
        ),
        OpenGraphMeta::__OPTIONAL_DB_FIELD => array(
          'type' => 'text',
          'not null' => FALSE,
          'default' => '',
          'serialize' => TRUE,
        ),
      ),
      'primary key' => array('nid'),
    );

    return $schema;
}

I've gotten rid of the 'default' => '' line in both 6.x and 7.x now. Fixed in dev.

Cool. thanks so much.
Might as well document this is related to the sql-mode...
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_stri...