Author Topic: Bugtracker bug  (Read 3654 times)

Miriam Ics

  • Testers
  • Noble Lord
  • *
  • Posts: 298
  • Myrnia (EC) Mattias Cat (BT) Luarin Ariana (DWI)
    • View Profile
Bugtracker bug
« Topic Start: 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.
"Resolve to serve no more, and you are at once freed. I do not ask that you place hands upon the tyrant to topple him over, but simply that you support him no longer; then you will behold him, like a great Colossus whose pedestal has been pulled away, fall of his own weight and break in pieces."

Nosferatus

  • Testers
  • Mighty Duke
  • *
  • Posts: 1093
  • Too weird to live, too rare to die
    • View Profile
Re: Bugtracker bug
« Reply #1: 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?
Formerly playing the Nosferatus and Bhrantan Family.
Currently playing the Polytus Family in: Gotland, Madina, Astrum, Outer Tilog

Wimpie

  • Developer
  • Mighty Duke
  • ****
  • Posts: 1777
    • View Profile
Re: Bugtracker bug
« Reply #2: November 22, 2017, 04:11:34 PM »
bugs.battlemaster.org

Please report a bug on here with all the possible information you might have.
Osgar (Thalmarkin, BT), Jeames (Perleone, EC)
PAUSED: Nasgar (Avernus, DWI), Jari (Outer Tilog, COL)

Andrew

  • M&F's Anaris
  • Administrator
  • Noble Lord
  • *
  • Posts: 324
  • Sometimes, With A Bopping Stick
    • View Profile
Re: Bugtracker bug
« Reply #3: 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.
Like my programming? Become my patron!

Wimpie

  • Developer
  • Mighty Duke
  • ****
  • Posts: 1777
    • View Profile
Re: Bugtracker bug
« Reply #4: 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.
Osgar (Thalmarkin, BT), Jeames (Perleone, EC)
PAUSED: Nasgar (Avernus, DWI), Jari (Outer Tilog, COL)

Miriam Ics

  • Testers
  • Noble Lord
  • *
  • Posts: 298
  • Myrnia (EC) Mattias Cat (BT) Luarin Ariana (DWI)
    • View Profile
Re: Bugtracker bug
« Reply #5: 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.
"Resolve to serve no more, and you are at once freed. I do not ask that you place hands upon the tyrant to topple him over, but simply that you support him no longer; then you will behold him, like a great Colossus whose pedestal has been pulled away, fall of his own weight and break in pieces."

Miriam Ics

  • Testers
  • Noble Lord
  • *
  • Posts: 298
  • Myrnia (EC) Mattias Cat (BT) Luarin Ariana (DWI)
    • View Profile
Re: Bugtracker bug
« Reply #6: November 23, 2017, 12:52:41 AM »
By the way, I love the bizarre dance after the tournament :)
"Resolve to serve no more, and you are at once freed. I do not ask that you place hands upon the tyrant to topple him over, but simply that you support him no longer; then you will behold him, like a great Colossus whose pedestal has been pulled away, fall of his own weight and break in pieces."

Wimpie

  • Developer
  • Mighty Duke
  • ****
  • Posts: 1777
    • View Profile
Re: Bugtracker bug
« Reply #7: November 23, 2017, 08:54:19 AM »
Yes, bug was already resolved by Delvin.
Osgar (Thalmarkin, BT), Jeames (Perleone, EC)
PAUSED: Nasgar (Avernus, DWI), Jari (Outer Tilog, COL)