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.
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
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) = )
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')
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 ◁
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')
Thank you for the reports! These will be handled as separate bug reports moving forward.
These were reported elsewhere and fixed:
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