RE: [PHP-DB] What is mysql error 28?
| From: | Gurhan Ozen | Date: | Wed, 17 Apr 2002 17:54:05 +0000 |
| Subject: | RE: [PHP-DB] What is mysql error 28? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18613@lists.php.net to get a copy of this message | ||
Hi Leif,
Anytime you get an MySQL error code number use perror program to see what it
is..
[root@atsiz /root]# perror 28
Error code 28: No space left on device
It seems like you don't have enough space to write to your table.
Gurhan
-----Original Message-----
From: Leif K-Brooks [mailto:eurleif@buyer-brokerage.com]
Sent: Wednesday, April 17, 2002 1:46 PM
To: php-db@lists.php.net
Subject: [PHP-DB] What is mysql error 28?
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!