[Known Issue]: modpack de Stramm v1-CPG 1.4.18: problème d'affichage des photos

[PicFanatic]

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.

[François Keller]

il serait intéressant d'avoir le message d'erreur complet en activant le mode de débugage.

[PicFanatic]

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.
  

[Pascal YAP]

Avez-vous oublié de faire un UPDATE.PHP ?

[Stramm]

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

[François Keller]

traduction du post de Stramm (thank's Stramm for your support)
il semble que vous utilisez un bridge non supporté actuellement par le ModPack

[PicFanatic]

Avez-vous oublié de faire un UPDATE.PHP ?

Non, je l'avais bien fait.

Merci.

[PicFanatic]

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
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.