Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: Error crítico: Error al procesar una consulta de base de datos.  (Read 6008 times)

0 Members and 1 Guest are viewing this topic.

hilduffmexico

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 18
  • Mikke Navarro
    • Mikke Navarro

Hola que tal, bueno primero ya búsque entre todos los temas algo que me pudiera ayudar, encontra algunos pero al final nunca terminaban de explicar, o decian que se solucionaba sólo el problema, es por eso que hago este nuevo topic.

Mi galeria funcionaba completamente normal, hasta hoy que entre y vi que salia el mensaje:

"Error crítico
Se produjo un error al procesar una consulta de base de datos."

Nunca me habia salido eso, después en los otros temas que encontre mencionaba que entrara a configuración>> mantenimiento>> Habilitar depuración ... y ya lo he hecho, me sale el siguiente mensaje.

Quote
While executing query 'SELECT SUM(hits) FROM cpg_pictures WHERE approved = 'YES'' in index.php on line 593

mySQL error: Table 'cpg_pictures' is marked as crashed and should be repaired
Fichero: /home/hilaryre/public_html/galeria/include/functions.inc.php - Linea: 270

y abajo, ya al final de la galeria dice: "Mostrar PHPInfo"... Salida de la depuración: mostrar/ocultar
doy click y sale todo esto.

