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: Mehdi Stramm Coppermine  (Read 4600 times)

0 Members and 1 Guest are viewing this topic.

spiritweb

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Mehdi Stramm Coppermine
« on: July 08, 2008, 02:58:22 pm »

Heya There Stramm
The Mod looksreally good, and having spent a little time making it friends with the Mehdi bridge (I have a working installable stramm mod to distribute) so that I can run coppermine stramm mod within joomla, I am left with one error, when I go to view the image having clicked on a thumbnail I recieve the following error:

Critical error

There was an error while processing a database query.

here is some debug info I have:

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 pic_comments AS c LEFT JOIN `judopengui1`.jdo_users AS u ON c.author_id=u.id WHERE pid='13' ORDER BY c.msg_id ASC" on 0

mySQL error:

USER:
------------------
Array
(
    [ID] => 777b2ce0636bdb435070d0d3ca9e003f
    [am] => 1
    [lang] => english_gb
    [liv] => Array
        (
            [0] => 3
            [1] => 6
            [2] => 2
        )

    [sort] => pa
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 62
    [user_name] => Fatal Cleric
    [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 pic_filetypes; (0.017s)
    [1] => select * from pic_plugins order by priority asc; (0.017s)
    [2] => SELECT * FROM pic_bridge (0.02s)
    [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 pic_usergroups WHERE group_id in (125) (0.018s)
    [4] => SELECT group_name FROM  pic_usergroups WHERE group_id= 125 (0.016s)
    [5] => SELECT user_favpics FROM pic_favpics WHERE user_id = 62 (0.018s)
    [6] => SELECT count(*) FROM  pic_pms WHERE owner=62 (0.02s)
    [7] => SELECT count(*) FROM  pic_pms WHERE owner=62 AND showed='0' (0.017s)
    [8] => SELECT count(*) FROM  pic_buddy WHERE user_id=62 (0.016s)
    [9] => SELECT count(*) FROM  pic_buddy_req WHERE buddy_to=62 (0.017s)
    [10] => DELETE FROM pic_banned WHERE expiry < '2008-07-08 12:50:43' (0.018s)
    [11] => SELECT * FROM pic_banned WHERE (ip_addr='88.110.215.130' OR ip_addr='88.110.215.130' OR user_id=62) AND brute_force=0 (0.017s)
    [12] => SELECT aid from pic_pictures WHERE pid='13'  LIMIT 1 (0.018s)
    [13] => SELECT title,keyword from pic_albums WHERE aid='2' (0.016s)
    [14] => SELECT COUNT(*) from pic_pictures WHERE ((aid='2'  ) )   (0.018s)
    [15] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from pic_pictures WHERE ((aid='2'  ) )   ORDER BY position ASC  (0.019s)
    [16] => SELECT title,keyword from pic_albums WHERE aid='2' (0.017s)
    [17] => SELECT COUNT(*) from pic_pictures WHERE ((aid='2'  ) )   (0.017s)
    [18] => SELECT * from pic_pictures WHERE ((aid='2'  ) )   ORDER BY position ASC  LIMIT 7 ,1 (0.022s)
    [19] => SELECT title, comments, votes, category, aid FROM pic_albums WHERE aid='2' LIMIT 1 (0.017s)
    [20] => SELECT name, parent FROM pic_categories WHERE cid = '2' (0.019s)
    [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 pic_comments AS c LEFT JOIN `judopengui1`.jdo_users AS u ON c.author_id=u.id WHERE pid='13' ORDER BY c.msg_id ASC (0.018s)
    [22] => SELECT COUNT(*) FROM pic_pictures WHERE approved = 'NO' (0.018s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.6 - OK
------------------
mySQL version: 5.0.22
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 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 0
Active Links 3
Client API version 5.0.41
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 | shell_exec,exec,system,passthru,popen,set_time_limit | shell_exec,exec,system,passthru,popen,set_time_limit
file_uploads | On | On
include_path | .:/usr/share/pear-php5 | .:/usr/share/pear-php5
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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 20M | 20M
post_max_size | 8M | 8M
==========================
Page generated in 1.397 seconds - 23 queries in 0.41 seconds - Album set : ; Meta set: ;

any idears what I may have to do to repair the error XD, it would be nice to pass you the stramm version that works within joomla via mehdi bridge

 but I can't till I get it working
« Last Edit: July 08, 2008, 03:03:54 pm by Hein Traag »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Mehdi Stramm Coppermine
« Reply #1 on: July 08, 2008, 03:58:57 pm »

use one of the avatar mods for joomla or remove the avatar calls (udb_base.inc.php -> function get_comments())

spiritweb

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Mehdi Stramm Coppermine
« Reply #2 on: July 08, 2008, 11:58:42 pm »

Heya Stramm
Thanks for getting back  :)
I looked at that function and yes, I can see the call there, so I commented it out, but then I had another call to undefined function error, so I removed that from theme.php, which lead to another error, and before I knew it, I had commented out 90% of the mod :(
Im guessing theres a problem with it reading the database, maybe I should forget the whole thing.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Mehdi Stramm Coppermine
« Reply #3 on: July 09, 2008, 07:47:43 am »

commenting out won't help, you just need to remove the avatar path (deleting it within the query)... f

Code: [Select]
, u.{$this->field['avatar_url']} AS avatar_url
If your database can't use joins, then look the avatar query up near the function call and there you can comment it out entirely
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.