حل خطأ MySQL Error : Duplicate entry 'topXstats_displayrecords_forumhome' for key 1

Abdul Rahim

[ أعضاء فى القلب ]
30 مايو 2011
3,386
23
0
بسم الله الرحمن الرحيم

الخطأ:
كود:
MySQL Error  : Duplicate entry 'topXstats_displayrecords_forumhome' for key 1
الحل:
كود:
ازرع كل أمر لوحده يعني واحد واحد

DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_displayrecords_forumhome' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_displayrecords' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_maxdisplayrecords' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_excludedforums' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_threadchars' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_userchars' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_newpostprefix' LIMIT 1;
DELETE FROM `setting` WHERE CONVERT(`setting`.`varname` USING utf8) = 'topXstats_oldpostprefix' LIMIT 1;
 

جوني

عضو
10 مارس 2009
220
1
18
رد: حل خطأ MySQL Error : Duplicate entry 'topXstats_displayrecords_forumhome' for ke

الله يعطيك العافية