Page 1 of 2

Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Mon Oct 28, 2013 7:33 pm
by S_Flash
V 1.51 Build 201310271556
При импорте вылазит подобное:

Code: Select all

Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('39', '19'). (domain.com) Mysql error:: 1062 (Duplicate entry '43-17' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('43', '17'). (domain.com) Mysql error:: 1062 (Duplicate entry '44-109' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('44', '109'). (domain.com) Mysql error:: 1062 (Duplicate entry '47-76' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('47', '76'). (domain.com) Mysql error:: 1062 (Duplicate entry '50-76' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('50', '76'). (domain.com) Mysql error:: 1062 (Duplicate entry '50-117' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('50', '117'). (domain.com) Mysql error:: 1062 (Duplicate entry '54-5' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('54', '5'). (domain.com) Mysql error:: 1062 (Duplicate entry '54-107' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('54', '107'). (domain.com) Mysql error:: 1062 (Duplicate entry '62-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('62', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '62-17' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('62', '17'). (domain.com) Mysql error:: 1062 (Duplicate entry '64-17' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('64', '17'). (domain.com) Mysql error:: 1062 (Duplicate entry '71-76' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('71', '76'). (domain.com) Mysql error:: 1062 (Duplicate entry '25-a1c05ea810e819b7bfb485bcb95f51cb' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('a1c05ea810e819b7bfb485bcb95f51cb', '25'). (domain.com) Mysql error:: 1062 (Duplicate entry '72-16' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('72', '16'). (domain.com) Mysql error:: 1062 (Duplicate entry '72-99' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('72', '99'). (domain.com) Mysql error:: 1062 (Duplicate entry '73-107' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('73', '107'). (domain.com) Mysql error:: 1062 (Duplicate entry '76-45' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('76', '45'). (domain.com) Mysql error:: 1062 (Duplicate entry '91-29' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('91', '29'). (domain.com) Mysql error:: 1062 (Duplicate entry '92-10' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('92', '10'). (domain.com) Mysql error:: 1062 (Duplicate entry '92-29' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('92', '29'). (domain.com) Mysql error:: 1062 (Duplicate entry '94-29' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('94', '29'). (domain.com) Mysql error:: 1062 (Duplicate entry '97-54' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('97', '54'). (domain.com) Mysql error:: 1062 (Duplicate entry '103-50' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('103', '50'). (domain.com) Mysql error:: 1062 (Duplicate entry '108-17' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('108', '17'). (domain.com) Mysql error:: 1062 (Duplicate entry '109-16' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('109', '16'). (domain.com) Mysql error:: 1062 (Duplicate entry '113-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('113', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '114-17' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('114', '17'). (domain.com) Mysql error:: 1062 (Duplicate entry '88-abd443470e1a97ac26db3c958b09a1c7' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('abd443470e1a97ac26db3c958b09a1c7', '88'). (domain.com) Mysql error:: 1062 (Duplicate entry '115-55' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('115', '55'). (domain.com) Mysql error:: 1062 (Duplicate entry '116-13' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('116', '13'). (domain.com) Mysql error:: 1062 (Duplicate entry '118-105' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('118', '105'). (domain.com) Mysql error:: 1062 (Duplicate entry '123-115' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('123', '115'). (domain.com) Mysql error:: 1062 (Duplicate entry '128-5' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('128', '5'). (domain.com) Mysql error:: 1062 (Duplicate entry '130-94' for key 'PRIMARY') (db_link) in query insert into rot_gal2group .............................

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Mon Oct 28, 2013 8:46 pm
by admin
Ок, скиньте плз базу и что именно добавлять.

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 6:22 am
by S_Flash
Импортирую Эмбед одновременно с URL, как описано тут http://www.smartcj.com/wiki/doku.php?id ... 0%B8%D1%85
Походу это и даёт Duplicate entry. Хотя сообщение поменялось:

Code: Select all

Mysql error:: 1062 (Duplicate entry '88-abd443470e1a97ac26db3c958b09a1c7' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('abd443470e1a97ac26db3c958b09a1c7', '88'). (domain.com) Mysql error:: 1062 (Duplicate entry '3457-13' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('3457', '13'). (domain.com) Mysql error:: 1062 (Duplicate entry '361-210d50aa9950a0f45d185e77dcedac1a' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('210d50aa9950a0f45d185e77dcedac1a', '361'). (domain.com) Mysql error:: 1062 (Duplicate entry '3615-5' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('3615', '5'). (domain.com) Mysql error:: 1062 (Duplicate entry '981-d49f4dace8e53bd7c3a0c520980e98ad' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('d49f4dace8e53bd7c3a0c520980e98ad', '981'). (domain.com) Mysql error:: 1062 (Duplicate entry '3743-49' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('3743', '49'). (domain.com) Mysql error:: 1062 (Duplicate entry '1161-0710a84e3c6d7dd66e25a575bf9ec732' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('0710a84e3c6d7dd66e25a575bf9ec732', '1161'). (domain.com) Mysql error:: 1062 (Duplicate entry '955-1700e09e9f9d708b0d95f606b3c1f0ae' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('1700e09e9f9d708b0d95f606b3c1f0ae', '955'). (domain.com) Mysql error:: 1062 (Duplicate entry '4006-13' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('4006', '13'). (domain.com) Mysql error:: 1062 (Duplicate entry '3433-118d667683f0fc9074a51e4485ac3cfa' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('118d667683f0fc9074a51e4485ac3cfa', '3433'). (domain.com) Mysql error:: 1062 (Duplicate entry '3437-361f6e87e11b746519f906e22fce8fa5' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('361f6e87e11b746519f906e22fce8fa5', '3437'). ........

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 2:38 pm
by admin
Проверка дупов добавлена в ап.

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 2:39 pm
by S_Flash
понял

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 2:49 pm
by admin
ok

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 3:53 pm
by S_Flash
Может всё-таки разобраться.. А то вдруго какой-то косяк вылезет потом в мускуле...

Вот совершеннео другой дамп заливал (ещё пока без апдейта):

Code: Select all

Mysql error:: 1062 (Duplicate entry '10619-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10619', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10619-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10619', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10621-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10621', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10621-126' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10621', '126'). (domain.com) Mysql error:: 1062 (Duplicate entry '10621-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10621', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10622-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10622', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10627-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10627', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10629-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10629', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10633-72' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10633', '72'). (domain.com) Mysql error:: 1062 (Duplicate entry '10634-147' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10634', '147'). (domain.com) Mysql error:: 1062 (Duplicate entry '10635-75' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10635', '75'). (domain.com) Mysql error:: 1062 (Duplicate entry '10635-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10635', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10636-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10636', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10638-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10638', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10638-93' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10638', '93'). (domain.com) Mysql error:: 1062 (Duplicate entry '10640-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10640', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10642-49' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10642', '49'). (domain.com) Mysql error:: 1062 (Duplicate entry '10643-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10643', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10644-126' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10644', '126'). (domain.com) Mysql error:: 1062 (Duplicate entry '10644-151' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10644', '151'). (domain.com) Mysql error:: 1062 (Duplicate entry '10645-49' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10645', '49'). (domain.com) Mysql error:: 1062 (Duplicate entry '10650-49' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10650', '49'). (domain.com) Mysql error:: 1062 (Duplicate entry '10655-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10655', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10657-93' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10657', '93'). (domain.com) Mysql error:: 1062 (Duplicate entry '10659-126' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10659', '126'). (domain.com) Mysql error:: 1062 (Duplicate entry '10659-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10659', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10661-147' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10661', '147'). (domain.com) Mysql error:: 1062 (Duplicate entry '10662-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10662', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10663-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10663', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10663-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10663', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10665-126' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10665', '126'). (domain.com) Mysql error:: 1062 (Duplicate entry '10666-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10666', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10667-49' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10667', '49'). (domain.com) Mysql error:: 1062 (Duplicate entry '10667-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10667', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10672-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10672', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10674-147' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10674', '147'). (domain.com) Mysql error:: 1062 (Duplicate entry '10675-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10675', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10675-93' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10675', '93'). (domain.com) Mysql error:: 1062 (Duplicate entry '10676-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10676', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10678-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10678', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10678-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10678', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10679-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10679', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10682-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10682', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10683-72' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10683', '72'). (domain.com) Mysql error:: 1062 (Duplicate entry '10684-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10684', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10686-38' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10686', '38'). (domain.com) Mysql error:: 1062 (Duplicate entry '10688-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10688', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10689-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10689', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10691-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10691', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10692-126' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10692', '126'). (domain.com) Mysql error:: 1062 (Duplicate entry '10693-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10693', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10694-15' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10694', '15'). (domain.com) Mysql error:: 1062 (Duplicate entry '10694-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10694', '4'). (domain.com) Mysql error:: 1062 (Duplicate entry '10694-93' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10694', '93'). (domain.com) Mysql error:: 1062 (Duplicate entry '10696-67' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10696', '67'). (domain.com) Mysql error:: 1062 (Duplicate entry '10696-4' for key 'PRIMARY') (db_link) in query insert into rot_gal2group (gal_id, group_id) values ('10696', '4'). (domain.com) 
По этому коду ошибки ничего не понятно?

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Tue Oct 29, 2013 4:07 pm
by admin
Дубли в таблице, проверка на дубли добавлена уже.
Вомзожно я не понял вашего сообщения.

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Thu Oct 31, 2013 7:45 pm
by S_Flash
Всё-равно вот проскачило при очередном дампе:
Mysql error:: 1062 (Duplicate entry '51-26f35c89162f436635cca1e50f8fc2ab' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('26f35c89162f436635cca1e50f8fc2ab', '51'). (mydomain.com)

Re: Mysql error:: 1062 (Duplicate entry '39-19' for key 'PRIMARY

Posted: Thu Oct 31, 2013 8:20 pm
by S_Flash
И вот такое:

Code: Select all

Mysql error:: 1062 (Duplicate entry '132-f3aac760eb5a2fc547dc8e89110b8b01' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('f3aac760eb5a2fc547dc8e89110b8b01', '132'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '801-680a0553dc94ba87fa93c7f80e04e031' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('680a0553dc94ba87fa93c7f80e04e031', '801'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '146-8c7314b9ecaf41b434f992f07760daf8' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('8c7314b9ecaf41b434f992f07760daf8', '146'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '7903-7afd06a03e72343ea48e8a57803c8de2' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('7afd06a03e72343ea48e8a57803c8de2', '7903'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '1067-bf150690220ed23939bf50d43a3bfe66' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('bf150690220ed23939bf50d43a3bfe66', '1067'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '15-39b8729792319f77a638759707217cec' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('39b8729792319f77a638759707217cec', '15'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '1585-25fa2067d64215d399c19e8fbaddec64' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('25fa2067d64215d399c19e8fbaddec64', '1585'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '1158-2bf053dd9901ac7b45c4352b3e151857' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('2bf053dd9901ac7b45c4352b3e151857', '1158'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '1067-7ea91a59742a46e0032b456fd4b39693' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('7ea91a59742a46e0032b456fd4b39693', '1067'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '40-0613053677f1939a3dbc34433a0c3239' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('0613053677f1939a3dbc34433a0c3239', '40'). (mydomain.com)
Моржет это как-то связано с тем, что было сообщение
Added: 660, Dupes:
14 galleries missed check filter and was NOT added


так как размеры ошибки мускуля примерно пропорциональны кол-ву непринятых галер.. Вот ещё пример короткого дампа:

Code: Select all

Mysql error:: 1062 (Duplicate entry '395-5e95dec552b117f5103b678cc6ad02d5' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('5e95dec552b117f5103b678cc6ad02d5', '395'). (mydomain.com) Mysql error:: 1062 (Duplicate entry '7901-86ef15950e4e4111ffd525191df089e2' for key 'PRIMARY') (db_link) in query insert into rot_gal2tag (gallery_md5, tag_id) values ('86ef15950e4e4111ffd525191df089e2', '7901'). (mydomain.com)
Added: 187, Dupes:
8 galleries missed check filter and was NOT added