Error crítico

Se produjo un error al procesar una consulta de base de datos.

While executing query 'SELECT COUNT(*)
                FROM cpg14x_pictures AS r
                INNER JOIN cpg14x_albums AS a ON a.aid = r.aid        
                WHERE (r.aid = 3870 OR keywords like '%colores_crepusculares%') AND r.aid NOT IN (122, 2213, 176, 220, 223, 231, 248, 259, 264, 332, 462, 394, 424, 522, 490, 531, 584, 586, 626, 676, 700, 712, 4188, 3901, 3915, 1500, 1569, 1970, 4191, 3354, 3453, 3462, 3672, 3673, 3780, 3781, 3805, 4968, 4224, 4223, 4973, 4394, 4431, 4654, 4562, 4566, 4768, 4777, 3782, 4863, 4884, 4967, 4963, 4969, 4970, 4971, 4975, 4991, 4993, 5001, 5006)
                AND approved = 'YES'  AND (r.hide_level IN (0, 1) OR (r.hide_level = 2 AND r.owner_id = 0)) 
                AND ((pv.pv_votes IS NOT NULL AND pv.pv_votes >= 10) OR r.votes >= 10) 
                 AND (r.keywords NOT LIKE '%z_vjur_concurso_actual%')  AND (r.keywords NOT LIKE '%zmv26%')  AND (r.keywords NOT LIKE '%z_vpop_mv26%') ' in include/functions.inc.php on line 3999

database error: 1054 : Unknown column 'pv.pv_votes' in 'where clause'

Fichero: /var/www/vhosts/fotometeo.ame-web.org/httpdocs/include/functions.inc.php - Línea: 407

Información para depuración

