Bonjour,
Lorsque je veux importer ma base de données avec phpmyadmin, j'obtiens cette erreur :
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
Quelqu'un aurait il une idée ?
Merci !