Recent Topics
  1. b2evolution CMS Support Forums
  2. Archives
  3. International support
  4. Aide en français
  5. disparition de tables...? O_o

disparition de tables...? O_o

1 Feb 27, 2006 14:57    

Depuis quelques temps j'ai cette erreur sur mon blog :

Oups, erreur MySQL!

Your query:
insert into evo_hitlog( visitTime, visitURL, hit_ignore, referingURL, baseDomain, hit_blog_ID, hit_remote_addr, hit_user_agent ) values( FROM_UNIXTIME(1141048510), '/3/b2evolution/blogs/new_file.php', 'no', 'http://mwankh.free.fr/', 'mwankh.free.fr', 5, '83.205.80.205', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1)')

MySQL said:
Table 'mwankh.evo_hitlog' doesn't exist

A savoir que si on insiste un peu (plusieurs réactulisation) et bien ça passe sans erreur.

Pour tester j'ai essayer un petit chek up du machin...
voici le résultat :

Connected successfullymwankh.evo_antispam check error Table 'mwankh.evo_antispam' doesn't exist
mwankh.evo_blogs check status OK
mwankh.evo_blogusers check error Table 'mwankh.evo_blogusers' doesn't exist
mwankh.evo_categories check status OK
mwankh.evo_comments check status OK
mwankh.evo_groups check error Table 'mwankh.evo_groups' doesn't exist
mwankh.evo_hitlog check error Table 'mwankh.evo_hitlog' doesn't exist
mwankh.evo_locales check error Table 'mwankh.evo_locales' doesn't exist
mwankh.evo_postcats check warning 2 clients are using or haven't closed the table properly
mwankh.evo_postcats check status OK
mwankh.evo_posts check warning 2 clients are using or haven't closed the table properly
mwankh.evo_posts check status OK
mwankh.evo_settings check status OK
mwankh.evo_users check status OK
mwankh.evo_antispam repair error Table 'mwankh.evo_antispam' doesn't exist
mwankh.evo_blogs repair status OK
mwankh.evo_blogusers repair error Table 'mwankh.evo_blogusers' doesn't exist
mwankh.evo_categories repair status OK
mwankh.evo_comments repair status OK
mwankh.evo_groups repair error Table 'mwankh.evo_groups' doesn't exist
mwankh.evo_hitlog repair error Table 'mwankh.evo_hitlog' doesn't exist
mwankh.evo_locales repair error Table 'mwankh.evo_locales' doesn't exist
mwankh.evo_postcats repair status OK
mwankh.evo_posts repair status OK
mwankh.evo_settings repair status OK
mwankh.evo_users repair status OK
mwankh.evo_antispam optimize error Table 'mwankh.evo_antispam' doesn't exist
mwankh.evo_blogs optimize status OK
mwankh.evo_blogusers optimize error Table 'mwankh.evo_blogusers' doesn't exist
mwankh.evo_categories optimize status OK
mwankh.evo_comments optimize status OK
mwankh.evo_groups optimize error Table 'mwankh.evo_groups' doesn't exist
mwankh.evo_hitlog optimize error Table 'mwankh.evo_hitlog' doesn't exist
mwankh.evo_locales optimize error Table 'mwankh.evo_locales' doesn't exist
mwankh.evo_postcats optimize status OK
mwankh.evo_posts optimize status OK
mwankh.evo_settings optimize status OK
mwankh.evo_users optimize status OK
mwankh.evo_antispam analyze error Table 'mwankh.evo_antispam' doesn't exist
mwankh.evo_blogs analyze status Table is already up to date
mwankh.evo_blogusers analyze error Table 'mwankh.evo_blogusers' doesn't exist
mwankh.evo_categories analyze status Table is already up to date
mwankh.evo_comments analyze status Table is already up to date
mwankh.evo_groups analyze error Table 'mwankh.evo_groups' doesn't exist
mwankh.evo_hitlog analyze error Table 'mwankh.evo_hitlog' doesn't exist
mwankh.evo_locales analyze error Table 'mwankh.evo_locales' doesn't exist
mwankh.evo_postcats analyze status Table is already up to date
mwankh.evo_posts analyze status Table is already up to date
mwankh.evo_settings analyze status Table is already up to date
mwankh.evo_users analyze status Table is already up to date
Query failed: Table 'mwankh.evo_hitlog' doesn't exist

Vous auriez pas une idée de ce que je peux faire pour arrêter le massacre? :-/

Back to top

2 Mar 01, 2006 05:44

On dirait que ton serveur MySQL a des soucis...

Tu as en effet cinq tables qui ont "disparu" comme l'indiquent les lignes suivantes:

mwankh.evo_antispam check error Table 'mwankh.evo_antispam' doesn't exist
mwankh.evo_blogusers check error Table 'mwankh.evo_blogusers' doesn't exist
mwankh.evo_groups check error Table 'mwankh.evo_groups' doesn't exist
mwankh.evo_hitlog check error Table 'mwankh.evo_hitlog' doesn't exist
mwankh.evo_locales check error Table 'mwankh.evo_locales' doesn't exist

Et ceci confirme que ton serveur MySQL a des problèmes:

mwankh.evo_postcats check warning 2 clients are using or haven't closed the table properly
mwankh.evo_posts check warning 2 clients are using or haven't closed the table properly

Si c'est un problème de disque dur ces tables sont perdues, et pour y remédier il n'y a pas tellement de solution:
- Si tu as une sauvegarde récente de ta base, utilise là.
- Si tu n'en as pas, tu pourrais bien entendu recréer ces tables manquantes mais elles seront vides, ce qui fera planter B2evolution pour les tables evo_blogusers , evo_groups et evo_locales, je crains donc que tu sois contraint de remettre ton installation à zéro en relançant le script d'installation ...

Par contre si c'est un problème de surcharge du serveur, ce qui semble être le cas vu que tu dis que les choses rentrent dans l'ordre au bout de quelques tentaitves, il te faut envisager de passer chez un autre hébergeur, voire de passer sur un serveur dédié...
Bon courage à toi ;)

Back to top


Form is loading...