Database error

Hi guys need some help as I'm getting this and the site and admin will not load just get

Help I have asked my server comp and thy said:

well, the issue is that the mysql query is using too much memory

you need to optimize your code and query to bring down the memory usage

Database error in ~~~~~~~~~

Query:

SELECT DISTINCT `Key` FROM `sys_pre_values`

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

Found error in the file '/home/~~~~~~~~/public_html/inc/prof.inc.php' at line 31.
Called 'fromCache' function with erroneous argument #2.


Debug backtrace:

Hello I can suggest to you only these two ways:

1. Remove some part of your modules, leave only really needed

2. Or try to increase some parameters of your site. Read full description about speed optimization here: http://www.boonex.com/trac/dolphin/wiki/HostingServerSetupRecommendations

Just a thought.. SInce the MySQL error is:

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

What is the permission level for the /tmp directory? Make sure it's 755 at least.

 Hi yes it is on 775.

775, or 755? It should be 755.

 sorry yes it is 755.

II would try deleting the contents of the /tmp directory (if there is a .htaccess file, leave it there). Sometimes an error 28 can be caused when there is not enough space available to read/write to the folder.

 Hi thanks for that, all there is in that folder is

default_filter.cache (should I delete this?)   and

htaccess

I believe you are looking at the wrong tmp folder.

The mysql error is referring to the main tmp folder on the linux server. /tmp

Not the tmp folder in your dolphin install. which would be something like /home/~~~~~/public_html/tmp

This has nothing to do with dolphin. It's a server issue.

So check permissions on the main servers /tmp folder, make sure the server has not run out of hard drive space.

I don't believe your host properly diagnosed the problem.

 ok I get you now sorry. yes on my server I have

and it is been used up very fast, its now at 80% used what can I do.

You are still looking in the wrong place. That file you specified. is in /usr/ And i do not know what it is your looking at.

Your original error is in /tmp and it says it cannot write to it.

And 80% of what? If your refering to your hard drive space, then talk to your host. I do not know what you started with for space.

 OK this is the emails I get, where do I look as I have looked in the dolphin and you said no then I looked on the server  /usr/tmpDSK  you say no. please help as I'm lost now. and my server comp are not responding to my tickets.

Database error in ~~~~~~~~~

Query:

SELECT DISTINCT `Key` FROM `sys_pre_values`

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

Found error in the file '/home/~~~~~~~~/public_html/inc/prof.inc.php' at line 31.
Called 'fromCache' function with erroneous argument #2.


Debug backtrace:

Ok i will point it out. Here is your error.

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

I will now highlight the folder name in BOLD.

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

The error says. Can't create/write meaning either the permissions are wrong on the /tmp folder or you are out of hard drive space so it can't create the file.

Mysql error: Can't create/write to file '/tmp/#sql_2da4_0.MYI' (Errcode: 28)

Based on my research Errcode: 28 normally means you do not have enough space left on the hard drive for the MySql server to write its temporary data.

 Thanks as I was looking into the code online thats what its saying but I have 2 hard disk of 40gb one is at 99% and the other one at 5% so I dont see the problem. as i have loads of space.

2 hard drives or 10. Makes little difference if they are separate. (not part of a raid array) and based on your percentage of usage, i would guess the drives are separate.

So for example, if the /tmp folder happens to be on that drive that is 99% full, then that could very well be the problem. So you cannot rule that out.

Check all your server logs. See if your getting out of space errors from other parts of your system.