I realized today that the boxes sql table is very strange for different reasons:

1) bid is an auto_increment field, whereas as all other tables use the sequences table.

2) the info field is UNIQUE eventhough it is NOT marked as required in form UI.

PS: It seems somebody else found the problem already on http://drupal.org/node/27397 but didnt file an issue, at least I couldnt find it.

Comments

crac’s picture

crac commented

Here the original (buggy) sql files for

a) mysql

CREATE TABLE boxes (
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
  body longtext,
  info varchar(128) NOT NULL default '',
  format int(4) NOT NULL default '0',
  PRIMARY KEY (bid),
  UNIQUE KEY title (title),
  UNIQUE KEY info (info)
) TYPE=MyISAM;

b) psql

CREATE TABLE boxes (
  bid SERIAL,
  title varchar(64) NOT NULL default '',
  body text default '',
  info varchar(128) NOT NULL default '',
  format smallint NOT NULL default '0',
  PRIMARY KEY  (bid),
  UNIQUE (info),
  UNIQUE (title)
);
tostinni’s picture

tostinni commented
Status: Active » Closed (duplicate)

This has been fixed in HEAD see http://drupal.org/node/27713
If you want to see this corrected in 4.6 see there http://drupal.org/node/11724

So I think this is a duplicate bug.

Regards