[SQL]Plantage d'une base et erreur d'import . [Résolu/Fermé]

Signaler
-
Messages postés
1251
Date d'inscription
samedi 9 décembre 2006
Statut
Membre
Dernière intervention
18 août 2010
-
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

Messages postés
1251
Date d'inscription
samedi 9 décembre 2006
Statut
Membre
Dernière intervention
18 août 2010
274
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.