when i tried to feed my pet, instead of getting the page where the pet comments on the food and it shows me how hungry they are, i got this message:
SQL Error UPDATE pets SET hunger='1' WHERE petid='980147' LIMIT 1
the error occurred on firefox and chrome. i was trying to feed a bunch of food that my pet has never eaten before, and each one gave me this error. when i fed her something she's eaten before, everything worked normally. after clearing my inventory (i had >250 items) and trying to feed new food to her, i no longer got the error.
some things i noticed while testing the error:
since it managed to fix itself, i haven't been able to replicate the error with this or any other pet so idk if it's a one time thing, but i figured it's notable since i got to keep the items i fed to my pet.
Just had a similar one, but when in the Subeautique, on this page: https://subeta.net/explore/subeautique.php/shop
Just a blank page with the below error, was gone again after a refresh.
SQL Error
INSERT INTO user_items (id,userid,itemid) VALUES ('',176589,)
I get those randomly along with blank or partially blank pages. Just had one while trying to turn stuff in to Shinwa.
RIP Mom, I love & miss you more than you know. Tell Dede hi.
Ocean Conservation Namibia on YouTube... they do good work! https://www.ocnamibia.org
SQL Error UPDATE pets SET hunger='4' WHERE petid='815225' LIMIT 1
i got this two or three times during the early part of the quest-a-thon when the site was lagging really badly, and again just now. i've just been deleting the "used" food and avoiding feeding while the site is lagging, not sure if there's anything else i can do to avoid this one p;
Is this still going on now that the event is over?
i just ran into the error before i made that post (it's what reminded me to go look for an SQL error thread), and the event ended yesterday, so i guess so?
i think it only happens when the site lags really badly; the item use page was loading for a minute or so each time i ran into it.
Ahh, ok. You are getting proper credit for feeding it to your pet, though?
i'm pretty sure i got credit for the foods; when clicking on the item afterwards i get the "already eaten" note, an account search gets me "1 found fed to your pet widowmaker," and her foods eaten count went up
also i just reread mei's original post -- i had a near-empty inventory when i tried to feed widow a and got the error, so i don't think the amount of items in my inventory had anything to do with it, i think it's just lag-related?
i haven't had this issue since the first time (mostly bc i haven't been feeding my pet), but i remember it did take me a really long time to load the page after feeding my pet, so it would make sense if it were lag related
I’m getting the same error as Reya on every page
What the heck happened to the site while I was on the phone?
Got from cache: userobject.305899
Got from cache: ipban_list
Got from cache: configurator_list
Got from cache: user:buffs:305899
Got from cache: feed_friends_305899
Got from cache: feed_filter_305899
Got from cache: feed_privacy_305899
Got from cache: feed_twitter_305899
Got from cache: feed_facebook_305899
Got from cache: forums:topic:891011
Got from cache: xforums:forum:285
Got from cache: forum🧵list:891011
Got from cache: post:count:891011
Got from cache: xforums:forum:285
Got from cache: forums:minimods:285
Got from cache: forums:npcs
Got from cache: SELECT userid FROM forums_subs WHERE topicid='891011' AND userid='305899' LIMIT 1
Got from cache: list:minimods:285
Got from cache: forums:first:891011
Got from cache: SELECT * FROM forums_posts WHERE topicid='891011' ORDER BY postid ASC LIMIT 1 LIMIT 1
Got from cache: xforums:forum:285
Got from cache: xforums:forum:19
Got from cache: forum:category:1
Got from cache: SELECT * FROM forums_haveread WHERE topicid='891011' AND userid='305899' LIMIT 1
Got from cache: user:events:305899
Got from cache: item:getItem:176962
Got from cache: item:getItem:176962
Happens on every page.
RIP Mom, I love & miss you more than you know. Tell Dede hi.
Ocean Conservation Namibia on YouTube... they do good work! https://www.ocnamibia.org
Just wanted to confirm - these have cleared up, correct?
as far as i can recall, i haven't seen this issue since last month. i also haven't experienced any really bad lag since then. o:
A fix for the pet hunger SQL query was done a few weeks ago
🐝 ☕ bug (he/him) | your friendly neighborhood code wrangler. stay in the loop! join and check out the latest admin post highlights