Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: New coppermine gallery unable to view full image when clicking on thumb  (Read 5726 times)

0 Members and 1 Guest are viewing this topic.

greymouser69

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

Hello, I have a freshly installed coppermine gallery bridged successfully to joomla but we are having a problem viewing full sized images.

Clicking on a thumbnail gives the oh so informative error:  "There was an error while processing a database query."

Enabling debug mode shows:
Code: [Select]
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 `joomla`.jos_users AS u ON c.author_id=u.id WHERE pid='8' ORDER BY c.msg_id DESC" on 0

mySQL error:
File: /var/www/html2/cpg/include/functions.inc.php - Line: 248

More debug info:
Code: [Select]
USER:
------------------
Array
(
    [ID] => ab9d82c4095e099207c7e223b2dc4a9e
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 64
    [user_name] => greymouser
    [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] => 1
    [num_URI_upload] => 1
    [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 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 (1) (0s)
    [4] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [5] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 64 (0s)
    [6] => SELECT count(*) FROM  cpg14x_pms WHERE owner=64 (0s)
    [7] => SELECT count(*) FROM  cpg14x_pms WHERE owner=64 AND showed='0' (0s)
    [8] => SELECT count(*) FROM  cpg14x_buddy WHERE user_id=64 (0s)
    [9] => SELECT count(*) FROM  cpg14x_buddy_req WHERE buddy_to=64 (0s)
    [10] => DELETE FROM cpg14x_banned WHERE expiry < '2008-03-18 09:06:23' (0s)
    [11] => SELECT * FROM cpg14x_banned WHERE (ip_addr='199.44.153.216' OR ip_addr='199.44.153.216' OR user_id=64) AND brute_force=0 (0s)
    [12] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES'  (0s)
    [13] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,1 (0s)
    [14] => SELECT title, comments, votes, category, aid FROM cpg14x_albums WHERE aid='2' LIMIT 1 (0s)
    [15] => SELECT username as user_name FROM `joomla`.jos_users WHERE id = '64' (0s)
    [16] => SELECT cid, name, parent FROM cpg14x_categories WHERE cid = '1' (0s)
    [17] => SELECT cid, name, parent FROM cpg14x_categories WHERE cid = '2' (0s)
    [18] => 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 `joomla`.jos_users AS u ON c.author_id=u.id WHERE pid='8' ORDER BY c.msg_id DESC (0s)
    [19] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.1.6 - OK
------------------
mySQL version: 5.0.22-log
------------------
Coppermine version: 1.4.16(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 1
Active Links 5
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 | .:/usr/share/pear | .:/usr/share/pear
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 | 86400 | 86400
max_input_time | 86400 | 86400
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.336 seconds - 20 queries in 0 seconds - Album set : ; Meta set: ;

Additional notices:
Code: [Select]
raries/joomla/language/language.php

    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.com_coppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.com_coppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_shoutbox.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_shoutbox.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_extcoppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_extcoppermine.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_uddeim.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_uddeim.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_uddeim_mailbox.ini) [function.file-get-contents]: failed to open stream: No such file or directory
    * Warning line 335: file_get_contents(/var/www/html2/language/en-GB/en-GB.mod_uddeim_mailbox.ini) [function.file-get-contents]: failed to open stream: No such file or directory

ules/mod_shoutbox/mod_shoutbox.php

    * Notice line 327: Use of undefined constant _CONTACT_NAME - assumed '_CONTACT_NAME'
    * Notice line 406: Use of undefined constant _SEND_BUTTON - assumed '_SEND_BUTTON'

ponents/com_banners/models/banner.php

    * Notice line 36: Undefined index: tag_search

raries/joomla/environment/uri.php

    * Notice line 366: Undefined index: Itemid
    * Notice line 366: Undefined index: option
    * Notice line 366: Undefined index: Itemid
    * Notice line 366: Undefined index: option
    * Notice line 366: Undefined index: Itemid
    * Notice line 366: Undefined index: option
    * Notice line 366: Undefined index: Itemid
    * Notice line 366: Undefined index: option
    * Notice line 366: Undefined index: Itemid

/bridge/joomla15.inc.php

    * Notice line 278: Undefined property: JDatabaseMySQL::$_ressource

/include/themes.inc.php

    * Notice line 226: Undefined variable: USER_ID
    * Notice line 823: Undefined variable: pm_link
    * Notice line 2294: Undefined index: uid

/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

The gallery can be reached directly at http://www.thelostcastle.net/cpg/ and I currently have debug mode turned on for all.

Any help would be appreciated!
« Last Edit: March 18, 2008, 04:52:25 pm by Nibbler »
Logged

greymouser69

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

Forgot to mention its running the cpg1.4 modpack by Stramm as well and I also posted an issue on that forum in case it may be related to the mod pack.
Logged

Nibbler

  • Guest

Does the modpack support joomla bridging? I think not.
Logged

greymouser69

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

Well it says it should support most bridges...  Most everything seems to work, but I have figured out that the problem lies with it trying to pull an avatar image even though I have user avatars turned off in the config section.
Logged

Nibbler

  • Guest

most <> all.

You need to modify the joomla bridge file to make it compatible. Try http://forum.coppermine-gallery.net/index.php/topic,45626.0.html or search the board for related posts.
Logged

greymouser69

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

most <> all.

You need to modify the joomla bridge file to make it compatible. Try http://forum.coppermine-gallery.net/index.php/topic,45626.0.html or search the board for related posts.

Very true Nibb :)

Ok it seems the simplest solution was to add a null field to the user table and point avatar_url in the bridge to that field.  I did that and the problem is solved.

Thanks and sorry for the trouble!
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.