Fatal Error keeps coming back

[SpookyDan]

A few days ago someone informed me my website www.danhaga.com was not working so I checked it out to find a blank white screen with only the text "Fatal Error :". 

I rebuilt every table in my database and it solved the problem and i found out it was the sessions table.

The next day the problem was back.  Plain white screen & Fatal Error:

I got into mysql and entered REPAIR TABLE cpg149_sessions which fixed it again and upgraded to the latest coppermine version.

Now this morning I have the same error.  I fixed it again but Im sure it will be back.

Any suggestions for fixing this?

Thanks

[SpookyDan]

This happened a few more times yesterday and I fixed it.

Today the gallery kinda shows up but says:

Critical Error

There was an error while processing a database query

(screenshot attached)

[SpookyDan]

Oh and running "REPAIR TABLE cpg149_sessions" does not fix this one.

On a side note I have other coppermine installations sepparate on my domain and they are running fine.

[Nibbler]

Enable debug mode and see what the problem is.

http://coppermine-gallery.net/tutorial/debug_mode.php

[SpookyDan]

Ive attached a screenshot of the error message.  You can also go to www.danhaga.com and see it for yourself.

__________________________

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

• => 633
              [1] => 634
              [2] => 73
              [3] => 72
              [4] => 9358
          )
  
  )
  
  ==========================
  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 cpg149_filetypes; (0.001s)
      [1] => select * from cpg149_plugins order by priority asc; (0.001s)
      [2] => delete from `gallery`.cpg149_sessions where time<1219162261 and remember=0; (0.005s)
      [3] => delete from `gallery`.cpg149_sessions where time<1217956261; (0.002s)
      [4] => select user_id from `gallery`.cpg149_sessions where session_id = '5a8a7feea338995d47b3977e4ec26a33' (0.001s)
      [5] => select user_id as id, user_password as password from `gallery`.cpg149_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.user_group+100 AS group_id FROM `gallery`.cpg149_users AS u INNER JOIN `gallery`.cpg149_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
      [7] => SELECT user_group_list FROM `gallery`.cpg149_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
      [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 cpg149_usergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpg149_usergroups WHERE group_id= 1 (0.001s)
      [10] => update `gallery`.cpg149_sessions set time='1219165861' where session_id = '5a8a7feea338995d47b3977e4ec26a33' (0.001s)
      [11] => SELECT user_favpics FROM cpg149_favpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM cpg149_banned WHERE expiry < '2008-08-19 17:11:02' (0.001s)
      [13] => SELECT * FROM cpg149_banned WHERE (ip_addr='66.93.57.170' OR ip_addr='66.93.57.170' OR user_id=1) AND brute_force=0 (0.001s)
      [14] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = ''  ORDER BY pos (0.001s)
      [15] => SELECT aid FROM cpg149_albums as a WHERE category>=10000 (0.001s)
      [16] => SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
      [17] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = '1'  ORDER BY pos (0.002s)
      [18] => SELECT aid FROM cpg149_albums as a WHERE category = '0' (0.001s)
      [19] => SELECT count(*) FROM cpg149_albums as a WHERE 1 (0.001s)
      [20] => SELECT count(*) FROM cpg149_pictures as p LEFT JOIN cpg149_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
      [21] => SELECT count(*) FROM cpg149_comments as c LEFT JOIN cpg149_pictures as p ON c.pid=p.pid LEFT JOIN cpg149_albums as a ON a.aid=p.aid WHERE 1 (0.003s)
      [22] => SELECT COUNT(*) FROM cpg149_pictures WHERE approved = 'NO' (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.11 - OK
  ------------------
  mySQL version: 4.1.14
  ------------------
  Coppermine version: 1.4.19(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  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.49
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE no value
  MYSQL_LIBS no value
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
  sql.safe_mode | Off | Off
  disable_functions | leak, symlink | leak, symlink
  file_uploads | On | On
  include_path | .:/include:/usr/lib/php | .:/include:/usr/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 | 90 | 90
  max_input_time | -1 | -1
  upload_max_filesize | 50M | 50M
  post_max_size | 50M | 50M
  ==========================
  Page generated in 0.131 seconds - 23 queries in 0.03 seconds - Album set : ; Meta set: ;

[Nibbler]

If running a repair doesn't help then you need to contact your host for support.

[SpookyDan]

Ive emailed tech support with my problems...

In the meantime i repaired the pictures table (see attachment for mysql messages)

Than I got a fatal error mentioning config file (see attached)

I repaired config than got a fatal error mentioning sessions table again (see attached)

I repaired sessions and the site is working again but for how long...

[Joachim Müller]

As Nibbler suggested: ask your webhost for support: one (ore more) database tables constantly crashing and needing repair is not related to coppermine, but an indication of something fishy on the webserver's end where the database runs on. Only your webhost can fix this for you. No need to go through all the effort and post debug_output and a lot of screenshots. Don't ask the mailman to get a new pair of shoes if he constantly falls down the stairs leading to your house. Instead: fix the stairs - they must be broken.