Posted by Raffle idems not showing up?

Anxiety Prime™
[11.25.22 RLC] (#191357)


View Forum Posts


Posted on
2020-07-10 18:03:46
What gameplay feature is this bug affecting?
Raffles

What's the issue? Please include any error messages you receive and as much detail as possible.
I had whent to a raffle called "5gb+IBF+cave kit+mats for sb/herbs/gems/feathers!" And it wasn't showing any of the prizes at all

Any links relating to this bug? For example, if a particular lion is bugging, what is the link to that lion?
https://www.lioden.com/raffle.php?id=12717

Any screenshots you can provide us with?
???.jpg

Please provide us with step by step explanation how this bug happened so we can attempt to replicate it. If it's complex, please include screenshots where possible:
In sales chat a user had posted a advertisement with the following Rachel Kay (#205899)"
https://www.lioden.com/raffle.php?id=127171 RAFFLE! cave kit, IBF, plus 5 GB!!! tickets can be bought for sb, feathers, gems, or herbs! ends july 15." I clicked it and all the showed up was this I messaged Katze about it and she said to post it here

???.jpg



Hrt Icon 0 players like this post! Like?

Roxanne (Nov
Semi-Hiatus) (#121082)


View Forum Posts


Posted on
2020-07-13 15:02:03
Same thing happened to me.

Raffle was made twice.
https://www.lioden.com/raffle.php?id=127414
https://www.lioden.com/raffle.php?id=127413

Received an error message
"PROBLEM: 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 ', 0), (127413, 0, 0, 1356443436938, 4436, 0), (127413, 0, 0, 1356443848680, 5293' at line 1"

Items were not taken from my hoard.



Hrt Icon 0 players like this post! Like?

Michael (#16)

Famous
View Forum Posts


Posted on
2020-07-13 15:48:30
@Rox: What were the other items that you tried to add to your raffle? I can see the two from the query error.

@Weasel: Did you receive a similar error, do you know? And would you be able to provide links to the items directly from your hoard?

Thank you, both!



Hrt Icon 0 players like this post! Like?

Roxanne (Nov
Semi-Hiatus) (#121082)


View Forum Posts


Posted on
2020-07-13 16:54:19
I tried to add a Touch of Demiurge, Dust: Meteorite and a Broken Camera.



Hrt Icon 0 players like this post! Like?

Anxiety Prime™
[11.25.22 RLC] (#191357)


View Forum Posts


Posted on
2020-07-13 18:20:40
It wasn't my raffle



Hrt Icon 0 players like this post! Like?

Michael (#16)

Famous
View Forum Posts


Posted on
2020-07-13 22:26:41
@Rox: The raffle system is one of the older systems on the site, and as such doesn't take advantage of some of our improved error handling. I've gone ahead and made some changes that will allow me to better track the errors that you receive. So if you would like to try to recreate your raffle, I can hopefully see this time what's going on should it fail again.

Thank you, and sorry for the inconvenience!

@Weasel: Sorry, I misunderstood and thought it was your raffle. I've gone ahead and canceled that raffle and notified the creator so that they may create it again properly.



Hrt Icon 0 players like this post! Like?

Roxanne (Nov
Semi-Hiatus) (#121082)


View Forum Posts


Posted on
2020-07-14 00:22:52
Raffle seems to have worked properly this time
New Raffle Link



Hrt Icon 0 players like this post! Like?

Michael (#16)

Famous
View Forum Posts


Posted on
2020-07-14 01:59:00
Glad to hear it! I'm going to go ahead and keep this thread open for a while, in case anyone else experiences this. At least hopefully now it will be easier to pin down. :)



Hrt Icon 0 players like this post! Like?

Anxiety Prime™
[11.25.22 RLC] (#191357)


View Forum Posts


Posted on
2020-08-06 19:45:02
Ahhhhhh I had this problem again! With this raffle here
https://www.lioden.com/raffle.php?id=129143



Hrt Icon 0 players like this post! Like?

Michael (#16)

Famous
View Forum Posts


Posted on
2020-08-07 17:20:11
I've gone ahead and unstuck your items assigned those item to the correct raffle, Weasel, and am currently investigating the cause of the issue.

Thank you for the heads up! :)



Hrt Icon 0 players like this post! Like?


Edited on 07/08/20 @ 17:47:51 by Michael (#16)

Michael (#16)

Famous
View Forum Posts


Posted on
2020-08-07 17:42:51
Actually I think I see what the issue is now. Not sure why I didn't check for this first -- it seems as though the raffle was created twice in the same second (lag, double-click, etc.). I've got some updates coming next week that I hope will alleviate this issue.



Hrt Icon 0 players like this post! Like?

Anxiety Prime™
[11.25.22 RLC] (#191357)


View Forum Posts


Posted on
2020-08-08 20:05:26
Ahhh okay!^^



Hrt Icon 0 players like this post! Like?







Memory Used: 626.09 KB - Queries: 2 - Query Time: 0.00047 - Total Time: 0.00425s