Groups Broken?

[Zamthos]

Okay guys, I recently updated my server to have bots, after this update Groups didn't seem to work at all! Is there any known fix for this issue? Thanks!

[lerxst2112]

Are there any query errors in your logs? Perhaps you missed an update or two.

[Zamthos]

Query errors? Where would I find the errors? I don't quite understand.

[Zamthos]

Is these where c0ncrete posts opcodes? :D

---------------------------------------------
[01.18. - 21:00:17] Starting Log: logs/eqemu_error_zone_9276.log
[01.18. - 21:00:17] [TASKS]Activities for Task 260 are not sequential starting at 0. Not loading task.
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 2) while loading activities from database
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 3) while loading activities from database
[01.18. - 22:29:39] Unable to get groupid, character not found!
[01.18. - 22:29:41] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4

EDIT: A few seconds later.
---------------------------------------------
[01.18. - 21:00:17] Starting Log: logs/eqemu_error_zone_9276.log
[01.18. - 21:00:17] [TASKS]Activities for Task 260 are not sequential starting at 0. Not loading task.
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 2) while loading activities from database
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 3) while loading activities from database
[01.18. - 22:29:39] Unable to get groupid, character not found!
[01.18. - 22:29:41] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 1
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_TargetMouse (#125 eq=0x0000), size: 4

[c0ncrete]

i think you have me confused with noport. i commend your attempt at humor, however misdirected. :p

[Zamthos]

I did, I apologize, where is the hero Gotham deserves you need him? ;(

[c0ncrete]

in his cave, covered with guano.

(and/or full of)

[c0ncrete]

Is these where c0ncrete posts opcodes? :D

---------------------------------------------
[01.18. - 21:00:17] Starting Log: logs/eqemu_error_zone_9276.log
[01.18. - 21:00:17] [TASKS]Activities for Task 260 are not sequential starting at 0. Not loading task.
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 2) while loading activities from database
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 3) while loading activities from database
[01.18. - 22:29:39] Unable to get groupid, character not found!
[01.18. - 22:29:41] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4
EDIT: A few seconds later.
---------------------------------------------
[01.18. - 21:00:17] Starting Log: logs/eqemu_error_zone_9276.log
[01.18. - 21:00:17] [TASKS]Activities for Task 260 are not sequential starting at 0. Not loading task.
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 2) while loading activities from database
[01.18. - 21:00:17] [TASKS]Activity for non-existent task (260, 3) while loading activities from database
[01.18. - 22:29:39] Unable to get groupid, character not found!
[01.18. - 22:29:41] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 1
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_Unknown (#0 eq=0x0000), size: 4
[01.18. - 22:29:46] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING: opcode: OP_TargetMouse (#125 eq=0x0000), size: 4


i get those same messages. i don't think any of them are anything to be concerned with.

[Zamthos]

I feel like I should be concerned though, haha, they're the only errors I see that could be linked to my groups not working.

[lerxst2112]

That error means this query failed:


if (RunQuery(query, MakeAnyLenString(&query, "SELECT groupid from group_id where name='%s'", name), errbuf, &result)) {


Is that error received because you zoned, or because you tried to create a group?

[sorvani]

Missed a SQL update maybe? I thought there was a req'd SQL recently that affected groups.

[lerxst2112]

Missed a SQL update maybe? I thought there was a req'd SQL recently that affected groups.

That is my guess, especially since switching from no bots to bots was mentioned.

[Zamthos]

Any idea which one that is specifically?

[Zamthos]

Really need this to work, can I get some feedback on anyone who has had a similar situation and knows a fix, because I have ran the required SQL updates and it still doesn't work.

[c0ncrete]

did you clean and build or just build when bots were added? i've had some weird issues resolved by cleaning and building from scratch.

[Zamthos]

I cleaned and built.

[trevius]

You most likely missed this:

http://code.google.com/p/projecteqemu/source/detail?r=2383

http://code.google.com/p/projecteqemu/source/browse/trunk/EQEmuServer/utils/sql/svn/2383_required_group_ismerc.sql?spec=svn2383&r=2383

[Zamthos]

Thank you Trevius!~ It worked! You just saved me a lot of pain and suffering. Thanks again. :D