[Mysql] Problème d'import

Problème d'import [Mysql] - SQL/NoSQL - Programmation

Marsh Posté le 30-05-2008 à 09:28:19    

Bonjour,
Lorsque je veux importer ma base de donnée avec phpmyadmin, j'obtiens cette erreur :
 

Code :
  1. Erreur
  2. requête SQL:
  4. -- phpMyAdmin SQL Dump
  5. -- version 2.6.1
  6. -- http://www.phpmyadmin.net
  7. --
  8. -- Serveur: localhost
  9. -- Généré le : Mardi 27 Mai 2008 à 12:08
  10. -- Version du serveur: 4.1.9
  11. -- Version de PHP: 4.3.10
  12. --
  13. -- Base de données: `arpebn`
  14. --
  15. -- --------------------------------------------------------
  16. --
  17. -- Structure de la table `jos_artforms`
  18. --
  19. CREATE TABLE `jos_artforms` (
  21. `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
  22. `titel` varchar( 255 ) NOT NULL default '',
  23. `text` text NOT NULL ,
  24. `danktext` text NOT NULL ,
  25. `customjscode` text NOT NULL ,
  26. `customcss` text NOT NULL ,
  27. `metakey` mediumtext NOT NULL ,
  28. `metadesc` text NOT NULL ,
  29. `email` varchar( 255 ) NOT NULL default '',
  30. `ccmail` varchar( 255 ) NOT NULL default '',
  31. `bccmail` varchar( 255 ) NOT NULL default '',
  32. `html` char( 2 ) NOT NULL default '0',
  33. `seccode` char( 2 ) NOT NULL default '0',
  34. `emailfield` char( 2 ) NOT NULL default '0',
  35. `allowatt` varchar( 10 ) NOT NULL default '0',
  36. `allowattfiles` mediumtext NOT NULL ,
  37. `allowattfilesize` int( 40 ) NOT NULL default '102400',
  38. `published` tinyint( 1 ) NOT NULL default '0',
  39. `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  40. `created` datetime NOT NULL default '0000-00-00 00:00:00',
  41. `created_by` int( 10 ) unsigned NOT NULL default '0',
  42. `checked_out` tinyint( 1 ) unsigned NOT NULL default '0',
  43. `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  44. `access` int( 10 ) unsigned NOT NULL default '0',
  45. `ordering` int( 10 ) unsigned NOT NULL default '9999',
  46. `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  47. `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  48. `modified_by` int( 10 ) unsigned NOT NULL default '0',
  49. `author` varchar( 255 ) NOT NULL default '',
  50. `modifier` varchar( 255 ) NOT NULL default '',
  51. `version` int( 10 ) unsigned NOT NULL default '1',
  52. `hits` int( 10 ) unsigned NOT NULL default '0',
  53. `created_by_alias` varchar( 255 ) NOT NULL default '',
  54. `afeditor` varchar( 255 ) NOT NULL default '',
  55. `attribs` text NOT NULL ,
  56. PRIMARY KEY ( `id` )
  57. ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;
  61. MySQL a répondu:
  63. #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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 38


 
 
Auriez vous une idée ?
Merci  ;)


---------------
Championnat GT Sport
Reply

Marsh Posté le 30-05-2008 à 09:28:19   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed