retitle 651942 upgrades fails while using sympa with postgresql
thanks
--
Emmanuel Bouthenot
mail: kolter@{openics,debian}.orggpg: 4096R/0x929D42C3
xmpp: kol...@im.openics.org irc: kolter@{freenode,oftc}
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
severity 651942 important
thanks
On Tue, Dec 13, 2011 at 02:10:35PM +0100, Giorgio Volpe wrote:
[...]
Update from sympa sympa_5.3.4-6.1 to 6.1.7 fails. I get many
DBD::Pg::st execute failed: ERROR: relation conf_table does not
exist at /usr/share/sympa/lib/Conf.pm line 668. errors. If i
Hi,
Sympa is distributed with queries that recreate the database from
scratch. For Postgres, you can find it here, for example:
https://www.sympa.org/distribution/current/src/etc/script/create_db.Pg
Please, pretty please : DON'T USE IT DIRECTLY ON YOUR PRODUCTION
DATABASE. It is full of drop
OK! I succeeded in upgrading! Thanks to David!
I've not only created conf_table but, by hand, upgraded all database structure.
(diff between old and new create_db).
On the bottom of this mail the SQL I've used ... if may be useful for somebody.
Than, when upgrading with apt-get install sympa
Dear all,
The conf table will be automatically added if you are using mysql or
SQLite. Other RDBMS-driven databases are not automatically upgraded.
What RDBMS are you using?
Regards,
David
Le 19/12/11 23:32, Emmanuel Bouthenot a écrit :
On Mon, Dec 19, 2011 at 10:58:38PM +0100, Giorgio
Il 05/01/2012 17:41, David Verdin ha scritto:
Dear all,
The conf table will be automatically added if you are using mysql or
SQLite. Other RDBMS-driven databases are not automatically upgraded.
What RDBMS are you using?
OK! Is this the problem?. I use postgres!
Is there a way to upgrade
Hi Giorgio,
Sorry for the late reply,
On Wed, Dec 14, 2011 at 10:50:58AM +0100, Giorgio Volpe wrote:
[...]
1) Dowloded
http://ftp.de.debian.org/debian/pool/main/s/sympa/sympa_6.1.7~dfsg-2_i386.deb
2) Tried to install with: dpkg -i sympa_6.1.7~dfsg-2_i386.deb
but the result is the same as
Il 19/12/2011 21.30, Emmanuel Bouthenot ha scritto:
That's sound weird, could you try with the following command: $ /usr/lib/sympa/bin/sympa.pl --upgrade M.
Same result! :-(
I get:
# /usr/lib/sympa/bin/sympa.pl --upgrade
info Configuration file read, default log level 0
DBD::Pg::st execute
On Mon, Dec 19, 2011 at 10:58:38PM +0100, Giorgio Volpe wrote:
Il 19/12/2011 21.30, Emmanuel Bouthenot ha scritto:
That's sound weird, could you try with the following command: $
/usr/lib/sympa/bin/sympa.pl --upgrade M.
Same result! :-(
I get:
# /usr/lib/sympa/bin/sympa.pl --upgrade
Package: sympa
Version: 6.1.7~dfsg-1
Severity: grave
Justification: renders package unusable
Update from sympa sympa_5.3.4-6.1 to 6.1.7 fails.
I get many DBD::Pg::st execute failed: ERROR: relation conf_table does not
exist at /usr/share/sympa/lib/Conf.pm line 668. errors.
If i manually try
Hi Giorgio,
On Tue, Dec 13, 2011 at 02:10:35PM +0100, Giorgio Volpe wrote:
Package: sympa
Version: 6.1.7~dfsg-1
Severity: grave
Justification: renders package unusable
Update from sympa sympa_5.3.4-6.1 to 6.1.7 fails.
I get many DBD::Pg::st execute failed: ERROR: relation conf_table
11 matches
Mail list logo