By WoozyDuck on

Hi all,

I have got the following error message when I have deleted some revisions!!!
I am not able to do anything with my web site, even the back-end is affected by this error.

user warning: Can't create/write to file '/tmp/#sql_3cb4_0.MYI' (Errcode: 122) query: SELECT DISTINCT b.* FROM ugc_blocks b LEFT JOIN ugc_blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /var/www/vhosts/mywebsite.com/httpdocs/includes/database.mysql.inc on line 172.

What is this message for?
and how can I fix it?

Many thanks

⋅ Categories: Drupal 5.x

Comments

WoozyDuck’s picture

WoozyDuck commented

OK I have found the problem.

It was lack pf space on our server, due to incorrect setting of limits, it was not enough space for Drupal, so I have changed the limits and increase it and it is working good now.

Just wanted to let other users know if they face the same issue.

Best.

innerfile.com’s picture

innerfile.com commented

I had the same problem on a VPS (it manifested itself in Drupal this way, but caused other problems for my mail server) and the problem was with limits on the number of inodes. I increased the limit and the problem went away.