Replies

Jul 29, 2018 7 years ago
mei
is a Grand Champion!
User Avatar

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:

  • my pet's "food eaten" counter goes up and if i click the item in my inventory it tells me my pet has eaten it
  • the item is not consumed
  • my pet's hunger doesn't increase

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.

Jul 31, 2018 7 years ago
Evy
does not get outside
User Avatar
Winnie

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,)

Aug 1, 2018 7 years ago
FCoD
needs more chocolate
User Avatar
Ms. Hollyhock

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

https://www.hopeforpaws.org/

Sep 16, 2018 7 years ago
jensen
rolled snake eyes
User Avatar
RM

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;

oh sacred spork, smite mine enemies

Sep 16, 2018 7 years ago Official
Reya
has ALL of the beanbags!
User Avatar

Is this still going on now that the event is over?

Sep 16, 2018 7 years ago
jensen
rolled snake eyes
User Avatar
RM

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.

oh sacred spork, smite mine enemies

Sep 16, 2018 7 years ago
Reya
has ALL of the beanbags!
User Avatar

Ahh, ok. You are getting proper credit for feeding it to your pet, though?

Sep 16, 2018 7 years ago
jensen
rolled snake eyes
User Avatar
RM

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?

oh sacred spork, smite mine enemies

Sep 16, 2018 7 years ago
mei
is a Grand Champion!
User Avatar

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

Sep 16, 2018 7 years ago
cassygee
the Rreign Tamer
User Avatar
Calamity Jane

I’m getting the same error as Reya on every page


🌲 All proceeds from Empty Trees Emporium fund Empty Trees 2025 🌲


wishlist

Sep 16, 2018 7 years ago
FCoD
needs more chocolate
User Avatar
Ms. Hollyhock

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

https://www.hopeforpaws.org/

Oct 15, 2018 7 years ago Official
Reya
has ALL of the beanbags!
User Avatar

Just wanted to confirm - these have cleared up, correct?

Oct 15, 2018 7 years ago
jensen
rolled snake eyes
User Avatar
RM

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:

oh sacred spork, smite mine enemies

Oct 19, 2018 7 years ago
Bug
User Avatar
Segfault

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

Please log in to reply to this topic.