Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error on e-mail notification of new comments  (Read 7502 times)

0 Members and 1 Guest are viewing this topic.

Schnauzermom

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Error on e-mail notification of new comments
« on: October 03, 2006, 10:57:15 pm »

Coppermine 1.49, bridged to phpBB 2.0.21. Applied the mod, and my users couldn't click on thumbnails without received a database error.

I made the changes documented here:

http://forum.coppermine-gallery.net/index.php?topic=35177.0

..which fixed that error.

However, if they turn ON e-mail notification of new comments, the commenting user receives:

There was an error while processing a database query.

While executing query "SELECT n.user_id, n.mail_sent, u.user_email, u.username, p.owner_id, p.owner_name, p.title, p.filename  FROM cpg148_notify AS n INNER JOIN `db169772585`.phpbb_users AS u ON n.user_id=u.user_id  INNER JOIN cpg148_pictures AS p ON n.picture_id=p.pid WHERE n.picture_id=129" on Resource id #17

mySQL error: Table 'db169772585.cpg148_notify' doesn't exist

File: /homepages/24/d166997933/htdocs/scrapdawgs/gallery/include/functions.inc.php - Line: 248

USER:
------------------
Array
(
    [ID] => e2e21531c0d085fa8a85bfb84e087b3c
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 3
    [user_name] => Schnauzermom
    [groups] => Array
        (
           
  • => 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] => 5
    [num_URI_upload] => 3
    [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
(
   
  • => SELECT extension, mime, content, player FROM cpg148_filetypes; (0.001s)
  • [1] => select * from cpg148_plugins order by priority asc; (0s)
        [2] => SELECT * FROM cpg148_bridge (0s)
        [3] => SELECT u.user_id AS user_id, u.user_password AS password, u.user_level FROM `db169772585`.phpbb_users AS u, `db169772585`.phpbb_sessions AS s WHERE u.user_id=s.session_user_id AND s.session_id = '5a3b142d139124892d40c7e8200d4686' AND u.user_id > 0 (0s)
        [4] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, u.user_avatar AS avatar_url, u.user_notify_pm AS notify, u.user_notify AS auto_subscribe_post, u.user_notify AS auto_subscribe_comment, ug.group_id AS group_id FROM `db169772585`.phpbb_users AS u, `db169772585`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='3' (0s)
        [5] => 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 cpg148_usergroups WHERE group_id in (1) (0s)
        [6] => SELECT group_name FROM  cpg148_usergroups WHERE group_id= 1 (0s)
        [7] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 3 (0s)
        [8] => SELECT count(*) FROM  cpg148_pms WHERE owner=3 (0s)
        [9] => SELECT count(*) FROM  cpg148_pms WHERE owner=3 AND showed='0' (0s)
        [10] => DELETE FROM cpg148_banned WHERE expiry < '2006-10-03 16:54:11' (0s)
        [11] => SELECT * FROM cpg148_banned WHERE (ip_addr='75.7.197.49' OR ip_addr='75.7.197.49' OR user_id=3) AND brute_force=0 (0s)
        [12] => SELECT comments FROM cpg148_pictures, cpg148_albums WHERE cpg148_pictures.aid = cpg148_albums.aid AND pid='129' (0.001s)
        [13] => SELECT author_md5_id, author_id FROM cpg148_comments WHERE pid = '129' ORDER BY msg_id DESC LIMIT 1 (0.001s)
        [14] => INSERT INTO cpg148_comments (pid, msg_author, msg_body, msg_date, author_md5_id, author_id, msg_raw_ip, msg_hdr_ip) VALUES ('129', 'Schnauzermom', 'test', NOW(), '', '3', '75.7.197.49', '75.7.197.49') (0.001s)
        [15] => SELECT *, user_notify AS auto_subscribe_comment FROM `db169772585`.phpbb_users WHERE user_id = '3' (0.001s)
        [16] => SELECT n.user_id, n.mail_sent, u.user_email, u.username, p.owner_id, p.owner_name, p.title, p.filename  FROM cpg148_notify AS n INNER JOIN `db169772585`.phpbb_users AS u ON n.user_id=u.user_id  INNER JOIN cpg148_pictures AS p ON n.picture_id=p.pid WHERE n.picture_id=129 (0.016s)
        [17] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0.001s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
       
[msg_author] => Schnauzermom
    [msg_body] => test
    [event] => comment
    [pid] => 129
    [submit] => OK
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.4 - OK
------------------
mySQL version: 4.0.27-standard-log
------------------
Coppermine version: 1.4.9(stable)
==========================
Module: GD
------------------
GD Version: 2.0 or higher
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
XBM Support:
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 4.0.25
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
Compiled Version 1.2.1
Linked Version 1.2.1
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/local/lib/php | .:/usr/local/lib/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 | 50000 | 50000
max_input_time | -1 | -1
upload_max_filesize | 20M | 20M
post_max_size | 8M | 8M
==========================
Page generated in 0.176 seconds - 18 queries in 0.022 seconds - Album set : ; Meta set: ;


I suspect this is a continuation of the first error that I resolved, but I'll freely admit I don't know enough to fix it. So, I've turned this function off for now.

Any assistance would be great!
« Last Edit: October 04, 2006, 07:18:43 pm by Stramm »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Logged

Schnauzermom

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Error on e-mail notification of new comments
« Reply #2 on: October 04, 2006, 01:45:34 am »

I've been thru those threads, a few times. One of them points to the change I've already made, which fixed the problem of folks getting a database error when clicking on a thumbnail.

That bit didn't fix the e-mail reply problem, tho. And if there's something else there, I'm just not seeing it.
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Error on e-mail notification of new comments
« Reply #3 on: October 04, 2006, 09:02:29 am »

will install phpbb and see if I can reproduce this

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Error on e-mail notification of new comments
« Reply #4 on: October 04, 2006, 11:16:52 am »

Update the modpack (link in my sig) and please tell me if things work for you. You won't have to do the changes in the link you posted above anymore.

Changes done:
If there are no joins possible cause cpg and the forum are in different databases then the script will use an extra query for
a) the avatar URL in the comments
b) to get the email of subscribed users to send them a comment notification

If joins are possible then it behaves as usual and doesn't do the extra query

Schnauzermom

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Error on e-mail notification of new comments
« Reply #5 on: October 04, 2006, 05:39:41 pm »

I updated those 4 files, in their appropriate directories, and now I'm back to having a database error when clicking on a thumbnail. I did disable, then re-enable, bridging....? I also put back the original udb_base.inc.php, and that made no difference.
« Last Edit: October 04, 2006, 05:45:37 pm by Schnauzermom »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Error on e-mail notification of new comments
« Reply #6 on: October 04, 2006, 06:32:01 pm »

nope, update the entire modpack with  'Modpack v2 for CPG 1.4.9 bridge support'
http://stramm.st.funpic.org/displayimage.php?pos=-145

then, if you want, the 4 files ('Modpack v2 for CPG 1.4.9 cropping fix')
this never was available for the modpack and I didn't intend to do it for CPG 1.4. But cause I've done it for the next CPG I've ported it back

Schnauzermom

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Error on e-mail notification of new comments
« Reply #7 on: October 04, 2006, 07:08:22 pm »

My misunderstanding - sorry!  ::)

I've applied the updated modpack, and those 4 files. Both errors are gone! Thanks so much!
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.