Problème: Duplicate entry '1969' for key 1 unrgent !

Nouveau WRInaute
j'ai le message d’erreur suivant pour PhP classifieds
Error

SQL query:

INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`, `ad_region`) VALUES (1969, 8338, 21, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx, 1261653373, 1293189373, 1261656285, 0, 0, 0, 5, 0, 873, 0.00, 0, 0.00, '0', 0, 0, 0, 0, 0), (1952, 8283, 21, 'xxxxxxxxxxxxxxxxxxxx[...]

MySQL said: Documentation
#1062 - Duplicate entry '1969' for key 1

voici le script de la table:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `xxxxxxxxxxxx`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpclass_ad`
--

CREATE TABLE IF NOT EXISTS `phpclass_ad` (
`ad_id` int(11) NOT NULL auto_increment,
`ad_owner` int(11) default '0',
`ad_cat_id` int(11) default '0',
`ad_title` varchar(255) default '0',
`ad_description` text,
`ad_date` int(11) default '0',
`ad_date_expire` int(11) default '0',
`ad_date_updated` int(11) default '0',
`ad_expires_after_days` int(11) default '0',
`ad_owner_notified` tinyint(1) default '0',
`ad_has_video` tinyint(1) default '0',
`ad_has_picture` tinyint(1) default '0',
`ad_has_doc` int(11) default '0',
`ad_views` int(11) default '0',
`ad_votes` double(6,2) default '0.00',
`ad_voters` int(11) default '0',
`ad_totalscore` double(6,2) default '0.00',
`ad_last_vote_ip` varchar(20) default '0',
`ad_is_validated` tinyint(1) default '0',
`ad_is_sold` tinyint(1) default '0',
`ad_is_special` tinyint(1) default '0',
`ad_is_premium` tinyint(1) default '0',
`ad_region` int(11) default '0',
PRIMARY KEY (`ad_id`),
FULLTEXT KEY `ad_title` (`ad_title`),
FULLTEXT KEY `ad_title_2` (`ad_title`),
FULLTEXT KEY `ad_title_3` (`ad_title`),
FULLTEXT KEY `ad_title_4` (`ad_title`),
FULLTEXT KEY `ad_title_5` (`ad_title`),
FULLTEXT KEY `ad_title_6` (`ad_title`),
FULLTEXT KEY `ad_title_7` (`ad_title`),
FULLTEXT KEY `ad_title_8` (`ad_title`),
FULLTEXT KEY `ad_title_9` (`ad_title`),
FULLTEXT KEY `ad_title_10` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_11` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_12` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_13` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_14` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_15` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_16` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_17` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_18` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_19` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_20` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_21` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_22` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_23` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_24` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_25` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_26` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_27` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_28` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_29` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_30` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_31` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_32` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_33` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_34` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_35` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_36` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_37` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_38` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_39` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_40` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_41` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_42` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_43` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_44` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_45` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_46` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_47` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_48` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_49` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_50` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_51` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_52` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_53` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_54` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_55` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_56` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_57` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_58` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_59` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_60` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_61` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_62` (`ad_title`,`ad_description`),
FULLTEXT KEY `ad_title_63` (`ad_title`,`ad_description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4126 ;

--
-- Dumping data for table `phpclass_ad`
--

INSERT INTO `phpclass_ad` (`ad_id`, `ad_owner`, `ad_cat_id`, `ad_title`, `ad_description`, `ad_date`, `ad_date_expire`, `ad_date_updated`, `ad_expires_after_days`, `ad_owner_notified`, `ad_has_video`, `ad_has_picture`, `ad_has_doc`, `ad_views`, `ad_votes`, `ad_voters`, `ad_totalscore`, `ad_last_vote_ip`, `ad_is_validated`, `ad_is_sold`, `ad_is_special`, `ad_is_premium`, `ad_region`) VALUES
merci de m'aider à résoudre ce problème
 
WRInaute accro
+1
C'est bizarre que la requête INSERT donne une valeur à ad_id qui est en autoincrement.
Et aussi toutes ces clefs FULLTEXT redondantes.
 
Nouveau WRInaute
mais j'ai pas de ad_id qui est répétée, même le 1969 n'existe pas dans les données de la table,
et en plus ce problème ce répète toujours avec d'autres ID
 
Discussions similaires
Haut