The mailing list for listmasters using Sympa

[Oskar Eyb <address@concealed>]

> You did not mention what RDBMS you are using ?

Oh sorry... I'm using MySQL 4.1.18


> It looks like the 'topics_subscriber' DB field is tagged as 'not null'
> in your 'sympa' database. Can you check ?

Yes, it was set to NOT NULL.. I've changed it now.


> Anyway this DB field can be null and you should remove its 'not null'
> attribute.

Ok, I have done that.

Here is the structure in my DB:

CREATE TABLE `subscriber_table` (
  `list_subscriber` varchar(50) NOT NULL default '',
  `user_subscriber` varchar(100) NOT NULL default '',
  `robot_subscriber` varchar(80) NOT NULL default '',
  `date_subscriber` datetime NOT NULL default '0000-00-00 00:00:00',
  `update_subscriber` datetime default NULL,
  `visibility_subscriber` varchar(20) default NULL,
  `reception_subscriber` varchar(20) default NULL,
  `topics_subscriber` varchar(200) default NULL,
  `bounce_subscriber` varchar(35) default NULL,
  `comment_subscriber` varchar(150) default NULL,
  `subscribed_subscriber` enum('0','1') default NULL,
  `included_subscriber` enum('0','1') default NULL,
  `include_sources_subscriber` varchar(50) default NULL,
  `bounce_score_subscriber` smallint(6) default NULL,
  `bounce_address_subscriber` varchar(100) default NULL,
  PRIMARY KEY  (`list_subscriber`,`user_subscriber`),
  KEY `user_subscriber` (`user_subscriber`,`list_subscriber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Should I add  robot_subscriber as primary key?



> That's strange because the DB creation scripts we distribute never set
> the 'topics_subscriber' DB field as 'not null'. Did you create the
> database manually ? Did you edit the structure ?

I edit the structure as mentioned in my first mail with this subject
because executing create_db.mysql in the existing db causes no changes?!



Cheers,
Oskar