Delivery box: sending multiple items to the same person

[hannahpi]

I reproduced this on a newly created character. Steps to reproduce:

1. Created new character, named her Noobforu.
2. Bought 5 arrows
3. Manually sorted them to separate them (when purchased at the same time they're stacked)
4. Used delivery box sent 2 arrows 1 at a time to the same person (not myself). Got error on server side: [20:24:20][SQL] DB error - Duplicate entry '21846-1-0' for key 'PRIMARY' On client side I get Communication seems to be congested (something to that effect).

Additional Information:
[20:24:20][Error] Could not finalize send transaction. PlayerID: 21849 Target: Fia slotID: 1
[20:24:20][Info] parse: 00D | 005B 0058 04 from user: Fia
[20:24:25][Info] parse: 04D | 0200 01FF 10 from user: Noobforu
[20:24:25][Debug] DeliveryBox Action (0a)
[20:24:25][Debug] 4d 10 00 02 0a 02 01 ff ff ff ff ff 00 00 00 00
[20:24:25][Debug] 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
FreeSlots 21
ItemId 17318[20:24:25][Info] parse: 04D | 0201 0200 10 from user: Noobforu
[20:24:25][Debug] DeliveryBox Action (0f)
[20:24:25][Debug] 4d 10 01 02 0f ff ff ff ff ff ff ff 00 00 00 00
[20:24:25][Debug] 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

[teschnei]

can you do it by having the recipient a new char? the SQL error is erroring on the recipients side so it's not the sender that's causing problems

[hannahpi]

I'll have to create a new character to test this. I can't send on my main
character I just get communication is too congested, no errors server side
so I'm thinking that's a different issue entirely. Hold on and I'll test.

1. Created new Character
2. Logged into new character and logged out
3. Logged into Noobforu
4. Sent new character (Suppermine) 2 wooden arrows. First arrow sent
   successfully. Second arrow wouldn't send. Communication congested error
   on client and the following error server side:
   [17:54:41][SQL] DB error - Duplicate entry '21850-1-0' for key 'PRIMARY'
   [17:54:41][Error] Could not finalize send transaction. PlayerID: 21849
   Target: Suppermine slotID: 3
   [17:54:46][Info] parse: 04D | 00C5 00C4 10 from user: Noobforu
   [17:54:46][Debug] DeliveryBox Action (0a)
   [17:54:46][Debug] 4d 10 c5 00 0a 02 03 ff ff ff ff ff 00 00 00 00
   [17:54:46][Debug] 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
   FreeSlots 24

On Thu, Apr 24, 2014 at 5:31 PM, teschnei notifications@github.com wrote:

can you do it by having the recipient a new char? the SQL error is
erroring on the recipients side so it's not the sender that's causing
problems

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/169#issuecomment-41335160
.

[teschnei]

can you rerun triggers.sql and try again? its assigning slotID to 0 but it should always be 1-8 because of the trigger

[hannahpi]

thanks that seems to have fixed the issue for me

On Thu, Apr 24, 2014 at 8:00 PM, teschnei notifications@github.com wrote:

can you rerun triggers.sql and try again? its assigning slotID to 0 but it
should always be 1-8 because of the trigger

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/169#issuecomment-41346892
.