EVO_Clubic The Power Of Dreams | Bonjour,
Lorsque je veux importer ma base de donnée avec phpmyadmin, j'obtiens cette erreur :
Code :
- Erreur
- requête SQL:
- -- phpMyAdmin SQL Dump
- -- version 2.6.1
- -- http://www.phpmyadmin.net
- --
- -- Serveur: localhost
- -- Généré le : Mardi 27 Mai 2008 à 12:08
- -- Version du serveur: 4.1.9
- -- Version de PHP: 4.3.10
- --
- -- Base de données: `arpebn`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `jos_artforms`
- --
- CREATE TABLE `jos_artforms` (
- `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
- `titel` varchar( 255 ) NOT NULL default '',
- `text` text NOT NULL ,
- `danktext` text NOT NULL ,
- `customjscode` text NOT NULL ,
- `customcss` text NOT NULL ,
- `metakey` mediumtext NOT NULL ,
- `metadesc` text NOT NULL ,
- `email` varchar( 255 ) NOT NULL default '',
- `ccmail` varchar( 255 ) NOT NULL default '',
- `bccmail` varchar( 255 ) NOT NULL default '',
- `html` char( 2 ) NOT NULL default '0',
- `seccode` char( 2 ) NOT NULL default '0',
- `emailfield` char( 2 ) NOT NULL default '0',
- `allowatt` varchar( 10 ) NOT NULL default '0',
- `allowattfiles` mediumtext NOT NULL ,
- `allowattfilesize` int( 40 ) NOT NULL default '102400',
- `published` tinyint( 1 ) NOT NULL default '0',
- `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
- `created` datetime NOT NULL default '0000-00-00 00:00:00',
- `created_by` int( 10 ) unsigned NOT NULL default '0',
- `checked_out` tinyint( 1 ) unsigned NOT NULL default '0',
- `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
- `access` int( 10 ) unsigned NOT NULL default '0',
- `ordering` int( 10 ) unsigned NOT NULL default '9999',
- `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
- `modified` datetime NOT NULL default '0000-00-00 00:00:00',
- `modified_by` int( 10 ) unsigned NOT NULL default '0',
- `author` varchar( 255 ) NOT NULL default '',
- `modifier` varchar( 255 ) NOT NULL default '',
- `version` int( 10 ) unsigned NOT NULL default '1',
- `hits` int( 10 ) unsigned NOT NULL default '0',
- `created_by_alias` varchar( 255 ) NOT NULL default '',
- `afeditor` varchar( 255 ) NOT NULL default '',
- `attribs` text NOT NULL ,
- PRIMARY KEY ( `id` )
- ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;
- MySQL a répondu:
- #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
|
