Error on e-mail notification of new comments

[Schnauzermom]

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!

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=36859.msg173389#msg173389

[Schnauzermom]

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.

[Stramm]

will install phpbb and see if I can reproduce this

[Stramm]

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]

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.

[Stramm]

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]

My misunderstanding - sorry! 

I've applied the updated modpack, and those 4 files. Both errors are gone! Thanks so much!