MySQL-Error

Hello,

from time to time, i get a MySQL error message if i try to start my homepage.

One of these messages is for example:

1030 - Got error -1 from storage engine SQL=SELECT a.* FROM `joo_comprofiler_plugin_activity` AS a LEFT JOIN `joo_comprofiler_plugin_activity_hidden` AS b ON b.`type` = 'activity' AND b.`item` = a.`id` AND b.`user_id` = 836 LEFT JOIN `joo_comprofiler` AS c ON c.`id` = a.`user_id` LEFT JOIN `joo_users` AS d ON d.`id` = c.`id` LEFT JOIN `joo_comprofiler_plugin_activity` AS f ON ( ( f.`type` = 'activity' AND f.`item` = a.`id` ) OR ( f.`type` = 'activity' AND a.`type` = 'activity' AND f.`item` = a.`item` ) ) AND f.`id` NOT IN (SELECT `item` FROM `joo_comprofiler_plugin_activity_hidden` WHERE `type` = 'activity' AND `item` = f.`id` AND `user_id` = 836) AND f.`date` > a.`date` LEFT JOIN `joo_groupjive_plugin_events` AS gj_e ON a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND a.`item` = gj_e.`id` LEFT JOIN `joo_groupjive_plugin_file` AS gj_f ON a.`type` = 'groupjive' AND a.`subtype` = 'group.file' AND a.`item` = gj_f.`id` LEFT JOIN `joo_groupjive_plugin_photo` AS gj_p ON a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND a.`item` = gj_p.`id` LEFT JOIN `joo_groupjive_plugin_video` AS gj_v ON a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND a.`item` = gj_v.`id` LEFT JOIN `joo_groupjive_plugin_wall` AS gj_w ON a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND a.`item` = gj_w.`id` LEFT JOIN `joo_groupjive_groups` AS gj_g ON a.`type` = 'groupjive' AND ( ( a.`subtype` = 'group' AND a.`item` = gj_g.`id` ) OR ( a.`subtype` != 'group' AND a.`parent` = gj_g.`id` ) ) WHERE b.`id` IS NULL AND f.`id` IS NULL AND c.`approved` = 1 AND c.`confirmed` = 1 AND d.`block` = 0 AND ( ( a.`type` = 'groupjive' AND a.`subtype` = 'group.event' AND gj_e.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' OR ( a.`type` = 'groupjive' AND a.`subtype` != 'group.event' ) ) ) AND ( ( a.`type` = 'groupjive' AND a.`subtype` = 'group.file' AND gj_f.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' OR ( a.`type` = 'groupjive' AND a.`subtype` != 'group.file' ) ) ) AND ( ( a.`type` = 'groupjive' AND a.`subtype` = 'group.photo' AND gj_p.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' OR ( a.`type` = 'groupjive' AND a.`subtype` != 'group.photo' ) ) ) AND ( ( a.`type` = 'groupjive' AND a.`subtype` = 'group.video' AND gj_v.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' OR ( a.`type` = 'groupjive' AND a.`subtype` != 'group.video' ) ) ) AND ( ( a.`type` = 'groupjive' AND a.`subtype` = 'group.wall' AND gj_w.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' OR ( a.`type` = 'groupjive' AND a.`subtype` != 'group.wall' ) ) ) AND ( ( a.`type` = 'groupjive' AND gj_g.`id` IS NOT NULL ) OR ( a.`type` != 'groupjive' ) ) ORDER BY a.`date` DESC LIMIT 0, 10

How can i fix these errors?


Greetings
Joerg

Or this:

126 - Incorrect key file for table '/tmp/mysqltmp/#sql_7a429_2.MYI'; try to repair it SQL=SELECT DISTINCT m.*,u.name,u.email,u.username,c.avatar,c.avatarapproved, u.id, IF(s.session_id=null,0,1) AS 'isOnline' FROM joo_comprofiler_members AS m LEFT JOIN joo_comprofiler AS c ON m.referenceid=c.id LEFT JOIN joo_users AS u ON m.referenceid=u.id LEFT JOIN joo_session AS s ON s.userid=u.id WHERE m.memberid=968 AND m.pending=0 AND c.approved=1 AND c.confirmed=1 AND c.banned=0 AND u.block=0 LIMIT 0, 200

Contact your host as it looks like your MYSQL /tmp folder is full.

Hello,

the /tmp-folder exist but it is empty.


Joerg

That's your Joomla /tmp folder and has nothing to do with PHP or MYSQL. You need to contact your host regarding this. Once done go through the following and ensure you've latest nightly releases of any plugins installed.

www.joomlapolis.com/cb-20-addon-status

Hello,

i get access to the \tmp folder you wrote about.
This folder contains 3 orders with a few little files.

The \tmp error message still appears afters every 3th page visit and the problem is therefore not solved....

I receive still messages like this:

126 - Incorrect key file for table '/tmp/mysqltmp/#sql_b6efe_1.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROM `joo_content`




Joerg