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: Email Comments for CPG 1.6  (Read 668 times)

0 Members and 1 Guest are viewing this topic.

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 774
    • GMC Design Photo Gallery
Email Comments for CPG 1.6
« on: November 17, 2018, 03:09:51 pm »

This is a port of my cpg1.5.x plugin email_comments

Updates:
  • Eliminate direct calls to MySQL functions and convert to CPG wrapper functions that use the CPG database abstraction layer.
    MySQL functions are removed in PHP 7.
  • German language file contributed by cmfa.
  • Errant ) removed from display reported by cmfa
  • 'show/hide plugin options' added to language file reported by cmfa (already in german language file as well)
See thread http://forum.coppermine-gallery.net/index.php/topic,78163.0.html for the history under 1.5.

« Last Edit: November 17, 2018, 03:21:27 pm by gmc »
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 849
  • +Tinyportal Support team.
Re: Email Comments for CPG 1.6
« Reply #1 on: November 19, 2018, 08:39:55 pm »

Had reports of errors when my members posted comments.  Turned this plugin off and the comments post fine,  but turn it on and make a comment it gives me this error on page,

Critical Error
There was an error while processing a database query.
Logged
Running SMF 2.0.13  / Tinyportal 1.2, bridged with Coppermine 1.5.34, plus cpmfetch 2.0.0

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 774
    • GMC Design Photo Gallery
Re: Re: Email Comments for CPG 1.6
« Reply #2 on: November 20, 2018, 12:38:03 am »

Had reports of errors when my members posted comments.  Turned this plugin off and the comments post fine,  but turn it on and make a comment it gives me this error on page,

Critical Error
There was an error while processing a database query.
Can you turn on debug (for admin at least) and see what the real error message is??
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

lurkalot

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 849
  • +Tinyportal Support team.
Re: Email Comments for CPG 1.6
« Reply #3 on: November 20, 2018, 09:13:43 am »

Thanks.  Just turned it on and enabled the plugin. Then made comment to generate the error.  This is a bridged setup with SMF 2.0.15 if that's any help.

Version Information:
Forum version: SMF 2.0.15 (more detailed)
Current SMF version: SMF 2.0.15
GD version: bundled (2.1.0 compatible)
Database Server: MySQL
MySQL version: 5.6.41
PHP: 5.6.38
Server version: Apache


Critical error

There was an error while processing a database query.

While executing query 'SELECT email_address AS user_email, id_member AS user_id, real_name AS username  FROM `caxxxx_sxxd`.smf_members WHERE id_member IN (, )' in plugins/email_comments/codebase.php on line 182

database error: 1064 : 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 ' )' at line 1

File: /hxxx/xxxxxx/public_html/gallery/include/functions.inc.php - Line: 250 
Logged
Running SMF 2.0.13  / Tinyportal 1.2, bridged with Coppermine 1.5.34, plus cpmfetch 2.0.0
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.