The mailing list for listmasters using Sympa

[Paul Wisén <address@concealed>]

hmm. I was upgrading to from Sympa 3.0.3 to Sympa 3.1.1 and got this when i
tried to start up sympa again..
---------
Starting module sympa.pl: DBD::mysql::db do failed: All parts of a PRIMARY
KEY must be NOT NULL;  If you need NULL in a key, use UNIQUE instead at
/home/sympa/bin/List.pm line 4936.
Database sympa defined in sympa.conf has not the right structure or is
unreachable. If you don't use any database, comment db_xxx parameters in
sympa.conf
[FAILED]
Starting module archived.pl: [  OK  ]
Starting module bounced.pl: DBD::mysql::db do failed: All parts of a PRIMARY
KEY must be NOT NULL;  If you need NULL in a key, use UNIQUE instead at
/home/sympa/bin/List.pm line 4936.
Sympa not setup to use DBI, unable to manage bounces
[FAILED]
---------

the install script first told me to do this so I did:

ALTER TABLE subscriber_table ADD comment_subscriber varchar (150);

My database structure then looks like this:

+-----------------------+--------------+------+-----+---------------------+-
------+
| Field                 | Type         | Null | Key | Default             |
Extra |
+-----------------------+--------------+------+-----+---------------------+-
------+
| list_subscriber       | varchar(50)  |      | PRI |                     |
|
| user_subscriber       | varchar(50)  |      | PRI |                     |
|
| date_subscriber       | datetime     |      |     | 0000-00-00 00:00:00 |
|
| visibility_subscriber | varchar(20)  | YES  |     | NULL                |
|
| reception_subscriber  | varchar(20)  | YES  |     | NULL                |
|
| bounce_subscriber     | varchar(30)  | YES  |     | NULL                |
|
| update_subscriber     | datetime     | YES  |     | NULL                |
|
| comment_subscriber    | varchar(150) | YES  |     | NULL                |
|
+-----------------------+--------------+------+-----+---------------------+-
------+

I can't find any rows with null in list_subscriber or user_subscriber and I
haven't changed the sympa.conf file so..

what could be the problem ?

(it's probably soo simple, when you find it.. ;)  )

regards / Paul Wisén Busnet Sweden
www.busnet.se