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
¿Quieres respuesta a tu problema? LEER SI O SI (http://forum.coppermine-gallery.net/index.php/topic,54781.msg272625.html#msg272625)
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.
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,