The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

Yes, Sympa is now fully virtual host enabled and thus you need to have a value for this field.
As you come from a "no virtual host" version, I suggeest you set the default value "*" for each line.

This require a manipulation of you text query, but nothing a little perl script could not handle. You should also add all the manipulations to perform to a migration script that will be used once you are ready to definitively switch the servers.

Regards,

David

Le 09/06/2010 14:56, Jean-Baptiste Denis a écrit :

address@concealed">

Ok, so here i am.

- i've run the create_db.Pg script (from 6.0.3) on a fresh new installation.
- i've dumped the old database using pg_dump -Fp --data-only ...

When i try to restore the old data in the new database, i've got this error 
message :

ERROR:  a NULL value is violating the NOT NULL constraint of « 
robot_subscriber » column.

Indeed, the old subscriber_table from the 3.4.3 version does not contain a 
"robot subscriber" column. The new table contains it with a NOT NULL 
constraint.

Maybe this is a more SQL related problem, but i'd like to know if there is a 
good way to handle this problem in the Sympa context. I could just reset the 
constraint for the restore, but i don't know if this is a good idea.

Regards,

Jean-Baptiste

  

--
David Verdin
Comité réseau des universités

Due to the limitations of human brain, I fail to remember all the mails.
So if you want your bug reports or feature requests for Sympa to be processed, please post them to the Sympa tracker