Delivery Box error with second slot (latest packet_system)

[bluesolarflare]

I am seeing an issue with the Delivery Box.

When trying to send an item to a mule, the first item sends, but the second item in the second slot gets stuck and then I get the message "communications seems congested"

I am running the latest packet_system.cpp which switches box 2 around and I have cleared out the delivery_box.sql table multiple times, but every single time I get an error. The error log in DSGame-Server is as follows:

Code: Select all

[16:20:26][1;35m[SQL][0m DB error - Duplicate entry '21832-1-0' for key 'PRIMARY'
[16:20:26][1;35m[SQL][0m Query: INSERT INTO delivery_box(charid, charname, box, itemid, itemsubid, quantity, extra, senderid, sender) VALUES(21832, 'Testtaru', 1, 17860, 0, 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 21830, 'Testuser'); 
[16:20:26][1;31m[Error][0m Could not finalize send transaction. PlayerID: 21830 Target: Testtaru slotID: 1[16:20:31][1;37m[Info][0m parse: 04D | 0030 002F 10 from user: Testuser
[16:20:31][1;36m[Debug][0m [1;36mDeliveryBox Action (0a)

Removing the items in the delivery box sql file, restarting the server, and trying to send again has the same effect.

[kjLotus]

Working fine for me. Open box, entered character name, put up one item in slot 1, put up another item in slot 2, hit send, they are both sent.

Is this what you are doing?

[bluesolarflare]

Correct. In fact it will only accept the first item (slot1)
Anything in the other slots gives the congestion message and the logs say there is a duplicate.

[kjLotus]

have you rerun triggers.sql?

[bluesolarflare]

I think I did but I'll rerun it to make sure.

[whasf]

I am seeing an issue with the Delivery Box.

When trying to send an item to a mule, the first item sends, but the second item in the second slot gets stuck and then I get the message "communications seems congested"

I am running the latest packet_system.cpp which switches box 2 around and I have cleared out the delivery_box.sql table multiple times, but every single time I get an error. The error log in DSGame-Server is as follows:

Code: Select all

[16:20:26][1;35m[SQL][0m DB error - Duplicate entry '21832-1-0' for key 'PRIMARY'
[16:20:26][1;35m[SQL][0m Query: INSERT INTO delivery_box(charid, charname, box, itemid, itemsubid, quantity, extra, senderid, sender) VALUES(21832, 'Testtaru', 1, 17860, 0, 1, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', 21830, 'Testuser'); 
[16:20:26][1;31m[Error][0m Could not finalize send transaction. PlayerID: 21830 Target: Testtaru slotID: 1[16:20:31][1;37m[Info][0m parse: 04D | 0030 002F 10 from user: Testuser
[16:20:31][1;36m[Debug][0m [1;36mDeliveryBox Action (0a)

Removing the items in the delivery box sql file, restarting the server, and trying to send again has the same effect.

So your delivery_box MySQL table is empty? (I'm not talking about a .sql file, I'm talking about the actual database table)

[bluesolarflare]

have you rerun triggers.sql?

That was the culprit. Reran triggers and everything is fine now. I went back and checked my batch file that I run after merges and somehow it is missing along with another SQL file for the treasure spawn points. Thanks for the quick resolution in helping me find my error.