Subo nuevas imágenes pero no aparece en ULTIMAS IMAGENES

[valdz]

Les escribo para que me ayuden a resolver este problema que tengo, les cuento:

    Actualicé a la versión 1.4.19, aunque el problema ya venía, creí que actualizando se resolvería, pero no. El caso es que subo imágenes y si se suben en el album que quiero, pero en la página principal no aparece en ULTIMAS IMAGENES, pero si aparece en IMAGENES AL AZAR; cuando se dá el caso, entro a la categoría-album y aparece en IMAGENES AL AZAR y también en ULTIMAS IMAGENES, si le doy click en IMAGENES AL AZAR me dice "ninguna imagen que enseñar" pero si le doy en ULTIMAS IMAGENES si la abre correctamente. ¿qué estará pasando?

    Por su respuesta, gracias.

                          Felipe V

[Fabricio Ferrero]

¿Quieres respuesta a tu problema? LEER SI O SI

[valdz]

He regresado para continuar.

El enlace a la galería es http://www.costachica.com.mx/imagscch

Ingresé como administrador y cuando intenté dar de alta al usuario de prueba me salió el siguiente error:
------------------------------------------------
While executing query "INSERT INTO cpg132_users(user_regdate, user_active, user_profile6)

VALUES (NOW(), 'YES', '')" on 0

mySQL error: Duplicate entry '0' for key 1
-----------------------------------------------
más abajo la leyenda:
----------------------------------------------
Fichero: /var/www/vhosts/costachica.com.mx/httpdocs/imagscch/include/functions.inc.php - Línea: 250
----------------------------------------------
Información de Debug

USER:
------------------
Array
(
    [ID] => 6860c1a645e5a6eacd3d9116617546f0
    [am] => 1
    [lang] => spanish
    [liv] => Array
        (
           

• => 0
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => admin
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 10
      [num_URI_upload] => 5
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg132_filetypes; (0s)
      [1] => delete from `mysqlcch`.cpg132_sessions where time<1227297202 and remember=0;
  
  (0s)
      [2] => delete from `mysqlcch`.cpg132_sessions where time<1226091202; (0s)
      [3] => select user_id from `mysqlcch`.cpg132_sessions where session_id =
  
  'c10de537eae21e0cadeb42fb9fe45b85' (0s)
      [4] => select user_id as id, user_password as password from `mysqlcch`.cpg132_users
  
  where user_id=1 (0s)
      [5] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS
  
  password, u.user_group+100 AS group_id FROM `mysqlcch`.cpg132_users AS u INNER JOIN
  
  `mysqlcch`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [6] => SELECT user_group_list FROM `mysqlcch`.cpg132_users AS u WHERE user_id='1'
  
  and user_group_list <> ''; (0s)
      [7] => 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 cpg132_usergroups WHERE
  
  group_id in (1) (0s)
      [8] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1 (0s)
      [9] => update `mysqlcch`.cpg132_sessions set time='1227300802' where session_id =
  
  'c10de537eae21e0cadeb42fb9fe45b85' (0s)
      [10] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 1 (0s)
      [11] => DELETE FROM cpg132_banned WHERE expiry < '2008-11-21 14:53:22' (0s)
      [12] => SELECT * FROM cpg132_banned WHERE (ip_addr='189.147.13.97' OR
  
  ip_addr='189.147.13.97' OR user_id=1) AND brute_force=0 (0s)
      [13] => INSERT INTO cpg132_users(user_regdate, user_active, user_profile6) VALUES
  
  (NOW(), 'YES', '') (0s)
      [14] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [op] => new_user
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.1.6 - OK
  ------------------
  mySQL version: 5.0.22
  ------------------
  Coppermine version: 1.4.19(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 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:
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .: | .:
  open_basedir | /var/www/vhosts/costachica.com.mx/httpdocs:/tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 64M | 20M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.061 seconds - 15 queries in 0 seconds - Album set : ; Meta set: ;
  ------------------------------------
  ------------------------------------
  Para dar de alta al ususario prueba lo que hice fué modificar la cuenta de un usuario que estaba bloqueado y listo:
  
  USUARIO:  prueba
  PASS:  prueba
  
  Les recuerdo que el problema inicial era (y es) que al subir una nueva imágen no podía ver las imágenes al hacer click en Imágenes al azar y Ultimas imágenes no aparece. El error que aparece es el siguiente:
  
  Ninguna imagen que enseñar.
  
  Fichero: /var/www/vhosts/costachica.com.mx/httpdocs/imagscch/displayimage.php - Línea: 275
  
  Información de DEBUG
  
  USER:
  ------------------
  Array
  (
      [ID] => 6860c1a645e5a6eacd3d9116617546f0
      [am] => 1
      [lang] => spanish
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => admin
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 10
      [num_URI_upload] => 5
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg132_filetypes; (0s)
      [1] => delete from `mysqlcch`.cpg132_sessions where time<1227296649 and remember=0;
  
  (0s)
      [2] => delete from `mysqlcch`.cpg132_sessions where time<1226090649; (0s)
      [3] => select user_id from `mysqlcch`.cpg132_sessions where session_id =
  
  'c10de537eae21e0cadeb42fb9fe45b85' (0s)
      [4] => select user_id as id, user_password as password from `mysqlcch`.cpg132_users
  
  where user_id=1 (0s)
      [5] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS
  
  password, u.user_group+100 AS group_id FROM `mysqlcch`.cpg132_users AS u INNER JOIN
  
  `mysqlcch`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [6] => SELECT user_group_list FROM `mysqlcch`.cpg132_users AS u WHERE user_id='1'
  
  and user_group_list <> ''; (0s)
      [7] => 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 cpg132_usergroups WHERE
  
  group_id in (1) (0s)
      [8] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1 (0s)
      [9] => update `mysqlcch`.cpg132_sessions set time='1227300249' where session_id =
  
  'c10de537eae21e0cadeb42fb9fe45b85' (0s)
      [10] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 1 (0s)
      [11] => DELETE FROM cpg132_banned WHERE expiry < '2008-11-21 14:44:09' (0s)
      [12] => SELECT * FROM cpg132_banned WHERE (ip_addr='189.147.13.97' OR
  
  ip_addr='189.147.13.97' OR user_id=1) AND brute_force=0 (0s)
      [13] => SELECT aid FROM cpg132_albums WHERE category = 8 (0s)
      [14] => SELECT cid FROM cpg132_categories WHERE parent = '8' (0s)
      [15] => SELECT * FROM cpg132_pictures WHERE approved = 'YES' AND aid IN (69) 
  
  ORDER BY RAND() LIMIT 1 (0.001s)
      [16] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [album] => random
      [cat] => 8
      [pos] => 0
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.1.6 - OK
  ------------------
  mySQL version: 5.0.22
  ------------------
  Coppermine version: 1.4.19(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 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:
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .: | .:
  open_basedir | /var/www/vhosts/costachica.com.mx/httpdocs:/tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 64M | 20M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.065 seconds - 17 queries in 0.001 seconds - Album set : AND aid IN (69) ;
  
  Meta set: AND aid IN (69) ;
  
          Gracias por su respuesta.
  

[Fabricio Ferrero]

No es necesario colocar tu debug output a menos que yo te lo solicite. Además, eso no es nigún error. Desactiva la información de debug y las 'advertencias' sino significan nada para vos y listo. Agrego una captura de pantalla de tu web, parece que el problema se solucionó ya que puedo ver todo correctamente.

Espero respuesta para resolver el tema,

Saludos,