Quote
USER:
------------------
Array
(
    [ID] => 243d1941442a9f29813c39fd45bb6b7c
    [am] => 1
    [lang] => spanish
    [liv_a] => Array
        (
           
  • => 1043

        )

    [theme] => curve
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => mikke
    [groups] => Array
        (
           
  • => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [access_level] => 3
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [can_create_public_albums] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT name, value FROM cpg_config [include/init.inc.php:181] (0 ms)
  • [1] => SELECT * FROM cpg_plugins ORDER BY priority
[include/plugin_api.inc.php:54] (0 ms)
    [2] => SELECT user_id, time FROM `hilaryre_galeria`.cpg_sessions WHERE session_id = 'dbba0affe2fb07b8f8e2ba0157eb0edf' [bridge/coppermine.inc.php:264] (0 ms)
    [3] => SELECT user_id, user_password FROM `hilaryre_galeria`.cpg_users WHERE user_id = 2 [bridge/coppermine.inc.php:276] (0 ms)
    [4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `hilaryre_galeria`.cpg_users AS u LEFT JOIN `hilaryre_galeria`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2' [bridge/udb_base.inc.php:70] (0 ms)
    [5] => SELECT user_group_list FROM `hilaryre_galeria`.cpg_users AS u WHERE user_id='2' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (0 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 cpg_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:323] (0 ms)
    [7] => SELECT group_name FROM cpg_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:327] (0 ms)
    [8] => SELECT COUNT(*) FROM cpg_categorymap WHERE group_id in (1) [bridge/udb_base.inc.php:340] (0 ms)
    [9] => UPDATE `hilaryre_galeria`.cpg_sessions SET time = 1343008729 WHERE session_id = 'dbba0affe2fb07b8f8e2ba0157eb0edf' [bridge/coppermine.inc.php:321] (0 ms)
    [10] => UPDATE `hilaryre_galeria`.cpg_users SET user_lastvisit = NOW() WHERE user_id = '2' [bridge/coppermine.inc.php:325] (0 ms)
    [11] => SELECT lang_id FROM cpg_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
    [12] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 2 [include/init.inc.php:387] (14 ms)
    [13] => DELETE FROM cpg_banned WHERE expiry < '2012-07-23 03:58:49' [include/init.inc.php:443] (0 ms)
    [14] => SELECT null FROM cpg_banned WHERE (user_id=2 OR '187.194.244.29' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
    [15] => SELECT name, description, thumb FROM cpg_categories WHERE cid = 1 [index.php:268] (4 ms)
    [16] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
        FROM cpg_albums AS a
        INNER JOIN cpg_pictures AS p ON p.aid = a.aid
        WHERE a.category > 10000
        AND approved = 'YES' [index.php:292] (0 ms)
    [17] => SELECT name, description, cid, thumb, depth, lft
        FROM cpg_categories AS c
        WHERE depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY c.lft [index.php:316] (0 ms)
    [18] => SELECT category, COUNT(*) AS num
        FROM cpg_albums AS a
        INNER JOIN cpg_categories ON cid = category
        WHERE depth BETWEEN 0 + 1 AND 0 + 1
GROUP BY category ORDER BY NULL [index.php:358] (0 ms)
    [19] => SELECT title, r.description, keyword, category, aid, alb_hits, visibility, r.thumb, r.owner
        FROM cpg_categories AS c
        INNER JOIN cpg_albums AS r ON r.category = c.cid
        WHERE c.depth BETWEEN 0 + 1 AND 0 + 1
ORDER BY r.pos, r.aid [index.php:379] (0 ms)
    [20] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload
        FROM cpg_categories AS c
        INNER JOIN cpg_albums AS r ON r.category = c.cid
        INNER JOIN cpg_pictures AS p ON p.aid = r.aid
        WHERE (1)
        AND approved = 'YES'
        AND c.depth BETWEEN 0 + 1 AND 0 + 1
        GROUP BY r.aid
        ORDER BY NULL [index.php:414] (2 ms)
    [21] => SELECT COUNT(*) FROM cpg_albums AS a WHERE 1  [index.php:542] (0 ms)
    [22] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'YES' [index.php:555] (7 ms)
    [23] => SELECT COUNT(*) FROM cpg_comments [index.php:574] (0 ms)
    [24] => SELECT COUNT(*) FROM cpg_categories [index.php:580] (0 ms)
    [25] => SELECT SUM(hits) FROM cpg_pictures WHERE approved = 'YES' [index.php:593] (48 ms)
    [26] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' [include/functions.inc.php:2438] (6 ms)
    [27] => SELECT lang_id, abbr FROM cpg_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2316] (0 ms)
    [28] => DELETE FROM cpg_temp_messages WHERE time < 1343005129 [include/functions.inc.php:4947] (0 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [__utmc] => 1
    [cprelogin] => no
    [cpsession] => hilaryre:5533970053494096311226660924831970115609952027239651948319779476
    [langedit] =>
    [lang] =>
    [__utma] => 1.256602543.1342981145.1342985189.1343006730.3
    [__utmz] => 1.1342981145.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
    [cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiIyNDNkMTk0MTQ0MmE5ZjI5ODEzYzM5ZmQ0NWJiNmI3YyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJzcGFuaXNoIjtzOjU6Imxpdl9hIjthOjE6e2k6MDtpOjEwNDM7fXM6NToidGhlbWUiO3M6NToiY3VydmUiO30=
    [__gads] => ID=e0a084af9015d908:T=1342981282:S=ALNI_MZAElbCOoG_6ufFx39xdUD8gk8BBw
    [6f51bfbd5ae300ed6f7d99fdef48aa8a] => 2fdda02b33d3f36b96d2645465553851
    [__utmb] => 1.22.10.1343006730
    [5e5bfaf945fcdafbd37e0cf84a4b1085] => 7314186c618771fbafe6b21282e238c4
    [PHPSESSID] => c588a2245206902abfedad2e5c6506dc
)

==========================
SESSION :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version        5.2.17     OK   
MySQL version      5.1.63-cll OK   
Coppermine version 1.5.16     stable

==========================
Module: GD
------------------
Exact version                    2.0.34                     
GD Version                       bundled (2.0.34 compatible)
FreeType Support                 1                         
FreeType Linkage                 with freetype             
T1Lib Support                                               
GIF Read Support                 1                         
GIF Create Support               1                         
JPG Support                      1                         
PNG Support                      1                         
WBMP Support                     1                         
XPM Support                      1                         
XBM Support                      1                         
JIS-mapped Japanese Font Support                           

==========================
Key config settings
------------------
site_url             http://hilduff.com/galeria/                           
charset              utf-8                                                 
allow_private_albums 1                                                     
cookie_name          cpg15x                                                 
cookie_path          /                                                     
impath                                                                     
lang                 spanish                                               
main_page_layout     lastalb/breadcrumb/catlist/alblist/lastup/lasthits/topn
silly_safe_mode      0                                                     
smtp_host                                                                   
theme                curve                                                 
thumb_method         gd2                                                   

==========================
Plugins
------------------

==========================
Server restrictions
------------------
safe_mode                0                                                                           
safe_mode_exec_dir       /usr/local/php/bin                                                         
safe_mode_gid            0                                                                           
safe_mode_include_dir                                                                               
sql.safe_mode                                                                                       
disable_functions        show_source, system, shell_exec, passthru, popen, proc_open, allow_url_fopen
file_uploads             1                                                                           
include_path             .:/usr/lib/php:/usr/local/lib/php                                           
open_basedir                                                                                         
allow_url_fopen          1                                                                           
max_execution_time       360                                                                         
max_input_time           60                                                                         
upload_max_filesize      100M                                                                       
post_max_size            100M                                                                       
memory_limit             192M                                                                       
suhosin.post.max_vars                                                                               
suhosin.request.max_vars                                                                             


==========================
Page (performance)
------------------
Parameter        Current Peak   
Memory usage     4,66 Mb 7,19 Mb
Page generation  231 ms  231 ms
Page query time  81 ms   81 ms 
Page query count 29      29     


==========================
               

pero ya no se que hacer, espero que alguien pueda ayudarme, el link de mi galeria es:
http://hilduffmexico.com/galeria el problema solo aparece en la pagina principal index.php ... las imágenes y todo siguen ahi, como dato y no se si tenga algo que ver, la galeria anteriormente estaba en otro dominio y me ayudaron los del host a cambiarla a este nuevo dominio, no se si eso afecte. Agradezco su ayuda.
Logged

carolusabe

  • Coppermine newbie
  • Country: es
  • Offline Offline
  • Gender: Female
  • Posts: 19
Re: Error crítico: Error al procesar una consulta de base de datos.
« Reply #1 on: December 18, 2012, 05:48:38 pm »

Tengo exactamente el mismo problema con mi galeria http://g-arterton.com/galeria
Exactamente igual, y no se que hacer.

He creido innecesario crear un topic nuevo ya que este estaba creado y es exactamente el mismo problema.
Por favor si alguien sabe algo, estaría infinitamente agradecida!
Gracias de antemano
Carola.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.