SQL errors in free shop
Replies
Mar 27, 2017
9 years ago
Flying Ace
Speiro
I just got logged out randomly while trying to buy from the free shop, and got the following error:
Quote
SQL Error</p>
<p>The number there appears to be the item ID, so there&;s an interesting way to peek at what you&;re buying to see if you get something good. :x</p>
<p>After I logged back in and tried making another purchase, I got this:</p>
<p>[quote]SQL Error</p>
<p>
INSERT INTO user_items (id,userid,itemid) VALUES ('',,172107)[/quote]
<p>The number there appears to be the item ID, so there&;s an interesting way to peek at what you&;re buying to see if you get something good. :x</p>
<p>After I logged back in and tried making another purchase, I got this:</p>
<p>[quote]SQL Error</p>
SELECT COUNT(1) AS cnt FROM stocked_items WHERE stockid=��˹���P� LIMIT 1
<p>
It seems to be working ok now that I've logged in and reloaded the shop completely, at least for now. I think it's just not set up to properly handle errors if you're not logged in.
Please log in to reply to this topic.