Page 1 of 1

Delivery Box error with second slot (latest packet_system)

Posted: Mon Dec 07, 2015 7:23 pm
by 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.

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 8:35 pm
by 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?

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 8:40 pm
by 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.

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 8:58 pm
by kjLotus
have you rerun triggers.sql?

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 9:01 pm
by bluesolarflare
I think I did but I'll rerun it to make sure.

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 9:16 pm
by whasf
bluesolarflare wrote: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)

Re: Delivery Box error with second slot (latest packet_syste

Posted: Mon Dec 07, 2015 10:32 pm
by bluesolarflare
kjLotus wrote: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.