Enregistrement impossible 1.4.25

[tangamania]

Bonjour,

J'ai mis a jour coppermine de la version 1.3.2 a la version 1.4.25 jusque la pas de probleme ...
Mais depuis cette mise a jour plus personne ne peux s'enregister : message "Erreur critique : Il y eu une erreur lors de l'exécution de la requête  "
Voici le lien vers ma gallerie : http://membres.lycos.fr/stringomania.

Merci d'avance a tout ceux qui pourront m'aider   

Claire

[Pascal YAP]

après votre mise à jour, avez-vous lancé UPDATE.PHP ?

ATTENTION GALERIE à la LIMITE du Classé X
Merci de prévenir les Utilisateurs de notre FORUM DANS DE TELS CAS DE FIGURE

[François Keller]

activez le mode de débuggage pour avoir le message d'erreur complet

[tangamania]

bonsoir,

Oui j"ai bien fait la update.php

voila les infos de debuggages :

Code Select Expand

USER:
------------------
Array
(
   [ID] => 4cf89eb3b596a332ba2286f08de4a233
   [am] => 1
   [lang] => french
)

==========================
USER DATA:
------------------
Array
(
   [user_id] => 1
   [user_name] => stringomania
   [groups] => Array
       (
           [0] => 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] => 5
   [num_URI_upload] => 3
   [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
(
   [0] => SELECT extension, mime, content, player FROM cpg132_filetypes; (0.001s)
   [1] => select * from cpg132_plugins order by priority asc; (0s)
   [2] => delete from `stringomania_db`.cpg132_sessions where time<1261089297 and remember=0; (0.001s)
   [3] => delete from `stringomania_db`.cpg132_sessions where time<1259883297; (0s)
   [4] => select user_id from `stringomania_db`.cpg132_sessions where session_id = '04615d81d3a7f72fffb3dfc2fdf2681f' (0.001s)
   [5] => select user_id as id, user_password as password from `stringomania_db`.cpg132_users where user_id=1 (0s)
   [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `stringomania_db`.cpg132_users AS u INNER JOIN `stringomania_db`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
   [7] => SELECT user_group_list FROM `stringomania_db`.cpg132_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
   [8] => 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)
   [9] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1 (0s)
   [10] => update `stringomania_db`.cpg132_sessions set time='1261092897' where session_id = '04615d81d3a7f72fffb3dfc2fdf2681f' (0s)
   [11] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 1 (0.001s)
   [12] => DELETE FROM cpg132_banned WHERE expiry < '2009-12-18 00:34:57' (0.001s)
   [13] => SELECT * FROM cpg132_banned WHERE (ip_addr='82.250.254.23' OR ip_addr='82.250.254.23' OR user_id=1) AND brute_force=0 (0s)
   [14] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = ''  ORDER BY pos (0.001s)
   [15] => SELECT aid FROM cpg132_albums as a WHERE category>=10000 (0.001s)
   [16] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
   [17] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos (0s)
   [18] => SELECT aid FROM cpg132_albums as a WHERE category = '0' (0.001s)
   [19] => SELECT count(*) FROM cpg132_albums as a WHERE 1 (0.002s)
   [20] => SELECT count(*) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
   [21] => SELECT count(*) FROM cpg132_comments as c LEFT JOIN cpg132_pictures as p ON c.pid=p.pid LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
   [22] => SELECT count(*) FROM cpg132_categories WHERE 1 (0.002s)
   [23] => SELECT sum(hits) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON p.aid=a.aid WHERE 1 (0.003s)
   [24] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' (0.001s)
   [25] => SELECT count(*) FROM cpg132_albums as a WHERE category = '0' (0s)
   [26] => SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,6 (0.001s)
   [27] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg132_albums AS a  LEFT JOIN cpg132_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (17, 7, 8, 9, 10, 6)GROUP BY a.aid (0.005s)
   [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='615' (0.001s)
   [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='754' (0.001s)
   [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='749' (0.001s)
   [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='756' (0.001s)
   [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='641' (0s)
   [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg132_pictures WHERE pid='736' (0.001s)
   [34] => SELECT * FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (0.01s)
   [35] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'  (0.001s)
   [36] => SELECT * FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0.001s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.11 - OK
------------------
mySQL version: 4.0.18-standard
------------------
Coppermine version: 1.4.25(stable)
==========================
Module: GD
------------------
GD Version: 2.0 or higher
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:
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.77
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 | On | On
safe_mode_exec_dir | /usr/share/php/safe_exec | /usr/share/php/safe_exec
safe_mode_gid | Off | Off
safe_mode_include_dir | /usr/share/php/mmp_lib | /usr/share/php/mmp_lib
safe_mode_exec_dir | /usr/share/php/safe_exec | /usr/share/php/safe_exec
sql.safe_mode | Off | Off
disable_functions | highlight_file,diskfreespace, exec, passthru, system, popen, fsockopen, pfsockopen, show_source, php_uname, ini_get, ini_alter, ini_restore, ini_set, getrusage, mysql_list_dbs, get_current_user, set_time_limit, getmyuid, getmygid, getmypid, dl, leak, listen, chown, chmod, chgrp, realpath, tmpfile, link, mb_send_mail, stream_bucket_append, stream_bucket_make_writeable, stream_bucket_new, stream_bucket_prepend, stream_context_create, stream_context_get_default, stream_context_get_options, stream_context_set_option, stream_context_set_params, stream_copy_to_stream, stream_encoding, stream_filter_append, stream_filter_prepend, stream_filter_register, stream_filter_remove, stream_get_contents, stream_get_filters, stream_get_line, stream_get_meta_data, stream_get_transports, stream_get_wrappers, stream_register_wrapper, stream_resolve_include_path, stream_select, stream_set_blocking, stream_set_timeout, stream_set_write_buffer, stream_socket_accept, stream_socket_client, stream_socket_enable_crypto, stream_socket_get_name, stream_socket_pair, stream_socket_recvfrom, stream_socket_sendto, stream_socket_server, stream_socket_shutdown, stream_wrapper_register, stream_wrapper_restore, stream_wrapper_unregister, shell_exec, error_log, openlog, syslog, apache_child_terminate, apache_get_modules, apache_get_version, apache_getenv, apache_note, apache_setenv, virtual, socket_create, socket_write, pcntl_exec, proc_nice, proc_open, proc_terminate, pfsockopenproc_nice | highlight_file,diskfreespace, exec, passthru, system, popen, fsockopen, pfsockopen, show_source, php_uname, ini_get, ini_alter, ini_restore, ini_set, getrusage, mysql_list_dbs, get_current_user, set_time_limit, getmyuid, getmygid, getmypid, dl, leak, listen, chown, chmod, chgrp, realpath, tmpfile, link, mb_send_mail, stream_bucket_append, stream_bucket_make_writeable, stream_bucket_new, stream_bucket_prepend, stream_context_create, stream_context_get_default, stream_context_get_options, stream_context_set_option, stream_context_set_params, stream_copy_to_stream, stream_encoding, stream_filter_append, stream_filter_prepend, stream_filter_register, stream_filter_remove, stream_get_contents, stream_get_filters, stream_get_line, stream_get_meta_data, stream_get_transports, stream_get_wrappers, stream_register_wrapper, stream_resolve_include_path, stream_select, stream_set_blocking, stream_set_timeout, stream_set_write_buffer, stream_socket_accept, stream_socket_client, stream_socket_enable_crypto, stream_socket_get_name, stream_socket_pair, stream_socket_recvfrom, stream_socket_sendto, stream_socket_server, stream_socket_shutdown, stream_wrapper_register, stream_wrapper_restore, stream_wrapper_unregister, shell_exec, error_log, openlog, syslog, apache_child_terminate, apache_get_modules, apache_get_version, apache_getenv, apache_note, apache_setenv, virtual, socket_create, socket_write, pcntl_exec, proc_nice, proc_open, proc_terminate, pfsockopenproc_nice
file_uploads | On | On
include_path | .:/usr/share/php/mmp_lib | .:/usr/share/php/mmp_lib
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -f tripod@mail-return.hpb.lyceu.net | /usr/sbin/sendmail -t -f tripod@mail-return.hpb.lyceu.net
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 10 | 10
max_input_time | -1 | -1
upload_max_filesize | 4000000 | 4000000
post_max_size | 512000 | 512000
==========================
Page generated in 0.159 seconds - 37 queries in 0.042 seconds - Album set : ; Meta set: ;

Merci d'avance

[tangamania]

bonsoir,
j'ai aussi un message d'erreur sur debugger.inc.php on line 50
meric d'avance
claire

[Pascal YAP]

Quel est ce message ?
Que dit cette ligne 50 ?

[tangamania]

bonsoir,

ligne 50 : $this->old_display_level = ini_set('display_errors', 1);
ligne 51 : $this->old_error_logging = ini_set('log_errors', 0);

Merci

[François Keller]

les warnings concernant debugg.inc.php ne posent pas de problèmes, ce ne sont que des alertes, pas des messages d'erreur. J'espérais un "Vrai" message d'erreur à la place de celui qui apparait.
Essayez de réuploader les fichiers coppermine en vous assurant qu'ils remplacent bien ceux existant

[tangamania]

bonjour,

voila deux autre message :

/include/init.inc.php

    * Warning line 35: ini_get() has been disabled for security reasons
    * Warning line 35: ini_get() has been disabled for security reasons

Merci d'avance

Claire

[François Keller]

oui ceux là je les avais vu, avez vous fait ce que je demandais dans mon dernier post ?