Sujet Précédent Sujet Suivant

[SQL]Plantage d'une base et erreur d'import .

Résolu/Fermé
FuriousKing - 19 mars 2009 à 15:09
Sandriine Messages postés 1255 Date d'inscription samedi 9 décembre 2006 Statut Membre Dernière intervention 18 août 2010 - 19 mars 2009 à 15:35
Bonjour, et merci d'avance de prendre de votre temps pour me lire .

J'ai actuellement un problème avec une de mes base SQL, après un crash de celle ci, j'ai tenter d'importer une version exporter juste avant le crash, problème, elle ne marche pas .
Et comme moi et la SQL sa fait 2 et bien je ne suis pas prêt de trouver le problème (même après plusieurs recherches) .

Voici l'erreur (a savoir j'ai cacher les nombres de l'adresse IP par des étoiles :

Erreur

Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.

ERROR: Ponctuation invalide @ 274
STR: />
SQL: !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';


requête SQL:

!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr"> <head> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <script type="text/javascript"> // <![CDATA[ // Updates the title of the frameset if possible (ns4 does not allow this) if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string') { parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';

MySQL a répondu:Documentation
#1064 - 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 '!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3' at line 1









Et voici le code complet de la sauvegarde :









!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="fr" lang="fr" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=0fb26af50dde27036b54ee862109d989&js_frame=right&nocache=3599007514" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = '**.***.**.** / localhost / Xnova / game_messages | phpMyAdmin 2.11.3deb1ubuntu1';
}

// ]]>
</script>


<script src="./js/tooltip.js" type="text/javascript"></script>
<meta name="OBGZip" content="true" />
<!--[if IE 6]>
<style type="text/css">
/* <![CDATA[ */
html {
overflow-y: scroll;
}
/* ]]> */
</style>
<![endif]-->
</head>

<body>
<div id="TooltipContainer" onmouseover="holdTooltip();" onmouseout="swapTooltip('default');"></div>
<div id="serverinfo">
<a href="main.php?token=0fb26af50dde27036b54ee862109d989" class="item"> <img class="icon" src="./themes/original/img/s_host.png" width="16" height="16" alt="" />
Serveur: localhost</a>
<span class="separator"><img class="icon" src="./themes/original/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="db_structure.php?db=Xnova&token=0fb26af50dde27036b54ee862109d989" class="item"> <img class="icon" src="./themes/original/img/s_db.png" width="16" height="16" alt="" />
Base de données: Xnova</a>
<span class="separator"><img class="icon" src="./themes/original/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="tbl_structure.php?db=Xnova&table=game_messages&token=0fb26af50dde27036b54ee862109d989" class="item"> <img class="icon" src="./themes/original/img/s_tbl.png" width="16" height="16" alt="" />
Table: game_messages</a>
<span class="table_comment" id="span_table_comment">"Table './Xnova/game_messages' is marked as crashed and should be repaired"</span>
</div>
<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Erreur</h1>
<p><strong>requête SQL:</strong>
<a href="tbl_sql.php?db=Xnova&table=game_messages&token=0fb26af50dde27036b54ee862109d989&sql_query=SHOW+CREATE+TABLE+%60Xnova%60.%60game_messages%60&show_query=1"><img class="icon" src=" ./themes/original/img/b_edit.png" width="16" height="16" alt="Modifier" /></a> </p>
<p>
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span> <span class="syntax_alpha syntax_alpha_reservedWord">CREATE</span> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_quote syntax_quote_backtick">`Xnova`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`game_messages`</span> </span>
</p>
<p>
<strong>MySQL a répondu:</strong><a href="http://dev.mysql.com/doc/refman/5.0/fr/error-messages-server.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p> 
#145 - Table './Xnova/game_messages' is marked as crashed and should be repaired
<br />
</div><fieldset class="tblFooters"> </fieldset>

<script type="text/javascript">
//<![CDATA[
// updates current settings
if (window.parent.setAll) {
window.parent.setAll('fr-utf-8', 'utf8_unicode_ci', '1', 'Xnova', 'game_messages');
}
// set current db, table and sql query in the querywindow
if (window.parent.reload_querywindow) {
window.parent.reload_querywindow(
'Xnova',
'game_messages',
'');
}

if (window.parent.frame_content) {
// reset content frame name, as querywindow needs to set a unique name
// before submitting form data, and navigation frame needs the original name
if (typeof(window.parent.frame_content.name) != 'undefined'
&& window.parent.frame_content.name != 'frame_content') {
window.parent.frame_content.name = 'frame_content';
}
if (typeof(window.parent.frame_content.id) != 'undefined'
&& window.parent.frame_content.id != 'frame_content') {
window.parent.frame_content.id = 'frame_content';
}
//window.parent.frame_content.setAttribute('name', 'frame_content');
//window.parent.frame_content.setAttribute('id', 'frame_content');
}
//]]>
</script>
</body>
</html>


J'ai tenter de l'importer en UTF8 et en Latin1 ,sa na rien changer .

Merci d'avance pour votre possible aide .

1 réponse

Réponse 1 / 1
Sandriine Messages postés 1255 Date d'inscription samedi 9 décembre 2006 Statut Membre Dernière intervention 18 août 2010 283
19 mars 2009 à 15:35
Quelle horreur!!! Non mais sans blague tu as vu ce que tu as posté? C'est illisible et incompréhensible.

Pour mettre du code en valeur, tu dois l'entourer de balises < code > et < /code >.

D'autre part tu ne peux pas nous donner tout ton code comme ça! Il faut que tu sélectionne le bon code qui pose problème.

Donc stp édite ton message, merci.
0

Discussions similaires

Instagram "Désolé, une erreur s'est produite"
bananamilk -
cedric.masdeb -

60 réponses
SQL Lister les tables d'une base
ruth -
sara -

29 réponses
Erreur vidéo inconnue sur le Freebox Player
mouhaaV2.0 -
LH -

59 réponses
Free erreur 38 : impossible d'envoyer des SMS
warnawak -
marcellou -

58 réponses
Erreur de lecture sur iptv smarters
Bogs -
bazfile -

1 réponse