Hello! Today I'm shocked - my gallery does not work! Yesterday all was great, I can correct it? How? Please help! I'm desperate!
http://www.eva-longoria.net.ru/gallery/
http://coppermine-gallery.net/tutorial/debug_mode.php
Thanks, I use this tutorial and write "1" on debug_mode, my result:
UPDATE `eva_longoria_net_ru`.`cpg1410_config` SET `value` = '1' WHERE CONVERT( `cpg1410_config`.`name` USING utf8 ) = 'debug_mode' LIMIT 1 ;
but fatal error still is
I can correct it or I need delete gallery? ??? :'(
Keep in mind that everyone on this board who lends support does so on a volunteer basis. It's not a hotline.
I know, sorry, i'm only desperate because i can not open my gallery - i receive error. I want correct it but i don't know how. My friend say me what all gallery, who received Fatal Error need delete, it's true? I can't correct it?
No what your friend said is false.
are you sure to set correctly debug mode to one via a tool like phpmyadmin ?
It is difficult for us to help you without seeing what's going wrong.
I would suggest doing the same when you would upgrade your install:
download the latest version and follow the steps described in the link below.
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#14
I'm sorry - i'm not really good understand what you mean, because i'm from Russia and my English is bad
I use this - http://coppermine-gallery.net/tutorial/debug_mode.php
and nothing no change - Fatal Error
i first time meet a error in a gallery so i don't know what i need do
How i can know why Fatal Error appeared in my gallery?
Following http://coppermine-gallery.net/tutorial/debug_mode.php should give you the reason. Make sure you edited the right database and table. Try repairing each table in the coppermine database using phpmyadmin.
Thanks, but where the message on a error should be written in PHPmyadmin?
It won't be in phpmyadmin. It will be displayed on the gallery instead of just 'fatal error'.
I used this tutorial again, but again Fatal Error
OK then, edit sql/update.sql and add this code at the end.
UPDATE `CPG_config` SET `value` = '1' WHERE `name` = 'debug_mode';
Then run update.php.
I done it - Fatal Error again((
I edit sql/update.sql - nothing no change in my gallery((
Now message:
Fatal error :
While executing query "delete from `eva_longoria_net_ru`.sessions where time<1203968404 and remember=0;" on Resource id #6
mySQL error: Table './eva_longoria_net_ru/sessions' is marked as crashed and should be repaired
What is what?
You didn't run update.php. Your error message is :
While executing query "delete from `eva_longoria_net_ru`.sessions where time<1203968397 and remember=0;" on Resource id #6
mySQL error: Table './eva_longoria_net_ru/sessions' is marked as crashed and should be repaired
Which means you need to repair your sessions table using phpmyadmin.
http://forum.coppermine-gallery.net/index.php/topic,10409.0.html
You edited the wrong config table earlier, so make sure you run the repair on the correct table.
Thanks and sorry,what I done edit in update.php?
I read this topic http://forum.coppermine-gallery.net/index.php/topic,10409.0.html but not understand - how I can correct this problem?
Run
REPAIR TABLE `eva_longoria_net_ru`.sessions
in phpmyadmin.
Where exactly I should add this code? I open cpg1410_sessions and that then?
Now i done it and what i have:
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) ;
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
your gallery is working now, so you can desable the debug mode via the config page
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?
QuoteI delete this message
wich message ?
This (I disable the debug mode)
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,
desable debugg mode
ONG, Fatal Error again
http://www.eva-longoria.net.ru/gallery/
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.
site work's as expected for me