What is mysql error 28?
| From: | Leif K-Brooks | Date: | Wed, 17 Apr 2002 17:45:37 +0000 |
| Subject: | What is mysql error 28? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18612@lists.php.net to get a copy of this message | ||
I have a website which has, among other things, virtual items. The items
are stored in table items, the different types of items in item_types. I
use the following query to get a user's items:
SELECT DISTINCT t1.id,t1.itemtype,t2.name FROM items as t1,item_types as t2
WHERE (t1.itemtype = t2.id AND t1.owner = '$theirrealinfo[username]' AND
t1.placein='inventory')
A few minutes ago, items mysteriosly started getting then followowing error
from mysql_error(): "Got error 28 in table handler". Thanks to anyone who
can help!
P.S. They just started working again. I'm still sending this because I want
to know what was wrong. Thanks again!