Replies

Dec 16, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

Trying to use a Bloodred Potion on my active pet and I get this message:

Quote
Database error - send this to Keith: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &;)&; at line 1 (SQL: SELECT * FROM feed_categories WHERE ident NOT IN())

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 18, 2019 6 years ago
METROID
has been EXTERMINATED
User Avatar
Havoc

I think this issue is affecting everyone, unable to colour pets. Lemme mess with elixirs, see what happens. Hisui's gonna be the test dummy.

'Your pet has changed into a Arid Mahar!'

Well, elixirs seem to be spared. Good, I guess. Now to colour Hisui back to Glacier and see if I get it too.

'Your pet has changed into a Glacier Mahar!'

......is it only affecting active pets then? Well, guess I gotta mess with Elfric. [edit] Your pet has changed into a Arid Kumos! Maybe it's fixed now. .-.

[flower=Metroid]

Wanna know more about battling? ❤️ The Official Battle Guide v3.3 ❤️ Need to find books? 🌈 The Book Grind Guide v1.0 🌈

Dec 18, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

Unfortunately I get the error even when using a different potion on a different pet. Elixirs and zaps are fine, but straight potions give the error. For now I'm unable to use my Bloodred and Sweetheart Potion I planned on using. Maybe you're not getting the error? Which is very lucky of you. I guess also unless certain other color changes also work because I got Riftborn just fine. Galactic, Steamwork, Nostalgic, etc. may not be issues either.

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 18, 2019 6 years ago
METROID
has been EXTERMINATED
User Avatar
Havoc

Well, the glacier potion is a genetech combo item, so maybe that's why it isn't affected either. I will dedicate myself to testing and trying to replicate it. FOR SCIENCE. [edit]Nuzlocke shall suffer. 'Your pet has changed into a Common Harvester!' Good. 'Your pet has changed into a Bloodred Harvester!' ....I'm mad I can't replicate this.

[flower=Metroid]

Wanna know more about battling? ❤️ The Official Battle Guide v3.3 ❤️ Need to find books? 🌈 The Book Grind Guide v1.0 🌈

Dec 18, 2019 6 years ago
Floriography
has a bad feeling about this
User Avatar
Arhil

&

I tried the exact combination of the Yaherra Xuna to see if I could get the problem to replicate. Created one, turned it into a sun, then made it active pet, then bloodred and didn't run into any issues!

I wonder if it's another issue like the centering of texts where only some users are experiencing it (for whatever reason) and others aren't.

Honestly at this point I'd just love a blanket update from staff that says we are aware of what's broken, here's what we are doing, and I don't know just more information in general from the higher ups.

I'm usually pretty chill about waiting for the site to fix itself, but this is really making it hard for users to play and I feel bad for them :c

Dec 18, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

Just an example of what it looks like on my active and it goes back to the Sun color. At least you're not getting this issue. No idea what's causing this.

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 18, 2019 6 years ago
METROID
has been EXTERMINATED
User Avatar
Havoc

Hmm....what browser are you using? I use Firefox and am on a regular PC.

[flower=Metroid]

Wanna know more about battling? ❤️ The Official Battle Guide v3.3 ❤️ Need to find books? 🌈 The Book Grind Guide v1.0 🌈

Dec 19, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

I am using chrome and I use windows.

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 20, 2019 6 years ago Official
Spotlight Champion
Destiny
User Avatar
Dexter

This should be fixed guys! Can you confirm?

Dexter by

Dec 20, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

Positive: It does change my pet now. (However I still get the string of text) Negative: The potion doesn't go away from my inventory. That is definitely an issue.

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 21, 2019 6 years ago Official
Bug
User Avatar
Segfault

Thank you for confirming. I've just made another change to make sure the item is correctly removed from your inventory.

The database error seems like that error is being caused by a problem with adding it to the Friend Feed (normally when a potion gets used, your friends will be able to see that you used it in their Friend Feeds) I am still working on fixing that part :)

🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights

Dec 21, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

I appreciate the fixes :) but as of right now they're still in my inventory. Unless you're currently working on this, this could be easily exploited. I could delete them right now if necessary.

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 21, 2019 6 years ago Official
Bug
User Avatar
Segfault

Yes, please delete the potion.

I did test by using a Potion on my own pet, and it seemed to delete it correctly. However, I've just removed the Friend Feed code for now since it was still potentially causing an exploitable bug.

What that means is potions should be used up correctly and can't be exploited anymore, but potion usage won't show up on friend feeds. We'll keep this forum topic open and I'll update once I fix the related database error and can put the Friend Feed code back.

🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights

Dec 23, 2019 6 years ago Official
Bug
User Avatar
Segfault

Could you please let me know if using a potion on your pet still results in a database error?

🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights

Dec 23, 2019 6 years ago
Hexfear
fighter of the dayman
User Avatar
Epilepsy

I no longer get the database error. :)

I love you more than I can ever scream~
[img align=center]https://media.giphy.com/media/SSESzckUst0SHBdtGB/giphy.gif[/img]

Dec 23, 2019 6 years ago Official
Bug
User Avatar
Segfault

Awesome! I had fixed the friend feed code and put it back, just needed confirmation it is working. Thank you for helping test it out. Closing this as resolved <3

🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights

Please log in to reply to this topic.