Coppermine critical error

[Infernal]

Ok hello and thanks for giving me some of your time
I am a huge fan of coppermine...i love it it always worked for me well except now

Error link gallery is the coppermine folder
http://www.add-fun.com/gallery/index.php

error message

There was an error while processing a database query.



File:
gallery/include/functions.inc.php - Line: 249



COde from debug mode unde the error message

<code>
While executing query "SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_2115_0.MYI'; try to repair it
</code>


Long debug code that we should post on problems

<code>
USER:
------------------
Array
(
    [ID] => 34536684a31d982b98c63011f720faba
    [am] => 1
    [lang] => english
    [search] => Array
        (
            [search] => c
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => -Censored-
    [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 cpg1411_filetypes; (0s)
      [1] => select * from cpg1411_plugins order by priority asc; (0s)
      [2] => delete from `addghe2_addict54`.cpg1411_sessions where time<1194935387 and remember=0; (0s)
      [3] => delete from `addghe2_addict54`.cpg1411_sessions where time<1193729387; (0s)
      [4] => select user_id from `addghe2_addict54`.cpg1411_sessions where session_id=md5("604549c91c7f22765ec29cb19f78fd0b8c5ee5140b5012d51f6c8aa3f193f5b2"); (0s)
      [5] => select user_id as id, user_password as password from `addghe2_addict54`.cpg1411_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `addghe2_addict54`.cpg1411_users AS u INNER JOIN `addghe2_addict54`.cpg1411_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `addghe2_addict54`.cpg1411_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => 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 cpg1411_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  cpg1411_usergroups WHERE group_id= 1 (0s)
      [10] => update `addghe2_addict54`.cpg1411_sessions set time='1194938987' where session_id=md5('604549c91c7f22765ec29cb19f78fd0b8c5ee5140b5012d51f6c8aa3f193f5b2'); (0s)
      [11] => SELECT user_favpics FROM cpg1411_favpics WHERE user_id = 1 (0.002s)
      [12] => DELETE FROM cpg1411_banned WHERE expiry < '2007-11-13 07:29:47' (0.001s)
      [13] => SELECT * FROM cpg1411_banned WHERE (ip_addr='82.77.137.33' OR ip_addr='82.77.137.33' OR user_id=1) AND brute_force=0 (0s)
      [14] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '0'  ORDER BY pos (0s)
      [15] => SELECT aid FROM cpg1411_albums as a WHERE category>=10000 (0s)
      [16] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
      [17] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '1'  ORDER BY pos (0s)
      [18] => SELECT aid FROM cpg1411_albums as a WHERE category = '0' (0s)
      [19] => SELECT count(*) FROM cpg1411_albums as a WHERE 1 (0s)
      [20] => SELECT count(*) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.01s)
      [21] => SELECT count(*) FROM cpg1411_comments as c LEFT JOIN cpg1411_pictures as p ON c.pid=p.pid LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
      [22] => SELECT count(*) FROM cpg1411_categories WHERE 1 (0s)
      [23] => SELECT sum(hits) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON p.aid=a.aid WHERE 1 (0.022s)
      [24] => SELECT COUNT(*) FROM cpg1411_pictures WHERE approved = 'NO' (0.005s)
      [25] => SELECT count(*) FROM cpg1411_albums as a WHERE category = '0' (0s)
      [26] => SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg1411_albums as a LEFT JOIN cpg1411_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,1 (0s)
      [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 cpg1411_albums AS a  LEFT JOIN cpg1411_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (1)GROUP BY a.aid (0.021s)
      [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1411_pictures WHERE pid='12960' (0s)
      [29] => SELECT COUNT(*) from cpg1411_pictures WHERE approved = 'YES'  (0.005s)
      [30] => SELECT * FROM cpg1411_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12 (0.143s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [cat] => 0
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.2.3 - OK
  ------------------
  mySQL version: 5.0.27-standard
  ------------------
  Coppermine version: 1.4.12(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.34 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: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.27
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.1.2
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  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 | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
  open_basedir | no value | 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 | 8M | 8M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.28 seconds - 31 queries in 0.21 seconds - Album set : ; Meta set: ;
  
  </code>
  
  
  
  
  Hope you can help
  Thanks and have a good day
  

[François Keller]

Hi

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

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

repair your cpg1411_pictures via phpmyadmin or similar toll

[Infernal]

i tryed using my cpanel repair from the sql area and it just tells me everything is ok and i still get the error
i even deleted the extra aid as i found of the forums
sadly for myself i can't seem to find a phpmyadmin repair option

[Joachim Müller]

Using phpMyAdmin: in the left frame, click on the database name or select the database from the dropdown (if you have multiple databases available). In the main frame of phpMyAdmin, you should now see an overview page of all tables that reside within the database you previously selected. Tick (select) the table(s) that are reported to be crashed (cpg1411_pictures in your case). Scroll down to the bottom of the page and pick from the dropdown list that is labelled "with selected" the command "repair table".
If you can't do that, ask your webhsot for support.
This is not related to coppermine, but mysql database management. Repairing a crashed database table has been discussed frequently on this forum (you should have performed a search before posting). Also please don't post debug_output in the future unless a supporter explicitely asks for it.

[Infernal]

.cpg1411_albums                    OK
.cpg1411_banned                    OK
.cpg1411_bridge                    OK
.cpg1411_categories                OK
.cpg1411_comments                  OK
.cpg1411_config                    OK
.cpg1411_dict                      OK
.cpg1411_ecards                    OK
.cpg1411_exif                      OK
.cpg1411_favpics                   OK
.cpg1411_filetypes                 OK
.cpg1411_hit_stats                 OK
.cpg1411_pictures                  OK
.cpg1411_plugins                   OK
.cpg1411_sessions                  OK
.cpg1411_temp_data                 OK
.cpg1411_usergroups                OK
.cpg1411_users                     OK
.cpg1411_vote_stats                OK
.cpg1411_votes                     OK
I always get this that all databases are ok
please some more help

[Infernal]

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

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

did so and now i just get another error

i messaged my hosting they told me to ask the providers


thank you for the help

[Joachim Müller]

i messaged my hosting they told me to ask the providers

They told you what? They told you to ask the developers of the application ? Are you sure? If the webhost sees such a message and says that it's the application's fault then I strongly suggest looking for another webhost?

did so and now i just get another error

The fatal error you get is just that: it is fatal, that's why the script halts and doesn't do anything else but displaying the error message - the script dies. If you then perform the repair, it's very likely that you will see other fatal error messages about other tables that are crashed as well. That's possible because coppermine didn't even attempt to run queries against those other tables before - the first fatal error makes the script grind to a halt. Repair the other broken tables the same way you repaired the first table.

It's even possible that the tables are crashed beyond repair. In this case, you'll have to use your backup (if you have one).

[Nibbler]

It's not the pictures table that is broken - read the message. The table that is broken is the temporary table created by mysql while running the query. Only your webhost can address this; my guess would be lack of space on /tmp. Disable the random meta album in config as a workaround.

[Infernal]

yes it's exactly what nibbler posted
i read up a lot more on this
my database is all fine and i read about everything bout coppermine databases you have on the forum
mine works perfectly but this temp table is not done because of space

my host is midphase which promises me 99999 databases so i will raise hell if they do not fix this very soon
i will try and take out random


thanks a lot for the help...i will post the outcome of this