Bonjour,
j'ai un souci avec l'importation d'une toute petite base (22 Mo) sur une machine Vista et uniquement sur cette machine vista (wamp5)
La même base, initialement sauvegardée sur une gentoo, est correctement restaurée sur un xp (WAMP5), sur une ubuntu (LAMP de base).
Sur ces machines sont également restaurées régulièrement des bases de 3 Go sans aucun souci
Voic les messages d'erreurs que j'ai une première fois
une deuxième fois
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14 Script line: 2399 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 '',NULL,1,0,1,0),(37,56663,'29.12.37','Compresseurs volumétriques rotatifs',NULL' at line 1 Script line: 2400 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 'NULL,1,0,1,0),(65,72576,'54-17-228','Médis',NULL,1,0,1,0),(65,72577,'54-17-229'' at line 1 Script line: 2401 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 '1,0,1,0),(65,101354,'11-78-644','Verrière',NULL,1,0,1,0),(65,101355,'11-78-645'' at line 1 Script line: 2402 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 '','L\'ISLE D\'ESPAGNAC\r',NULL,1,0,1,0),(1,15484,'32300','L\'ISLE DE NOE\r',NULL' at line 1 Script line: 2403 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 '1,0),(1,28910,'91400','SACLAY\r',NULL,1,0,1,0),(1,28911,'02200','SACONIN ET BREU' at line 1 Script line: 2636 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 '63,61598,64),(60612,62,61599,64),(60838,63,61599,64),(60612,62,61600,64),(60838,' at line 1 Script line: 2637 Column count doesn't match value count at row 39367 Script line: 2639 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 '65),(61017,63,93446,65),(60663,62,93447,65),(63731,64,93447,65),(61016,63,93447,' at line 1 Script line: 3009 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 'B9C61E92180A9A557A1B70458AA2A30AE56C0F924C9A08454867918EFC3877F706E5E2D193D54E0E' at line 1 Script line: 3011 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 '362F5769647468735B32333320302030203020302030203738372035303420302030203020302030' at line 1 Script line: 3284 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 '101',1),(10000030,10001704,'bbb_102',1),(10000030,10001705,'bbb_103',1),(1000003' at line 1 Script line: 3311 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 'Actif','',120131,0),(10001627,'Inactif','',120131,0),(10001628,'Portée','',1201' at line 1 Script line: 5188 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 '','_graal_ove_acteurs_interlos_01.php',0,0,0,0,4,'aam'),(10000365,'Div_00152','_' at line 1 Script line: 5214 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 'des demandes de prix (modèle 3 désignation seule sans notion de valeur ni de q' at line 1
On note que que cela ne plante pas au même endroit !!!
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11 Script line: 2399 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 '26.24','Produits céramiques à usage technique et services associés',NULL,1,0,' at line 1 Script line: 2400 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 '54-17-258','Neuillac',NULL,1,0,1,0),(65,72607,'54-17-259','Neulles',NULL,1,0,1,0' at line 1 Script line: 2401 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 '),(65,93064,'31-62-074','Bailleulval',NULL,1,0,1,0),(65,93065,'31-62-075','Bainc' at line 1 Script line: 2402 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 'CHATEAUROUX\r',NULL,1,0,1,0),(1,7306,'44690','CHATEAUTHEBAUD\r',NULL,1,0,1,0),(1' at line 1 Script line: 2403 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 '16270','ROUMAZIERES\r',NULL,1,0,1,0),(1,28660,'16270','ROUMAZIERES LOUBERT\r',NU' at line 1 Script line: 2636 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 '63,66611,65),(60602,62,66612,65),(61275,64,66612,65),(60808,63,66612,65),(60602,' at line 1 Script line: 2637 Column count doesn't match value count at row 16398 Script line: 2639 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 '03785,65),(64682,64,103785,65),(61101,63,103785,65),(60686,62,103786,65),(64679,' at line 1 Script line: 3259 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 '0,1,1,0,0,0,0,NULL),(10002258,10001001,1,1,0,0,0,0,NULL),(10002259,10001002,1,1,' at line 1 Script line: 3284 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 '47,'aau_100',1),(10000087,10000048,'aau_101',1),(10000087,10000049,'aau_102',1),' at line 1 Script line: 3311 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 'Critères','',120131,0),(10001752,'Valeur','',120131,0),(10001753,'Position','',' at line 1
Petite précision : là où cela fonctionne, dans le my.ini, le default-character-set=utf8 alors que sur vista il est latin1
Mais si je le passe en utf8, alors là, c'est la cata ... impossibilité de créer certaines tables et donc là, tout part en vrille ...
D'avance, merci pour vos pistes. Je suis bien planté et j'ai besoin d'exploiter cette base dans un environnement Vista.
Partager