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 [2]   Go Down

Author Topic: FATAL ERROR - NEED help  (Read 12142 times)

0 Members and 1 Guest are viewing this topic.

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #20 on: February 25, 2008, 10:02:45 pm »

Where exactly I should add this code? I open cpg1410_sessions and that then?
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #21 on: February 25, 2008, 10:09:37 pm »

Now i done it and what i have:

Code: [Select]
USER:
------------------
Array
(
    [ID] => f34088b73f460d1d9b1fc8874e2135dd
    [am] => 1
    [lang] => russian
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 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
(
    [0] => SELECT extension, mime, content, player FROM filetypes; (0.002s)
    [1] => select * from plugins order by priority asc; (0.001s)
    [2] => delete from `eva_longoria_net_ru`.sessions where time<1203970079 and remember=0; (0.005s)
    [3] => delete from `eva_longoria_net_ru`.sessions where time<1202764079; (0.002s)
    [4] => SELECT session_id FROM `eva_longoria_net_ru`.sessions WHERE session_id=MD5('b80eacee33ef42d8a6e2b1397f78c1df21e4eff2cefdd80cc68ee9930f67d78e') (0.001s)
    [5] => insert into `eva_longoria_net_ru`.sessions (session_id, user_id, time, remember) values ("db6842b174d4accfc71ada790f79e322", 0, "1203973679", 0); (0.001s)
    [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 usergroups WHERE group_id in (3) (0.036s)
    [7] => SELECT group_name FROM  usergroups WHERE group_id= 3 (0.002s)
    [8] => update `eva_longoria_net_ru`.sessions set time='1203973679' where session_id=md5('b80eacee33ef42d8a6e2b1397f78c1df21e4eff2cefdd80cc68ee9930f67d78e'); (0s)
    [9] => DELETE FROM banned WHERE expiry < '2008-02-25 21:08:08' (0.021s)
    [10] => SELECT * FROM banned WHERE (ip_addr='77.241.38.15' OR ip_addr='77.241.38.15' OR user_id=0) AND brute_force=0 (0s)
    [11] => SELECT aid FROM albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.002s)
    [12] => SELECT aid FROM albums (0.003s)
    [13] => SELECT cid, name, description, thumb FROM categories WHERE parent = ''  ORDER BY pos (0.016s)
    [14] => SELECT aid FROM albums as a WHERE category>=10000 (0s)
    [15] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.027s)
    [16] => SELECT cid, name, description, thumb FROM categories WHERE parent = '1'  ORDER BY pos (0.008s)
    [17] => SELECT aid FROM albums WHERE category = 6 (0.008s)
    [18] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0.006s)
    [19] => SELECT count(*) FROM albums as a WHERE category = '6' (0.008s)
    [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM albums as a LEFT JOIN pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,12 (0.003s)
    [21] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM albums AS a  LEFT JOIN pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (133, 2, 3, 8, 16, 51, 29, 31, 46, 47, 60, 215)GROUP BY a.aid (0.011s)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='58' (0.002s)
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='813' (0.001s)
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='486' (0.002s)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='739' (0.006s)
    [26] => SELECT cid, name, description, thumb FROM categories WHERE parent = '6'  ORDER BY pos (0.001s)
    [27] => SELECT aid FROM albums WHERE category = 42 (0.004s)
    [28] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 42 (0.001s)
    [29] => SELECT aid FROM albums WHERE category = 43 (0s)
    [30] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 43 (0.002s)
    [31] => SELECT aid FROM albums WHERE category = 7 (0.002s)
    [32] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0.002s)
    [33] => SELECT cid, name, description, thumb FROM categories WHERE parent = '7'  ORDER BY pos (0.002s)
    [34] => SELECT aid FROM albums WHERE category = 40 (0.002s)
    [35] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 40 (0.008s)
    [36] => SELECT aid FROM albums WHERE category = 41 (0.005s)
    [37] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 41 (0.004s)
    [38] => SELECT aid FROM albums WHERE category = 8 (0.007s)
    [39] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0.024s)
    [40] => SELECT cid, name, description, thumb FROM categories WHERE parent = '8'  ORDER BY pos (0.013s)
    [41] => SELECT aid FROM albums WHERE category = 38 (0.003s)
    [42] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 38 (0.005s)
    [43] => SELECT aid FROM albums WHERE category = 39 (0.011s)
    [44] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 39 (0.003s)
    [45] => SELECT aid FROM albums WHERE category = 15 (0.002s)
    [46] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 15 (0.001s)
    [47] => SELECT cid, name, description, thumb FROM categories WHERE parent = '15'  ORDER BY pos (0.028s)
    [48] => SELECT aid FROM albums WHERE category = 16 (0.007s)
    [49] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 16 (0.003s)
    [50] => SELECT aid FROM albums WHERE category = 17 (0.002s)
    [51] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 17 (0.003s)
    [52] => SELECT aid FROM albums WHERE category = 18 (0.002s)
    [53] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 18 (0.007s)
    [54] => SELECT cid, name, description, thumb FROM categories WHERE parent = '18'  ORDER BY pos (0.003s)
    [55] => SELECT aid FROM albums WHERE category = 19 (0.001s)
    [56] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 19 (0.029s)
    [57] => SELECT aid FROM albums WHERE category = 20 (0.003s)
    [58] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 20 (0.001s)
    [59] => SELECT cid, name, description, thumb FROM categories WHERE parent = '20'  ORDER BY pos (0s)
    [60] => SELECT aid FROM albums WHERE category = 21 (0s)
    [61] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 21 (0s)
    [62] => SELECT aid FROM albums WHERE category = 22 (0.001s)
    [63] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 22 (0.003s)
    [64] => SELECT aid FROM albums WHERE category = 2 (0s)
    [65] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.001s)
    [66] => SELECT aid FROM albums WHERE category = 31 (0s)
    [67] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 31 (0s)
    [68] => SELECT aid FROM albums WHERE category = 23 (0s)
    [69] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 23 (0s)
    [70] => SELECT cid, name, description, thumb FROM categories WHERE parent = '23'  ORDER BY pos (0s)
    [71] => SELECT aid FROM albums WHERE category = 28 (0s)
    [72] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 28 (0s)
    [73] => SELECT aid FROM albums WHERE category = 29 (0.001s)
    [74] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 29 (0.001s)
    [75] => SELECT aid FROM albums WHERE category = 37 (0s)
    [76] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 37 (0s)
    [77] => SELECT aid FROM albums WHERE category = 30 (0s)
    [78] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 30 (0s)
    [79] => SELECT aid FROM albums WHERE category = 44 (0s)
    [80] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 44 (0s)
    [81] => SELECT cid, name, description, thumb FROM categories WHERE parent = '44'  ORDER BY pos (0s)
    [82] => SELECT aid FROM albums WHERE category = 45 (0s)
    [83] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 45 (0s)
    [84] => SELECT aid FROM albums WHERE category = 46 (0s)
    [85] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 46 (0s)
    [86] => SELECT aid FROM albums WHERE category = 24 (0s)
    [87] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 24 (0s)
    [88] => SELECT cid, name, description, thumb FROM categories WHERE parent = '24'  ORDER BY pos (0s)
    [89] => SELECT aid FROM albums WHERE category = 25 (0s)
    [90] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 25 (0s)
    [91] => SELECT aid FROM albums WHERE category = 36 (0s)
    [92] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 36 (0s)
    [93] => SELECT aid FROM albums as a WHERE category = '0' (0s)
    [94] => SELECT count(*) FROM albums as a WHERE 1 (0s)
    [95] => SELECT count(*) FROM pictures as p LEFT JOIN albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.013s)
    [96] => SELECT count(*) FROM comments as c LEFT JOIN pictures as p ON c.pid=p.pid LEFT JOIN albums as a ON a.aid=p.aid WHERE 1 (0.004s)
    [97] => SELECT count(*) FROM categories WHERE 1 (0s)
    [98] => SELECT sum(hits) FROM pictures as p LEFT JOIN albums as a ON p.aid=a.aid WHERE 1 (0.018s)
    [99] => SELECT count(*) FROM albums as a WHERE category = '0' (0.001s)
    [100] => SELECT COUNT(*) from pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  (0.015s)
    [101] => SELECT * FROM pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  ORDER BY RAND() LIMIT 8 (0.456s)
    [102] => SELECT COUNT(*) from pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  (0s)
    [103] => SELECT * FROM pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  ORDER BY pid DESC  LIMIT 0 ,8 (0.047s)
)

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

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

