Bonsoir,
J'ai installé le modpack de Stramm v1 pour CPG 1.4.18 (bridge support).
Depuis, lorsque j'ouvre mon album dans Coppermine (thème: Classic), j'ai bien les vignettes mais l'erreur suivante apparaît lorsque je clique sur une vignette pour faire apparaître l'image intermédiaire correspondante:
Erreur critique
Il y eu une erreur lors de l'exécution de la requête
Lorsque je supprime l'installation du modpack (en "pseudo-"upgradant CPG 1.4.18 sur lui-même), je récupère la visualisation des images intermédiaires.
A noter que mon CPG 1.4.18 provient d'une mise à jour de 1.4.16 déjà installé et que les fichiers "include/config.inc.php" et "anycontent.php" ainsi que le dossier "Album" proviennent de mon installation de 1.4.16 (ainsi qu'il est demandé dans la procédure de mise à jour vers 1.4.18).
Avez-vous une idée sur la cause du problème ? Sinon je me passerai du modpack.
Cordialement.
il serait intéressant d'avoir le message d'erreur complet en activant le mode de débugage.
Voici ce qui apparaît en mode débugage:
Erreur critique
Il y eu une erreur lors de l'exécution de la requête.
While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u. AS avatar_url FROM cpg14x_comments AS c LEFT JOIN `adventure_e107`.e107_user AS u ON c.author_id=u.user_id WHERE pid='1021' ORDER BY c.msg_id ASC" on 0
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS avatar_url FROM cpg14x_comments AS c LEFT JOIN `adventure_e107`.e107_user AS ' at line 1
Fichier: /www/987mb.com/a/d/v/adventure/htdocs/coppermine/include/functions.inc.php - Ligne: 248
USER:
------------------
Array
(
[ID] => 5fa9580dd3a68b51bebc15a0eb8ba431
[am] => 1
[lang] => french
[sort] => na
[liv] => Array
(
- => 669
[1] => 659
[2] => 1316
[3] => 936
[4] => 660
)
[search] => Array
(
[search] => catherine
[album] => search
[title] => on
[newer_than] =>
[caption] => on
[older_than] =>
[keywords] => on
[type] => AND
[filename] => on
[params] => Array
(
[title] => on
[caption] => on
[keywords] => on
[filename] => on
)
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => Administrateur
[groups] => Array
(
- => 2
[1] => 1
)
[has_admin_access] => 1
[can_see_all_albums] => 1
[disk_max] => 1024
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[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] => 0
[can_create_albums] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[group_name] => Registered
[upload_form_config] => 3
[group_quota] => 0
[group_id] => 2
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => SELECT * FROM cpg14x_bridge (0s)
[3] => SELECT * FROM `XXXXXXX`.e107_userclass_classes WHERE `userclass_name` = 'COPPERMINE_ADMIN' (0s)
[4] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MIN(can_rate_pictures) as can_rate_pictures, MIN(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MIN(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MIN(can_post_comments) as can_post_comments, MIN(can_upload_pictures) as can_upload_pictures, MIN(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MAX(pub_upl_need_approval) as pub_upl_need_approval, MAX( priv_upl_need_approval) as priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (2,1) (0s)
[5] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 2 (0s)
[6] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
[7] => SELECT count(*) FROM cpg14x_pms WHERE owner=1 (0s)
[8] => SELECT count(*) FROM cpg14x_pms WHERE owner=1 AND showed='0' (0s)
[9] => SELECT count(*) FROM cpg14x_buddy WHERE user_id=1 (0s)
[10] => SELECT count(*) FROM cpg14x_buddy_req WHERE buddy_to=1 (0s)
[11] => DELETE FROM cpg14x_banned WHERE expiry < '2008-04-21 23:18:15' (0s)
[12] => SELECT * FROM cpg14x_banned WHERE (ip_addr='80.170.6.209' OR ip_addr='80.170.6.209' OR user_id=1) AND brute_force=0 (0s)
[13] => SELECT aid from cpg14x_pictures WHERE pid='1021' LIMIT 1 (0s)
[14] => SELECT title,keyword from cpg14x_albums WHERE aid='4' (0s)
[15] => SELECT COUNT(*) from cpg14x_pictures WHERE ((aid='4' ) ) (0s)
[16] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from cpg14x_pictures WHERE ((aid='4' ) ) ORDER BY filename ASC (0.006s)
[17] => SELECT title,keyword from cpg14x_albums WHERE aid='4' (0s)
[18] => SELECT COUNT(*) from cpg14x_pictures WHERE ((aid='4' ) ) (0s)
[19] => SELECT * from cpg14x_pictures WHERE ((aid='4' ) ) ORDER BY filename ASC LIMIT 367 ,1 (0.006s)
[20] => SELECT title, comments, votes, category, aid FROM cpg14x_albums WHERE aid='4' LIMIT 1 (0.001s)
[21] => SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u. AS avatar_url FROM cpg14x_comments AS c LEFT JOIN `XXXXXXXX`.e107_user AS u ON c.author_id=u.user_id WHERE pid='1021' ORDER BY c.msg_id ASC (0s)
[22] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)
==========================
GET :
------------------
Array
(
[album] => random
[cat] => 0
[pos] => -1021
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 5.1.6 - OK
------------------
mySQL version: 5.0.27-Debian_0.dotdeb.1
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support:
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.27
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.2
Linked Version 1.2.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | On
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 | system,exec,curl_setopt,curl_init,curl_close,curl_exec,shell_exec,passthru,set_time_limit,error_log,ini_alter,dl,mb_send_mail,proc_open,pfsockopen,openlog,syslog,readlink,symlink,link,leak,fsockopen,popen,escapeshellcmd,apache_child_terminate apache_get_modules,apache_get_version,apache_getenv,apache_note,apache_setenv,virtual,readfile | system,exec,curl_setopt,curl_init,curl_close,curl_exec,shell_exec,passthru,set_time_limit,error_log,ini_alter,dl,mb_send_mail,proc_open,pfsockopen,openlog,syslog,readlink,symlink,link,leak,fsockopen,popen,escapeshellcmd,apache_child_terminate apache_get_modules,apache_get_version,apache_getenv,apache_note,apache_setenv,virtual,readfile
file_uploads | On | On
include_path | .:/usr/share/php | .:/usr/share/php
open_basedir | no value | 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 | 10 | 10
max_input_time | 10 | 10
upload_max_filesize | 1M | 1M
post_max_size | 1M | 1M
==========================
Page generated in 0.301 seconds - 23 queries in 0.013 seconds - Album set : ; Meta set: ;
Remarques
Notice line 51: ob_end_clean() [ref.outcontrol]: failed to delete buffer. No buffer to delete.[/b]
Cordialement.
Avez-vous oublié de faire un UPDATE.PHP ?
Using a bridge not supported by the modpack. Currently phpbb 2.x, smf 1.x, punbb1.2.
Announcement thread for more info: http://forum.coppermine-gallery.net/index.php/topic,28367.0.html
traduction du post de Stramm (thank's Stramm for your support)
il semble que vous utilisez un bridge non supporté actuellement par le ModPack
Quote from: Pascal YAP on April 21, 2008, 09:31:40 PM
Avez-vous oublié de faire un UPDATE.PHP ?
Non, je l'avais bien fait.
Merci.
Quote from: François Keller on April 21, 2008, 10:48:05 PM
traduction du post de Stramm (thank's Stramm for your support)
il semble que vous utilisez un bridge non supporté actuellement par le ModPack
Effectivement, mon CMS étant e107, j'utilise un bridge "cpg_bridge_v1.02" que j'ai obtenu ici: http://coppermine-gallery.net/forum/index.php?topic=36151.0 (http://coppermine-gallery.net/forum/index.php?topic=36151.0)
Ce bridge n'est pas sur la liste de Stramm. Je vais donc désinstaller le modpack et surveiller si Stramm ou un collaborateur codent et mettent en ligne le bridge adéquat.
Thank you Stramm, merci à tous !
PS Je considère ma discussion close.