Timeouts, Error Codes (5xx), Lag | FIRST POST UPDATED 7/22
Filter
Show Official Posts OnlyReplies
I was putting Candy Hearts in trades at the time.
Like a good neighbor, stay over there!
Fed my pet Cryistel a for a Drill's Quest a few minutes ago.
Application Error appeared in place of the page that shows up when the pet eats the food. Item was marked as eaten for the quest, and in the pet's foods eaten list (it wasn't previously), but item remained in inventory. I deleted it manually. Hunger level did not increase.
Edited to add that I fed my pet earlier in the day without any errors, and just fed my pet without issue. Could have been a one off hiccup in the server?
Well done Bug, and great work as always! ❤
Most of these are one-off hiccups in the servers. But, the frequency of these increases when the site as a whole is under more strain. Thus, to resolve these errors we have to look at and address the root causes behind it; that is, make changes and updates around the site that make it better able to handle strain in general. That's been an ongoing, longterm effort here :)
Bug reports are still helpful because they can point us in the right direction, especially if we notice people are getting frequent errors in one part of the site, it tells us we should look at that specific part and try to see what can be improved there.
For your bug report here, thank you for deleting the extra item, and thanks for the detailed report. Letting us know what succeeded and what didn't tells us the exact point where the code failed (it seems, in this case, right before updating your pet's hunger) and that's super helpful <3
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
I was trying to buy an item in a shop and this popped up:
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 COUNT(1) AS count FROM stocked_items WHERE stockid=)
Then I had to log in again, and everything seemed okay . . ?
Do you know what item you were trying to buy, which shop you were buying it from, and approximately what time you attempted to purchase it?
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
About 4 minutes ago, I was buying The Truth About Clowns from the Carnival Shop. The error popped up, I refreshed, and then had to log in again. I did end up having the book I bought in my inventory.
Ok, thank you! Do let me know if it happens again.
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
in Lamour parlor on mouseover:
Database error - send this to Keith: SQLSTATE[HY000] [2002] Connection refused (SQL: SELECT * FROM user WHERE userid='508662')
Collecting minions , weapons, rainbow and evil things now, PM me if you are selling!
What item did you mouseover, and are you still getting that error, or did it only happen once (and the mouseover worked the next time)?
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
I was trying to use shop search and I got this error code:
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 's token' AND rarity<300' at line 1 (SQL: SELECT itemid,rarity,shop,price,userprice FROM item WHERE name='New year's token' AND rarity<300)
I realized that I misspelled the item, but was curious if the apostrophe was causing the error code.
Trying to quickstock my shop just now and got an error 520. Issue resolved upon refresh but this happens to me frequently (ps thank you for all the hard work you do Bug, you're great)
Was trying to search for Charity Bobblehead in [link=https://subeta.net/user_shops.php/shop/2592]this shop[/link] and got this message. Happens not matter what item I search for.
WHEREitemidIN (SELECTitemidFROMitemWHEREnameLIK' at line 1 (SQL: SELECTitemid, amount FROM user_shop_items WHERE itemid IN (SELECT itemid FROM item WHERE name LIKE &;%charity%&;) AND shopid=&;2592&; GROUP BY itemid)
Thank you for the report! Could you paste that here: Search within shop gives SQL error I will post updates on that topic.
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights
I am with lag in the foruns :/ Lot of time to load one single page.
Still Lagging. I dont even know if this will post...
Nevermind, it fixed itself after loading for about seven minutes straight. I'm gonna go read a book until the site calms down.
