Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: {Urgent} My Site is down (Fatal Error)  (Read 2526 times)

0 Members and 1 Guest are viewing this topic.

Shaitaan

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
[Solved]: {Urgent} My Site is down (Fatal Error)
« on: July 30, 2009, 06:47:32 am »

dear admins:

yesterday i have uploaded few pictures to my album the site was up and running. today in the morning i wanted to add some more pictures the site index page is giving me error as "Fatal error:" no further error is showing.

can you pls. help me its really urgent.

my site is : www.ismailigallery.com

waiting for ur response.

« Last Edit: July 30, 2009, 08:26:13 am by Joachim Müller »
Logged

Shaitaan

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: {Urgent} My Site is down (Fatal Error)
« Reply #1 on: July 30, 2009, 07:02:00 am »

as per the searching to forum i have enabled my script to debug mode now the error is:

Quote
While executing query "delete from `music_gallery`.cpg_sessions where time<1248926411 and remember=0;" on Resource id #5

mySQL error: Table './music_gallery/cpg_sessions' is marked as crashed and should be repaired

now can you pls. tell me how to repair it and over come the problem.
Logged

Shaitaan

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
Re: {Urgent} My Site is down (Fatal Error)
« Reply #2 on: July 30, 2009, 07:05:42 am »

i took the risk and repaired my table via phpadmin now its up and running now... in debug mode i m having following codes how to over come that...


Quote
USER:
------------------
Array
(
    [ID] => 624462f6c8692252baeefdda6368e4e0
    [am] => 1
    [lang] => english
)

==========================
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] => 3
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 3
    [ufc_min] => 3
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg_filetypes; (0s)
  • [1] => select * from cpg_plugins order by priority asc; (0s)
        [2] => delete from `music_gallery`.cpg_sessions where time<1248926600 and remember=0; (0s)
        [3] => delete from `music_gallery`.cpg_sessions where time<1247720600; (0s)
        [4] => SELECT session_id FROM `music_gallery`.cpg_sessions WHERE session_id = '953be42382375ede64d2ff5ca0d711b0' (0s)
        [5] => insert into `music_gallery`.cpg_sessions (session_id, user_id, time, remember) values ("953be42382375ede64d2ff5ca0d711b0", 0, "1248930200", 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 cpg_usergroups WHERE group_id in (3) (0s)
        [7] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 3 (0s)
        [8] => update `music_gallery`.cpg_sessions set time='1248930200' where session_id = '953be42382375ede64d2ff5ca0d711b0' (0s)
        [9] => DELETE FROM cpg_banned WHERE expiry < '2009-07-30 10:03:20' (0s)
        [10] => SELECT * FROM cpg_banned WHERE (ip_addr='203.101.171.10' OR ip_addr='10.255.249.248' OR user_id=0) AND brute_force=0 (0s)
        [11] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
        [12] => SELECT aid FROM cpg_albums (0s)
        [13] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = ''  ORDER BY pos (0s)
        [14] => SELECT aid FROM cpg_albums WHERE category = 2 (0s)
        [15] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
        [16] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '2'  ORDER BY pos (0s)
        [17] => SELECT aid FROM cpg_albums WHERE category = 11 (0s)
        [18] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 11 (0s)
        [19] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '11'  ORDER BY pos (0s)
        [20] => SELECT aid FROM cpg_albums WHERE category = 3 (0s)
        [21] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
        [22] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '3'  ORDER BY pos (0s)
        [23] => SELECT aid FROM cpg_albums WHERE category = 4 (0s)
        [24] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0s)
        [25] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '4'  ORDER BY pos (0s)
        [26] => SELECT aid FROM cpg_albums WHERE category = 7 (0.001s)
        [27] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
        [28] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '7'  ORDER BY pos (0s)
        [29] => SELECT aid FROM cpg_albums WHERE category = 9 (0s)
        [30] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 9 (0s)
        [31] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '9'  ORDER BY pos (0s)
        [32] => SELECT aid FROM cpg_albums WHERE category = 8 (0s)
        [33] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
        [34] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '8'  ORDER BY pos (0s)
        [35] => SELECT aid FROM cpg_albums WHERE category = 10 (0s)
        [36] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
        [37] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '10'  ORDER BY pos (0s)
        [38] => SELECT aid FROM cpg_albums WHERE category = 5 (0s)
        [39] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0s)
        [40] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '5'  ORDER BY pos (0s)
        [41] => SELECT aid FROM cpg_albums WHERE category = 6 (0s)
        [42] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
        [43] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '6'  ORDER BY pos (0s)
        [44] => SELECT aid FROM cpg_albums as a WHERE category>=10000 (0s)
        [45] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
        [46] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1'  ORDER BY pos (0s)
        [47] => SELECT aid FROM cpg_albums as a WHERE category = '0' (0s)
        [48] => SELECT count(*) FROM cpg_albums as a WHERE 1 (0s)
        [49] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
        [50] => SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 (0s)
        [51] => SELECT count(*) FROM cpg_categories WHERE 1 (0s)
        [52] => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1 (0.001s)
        [53] => SELECT count(*) FROM cpg_albums as a WHERE category = '0' (0s)
        [54] => SELECT * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40)  ORDER BY RAND() LIMIT 8 (0.014s)
        [55] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40)  (0.001s)
        [56] => SELECT * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40)  ORDER BY pid DESC  LIMIT 0 ,8 (0.006s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
    )

    ==========================
    Page generated in 0.066 seconds - 57 queries in 0.023 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40) ;
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: {Urgent} My Site is down (Fatal Error)
« Reply #3 on: July 30, 2009, 07:09:43 am »

desable debug mode
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 19 queries.