Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: Error crítico: Error al procesar una consulta de base de datos.  (Read 6011 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.024 seconds with 18 queries.