==========================
Page generated in 11.407 seconds - 104 queries in 0.926 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329) ;
Logged

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #22 on: February 25, 2008, 10:12:53 pm »

And i have this message in Adminmyphp:

eva_longoria_net_ru.sessions repair warning Number of rows changed from 162 to 127
eva_longoria_net_ru.sessions repair status OK
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: FATAL ERROR - NEED help
« Reply #23 on: February 25, 2008, 10:21:33 pm »

your gallery is working now, so you can desable the debug mode via the config page
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

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #24 on: February 25, 2008, 10:26:09 pm »

Thanks so much to all, you are the best! I delete this message but my friend say me what in my gallery have wrong and Fatal Error can be again, it's true?
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: FATAL ERROR - NEED help
« Reply #25 on: February 25, 2008, 10:48:05 pm »

Quote
I delete this message
wich message ?

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

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #26 on: February 25, 2008, 11:00:09 pm »

This (I disable the debug mode)

Code: [Select]
USER:
------------------
Array
(
    [ID] => f34088b73f460d1d9b1fc8874e2135dd
    [am] => 1
    [lang] => russian
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 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
(
    [0] => SELECT extension, mime, content, player FROM filetypes; (0.002s)
    [1] => select * from plugins order by priority asc; (0.001s)
    [2] => delete from `eva_longoria_net_ru`.sessions where time<1203970079 and remember=0; (0.005s)
    [3] => delete from `eva_longoria_net_ru`.sessions where time<1202764079; (0.002s)
    [4] => SELECT session_id FROM `eva_longoria_net_ru`.sessions WHERE session_id=MD5('b80eacee33ef42d8a6e2b1397f78c1df21e4eff2cefdd80cc68ee9930f67d78e') (0.001s)
    [5] => insert into `eva_longoria_net_ru`.sessions (session_id, user_id, time, remember) values ("db6842b174d4accfc71ada790f79e322", 0, "1203973679", 0); (0.001s)
    [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 usergroups WHERE group_id in (3) (0.036s)
    [7] => SELECT group_name FROM  usergroups WHERE group_id= 3 (0.002s)
    [8] => update `eva_longoria_net_ru`.sessions set time='1203973679' where session_id=md5('b80eacee33ef42d8a6e2b1397f78c1df21e4eff2cefdd80cc68ee9930f67d78e'); (0s)
    [9] => DELETE FROM banned WHERE expiry < '2008-02-25 21:08:08' (0.021s)
    [10] => SELECT * FROM banned WHERE (ip_addr='77.241.38.15' OR ip_addr='77.241.38.15' OR user_id=0) AND brute_force=0 (0s)
    [11] => SELECT aid FROM albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.002s)
    [12] => SELECT aid FROM albums (0.003s)
    [13] => SELECT cid, name, description, thumb FROM categories WHERE parent = ''  ORDER BY pos (0.016s)
    [14] => SELECT aid FROM albums as a WHERE category>=10000 (0s)
    [15] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.027s)
    [16] => SELECT cid, name, description, thumb FROM categories WHERE parent = '1'  ORDER BY pos (0.008s)
    [17] => SELECT aid FROM albums WHERE category = 6 (0.008s)
    [18] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0.006s)
    [19] => SELECT count(*) FROM albums as a WHERE category = '6' (0.008s)
    [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM albums as a LEFT JOIN pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,12 (0.003s)
    [21] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM albums AS a  LEFT JOIN pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (133, 2, 3, 8, 16, 51, 29, 31, 46, 47, 60, 215)GROUP BY a.aid (0.011s)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='58' (0.002s)
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='813' (0.001s)
    [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='486' (0.002s)
    [25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM pictures WHERE pid='739' (0.006s)
    [26] => SELECT cid, name, description, thumb FROM categories WHERE parent = '6'  ORDER BY pos (0.001s)
    [27] => SELECT aid FROM albums WHERE category = 42 (0.004s)
    [28] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 42 (0.001s)
    [29] => SELECT aid FROM albums WHERE category = 43 (0s)
    [30] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 43 (0.002s)
    [31] => SELECT aid FROM albums WHERE category = 7 (0.002s)
    [32] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0.002s)
    [33] => SELECT cid, name, description, thumb FROM categories WHERE parent = '7'  ORDER BY pos (0.002s)
    [34] => SELECT aid FROM albums WHERE category = 40 (0.002s)
    [35] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 40 (0.008s)
    [36] => SELECT aid FROM albums WHERE category = 41 (0.005s)
    [37] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 41 (0.004s)
    [38] => SELECT aid FROM albums WHERE category = 8 (0.007s)
    [39] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0.024s)
    [40] => SELECT cid, name, description, thumb FROM categories WHERE parent = '8'  ORDER BY pos (0.013s)
    [41] => SELECT aid FROM albums WHERE category = 38 (0.003s)
    [42] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 38 (0.005s)
    [43] => SELECT aid FROM albums WHERE category = 39 (0.011s)
    [44] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 39 (0.003s)
    [45] => SELECT aid FROM albums WHERE category = 15 (0.002s)
    [46] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 15 (0.001s)
    [47] => SELECT cid, name, description, thumb FROM categories WHERE parent = '15'  ORDER BY pos (0.028s)
    [48] => SELECT aid FROM albums WHERE category = 16 (0.007s)
    [49] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 16 (0.003s)
    [50] => SELECT aid FROM albums WHERE category = 17 (0.002s)
    [51] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 17 (0.003s)
    [52] => SELECT aid FROM albums WHERE category = 18 (0.002s)
    [53] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 18 (0.007s)
    [54] => SELECT cid, name, description, thumb FROM categories WHERE parent = '18'  ORDER BY pos (0.003s)
    [55] => SELECT aid FROM albums WHERE category = 19 (0.001s)
    [56] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 19 (0.029s)
    [57] => SELECT aid FROM albums WHERE category = 20 (0.003s)
    [58] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 20 (0.001s)
    [59] => SELECT cid, name, description, thumb FROM categories WHERE parent = '20'  ORDER BY pos (0s)
    [60] => SELECT aid FROM albums WHERE category = 21 (0s)
    [61] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 21 (0s)
    [62] => SELECT aid FROM albums WHERE category = 22 (0.001s)
    [63] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 22 (0.003s)
    [64] => SELECT aid FROM albums WHERE category = 2 (0s)
    [65] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.001s)
    [66] => SELECT aid FROM albums WHERE category = 31 (0s)
    [67] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 31 (0s)
    [68] => SELECT aid FROM albums WHERE category = 23 (0s)
    [69] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 23 (0s)
    [70] => SELECT cid, name, description, thumb FROM categories WHERE parent = '23'  ORDER BY pos (0s)
    [71] => SELECT aid FROM albums WHERE category = 28 (0s)
    [72] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 28 (0s)
    [73] => SELECT aid FROM albums WHERE category = 29 (0.001s)
    [74] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 29 (0.001s)
    [75] => SELECT aid FROM albums WHERE category = 37 (0s)
    [76] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 37 (0s)
    [77] => SELECT aid FROM albums WHERE category = 30 (0s)
    [78] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 30 (0s)
    [79] => SELECT aid FROM albums WHERE category = 44 (0s)
    [80] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 44 (0s)
    [81] => SELECT cid, name, description, thumb FROM categories WHERE parent = '44'  ORDER BY pos (0s)
    [82] => SELECT aid FROM albums WHERE category = 45 (0s)
    [83] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 45 (0s)
    [84] => SELECT aid FROM albums WHERE category = 46 (0s)
    [85] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 46 (0s)
    [86] => SELECT aid FROM albums WHERE category = 24 (0s)
    [87] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 24 (0s)
    [88] => SELECT cid, name, description, thumb FROM categories WHERE parent = '24'  ORDER BY pos (0s)
    [89] => SELECT aid FROM albums WHERE category = 25 (0s)
    [90] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 25 (0s)
    [91] => SELECT aid FROM albums WHERE category = 36 (0s)
    [92] => SELECT count(*) FROM pictures as p, albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 36 (0s)
    [93] => SELECT aid FROM albums as a WHERE category = '0' (0s)
    [94] => SELECT count(*) FROM albums as a WHERE 1 (0s)
    [95] => SELECT count(*) FROM pictures as p LEFT JOIN albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.013s)
    [96] => SELECT count(*) FROM comments as c LEFT JOIN pictures as p ON c.pid=p.pid LEFT JOIN albums as a ON a.aid=p.aid WHERE 1 (0.004s)
    [97] => SELECT count(*) FROM categories WHERE 1 (0s)
    [98] => SELECT sum(hits) FROM pictures as p LEFT JOIN albums as a ON p.aid=a.aid WHERE 1 (0.018s)
    [99] => SELECT count(*) FROM albums as a WHERE category = '0' (0.001s)
    [100] => SELECT COUNT(*) from pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  (0.015s)
    [101] => SELECT * FROM pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  ORDER BY RAND() LIMIT 8 (0.456s)
    [102] => SELECT COUNT(*) from pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  (0s)
    [103] => SELECT * FROM pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329)  ORDER BY pid DESC  LIMIT 0 ,8 (0.047s)
)

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

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

==========================
Page generated in 11.407 seconds - 104 queries in 0.926 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,6,7,8,9,10,13,14,
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: FATAL ERROR - NEED help
« Reply #27 on: February 26, 2008, 07:58:49 am »

desable debugg 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

Katya

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 76
Re: FATAL ERROR - NEED help
« Reply #28 on: February 26, 2008, 10:21:25 pm »

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: FATAL ERROR - NEED help
« Reply #29 on: February 26, 2008, 11:24:36 pm »

Can't see it. Well, you know the drill: re-enable debug_mode to check what is wrong. It you have another crashed table, repair it. Then turn debug_mode off.
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9096
  • aka Frantz
    • Ma galerie
Re: FATAL ERROR - NEED help
« Reply #30 on: February 27, 2008, 07:41:54 am »

site work's as expected for me
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 [2]   Go Up
 

Page created in 0.022 seconds with 20 queries.