Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetret

[fantic]

Hallo!
Nachdem ich heute ein neues Album veröffentlicht habe ist plötzlich die nachstehende Fehlermeldung aufgetreten. Ein Update von 1.4.19 auf 1.4.20 hat keine Änderung bewirkt. Der Fehler tritt hauptsächlich beim Aufrufen der Alben auf. Sämtliche Bilder sind noch vorhanden. Themenwechsel hat ebenfalls keine Auswirkung auf die Fehlermeldung.
Wer weiß Rat?
Danke

_______

While executing query "SELECT * FROM cpg135_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 3" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_963_0.MYI'; try to repair it

------
USER:
------------------
Array
(
    [ID] => f9c893774fbdea77d404743f85a0ad7d
    [am] => 1
    [lang] => german
    [liv] => Array
        (
           

• => 7015
              [1] => 7013
              [2] => 7014
              [3] => 2710
              [4] => 4616
          )
  
      [search] => Array
          (
              [search] => berg
              [album] => search
              [title] => on
              [newer_than] =>
              [caption] => on
              [older_than] =>
              [keywords] => on
              [type] => AND
              [filename] => on
              [params] => Array
                  (
                      [title] => on
                      [caption] => on
                      [keywords] => on
                      [filename] => on
                  )
  
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => *****
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg135_filetypes; (0.001s)
      [1] => delete from `pn762`.cpg135_sessions where time<1235163335 and remember=0; (0.001s)
      [2] => delete from `pn762`.cpg135_sessions where time<1233957335; (0.001s)
      [3] => select user_id from `pn762`.cpg135_sessions where session_id = 'f2702b35b8df28c2b461d0f2f03b6e4b' (0.001s)
      [4] => select user_id as id, user_password as password from `pn762`.cpg135_users where user_id=1 (0.001s)
      [5] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `pn762`.cpg135_users AS u INNER JOIN `pn762`.cpg135_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
      [6] => SELECT user_group_list FROM `pn762`.cpg135_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
      [7] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg135_usergroups WHERE group_id in (1) (0.001s)
      [8] => SELECT group_name FROM  cpg135_usergroups WHERE group_id= 1 (0s)
      [9] => update `pn762`.cpg135_sessions set time='1235166935' where session_id = 'f2702b35b8df28c2b461d0f2f03b6e4b' (0.001s)
      [10] => SELECT user_favpics FROM cpg135_favpics WHERE user_id = 1 (0.001s)
      [11] => DELETE FROM cpg135_banned WHERE expiry < '2009-02-20 21:55:35' (0s)
      [12] => SELECT * FROM cpg135_banned WHERE (ip_addr='80.122.154.75' OR ip_addr='80.122.154.75' OR user_id=1) AND brute_force=0 (0s)
      [13] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = ''  ORDER BY pos (0.001s)
      [14] => SELECT aid FROM cpg135_albums WHERE category = 11 (0s)
      [15] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 11 (0s)
      [16] => SELECT count(*) FROM cpg135_albums as a WHERE category = '11' (0s)
      [17] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,6 (0.001s)
      [18] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (243, 242, 241, 240, 239, 238)GROUP BY a.aid (0.001s)
      [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='7019' (0s)
      [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='7001' (0s)
      [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6962' (0.001s)
      [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6950' (0s)
      [23] => SELECT aid FROM cpg135_albums WHERE category = 9 (0.001s)
      [24] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0.001s)
      [25] => SELECT count(*) FROM cpg135_albums as a WHERE category = '9' (0s)
      [26] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,9 (0.001s)
      [27] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (237, 236, 235, 234, 233, 232, 230, 229, 228)GROUP BY a.aid (0.003s)
      [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6678' (0s)
      [29] => SELECT aid FROM cpg135_albums WHERE category = 8 (0.001s)
      [30] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0.001s)
      [31] => SELECT count(*) FROM cpg135_albums as a WHERE category = '8' (0s)
      [32] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,9 (0.001s)
      [33] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (201, 200, 199, 198, 197, 195, 194, 192, 191)GROUP BY a.aid (0.002s)
      [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5852' (0s)
      [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5781' (0s)
      [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5763' (0s)
      [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5746' (0s)
      [38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5687' (0s)
      [39] => SELECT aid FROM cpg135_albums WHERE category = 6 (0.001s)
      [40] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0.002s)
      [41] => SELECT count(*) FROM cpg135_albums as a WHERE category = '6' (0s)
      [42] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,9 (0.001s)
      [43] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (154, 153, 152, 151, 150, 149, 143, 142, 141)GROUP BY a.aid (0.002s)
      [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='4744' (0s)
      [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='4729' (0s)
      [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='4680' (0s)
      [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='4633' (0s)
      [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='3779' (0s)
      [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='3791' (0s)
      [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='4604' (0s)
      [51] => SELECT aid FROM cpg135_albums WHERE category = 4 (0s)
      [52] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
      [53] => SELECT count(*) FROM cpg135_albums as a WHERE category = '4' (0s)
      [54] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,1 (0s)
      [55] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (146)GROUP BY a.aid (0.001s)
      [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6660' (0s)
      [57] => SELECT aid FROM cpg135_albums WHERE category = 5 (0s)
      [58] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
      [59] => SELECT count(*) FROM cpg135_albums as a WHERE category = '5' (0s)
      [60] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=5 ORDER BY a.pos LIMIT 0,7 (0s)
      [61] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (71, 77, 93, 78, 40, 47, 49)GROUP BY a.aid (0.002s)
      [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6806' (0s)
      [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='2241' (0s)
      [64] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='1046' (0s)
      [65] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='1210' (0s)
      [66] => SELECT aid FROM cpg135_albums WHERE category = 7 (0s)
      [67] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
      [68] => SELECT count(*) FROM cpg135_albums as a WHERE category = '7' (0.001s)
      [69] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,1 (0s)
      [70] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (147)GROUP BY a.aid (0s)
      [71] => SELECT aid FROM cpg135_albums WHERE category = 10 (0s)
      [72] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
      [73] => SELECT count(*) FROM cpg135_albums as a WHERE category = '10' (0s)
      [74] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p ON a.thumb=p.pid WHERE category=10 ORDER BY a.pos LIMIT 0,1 (0s)
      [75] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg135_albums AS a  LEFT JOIN cpg135_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (231)GROUP BY a.aid (0s)
      [76] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='6914' (0s)
      [77] => SELECT aid FROM cpg135_albums as a WHERE category = '0' (0s)
      [78] => SELECT count(*) FROM cpg135_albums as a WHERE 1 (0s)
      [79] => SELECT count(*) FROM cpg135_pictures as p LEFT JOIN cpg135_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.004s)
      [80] => SELECT count(*) FROM cpg135_comments as c LEFT JOIN cpg135_pictures as p ON c.pid=p.pid LEFT JOIN cpg135_albums as a ON a.aid=p.aid WHERE 1 (0s)
      [81] => SELECT count(*) FROM cpg135_categories WHERE 1 (0s)
      [82] => SELECT sum(hits) FROM cpg135_pictures as p LEFT JOIN cpg135_albums as a ON p.aid=a.aid WHERE 1 (0.009s)
      [83] => SELECT COUNT(*) FROM cpg135_pictures WHERE approved = 'NO' (0.002s)
      [84] => SELECT count(*) FROM cpg135_albums as a WHERE category = '0' (0s)
      [85] => SELECT COUNT(*) from cpg135_pictures WHERE approved = 'YES'  (0.002s)
      [86] => SELECT * FROM cpg135_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,6 (0s)
      [87] => SELECT count(*) from cpg135_comments where pid=7019 and msg_id!=0 (0s)
      [88] => SELECT count(*) from cpg135_comments where pid=7018 and msg_id!=0 (0s)
      [89] => SELECT count(*) from cpg135_comments where pid=7017 and msg_id!=0 (0s)
      [90] => SELECT count(*) from cpg135_comments where pid=7016 and msg_id!=0 (0s)
      [91] => SELECT count(*) from cpg135_comments where pid=7015 and msg_id!=0 (0s)
      [92] => SELECT count(*) from cpg135_comments where pid=7014 and msg_id!=0 (0s)
      [93] => SELECT * FROM cpg135_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 3 (0.096s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.1.6 - OK
  ------------------
  mySQL version: 5.0.22
  ------------------
  Coppermine version: 1.4.20(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XPM Support:
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | On
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .: | .:
  open_basedir | /var/www/vhosts/vplunz.at/httpdocs:/tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.334 seconds - 94 queries in 0.148 seconds - Album set : ; Meta set: ;

[Αndré]

mySQL error: Incorrect key file for table '/tmp/#sql_963_0.MYI'; try to repair it

Deine Datenbank ist beschädigt. Versuch sie mit phpMyAdmin/etc. zu reparieren.

[fantic]

Datenbank bereits mit phpmyadmin überprüft, ich finde keine Fehler. Gibt es einen Hinweis, in welcher Tabelle der Fehler liegt, ev. Tmp? http://www.vplunz.at/cpg135

[Αndré]

Sorry, aber mehr kann ich dazu nicht sagen.

[Joachim Müller]

Frage Deinen Webhoster.

[fantic]

Gelöst!
Nachdem ich übers Wochenende nochmals die Datenbank bei mir lokal aufgespielt habe und dabei die Galerie ohne Fehler gelaufen ist, wurde der Server heute genauer ins Visier genommen. Freier Webspace 1,8 MB war wohl zu wenig um tmp Dateien ablegen zu können und nachdem wieder Speicherplatz geschaffen worden ist, war auch der Fehler weg. So einfach kann eine Problemlösung sein. Herzlichen Dank für eure Unterstützung.