I have two shops, ones that have my special expensive things/cws that won't load my items and says there are no items in the shop. I did a quick account search and it shows the items as being in those stores. But I can't gain any access to them to take them out/price them

I'm having the same problem with one of my shops and with my gallery. It's very frustrating, because one is my pets food which I need to feed him now to battle and the other is where I stored food to donate. What is strange is that my other 4 shops are fine.

yeah, it's like stressing me out cause that is a lot of valuable things that i cant get to when i'm trying to sell stuff atm.

I don't blame you. It's sort of freaky. :(

Glad to know it's not just me, thought I was seeing things (or not) after putting some items in my shop and they are no where to be seen except they show up in account search as in the shop.

I'm having this issue as well - I know for a fact Warehouse has items in it because I've been stashing my extra holiday items there. My other shop and two galleries seem to be fine, though.

The only thing I can possibly think of that I've done differently with that one shop is recently quickstock it, but I'm not 100 percent sure about that

My shop only shows the items that were in it up until I put things in with quick stock and now it won't show any of the newer items at all.

I just put an item in one of my shops that wasn't having any problems, but it doesn't show up when I search it in the shop. It does show up though in account search.

The bright side of this?? I have gotten 2 forum points while posting here. LOL

Saaaaaame. The shop where I have my newly purchased CWs that I haven't added to my owned list and the shop where I've stashed my as-of-yet un-bonfired fireside items.

Super annoying.

When trying to access a specific category in a shop that wasn't showing anything I received this error text:

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=33853 AND category='' AND user_shop_prices.shopid=33853 AND GREATEST(user_shop_prices.price, user_shop_prices.csc) = )

Hope that may help who ever is looking into this.

Yeah, same for me. My shop isn't shopping items, and trying to access a category gave me:

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=33637 AND category='price check' AND user_shop_prices.shopid=33637 AND GREATEST(user_shop_prices.price, user_shop_prices.csc) = )

I'm also having this problem. I added two to my shop and they don't appear. They do show up on account search however.

I'm experiencing the same. Everything that is unpriced in my shop is not showing

Same problem as well.

I am also having this issue. I went to search for amulets to price them individually and got this-

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=9159 AND item.name LIKE '%amulet%'AND user_shop_prices.shopid=9159 AND GREATEST(user_shop_prices.price, user_shop_prices.csc) = )

I also then tried to search by items with prices of 0 sP and it told me I had no shop items.

phew. it's good to know i'm not the only one suffering with it. i was also worried of 'oh what if i got hacked and they took all the items out of the shop' but i have a lot of stuff in my wardrobe worth taking before those things. ^^;;

I added a new item to my shop, it showed up fine when I went straight from QS to edit items. But when I added a price manually, I got the following error message:

Oh No! That item is not in your shop. Maybe someone bought it?

I had added 43 copies of the item.

I wanted to give an update re: my shop, everything showed up yesterday :)

not me, not anymore. thanks!