Message d'erreur sur le site

Bonjour à tous,

Je viens d’hériter d’un serveur de base de donnée mysql ( installation faite par un tiers )

Il a toutes les dernières mises à jours. Et lorsque j’ai migré une base de donnée d’un site sous spip.

J’ai des messages d’erreurs qui s’affichent alors que sur le serveur de test aucun message.

Je pense qu’il s’agit d’un plugin qui a été ajouté mais je sais pas lequel .

Voici l’exemple d’un message " 1146 : Table ‘spip.spip_se_membres’ doesn’t exist

  TRUNCATE TABLE spip_se_membres " et j'ai fait un petit dpkg -l 

||/ Nom Version Description +++-================================-================================-================================================================================ ii acpi 1.5-2 displays information on ACPI devices ii acpi-support-base 0.137-5 scripts for handling base ACPI events such as the power button ii acpid 1:2.0.7-1 Advanced Configuration and Power Interface event daemon ii adduser 3.112+nmu2 add and remove users and groups ii apache2-mpm-prefork 2.2.16-6 Apache HTTP Server - traditional non-threaded model ii apache2-utils 2.2.16-6 utility programs for webservers ii apache2.2-bin 2.2.16-6 Apache HTTP Server common binary files ii apache2.2-common 2.2.16-6 Apache HTTP Server common files ii apt 0.8.10 Advanced front-end for dpkg ii apt-utils 0.8.10 APT utility programs ii aptitude 0.6.3-3.2 terminal-based package manager (terminal interface only) ii aspell 0.60.6-4 GNU Aspell spell-checker ii aspell-fr 0.50-3-7 French dictionary for aspell ii base-files 6.0 Debian base system miscellaneous files ii base-passwd 3.5.22 Debian base system master password and group files ii bash 4.1-3 The GNU Bourne Again SHell ii bsdmainutils 8.0.13 collection of more utilities from FreeBSD ii bsdutils 1:2.17.2-5 Basic utilities from 4.4BSD-Lite ii busybox 1:1.17.1-8 Tiny utilities for small and embedded systems ii console-setup 1.68 console font and keymap setup program ii console-terminus 4.30-2 Fixed-width fonts for fast reading on the Linux console ii coreutils 8.5-1 GNU core utilities ii cpio 2.11-4 GNU cpio -- a program to manage archives of files ii cron 3.0pl1-116 process scheduling daemon ii dash 0.5.5.1-7.4 POSIX-compliant shell ii dbconfig-common 1.8.46 common framework for packaging database applications ii debconf 1.5.36 Debian configuration management system ii debconf-i18n 1.5.36 full internationalization support for debconf ii debian-archive-keyring 2010.08.28 GnuPG archive keys of the Debian archive ii debian-policy 3.9.1.0 Debian Policy Manual and related documents ii debianutils 3.4 Miscellaneous utilities specific to Debian ii developers-reference-fr 3.4.4 guidelines and information for Debian developers, in French ii dictionaries-common 1.5.17 Common utilities for spelling dictionary tools ii diffutils 1:3.0-1 File comparison utilities ii discover 2.1.2-5 hardware identification system ii discover-data 2.2010.10.18 Data lists for Discover hardware detection system ii dmidecode 2.9-1.2 Dump Desktop Management Interface data ii dmsetup 2:1.02.48-5 The Linux Kernel Device Mapper userspace library ii doc-debian-fr 3.1.3.1 Debian Manuals, FAQs and other documents in French ii doc-linux-fr-text 2005.08-1 Linux docs in French: HOWTOs, MetaFAQs in ASCII format ii dpkg 1.15.8.8 Debian package management system ii e2fslibs 1.41.12-2 ext2/ext3/ext4 file system libraries ii e2fsprogs 1.41.12-2 ext2/ext3/ext4 file system utilities ii eject 2.1.5+deb1+cvs20081104-7.1 ejects CDs and operates CD-Changers under Linux ii file 5.04-5 Determines file type using "magic" numbers ii findutils 4.4.2-1+b1 utilities for finding files--find, xargs ii fontconfig-config 2.8.0-2.1 generic font configuration library - configuration ii gcc-4.4-base 4.4.5-8 The GNU Compiler Collection (base package) ii gettext-base 0.18.1.1-3 GNU Internationalization utilities for the base system ii gnupg 1.4.10-4 GNU privacy guard - a free PGP replacement ii gpgv 1.4.10-4 GNU privacy guard - signature verification tool ii grep 2.6.3-3 GNU grep, egrep and fgrep ii groff-base 1.20.1-10 GNU troff text-formatting system (base system components) ii grub-common 1.98+20100804-13 GRand Unified Bootloader, version 2 (common files) ii grub-pc 1.98+20100804-13 GRand Unified Bootloader, version 2 (PC/BIOS version) ii gzip 1.3.12-9 GNU compression utilities ii heirloom-mailx 12.4-2 feature-rich BSD mail(1) ii hostname 3.04 utility to set/show the host name or domain name ii htop 0.8.3-1 interactive processes viewer ii ifrench-gut 1:1.0-27 The French dictionary for ispell (GUTenberg version) ii ifupdown 0.6.10 high level tools to configure network interfaces ii info 4.13a.dfsg.1-6 Standalone GNU Info documentation browser ii initramfs-tools 0.98.7 tools for generating an initramfs ii initscripts 2.88dsf-13.1 scripts for initializing and shutting down the system ii insserv 1.14.0-2 Tool to organize boot sequence using LSB init.d script dependencies ii install-info 4.13a.dfsg.1-6 Manage installed documentation in info format ii installation-report 2.44 system installation report ii iproute 20100519-3 networking and traffic control tools ii iptables 1.4.8-3 administration tools for packet filtering and NAT ii iputils-ping 3:20100418-3 Tools to test the reachability of network hosts ii isc-dhcp-client 4.1.1-P1-15 ISC DHCP client ii isc-dhcp-common 4.1.1-P1-15 common files used by all the isc-dhcp* packages ii ispell 3.1.20.0-7 International Ispell (an interactive spelling corrector) ii javascript-common 7 Base support for javascript library packages ii kbd 1.15.2-2 Linux console font and keytable utilities ii keyboard-configuration 1.68 system-wide keyboard preferences ii klibc-utils 1.5.20-1 small utilities built with klibc for early boot ii laptop-detect 0.13.7 attempt to detect a laptop ii libacl1 2.2.49-4 Access control list shared library ii libapache2-mod-php5 5.3.3-7 server-side, HTML-embedded scripting language (Apache 2 module) ii libapr1 1.4.2-6 The Apache Portable Runtime Library ii libaprutil1 1.3.9+dfsg-5 The Apache Portable Runtime Utility Library ii libaprutil1-dbd-sqlite3 1.3.9+dfsg-5 The Apache Portable Runtime Utility Library - SQLite3 Driver ii libaprutil1-ldap 1.3.9+dfsg-5 The Apache Portable Runtime Utility Library - LDAP Driver ii libaspell15 0.60.6-4 GNU Aspell spell-checker runtime library ii libattr1 1:2.4.44-2 Extended attribute shared library ii libblkid1 2.17.2-5 block device id library ii libboost-iostreams1.42.0 1.42.0-4 Boost.Iostreams Library ii libbsd0 0.2.0-1 utility functions from BSD systems - shared library ii libbz2-1.0 1.0.5-6 high-quality block-sorting file compressor library - runtime ii libc-bin 2.11.2-9 Embedded GNU C Library: Binaries ii libc6 2.11.2-9 Embedded GNU C Library: Shared libraries ii libcap2 1:2.19-3 support for getting/setting POSIX.1e capabilities ii libcomerr2 1.41.12-2 common error description library ii libcwidget3 0.5.16-3 high-level terminal interface library for C++ (runtime files) ii libdb4.7 4.7.25-9 Berkeley v4.7 Database Libraries [runtime] ii libdb4.8 4.8.30-2 Berkeley v4.8 Database Libraries [runtime] ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database ii libdbi-perl 1.612-1 Perl Database Interface (DBI) ii libdevmapper1.02.1 2:1.02.48-5 The Linux Kernel Device Mapper userspace library ii libdiscover2 2.1.2-5 hardware identification library ii libedit2 2.11-20080614-2 BSD editline and history libraries ii libept1 1.0.4 High-level library for managing Debian package information ii libexpat1 2.0.1-7 XML parsing C library - runtime library ii libfontconfig1 2.8.0-2.1 generic font configuration library - runtime ii libfreetype6 2.4.2-2.1 FreeType 2 font engine, shared library files ii libgcc1 1:4.4.5-8 GCC support library ii libgcrypt11 1.4.5-2 LGPL Crypto library - runtime library ii libgd2-xpm 2.0.36~rc1~dfsg-5 GD Graphics Library version 2 ii libgdbm3 1.8.3-9 GNU dbm database routines (runtime version) ii libgnutls26 2.8.6-1 the GNU TLS library - runtime library ii libgpg-error0 1.6-1 library for common error values and messages in GnuPG components ii libgssapi-krb5-2 1.8.3+dfsg-4 MIT Kerberos runtime libraries - krb5 GSS-API Mechanism ii libhtml-template-perl 2.9-2 module for using HTML Templates with Perl ii libjpeg62 6b1-1 The Independent JPEG Group's JPEG runtime library (version 6.2) ii libjs-mootools 1.2.4.0~debian1-1 compact JavaScript framework ii libk5crypto3 1.8.3+dfsg-4 MIT Kerberos runtime libraries - Crypto Library ii libkeyutils1 1.4-1 Linux Key Management Utilities (library) ii libklibc 1.5.20-1 minimal libc subset for use with initramfs ii libkrb5-3 1.8.3+dfsg-4 MIT Kerberos runtime libraries ii libkrb5support0 1.8.3+dfsg-4 MIT Kerberos runtime libraries - Support library ii libldap-2.4-2 2.4.23-7 OpenLDAP libraries ii liblocale-gettext-perl 1.05-6 Using libc functions for internationalization in Perl ii libltdl7 2.2.6b-2 A system independent dlopen wrapper for GNU libtool ii liblzma2 5.0.0-2 XZ-format compression library ii libmagic1 5.04-5 File type determination library using "magic" numbers ii libmcrypt4 2.5.8-3.1 De-/Encryption Library ii libmysqlclient16 5.1.49-3 MySQL database client library ii libncurses5 5.7+20100313-5 shared libraries for terminal handling ii libncursesw5 5.7+20100313-5 shared libraries for terminal handling (wide character support) ii libnet-daemon-perl 0.43-1 Perl module for building portable Perl daemons easily ii libnewt0.52 0.52.11-1 Not Erik's Windowing Toolkit - text mode windowing with slang ii libnfnetlink0 1.0.0-1 Netfilter netlink library ii libnss-ldapd 0.7.13 NSS module for using LDAP as a naming service ii libonig2 5.9.1-1 Oniguruma regular expressions library ii libpam-ldapd 0.7.13 PAM module for using LDAP as an authentication service ii libpam-modules 1.1.1-6.1 Pluggable Authentication Modules for PAM ii libpam-runtime 1.1.1-6.1 Runtime support for the PAM library ii libpam0g 1.1.1-6.1 Pluggable Authentication Modules library ii libpci3 1:3.1.7-6 Linux PCI Utilities (shared library) ii libpcre3 8.02-1.1 Perl 5 Compatible Regular Expression Library - runtime files ii libplrpc-perl 0.2020-2 Perl extensions for writing PlRPC servers and clients ii libpng12-0 1.2.44-1 PNG library - runtime ii libpopt0 1.16-1 lib for parsing cmdline parameters ii libqdbm14 1.8.77-4 QDBM Database Libraries [runtime] ii libreadline6 6.1-3 GNU readline and history libraries, run-time libraries ii libsasl2-2 2.1.23.dfsg1-7 Cyrus SASL - authentication abstraction library ii libsasl2-modules 2.1.23.dfsg1-7 Cyrus SASL - pluggable authentication modules ii libselinux1 2.0.96-1 SELinux runtime shared libraries ii libsepol1 2.0.41-1 SELinux library for manipulating binary security policies ii libsigc++-2.0-0c2a 2.2.4.2-1 type-safe Signal Framework for C++ - runtime ii libslang2 2.2.2-4 The S-Lang programming library - runtime version ii libsqlite3-0 3.7.3-1 SQLite 3 shared library ii libss2 1.41.12-2 command-line interface parsing library ii libssl0.9.8 0.9.8o-4 SSL shared libraries ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3 ii libt1-5 5.1.2-3 Type 1 font rasterizer library - runtime ii libtasn1-3 2.7-1 Manage ASN.1 structures (runtime) ii libtext-charwidth-perl 0.04-6 get display widths of characters on the terminal ii libtext-iconv-perl 1.7-2 converts between character sets in Perl ii libtext-wrapi18n-perl 0.06-7 internationalized substitute of Text::Wrap ii libudev0 164-3 libudev shared library ii libusb-0.1-4 2:0.1.12-16 userspace USB programming library ii libuuid-perl 0.02-4 Perl extension for using UUID interfaces as defined in e2fsprogs ii libuuid1 2.17.2-5 Universally Unique ID library ii libwrap0 7.6.q-19 Wietse Venema's TCP wrappers library ii libx11-6 2:1.3.3-4 X11 client-side library ii libx11-data 2:1.3.3-4 X11 client-side library ii libxapian22 1.2.3-2 Search engine library ii libxau6 1:1.0.6-1 X11 authorisation library ii libxcb1 1.6-1 X C Binding ii libxdmcp6 1:1.0.3-2 X11 Display Manager Control Protocol library ii libxext6 2:1.1.2-1 X11 miscellaneous extension library ii libxml2 2.7.8.dfsg-2 GNOME XML library ii libxmuu1 2:1.0.5-2 X11 miscellaneous micro-utility library ii libxpm4 1:3.5.8-1 X11 pixmap library ii linux-base 2.6.32-30 Linux image base package ii linux-image-2.6-amd64 2.6.32+29 Linux 2.6 for 64-bit PCs (meta-package) ii linux-image-2.6.32-5-amd64 2.6.32-30 Linux 2.6.32 for 64-bit PCs ii locales 2.11.2-9 Embedded GNU C Library: National Language (locale) data [support] ii login 1:4.1.4.2+svn3283-2 system login tools ii logrotate 3.7.8-6 Log rotation utility ii lsb-base 3.2-23.2squeeze1 Linux Standard Base 3.2 init script functionality ii maint-guide-fr 1.2.25 French translation of Debian New Maintainers' Guide ii man-db 2.5.7-8 on-line manual pager ii manpages 3.27-1 Manual pages about using a GNU/Linux system ii manpages-fr 3.27fr1.4-1 French version of the manual pages about using GNU/Linux ii manpages-fr-extra 20101103 French version of the manual pages ii mawk 1.3.3-15 a pattern scanning and text processing language ii mime-support 3.48-1 MIME files 'mime.types' & 'mailcap', and support programs ii module-init-tools 3.12-1 tools for managing Linux kernel modules ii mount 2.17.2-5 Tools for mounting and manipulating filesystems ii mysql-client 5.1.49-3 MySQL database client (metapackage depending on the latest version) ii mysql-client-5.1 5.1.49-3 MySQL database client binaries ii mysql-common 5.1.49-3 MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.1.49-3 MySQL database server (metapackage depending on the latest version) ii mysql-server-5.1 5.1.49-3 MySQL database server binaries and system database setup ii mysql-server-core-5.1 5.1.49-3 MySQL database server binaries ii nano 2.2.4-1 small, friendly text editor inspired by Pico ii ncurses-base 5.7+20100313-5 basic terminal type definitions ii ncurses-bin 5.7+20100313-5 terminal-related programs and man pages ii net-tools 1.60-23 The NET-3 networking toolkit ii netbase 4.45 Basic TCP/IP networking system ii netcat-traditional 1.10-38 TCP/IP swiss army knife ii nslcd 0.7.13 Daemon for NSS and PAM lookups using LDAP ii openssh-blacklist 0.4.1 list of default blacklisted OpenSSH RSA and DSA keys ii openssh-blacklist-extra 0.4.1 list of non-default blacklisted OpenSSH RSA and DSA keys ii openssh-client 1:5.5p1-6 secure shell (SSH) client, for secure access to remote machines ii openssh-server 1:5.5p1-6 secure shell (SSH) server, for secure access from remote machines ii openssl 0.9.8o-4 Secure Socket Layer (SSL) binary and related cryptographic tools ii os-prober 1.42 utility to detect other OSes on a set of drives ii passwd 1:4.1.4.2+svn3283-2 change and administer password and group data ii pciutils 1:3.1.7-6 Linux PCI Utilities ii perl 5.10.1-17 Larry Wall's Practical Extraction and Report Language ii perl-base 5.10.1-17 minimal Perl system ii perl-modules 5.10.1-17 Core Perl modules ii php5-cli 5.3.3-7 command-line interpreter for the php5 scripting language ii php5-common 5.3.3-7 Common files for packages built from the php5 source ii php5-gd 5.3.3-7 GD module for php5 ii php5-mcrypt 5.3.3-7 MCrypt module for php5 ii php5-mysql 5.3.3-7 MySQL module for php5 ii php5-suhosin 0.9.32.1-1 advanced protection module for php5 ii phpmyadmin 4:3.3.7-3 MySQL web administration tool ii procps 1:3.2.8-9 /proc file system utilities ii psmisc 22.11-1 utilities that use the proc file system ii readline-common 6.1-3 GNU readline and history libraries, common files ii rsyslog 4.6.4-2 enhanced multi-threaded syslogd ii sed 4.2.1-7 The GNU sed stream editor ii sensible-utils 0.0.4 Utilities for sensible alternative selection ii sgml-base 1.26+nmu1 SGML infrastructure and SGML catalog file support ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL ii sysv-rc 2.88dsf-13.1 System-V-like runlevel change mechanism ii sysvinit 2.88dsf-13.1 System-V-like init utilities ii sysvinit-utils 2.88dsf-13.1 System-V-like utilities ii tar 1.23-3 GNU version of the tar archiving utility ii tasksel 2.88 Tool for selecting tasks for installation on Debian systems ii tasksel-data 2.88 Official tasks used for installation of Debian systems ii tcpd 7.6.q-19 Wietse Venema's TCP wrapper utilities ii traceroute 1:2.0.15-1 Traces the route taken by packets over an IPv4/IPv6 network ii ttf-dejavu-core 2.31-1 Vera font family derivate with additional characters ii tzdata 2010o-1 time zone and daylight-saving time data ii ucf 3.0025+nmu1 Update Configuration File: preserve user changes to config files. ii udev 164-3 /dev/ and hotplug management daemon ii usbutils 0.87-5 Linux USB utilities ii util-linux 2.17.2-5 Miscellaneous system utilities ii vim-common 2:7.2.445+hg~cb94c42c0e1a-1 Vi IMproved - Common files ii vim-tiny 2:7.2.445+hg~cb94c42c0e1a-1 Vi IMproved - enhanced vi editor - compact version ii wfrench 1.2.3-8 French dictionary words for /usr/share/dict ii wget 1.12-2.1 retrieves files from the web ii whiptail 0.52.11-1 Displays user-friendly dialog boxes from shell scripts ii wwwconfig-common 0.2.1 Debian web auto configuration ii xauth 1:1.0.4-1 X authentication utility ii xkb-data 1.8-2 X Keyboard Extension (XKB) configuration data ii xml-core 0.13 XML infrastructure and XML catalog file support ii xz-utils 5.0.0-2 XZ-format compression utilities ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime

Merci

Salut,

[quote=“geokool”]
Voici l’exemple d’un message " 1146 : Table ‘spip.spip_se_membres’ doesn’t exist
TRUNCATE TABLE spip_se_membres[/quote]

Je pencherais plutôt pour un problème de table, non ?
Regarde du côté des outils de réparation de Mysql.
Tu as une sauvegarde de la base de donnée ?

Voici ce que j’ai fait un scp -r de la base d’un serveur de test vers un serveur de production.

Sur le serveur de test pas de message d’erreur.

Re,
La sauvegarde avait été faite avec mysql, en ligne de commande ?
La version de spip est la même ? Pas de “plugins” additionnels (je ne sais pas s’il y a des addons dans spip, mais bon…) ?

Merci pour ton aide, un arrêt et redémarrage de mysql et le problème est résolu.

:wink:

Salut,
Je me doutais bien que ça venait d’une table de mysql ou de mysql lui-même.
Cool :023

Pense à passer en résolu (coche verte). :006