BattleMaster Community

BattleMaster => Development => Topic started by: Miriam Ics on November 22, 2017, 01:10:38 PM

Title: Bugtracker bug
Post by: Miriam Ics on November 22, 2017, 01:10:38 PM
Where can we report bugtrackers bugs?

I have a bug IC but can't report it at bugtracker. it says "APPLICATION WARNING #2702: Your session has become invalidated."

I will paste here the error IC, trying to send a message to all at tournament, at colonies, assassins.
Can someone please move this post to the right place?

Quote
Error during database query
Please report the following error to the bugtracker, together with a short statement on when it occurred, especially on which page or action:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or (T.ID is not NULL and P.ID!=5070 and P.active='yes') ORDER BY CharacterName A' at line 1

Query was: select P.ID from Players P left join Tournaments T on P.ID=T.Maker where P.active='yes' and P.ID!=5070 and P.Status in ('tournament','aftertour') and P.Location= or (T.ID is not NULL and P.ID!=5070 and P.active='yes') ORDER BY CharacterName ASC

Calling script: /stable/message-write.php
No valid recipients found for this selection.
Title: Re: Bugtracker bug
Post by: Nosferatus on November 22, 2017, 03:53:44 PM
some more information would probably be appreciated.
When did the bug occur?
What triggered it?

where and what character experienced it, etc would be appreciated.

Also i can visit the bug bug tracker and reopen a case without a problem.
What is your problem?
Cant you visit the bug tracker or cant you open up up a case?
Title: Re: Bugtracker bug
Post by: Wimpie on November 22, 2017, 04:11:34 PM
bugs.battlemaster.org (http://bugs.battlemaster.org)

Please report a bug on here with all the possible information you might have.
Title: Re: Bugtracker bug
Post by: Andrew on November 22, 2017, 04:27:22 PM
Mantis application warning #2702 is just it saying there's a session mismatch between the user and the server. I can't find anything really going into detail on, besides the fact that it's been fixed as a bug in multiple versions, to include a bug fixing it for the version BM runs (which is old as dirt, for the record).

As for the bug itself, in regards to the game...

select P.ID from Players P left join Tournaments T on P.ID=T.Maker where P.active='yes' and P.ID!=5070 and P.Status in ('tournament','aftertour') and P.Location= or (T.ID is not NULL and P.ID!=5070 and P.active='yes') ORDER BY CharacterName ASC

"P.Location= or" is missing the thing it should be equal to, which means a variable isn't getting passed, possibly because the player id in question doesn't actually have a location? I'm not sure what player id means in relation to BM, though. I'd probably need a chart to wrap my head around how it works sometimes.
Title: Re: Bugtracker bug
Post by: Wimpie on November 22, 2017, 04:42:22 PM
Yes, Delvin has been updating the Tournament scripts and also how it works with Locations. Hence why something apparently went wrong.

Please post a bug and Delvin will take a look.
Title: Re: Bugtracker bug
Post by: Miriam Ics on November 23, 2017, 12:51:15 AM
The error was after trying to send a message to "all at the tournament" at the colonies.
Apparently is fixed already and so is the bug at bugtracker.
I don't think it is worth it to open a bug repport now.
Title: Re: Bugtracker bug
Post by: Miriam Ics on November 23, 2017, 12:52:41 AM
By the way, I love the bizarre dance after the tournament :)
Title: Re: Bugtracker bug
Post by: Wimpie on November 23, 2017, 08:54:19 AM
Yes, bug was already resolved by Delvin.