Salida de la depuración: mostrar/ocultar USER: ------------------ Array ( [ID] => 722eef07dd9b6fdd2e4d07f8962834d2 [am] => 1 [sort] => ) ========================== USER DATA: ------------------ Array ( [user_id] => 0 [user_name] => Guest [groups] => Array ( [0] => 3 ) [group_quota] => 0 [can_rate_pictures] => 0 [can_send_ecards] => 0 [can_post_comments] => 0 [can_upload_pictures] => 0 [can_create_albums] => 0 [pub_upl_need_approval] => 0 [priv_upl_need_approval] => 0 [access_level] => 1 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] => Guests [can_create_public_albums] => 0 [can_see_all_albums] => 0 [group_id] => 3 [allowed_albums] => Array ( ) ) ========================== Queries: ------------------ Array ( [0] => SELECT name, value FROM cpg14x_config [include/init.inc.php:327] (0.37 ms) [1] => SELECT ac.aid as aid, is_active, show_author, show_score, show_album_link, album_id_redirect, common_author_name, show_album_title, title, keyword FROM cpg14x_active_contests ac LEFT JOIN cpg14x_albums al ON al.aid = ac.aid WHERE ac.is_active = 1 ORDER BY ac.aid ASC [include/init.inc.php:352] (0.48 ms) [2] => SELECT * FROM cpg14x_plugins ORDER BY priority [include/plugin_api.inc.php:48] (0.18 ms) [3] => DELETE FROM `fotometeo3`.cpg14x_sessions WHERE time < 1772259731 AND remember = 0 [bridge/udb_base.inc.php:59] (0.83 ms) [4] => DELETE FROM `fotometeo3`.cpg14x_sessions WHERE time < 1771053731 [bridge/udb_base.inc.php:59] (0.51 ms) [5] => UPDATE cpg14x_config SET value = 1772263331 WHERE name = 'session_cleanup' [bridge/udb_base.inc.php:59] (0.13 ms) [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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:350] (0.17 ms) [7] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:362] (0.09 ms) [8] => SELECT COUNT() FROM cpg14x_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.13 ms) [9] => SELECT aid FROM cpg14x_albums WHERE moderator_group IN (3) [include/init.inc.php:449] (0.12 ms) [10] => SELECT lang_id FROM cpg14x_languages WHERE enabled='YES' [include/init.inc.php:512] (0.15 ms) [11] => SELECT FROM cpg14x_final_extract_config LIMIT 1 [plugins/final_extract/codebase.php:147] (0.12 ms) [12] => SELECT home,login,my_gallery,upload_pic,album_list,lastup,lastcom,topn,toprated,favpics,search,my_profile,register FROM cpg14x_final_extract_config WHERE Group_Id=3 [plugins/final_extract/codebase.php:154] (0.13 ms) [13] => SHOW TABLES LIKE 'cpg14x_cms_config' [plugins/minicms/include/init.inc.php:63] (0.22 ms) [14] => SELECT * FROM cpg14x_cms_config [plugins/minicms/include/init.inc.php:69] (0.11 ms) [15] => SELECT * FROM cpg14x_plugins [plugins/slider/include/load_sliderset.php:16] (0.14 ms) [16] => SELECT * FROM cpg14x_plugin_slider [plugins/slider/include/load_sliderset.php:24] (0.11 ms) [17] => DELETE FROM cpg14x_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE [plugins/onlinestats/codebase.php:119] (0.15 ms) [18] => REPLACE INTO cpg14x_mod_online (user_id, user_name, user_ip, last_action) VALUES ('0', 'Guest', '216.73.216.50', NOW()) [plugins/onlinestats/codebase.php:121] (0.11 ms) [19] => DELETE FROM cpg14x_banned WHERE expiry < '2026-02-28 07:22:11' [include/init.inc.php:626] (0.11 ms) [20] => SELECT null FROM cpg14x_banned WHERE ('216.73.216.50' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:642] (0.19 ms) [21] => SELECT aid FROM cpg14x_albums WHERE (1 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:1273] (1.97 ms) [22] => SELECT category, title, al.aid as aid, keyword, description, alb_password_hint, alb_type, is_atlas, is_top10, stars_amount, vote_closed, max_vote_tries, maxpics_can_vote, active_contest, show_linked_pics, sort_code, is_active, show_author, show_score FROM cpg14x_albums al LEFT JOIN cpg14x_active_contests ac ON ac.aid = al.aid WHERE al.aid = 3870 [thumbnails.php:180] (0.24 ms) [23] => SELECT parent FROM cpg14x_categories WHERE cid = 186 LIMIT 1 [include/init.inc.php:168] (0.15 ms) [24] => SELECT parent FROM cpg14x_categories WHERE cid = 6 LIMIT 1 [include/init.inc.php:168] (0.13 ms) [25] => SELECT parent FROM cpg14x_categories WHERE cid = 172 LIMIT 1 [include/init.inc.php:168] (0.11 ms) [26] => SELECT parent FROM cpg14x_categories WHERE cid = 112 LIMIT 1 [include/init.inc.php:168] (0.07 ms) [27] => SELECT p.cid, p.name FROM cpg14x_categories AS c, cpg14x_categories AS p WHERE c.lft BETWEEN p.lft AND p.rgt AND c.cid = 186 ORDER BY p.lft [include/functions.inc.php:6271] (0.37 ms) [28] => SELECT * FROM cpg14x_cms WHERE conid='3870' AND type='1' ORDER BY cpos [plugins/minicms/codebase.php:92] (1.12 ms) [29] => SELECT vote_closed, maxpics_can_vote, alb_type FROM cpg14x_albums WHERE aid = 3870 [include/functions.inc.php:2472] (0.12 ms) [30] => SELECT show_linked_pics FROM cpg14x_albums WHERE aid = 3870 LIMIT 1 [include/fmfunctions.inc.php:3512] (0.11 ms) [31] => SELECT count(pv.pid) FROM cpg14x_pic_votes AS pv INNER JOIN cpg14x_pictures AS r ON r.pid = pv.pid WHERE (pv.aid = 3870) AND approved='YES' AND (hide_level IN (0, 1) OR (hide_level = 2 AND owner_id = 0)) [include/fmfunctions.inc.php:3433] (0.4 ms) [32] => SELECT show_linked_pics FROM cpg14x_albums WHERE aid = 3870 LIMIT 1 [include/fmfunctions.inc.php:3512] (0.12 ms) [33] => SELECT count(pv.pid) FROM cpg14x_pic_votes AS pv INNER JOIN cpg14x_pictures AS r ON r.pid = pv.pid WHERE (pv.aid = 3870) AND approved='YES' AND (hide_level IN (0, 1) OR (hide_level = 2 AND owner_id = 0)) AND r.owner_id <> 0 AND (r.picauthor_id IS NULL OR r.picauthor_id <> 0) [include/fmfunctions.inc.php:3433] (0.31 ms) [34] => SELECT count(pid) FROM cpg14x_pictures AS r WHERE (aid = 3870) AND approved='YES' AND (hide_level IN (0, 1) OR (hide_level = 2 AND owner_id = 0)) AND r.owner_id <> 0 AND (r.picauthor_id IS NULL OR r.picauthor_id <> 0) [include/fmfunctions.inc.php:3390] (0.23 ms) [35] => SELECT show_linked_pics, sort_code, visibility, alb_type FROM cpg14x_albums WHERE aid = 3870 [include/functions.inc.php:3418] (0.13 ms) [36] => SELECT COUNT(*) FROM cpg14x_pictures AS r INNER JOIN cpg14x_albums AS a ON a.aid = r.aid WHERE (r.aid = 3870 OR keywords like '%colores_crepusculares%') AND r.aid NOT IN (122, 2213, 176, 220, 223, 231, 248, 259, 264, 332, 462, 394, 424, 522, 490, 531, 584, 586, 626, 676, 700, 712, 4188, 3901, 3915, 1500, 1569, 1970, 4191, 3354, 3453, 3462, 3672, 3673, 3780, 3781, 3805, 4968, 4224, 4223, 4973, 4394, 4431, 4654, 4562, 4566, 4768, 4777, 3782, 4863, 4884, 4967, 4963, 4969, 4970, 4971, 4975, 4991, 4993, 5001, 5006) AND approved = 'YES' AND (r.hide_level IN (0, 1) OR (r.hide_level = 2 AND r.owner_id = 0)) AND ((pv.pv_votes IS NOT NULL AND pv.pv_votes >= 10) OR r.votes >= 10) AND (r.keywords NOT LIKE '%z_vjur_concurso_actual%') AND (r.keywords NOT LIKE '%zmv26%') AND (r.keywords NOT LIKE '%z_vpop_mv26%') [include/functions.inc.php:3999] (0.18 ms) ) ========================== GET : ------------------ Array ( [album] => toprated [cat] => -3870 ) ========================== POST : ------------------ Array ( ) ========================== COOKIE : ------------------ Array ( ) ==========================

FOTOMETEO

Asociación Meteorológica Española (AME)

Póster conmemorativo:
"10 años de concursos estacionales"

Últimos ganadores de cada concurso

Error crítico

FOTOMETEO

Asociación Meteorológica Española (AME)

Póster conmemorativo: "10 años de concursos estacionales"

Últimos ganadores de cada concurso

Error crítico

Póster conmemorativo:
"10 años de concursos estacionales"