My site is down - Critical error

[CD69]

I'm have problems hitting my db.

Here is the error output

With debug off

Critical error
There was an error while processing a database query 

Debug on

Critical error

There was an error while processing a database query.


While executing query "SELECT sum(hits) FROM cpg11d_pictures as p LEFT JOIN cpg11d_albums as a ON p.aid=a.aid WHERE 1" on 0

mySQL error: Got error 127 from table handler

File: /home/www/XYZ/cpg143h/include/functions.inc.php - Line: 248

The balance of the information

USER:
------------------
Array
(
    [ID] => 020e64a4db252ce5d602b4057dbc306e
    [am] => 1
    [lang] => english
    [liv] => Array
        (
           

• => 858
              [1] => 1341
              [2] => 1335
              [3] => 1328
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 0
      [user_name] => Guest
      [groups] => Array
          (
             
• => 3
          )
  
      [group_quota] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 0
      [can_post_comments] => 0
      [can_upload_pictures] => 0
      [can_create_albums] => 0
      [pub_upl_need_approval] => 1
      [priv_upl_need_approval] => 1
      [upload_form_config] => 1
      [num_file_upload] => 5
      [num_URI_upload] => 0
      [custom_user_upload] => 0
      [disk_max] => 0
      [disk_min] => 0
      [ufc_max] => 1
      [ufc_min] => 1
      [has_admin_access] => 0
      [group_name] => Guests
      [can_see_all_albums] => 0
      [group_id] => 3
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0.001s)
      [1] => select * from cpg11d_plugins order by priority asc; (0.001s)
      [2] => delete from `fishinpics`.cpg11d_sessions where time<1158711489 and remember=0; (0.001s)
      [3] => delete from `fishinpics`.cpg11d_sessions where time<1157505489; (0s)
      [4] => select user_id from `fishinpics`.cpg11d_sessions where session_id=md5("284e74d154a2f54a3d7a4103c93a3d1086cc2e26ea7cf94124ec0a6343a09d44"); (0.001s)
      [5] => select user_id as id, user_password as password from `fishinpics`.cpg11d_users where user_id=0 (0s)
      [6] => 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 cpg11d_usergroups WHERE group_id in (3) (0.001s)
      [7] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 3 (0s)
      [8] => update `fishinpics`.cpg11d_sessions set time='1158715089' where session_id=md5('284e74d154a2f54a3d7a4103c93a3d1086cc2e26ea7cf94124ec0a6343a09d44'); (0.001s)
      [9] => DELETE FROM cpg11d_banned WHERE expiry < '2006-09-19 19:18:10' (0s)
      [10] => SELECT * FROM cpg11d_banned WHERE (ip_addr='68.78.142.185' OR ip_addr='68.78.142.185' OR user_id=0) AND brute_force=0 (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [referer] => logout.php?referer=index.php
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 0.221 seconds - 11 queries in 0.006 seconds - Album set : ; Meta set: ;

Any help would be appreciated.

[kegobeer]

Error 127 means your cpg11d_pictures table is corrupted.  Use a tool like phpMyAdmin to repair the table:

REPAIR TABLE cpg11d_pictures

[CD69]

Thanks,

Now I'm getting another error

While executing query "DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE" on 0

mySQL error: You have an error in your SQL syntax near '' at line 1

USER:
------------------
Array
(
    [ID] => 020e64a4db252ce5d602b4057dbc306e
    [am] => 1
    [lang] => english
    [liv] => Array
        (
           

• => 858
              [1] => 1341
              [2] => 1335
              [3] => 1328
              [4] => 7111
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => Mike
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 100000
      [disk_min] => 100000
      [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] => 4
      [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] => 100000
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0.001s)
      [1] => select * from cpg11d_plugins order by priority asc; (0.001s)
      [2] => delete from `fishinpics`.cpg11d_sessions where time<1158718401 and remember=0; (0.03s)
      [3] => delete from `fishinpics`.cpg11d_sessions where time<1157512401; (0s)
      [4] => select user_id from `fishinpics`.cpg11d_sessions where session_id=md5("284e74d154a2f54a3d7a4103c93a3d1086cc2e26ea7cf94124ec0a6343a09d44"); (0.001s)
      [5] => select user_id as id, user_password as password from `fishinpics`.cpg11d_users where user_id=1 (0.001s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `fishinpics`.cpg11d_users AS u INNER JOIN `fishinpics`.cpg11d_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
      [7] => SELECT user_group_list FROM `fishinpics`.cpg11d_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 cpg11d_usergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 1 (0s)
      [10] => update `fishinpics`.cpg11d_sessions set time='1158722001' where session_id=md5('284e74d154a2f54a3d7a4103c93a3d1086cc2e26ea7cf94124ec0a6343a09d44'); (0.001s)
      [11] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 1 (0.054s)
      [12] => DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE (0s)
      [13] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0.014s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.4 - OK
  ------------------
  mySQL version: 3.23.58
  ------------------
  Coppermine version: 1.4.9(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support:
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.58
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/local/mysql/include
  MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.3
  Linked Version 1.1.4
  ==========================
  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/local/lib/php | .:/usr/local/lib/php
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  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 | -1 | -1
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.242 seconds - 14 queries in 0.105 seconds - Album set : ; Meta set: ;

[Sami]

You've installed onlinestats plugin ,
Check your config table (cpg11d_config in your case) and look for mod_updates_duration under that it should be there and it should has a 10 (or something simillar) as a value, if you can't find it add it manualy with phpmyadmin

[Joachim Müller]

Please don't post debug_output (this is what you called "The balance of the information") unless requested, it only clutters the thread.

mySQL error: Got error 127 from table handler

http://forum.coppermine-gallery.net/index.php?topic=29290.0
http://forum.coppermine-gallery.net/index.php?topic=33147.msg154632#msg154632
http://forum.coppermine-gallery.net/index.php?topic=34561.0
http://forum.coppermine-gallery.net/index.php?topic=23411.0

While executing query "DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE" on 0

Related to a mod/plugin you're using. There's no mod support outside of mod threads. Disable the mod if it doesn't work for you. Please respect the "one issue per thread" policy in the future.

Edit: Sami beat me to it, he answered while I was typing my reply. Posting anyway.

[CD69]

My apologizies GauGau, I always attempt to follow guidelines.

Sami,

Thank you.