Replies

Nov 25, 2019 6 years ago
Luck
is unlucky
User Avatar
Bella

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 itemid, name FROM item WHERE itemid IN ())

https://subeta.net/trade/trades.php?action=new There is a "ghost item" at the end of the item selection there is no picture or name just a check box. If you try to check the box and make a trade with the ghost item this happened.

he/him / 31 / EST



My best friend is



Nov 30, 2019 6 years ago
FCoD
needs more chocolate
User Avatar
Ms. Hollyhock

Just got this checking to see if I had any amulets in my shop before pricing:

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(item.itemid) as count FROM user_shop_items LEFT JOIN item ON item.itemid=user_shop_items.itemid LEFT JOIN user_shop_prices ON user_shop_prices.itemid=user_shop_items.itemid WHERE user_shop_items.shopid=827 AND item.name LIKE '%MAGE AMULET%'AND user_shop_prices.shopid=827 AND GREATEST(user_shop_prices.price, user_shop_prices.csc) = )

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/

Dec 1, 2019 6 years ago
Koreycabra
User Avatar
Nefer-temu

Get similar error when searching my items.

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(item.itemid) as count FROM user_shop_items LEFT JOIN item ON item.itemid=user_shop_items.itemid LEFT JOIN user_shop_prices ON user_shop_prices.itemid=user_shop_items.itemid WHERE user_shop_items.shopid=41554 AND category='rreign' AND user_shop_prices.shopid=41554 AND GREATEST(user_shop_prices.price, user_shop_prices.csc) = )

[sup]𝘛𝘳𝘢𝘯𝘴𝘪𝘦𝘯𝘵 𝘳𝘦𝘥 𝘭𝘦𝘢𝘧.. 𝘍𝘭𝘶𝘵𝘵𝘦𝘳𝘴 𝘵𝘰 𝘵𝘩𝘦 𝘱𝘳𝘦𝘤𝘪𝘱𝘪𝘤𝘦.. 𝘈𝘯𝘥 𝘣𝘳𝘢𝘷𝘦𝘭𝘺 𝘥𝘪𝘷𝘦𝘴.. 🍁[/sup] [img align=center height=60 width=80]https://cdn.pfps.gg/banners/7324-kazuha.gif[/img]

Dec 1, 2019 6 years ago
Junior Archaeologist
Magi
User Avatar

Similar when trying to add the "subeta adblock" filter to my custom css

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 't repost/edit to sell / / ---------------------------------------------------' at line 1 (SQL: UPDATE user_var set customcss='' WHERE userid='8066')

Dec 2, 2019 6 years ago
Ginseng
is a witch
User Avatar

I get this when attempting to update the "profile" block on my user profile, even when I don't add any additional code.

URL: https://subeta.net/profile_edit.php

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 'm Ty! Agender // 24 // Artist // Midwest // Married to [userid=692394] ❤ ' at line 1 (SQL: UPDATE user SET profile=' Hey, I'm Ty! Agender // 24 // Artist // Midwest // Married to [userid=692394] ❤ Recently graduated with a BFA in painting! He/they pronouns please. Currently in DnD and programming hell.

I'm in love with plants and deer, and I'm also wiccan. I have really severe ADHD. I come here to relax and overuse emojis, so feel free to chat. I like to do quests, pretend I know how to code, and collect wearables. I also love working on my pets, even if I'm slow at it! I tend to do a lot of my work for them offsite, so even if their profiles look a little bare please know they are all very much loved.

I'm pretty socially anxious, even if you're nice, as well as incredibly forgetful, so if I'm slow to respond I apologize!! If I take too long, feel free to give me a gentle nudge.

Previous username: Rodent Click to like my HA! ❤

Profile by [userid=484667] || Banner BG by Camille Chew || Plants by liticaharmony

' WHERE userid='647843')

━━━━━━━━━━━━━━━ 🌿 ⨯ They/Them 🌿 Cw Thread [sup]🌿[/sup] Cw Shop [sup]🌿[/sup] Ping Group ☆ Large HA Templates Download || ▷ Includes B1-10, B18-21 ◁

Dec 17, 2019 6 years ago
Luck
is unlucky
User Avatar
Bella

I'm really annoyed that I can't update my custom css to fix the recent random centering of some parts of the site because of this error.

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 't repost edit to sell / / ---------------------------------------------------' at line 1 (SQL: UPDATE user_var set customcss='' WHERE userid='580707')

he/him / 31 / EST



My best friend is



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

Thank you for the reports! These will be handled as separate bug reports moving forward.

These were reported elsewhere and fixed:

  • Editing profile; see here
  • Editing custom CSS; see here

If you are still encountering other database errors, please look for a forum topic on the specific error you've gotten, and make a new one if none already exists. Thank you so much <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.