[Problème] CPG 1.4.18 - Modpack Stramm - Intégration Joomla mehdiplugins

[Almeyric]

Bonjour,

Je suis entrain de faire un site sous joomla avec une galerie cpg 1.4.18 bridgé avec Mehdiplugins. Jusque là aucun soucis.

Etant a la recherche d'une fonction watermark, j'ai rajouté le modpack Stramm. Et là, je ne vois plus l'image intermédiaire. J'ai bien vu après coup sur le site de medhiplugins, qu'il y avait un soucis entre eux.

J'aimerais savoir si quelqu'un a réussi à resoudre ce problème ?

Le lien web : http://almeyric.hobby-site.org/public/hdccovers/galerie

Sinon voici ce que j'obtiens en mode débogue :

Code Select Expand

Erreur critique

Il y eu une erreur lors de l'exécution de la requête.

Code Select Expand

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 `hdccovers`.jos_users AS u ON c.author_id=u.id WHERE pid='19' ORDER BY c.msg_id ASC" on Resource id #28

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 `hdccovers`.jos_users AS u ON ' at line 1


Code Select Expand

USER:
------------------
Array
(
    [ID] => a664ab6e7424af7bb19bb14571c563e8
    [am] => 1
    [lang] => french
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 63
    [user_name] => Almeyric
    [groups] => Array
        (
            [0] => 125
        )

    [disk_max] =>
    [disk_min] =>
    [can_rate_pictures] =>
    [can_send_ecards] =>
    [ufc_max] =>
    [ufc_min] =>
    [custom_user_upload] =>
    [num_file_upload] =>
    [num_URI_upload] =>
    [can_post_comments] =>
    [can_upload_pictures] =>
    [can_create_albums] =>
    [has_admin_access] => 1
    [pub_upl_need_approval] =>
    [priv_upl_need_approval] =>
    [group_name] =>
    [upload_form_config] =>
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 125
)

==========================
Queries:
------------------
Array
(
    [0] => 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 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 cpg14x_usergroups WHERE group_id in (125) (0s)
    [4] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 125 (0s)
    [5] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 63 (0s)
    [6] => SELECT count(*) FROM  cpg14x_pms WHERE owner=63 (0s)
    [7] => SELECT count(*) FROM  cpg14x_pms WHERE owner=63 AND showed='0' (0s)
    [8] => SELECT count(*) FROM  cpg14x_buddy WHERE user_id=63 (0s)
    [9] => SELECT count(*) FROM  cpg14x_buddy_req WHERE buddy_to=63 (0s)
    [10] => DELETE FROM cpg14x_banned WHERE expiry < '2008-05-06 10:31:34' (0s)
    [11] => SELECT * FROM cpg14x_banned WHERE (ip_addr='195.25.174.52' OR ip_addr='195.25.174.52' OR user_id=63) AND brute_force=0 (0s)
    [12] => SELECT aid from cpg14x_pictures WHERE pid='19'  LIMIT 1 (0.001s)
    [13] => SELECT title,keyword from cpg14x_albums WHERE aid='2' (0s)
    [14] => SELECT COUNT(*) from cpg14x_pictures WHERE ((aid='2'  ) )   (0s)
    [15] => 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='2'  ) )   ORDER BY filename ASC  (0s)
    [16] => SELECT title,keyword from cpg14x_albums WHERE aid='2' (0s)
    [17] => SELECT COUNT(*) from cpg14x_pictures WHERE ((aid='2'  ) )   (0s)
    [18] => SELECT * from cpg14x_pictures WHERE ((aid='2'  ) )   ORDER BY filename ASC  LIMIT 3 ,1 (0.001s)
    [19] => SELECT title, comments, votes, category, aid FROM cpg14x_albums WHERE aid='2' LIMIT 1 (0s)
    [20] => SELECT name, parent FROM cpg14x_categories WHERE cid = '6' (0s)
    [21] => SELECT cid, name, parent FROM cpg14x_categories WHERE cid = '2' (0s)
    [22] => SELECT cid, name, parent FROM cpg14x_categories WHERE cid = '7' (0s)
    [23] => 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 `hdccovers`.jos_users AS u ON c.author_id=u.id WHERE pid='19' ORDER BY c.msg_id ASC (0s)
    [24] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
    [album] => random
    [cat] => 0
    [pos] => -19
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.5 - OK
------------------
mySQL version: 5.0.51a-community-nt
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
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 2
Client API version 5.0.45
==========================
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 | .;C:\php5\pear | .;C:\php5\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | no value | no value
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 | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.586 seconds - 25 queries in 0.002 seconds - Album set : ; Meta set: ;

Code Select Expand

Remarques
es\ja_fagus\ja_menus\Base.class.php

    * Notice line 44: Undefined variable: children
    * Notice line 44: Undefined index: 6
    * Notice line 244: Undefined index: 1
    * Notice line 244: Undefined index: 7
    * Notice line 244: Undefined index: 3

es\ja_fagus\ja_menus\CSSmenu.class.php

    * Notice line 26: Undefined index: 1
    * Notice line 27: Undefined index: 7
    * Notice line 26: Undefined index: 3

s\pathway.php

    * Notice line 112: Undefined offset: 88888888
    * Notice line 112: Trying to get property of non-object

\mod_mainmenu.php

    * Notice line 265: Undefined index: 0
    * Notice line 265: Undefined index: 6
    * Notice line 292: Undefined offset: 0
    * Notice line 292: Undefined offset: 0

\include\themes.inc.php

    * Notice line 226: Undefined variable: USER_ID
    * Notice line 912: Undefined variable: pm_link
    * Notice line 2294: Undefined index: uid
    * Notice line 2374: Undefined variable: ecard_tgt
    * Notice line 2375: Undefined variable: ecard_title
    * Notice line 2382: Undefined variable: report_tgt

\include\functions.inc.php

    * Notice line 88: Undefined variable: cpg_show_private_album

\bridge\udb_base.inc.php

    * Notice line 884: Undefined index: avatar_url

[François Keller]

bonjour,

le problème est je pense en partie que le bridge de mehdi est un hack plutôt qu'un bridge.
mais je n'ai pas de solution désolé  :-\

[Stramm]

http://forum.coppermine-gallery.net/index.php/topic,45626.0.html

[Almeyric]

Bon, je suis pas très bon en anglais. Mais je pense avoir fait les bonnes modifs dans joomla.inc.php donné par stramm.
Mais cela ne résoud rien. Si je comprend bien, il dit de comparer le fichier phpbb2018.inc.php avec le joomla.inc.php et de rajouté les 4 lignes. Etant donné que le forum est un smf 1.x je me suis basé sur celui là. Mais pareil, change rien.

Il dit aussi qu'il faut préciser le lien des avatars dans la configuration, mais je ne trouve pas ou ? De plus, la fonction avatar est sur non.

Sinon j'ai plus simple, je désinstalle le mod et je laisse l'intégration. Là, ça va marcher. Mais j'aimerai avoir la fonction Watermark du mod. Est-ce qu'il serait possible de simplement la rajouter ? Comme ça, je n'aurait pas de soucis d'intégration et j'aurai le watermark.