Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Fatal Error keeps coming back  (Read 2548 times)

0 Members and 1 Guest are viewing this topic.

SpookyDan

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Fatal Error keeps coming back
« on: August 18, 2008, 02:11:31 pm »

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
Logged

SpookyDan

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Fatal Error keeps coming back
« Reply #1 on: August 19, 2008, 06:45:31 pm »

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)
Logged

SpookyDan

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Fatal Error keeps coming back
« Reply #2 on: August 19, 2008, 06:48:35 pm »

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.
Logged

Nibbler

  • Guest
Re: Fatal Error keeps coming back
« Reply #3 on: August 19, 2008, 07:01:35 pm »

Enable debug mode and see what the problem is.

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

SpookyDan

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Fatal Error keeps coming back
« Reply #4 on: August 19, 2008, 07:14:46 pm »

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: ;
Logged

Nibbler

  • Guest
Re: Fatal Error keeps coming back
« Reply #5 on: August 19, 2008, 07:33:21 pm »

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

SpookyDan

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: Fatal Error keeps coming back
« Reply #6 on: August 19, 2008, 09:11:04 pm »

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...


Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Fatal Error keeps coming back
« Reply #7 on: August 23, 2008, 08:26:45 am »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.