Weird Error Code

[masterofollies]

Some people on my website are getting the following error code, and i've never seen it before and wouldn't know how to fix it.

File './rod_game/users.MYD' not found (Errcode: 24)

[guelphdad]

so check your data directory in the mysql install path. is the users.MYD file there or not? If it isn't then you've gone and deleted it.

[masterofollies]

I haven't touched my database in awhile. Also no one else has access to it. Where can I get to the data directory? I am using phpmyadmin.

[CFMaBiSmAd]

The mysql manual might help with this one -
B.1.2.18. 'File' Not Found and Similar Errors
If you get ERROR '...' not found (errno: 23), Can't open file: ... (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you haven't allocated enough file descriptors for the MySQL server. You can use the perror utility to get a description of what the error number means:

shell> perror 23
OS error code 23: File table overflow
shell> perror 24
OS error code 24: Too many open files
shell> perror 11
OS error code 11: Resource temporarily unavailable

The problem here is that mysqld is trying to keep open too many files simultaneously. You can either tell mysqld not to open so many files at once or increase the number of file descriptors available to mysqld. You are either running up against a mysql setting or an operating system setting.

P.S. How come people use the word 'Weird' to describe errors and programming problems? Programs only do what the code tells them to do and errors (with cryptic or verbose messages) get triggered when a condition occurs. There is nothing weird or magical about what code does or when errors get triggered, its all predictable because it is all based on what the logic in the code says to do.

[masterofollies]

Well I am sorry you don't like me calling it "weird". To me it's in a language I can't understand.

Perhaps I have too many fields in my users table. I have at least 150 fields in it.

[guelphdad]

too many columns won't give you an error. you should though consider your database design and make sure it is properly normalized.

[flyco]

I think this is the best not to have too many columns, as this may give you a wrong, if your simple so many problems will be less.
ipod movies (http://www.pqdvd.com/dvd-to-ipod-movie-video-converter.html)
ipod movies (http://www.pqdvd.com)