Accéder au contenu.
Menu Sympa

fr - [sympa-fr] sympa died DBD::mysql::st execute failed:

Objet : Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa

Archives de la liste

Chronologique Discussions  
  • From: adresse@cachée
  • To: adresse@cachée
  • Subject: [sympa-fr] sympa died DBD::mysql::st execute failed:
  • Date: Mon, 12 Mar 2007 14:55:23 +0100

J'ai un probleme avec, apparemment, la table 'admin' au lancement de sympa.pl
sous sun sparc avec une solaris 7 (version 5.2.4 de sympa).

Starting Sympa subsystem:
Starting module sympa.pl:
DBD::mysql::db do failed: Table 'admin_table' already exists at
/export/home/sympa/bin/List.pm line 10767.
DBD::mysql::db do failed: Table 'user_table' already exists at
/export/home/sympa/bin/List.pm line 10767.
DBD::mysql::db do failed: Table 'subscriber_table' already exists at
/export/home/sympa/bin/List.pm line 10767.
DBD::mysql::db do failed: Table 'netidmap_table' already exists at
/export/home/sympa/bin/List.pm line 10767.
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near '.`admin_table' at line 1
at /export/home/sympa/bin/List.pm line 10789.
success


10789 unless ($sth->execute) {
10790 do_log('err','Unable to execute SQL query : %s',
$dbh->errstr);
10791 return 1;
}

Pour que sympa.pl ne 'meurt' pas il a fallu que je change la ligne 10791
ci-dessu en 'return 1' à la place 'return undef'. Si je laisse 'return undef'
sympa.pl meurt. Quel est le problème et comment corriger ce problème ?
Ci-dessous la vérification des versions des modules perl utilisés lors de la
la compilation de sympa.
Dans l'attente.
Cordialement.



checking for PERL version:
-----------------------------
your version of perl is OK (5.008003 >= 5.005)

Checking for REQUIRED modules:
------------------------------------------
perl module from CPAN STATUS
----------- --------- ------
Archive::Zip Archive-Zip OK (1.18 >= 1.05)
CGI CGI OK (3.01 >= 2.52)
Crypt::CipherSaber CipherSaber OK (1.00 >= 0.50)
DBD::mysql Msql-Mysql-modulesOK (4.003 >= 2.0407)
DBI DBI OK (1.54 >= 1.06)
DB_File DB_FILE OK (1.808 >= 1.75)
Digest::MD5 Digest-MD5 OK (2.36 >= 2.00)
Encode Encode OK (1.99 >= 1.0)
FCGI FCGI OK (0.67 >= 0.67)
File::Spec File-Spec OK (3.24 >= 0.8)
IO::Scalar IO-stringy OK (2.105 >= 1.0)
LWP libwww-perl OK (5.805 >= 1.0)
Locale::TextDomain libintl-perl OK (1.16 >= 1.0)
MHonArc::UTF8 MHonArc OK (2.6.16 >= 2.6.0)
MIME::Base64 MIME-Base64 OK (3.07 >= 3.03)
MIME::Tools MIME-tools OK (5.420 >= 5.209)
Mail::Internet MailTools OK (1.60 >= 1.51)
Regexp::Common Regexp-Common OK (2.120 >= 1.0)
Template Template-ToolkitOK (2.18 >= 1.0)
XML::LibXML XML-LibXML OK (1.62 >= 1.0)

Checking for OPTIONAL modules:
------------------------------------------
perl module from CPAN STATUS
----------- --------- ------
Bundle::LWP LWP OK (1.11 >= 1.09)
Constant subroutine CGI::XHTML_DTD redefined at
/usr/local/lib/perl5/5.8.3/constant.pm line 108.
CGI::Fast CGI CGI::Fast doesn't return 1 (check it).



  • [sympa-fr] sympa died DBD::mysql::st execute failed:, pele, 12/03/2007

Archives gérées par MHonArc 2.6.19+.

Haut de le page