"Duplicate key in AccessSubscriberMap" at ItemAdd - Event

cient

Joined: 2006-06-01
Posts: 26
Posted: Wed, 2006-06-21 14:53

hello,

i dont know why, but since a unknown time i always get this error message while trying to add photos.

---
An error has occurred while interacting with the database.
---
INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (86,70)

1062: Duplicate entry '86' for key 1

ADOConnection._Execute(INSERT INTO g2_AccessSubscriberMap
(g_itemId, g_accessListId) VALUES (86,70)) % line 836, file: adodb.inc.php

ADOConnection.Execute(INSERT INTO
g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (?,?),
Array[2]) % line 1055, file: GalleryStorageExtras.class

GalleryStorageExtras.addMapEntry(GalleryAccessSubscriberMap,
Array[2]) % line 521, file: GalleryStorage.class
GalleryStorage.addMapEntry(GalleryAccessSubscriberMap,
Array[2]) % line 2924, file: GalleryCoreApi.class
GalleryCoreApi.addMapEntry(GalleryAccessSubscriberMap,
Array[2]) % line 294, file: GalleryEntity.class
---

does someone know why?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2006-06-21 18:02

topic moved to the support forums.

can you please check if your g2_SequenceId table has more than 1 row / entry?
 
cient

Joined: 2006-06-01
Posts: 26
Posted: Thu, 2006-06-22 06:15

there is just one entry, id: 194

btw: what idea is behind the tables g2_AccessSubscriberMap and g2_SequenceId ?
 
cient

Joined: 2006-06-01
Posts: 26
Posted: Fri, 2006-06-23 14:50

error was laying in my additional code, gallery is now running. thanks.

thread closed (;
 
ciscojay

Joined: 2006-01-09
Posts: 49
Posted: Tue, 2006-07-11 02:20

How do you find out if you, "g2_SequenceId table has more than 1 row / entry? From MyphpAdmin for MySQL?

have you been seen, lately...?
www.mycrazyfriends.com
 
ciscojay

Joined: 2006-01-09
Posts: 49
Posted: Tue, 2006-07-11 02:22

Okay- maybe this is it. It looks like there are 4 rows. Am I reading this correct? How do I fix it?

Row Statistics
Format fixed
Rows 4
Row length ø 5
Row size ø 261 Bytes
Creation Mar 25, 2006 at 06:23 PM
Last update Jul 10, 2006 at 05:51 PM

have you been seen, lately...?
www.mycrazyfriends.com
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2006-07-11 06:59

http://gallery.menalto.com/node/51508#comment-191103