forum.coppermine-gallery.net

Support => cpg1.4 plugins => cpg1.4.x Support => Older/other versions => cpg1.4 plugin contributions => Topic started by: Stramm on January 17, 2007, 02:28:02 pm

Title: Newsletter Plugin
Post by: Stramm on January 17, 2007, 02:28:02 pm

This one is pretty much a pluginized version of the 1.3 mod I posted ~ 2 years ago. Therefore the code isn't that pretty but works. No code cleanup or improvements added except that it only works with the modpack.
Reason for the restriction to the modpack: I do not like newsletter scripts to much. But sometimes they come in pretty handy. Still the users should have the possibility to opt out. This they can do when unchecking 'Allow admin emails' in their profile. Or the similar setting in a bridged environment (should work bridged but I haven't tested that at all).

How does it work:
Unzip the archive in the plugin dir, install it via the coppermine config. Now you'll see a new button 'Newsletter' in the admin menu. A click on it gives you the option to 1. send mail or 2. check the archive. Check archive lets you view/ delete old newsletters you've sent. Send mail allows you to create a new mail template or to edit an old one and resend it.
When you've created/ edited your template (you can use the placeholder {username} to insert the username), hit send and you come to an options page.

How to send mails: php_mail or sendmail, php_mail means what you've set in coppermine config or you can force sendmail (excluding coppermines mailer include)
Sendmail path: The path to sendmail if you've chosen above to use it
Server OS: should be self detecting, uses \r\n as linefeed for win and \n for nix
How many mails per batch: Best is to use a low value even if that needs longer. Timeout problems won't occur or at least not that often. The newsletter will send the number of set emails, refreshes the page and sends the next batch
Send as preview: If checkt the plugin won't send the newsletter but only a preview to the admin
Automatic wordwrap after 72 chars: If checked the wordwrap every 72 chars is enabled

Click send and the plugin will send away

What if I run into a timeout: I only experienced that with huge batches and/ or invalid email addies.
Check the address bar and find an entry lastmailed=xxx, raise the xxx number and hit the browsers reload button. The plugin will continue to send
eg lastmailed=180, your batch size is 20, then set it to lastmailed=200, the plugin will continue at email nr. 200
or you set nummails=1 (batch size), then you'll see exactly what email makes the troubles, then raise lastmailed by one and edit the trouble email.

edit: Translations are welcome (see plugin/newsletter/lang/english.php as reference, use the lang file naming scheme coppermine uses - see the lang dir)

Title: Re: Newsletter Plugin
Post by: twogayther on January 17, 2007, 03:12:03 pm

Hi

I have a probleme with this plugin.
I install it and after when i use menu newsletter i have this error :
Fatal error: main() [function.require]: Failed opening required 'plugins/newsletter/include/functions.inc.php' (include_path='/mnt/105/sdb/c/a/godeboy/include:.:/usr/php4/lib/php') in /mnt/105/sdb/c/a/godeboy/plugins/newsletter/newsletter.php on line 9

In adress bar i can see this url http://mysite.com/index.php?file=newsletter/newsletter

Isn't it here the problem ... ?
Thank and excuse because i don't speak english not at all

EDIT : I find the first problem the file function.inc.php was not in the good place .
but i have always a problem . Did anyone test it ?

Title: Re: Newsletter Plugin
Post by: Stramm on January 17, 2007, 05:12:40 pm

post a real url, don't rename the folder name 'newsletter'

Title: Re: Newsletter Plugin
Post by: twogayther on January 18, 2007, 12:06:42 pm

Hi,

I don't have rename folder newsletter
real url is http://godeboy.free.fr/index.php?file=newsletter/newsletter

here's the debogage info :

While executing query "SELECT count(user_id) AS num FROM `godeboy`.coppermine_users WHERE user_email <> '' AND = '1' AND user_active = 'YES'" on

mySQL error: 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 '= '1' AND user_active = 'YES'' at line 1

Fichier: /mnt/105/sdb/c/a/godeboy/include/functions.inc.php - Ligne: 249

Title: Re: Newsletter Plugin
Post by: Stramm on January 18, 2007, 02:31:28 pm

I don't see your coppermine gallery when opening http://www.mysite.com

and I clearly have written (in bold) in the first post of this thread, third sentence, that this plugin only works when you have the modpack installed. In the following sentences I have explained why...

Again, if you do not have the modpack installed it won't work. If you want support, post true URLs. Urls, when I click them that your coppermine gallery opens.

Don't post debug output unless requested. It tells you that above the debug output. I'm going to edit your above post to unclutter this thread. Please do more reading...

Title: Re: Newsletter Plugin
Post by: twogayther on January 18, 2007, 04:55:55 pm

Hi,

I explain you i dont' speack not at all english but i understand you're angry ...
but untderstand I do an personnal job when i wrote in english

I don't need help so ..

Not a problem
Have a nice day .
bye

Title: Re: Newsletter Plugin
Post by: angeldevil on January 18, 2007, 10:21:45 pm

Great work Stramm!! thank you ;D

finally one newsletter!

I've traslated in italian language

Title: Re: Newsletter Plugin
Post by: Stramm on January 19, 2007, 08:14:06 am

Thanks for the translation, much appreciated

Title: Re: Newsletter Plugin
Post by: Pascal YAP on January 19, 2007, 10:03:50 am

Mornin' Stramm,

Here's French lang

Because my Zipper is out today, i can'nt send a ZIP lang ???
Copy and Past in a new file nammed french.php

PYAP

Code: [Select]

<?php
/**************************************************
  CPG Newsletter Plugin for Coppermine Photo Gallery
  *************************************************
  Copyright (c) 2006 Thomas Lange <stramm@gmx.net>
  *************************************************
  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.
  *************************************************
  Coppermine version: 1.4.10
  Newsletter version: 1.01 Translation by PYAP
  $Revision: 1.0 $
  $Author: stramm $
***************************************************/
if (!defined('IN_COPPERMINE')) 
{
	die('Not in Coppermine...');
}
$lang_newsletter = array(
  	'uninstall' => 'Voulez-vous supprimer la table SQL dans laquelle les infos de votre Newsletter sont stockÃ©es ?',
	'admin_title' => 'NewsLetter',
    'title' => 'NewsLetter',
	'user' => 'Utilisateur',
	'pw' => 'Mot de Passe',
	'welcome' => 'Bienvenue sur le plugin NewsLetter... ',
	'mail_menu' => 'Menu',
	'send' => 'ExpÃ©diez le Mail',
	'archive' => 'Controlez Archive',
	'active_users' => 'Nombre de emails confirm&eacute; dans la base de donnÃ©s : ',
	'archive_welcome' => 'Archive Newsletter ',
	'show_archive_mail' => 'Montrez',
	'delete_archive_mail' => 'Supprimez',
    'subject' => 'Sujet de la NewsLetter',
	'content' => 'Contenu de la NewsLetter',
	'chose_send' => 'Faites une sÃ©lection',
	'create_new' => 'CrÃ©ez un nouvel email',
	'create_edit' => 'Editez un email existant et expÃ©diez-le de nouveau',
	'sending' => 'ExpÃ©diÃ©...',
	'date' => 'Date',
	'send' => 'ExpÃ©diez le email',
	'nomail_error' => 'ATTENTION : Vous avez sans doute oubliÃ© de taper une adresse email !',
	'sendmail_path' => 'Sendmail-path<br>(si vous avez choisi sendmail, <br>incl. option [-t])',
	'batch' => 'Combien de email dÃ©sirez-vous expÃ©dier par batch ?',
	'send_type' => 'Comment expÃ©dier les emails ?',
	'serveros' => 'Server OS',
	'preview' => 'ExpÃ©diez Ã  vous-mÃªme un preview',
	'wordwrap' => 'Automatic wordwrap apr&egrave; 72 caracteres',
	'sendmail_error' => 'Mauvais chemin (path) vers sendmail ou pas installÃ©',
	'edit_archive_mail' => 'SÃ©lectionnez',  
	'mailing' => 'Mailing ...',  
	'all_sent' => 'Tous les emails sont expÃ©diÃ©s',
	'preview_sent' => 'La prÃ©visualisation du email envoyÃ©<br><br>Vous pouvez fermer cette fenetre navigateur.<br><br><br><b>Si vous &egrave;tes satisfait de votre email, uncheck \'Expediez Ã¨ vous-meme un preview\' et tapez \'ExpÃ©diez\' de nouveau !!!</b>',
	'continue' => 'Continuez',  
	'click' => 'click',  
	'wait' => 'Attendez quelques instants...',  
  );
?>

edit by Stramm : attached the lang file as zip... thanks PYAP :)

Title: Re: Newsletter Plugin
Post by: marpessa on February 13, 2007, 12:38:28 am

I'd love to use this but I keep getting that error when I click on "newsletter" button.

Critical error: There was an error while processing a database query

Help? :)

Title: Re: Newsletter Plugin
Post by: Nibbler on February 13, 2007, 12:51:38 am

Enable debug mode and post the mysql error message (not the entire debug output) you get when you replicate the error.

Title: Re: Newsletter Plugin
Post by: Stramm on February 13, 2007, 09:42:04 am

have you read the very first post of this thread? Especially that part...

Quote

it only works with the modpack

Title: Re: Newsletter Plugin
Post by: Hein Traag on February 13, 2007, 10:05:22 am

Goodmorning!

dutch.php added as zip.

Hein

Title: Re: Newsletter Plugin
Post by: marpessa on February 13, 2007, 10:11:03 am

Quote from: Stramm on February 13, 2007, 09:42:04 am

have you read the very first post of this thread? Especially that part...

Oh... Where can I find the modepack and would it work with 1.4?

Title: Re: Newsletter Plugin
Post by: Hein Traag on February 13, 2007, 10:27:17 am

In the first post it is said it only works with the modpack (which Stramm made).
So you might want to go look in here http://forum.coppermine-gallery.net/index.php?board=81.0 (http://forum.coppermine-gallery.net/index.php?board=81.0)

Title: Re: Newsletter Plugin
Post by: Stramm on February 13, 2007, 12:13:37 pm

Hein, thank you for the translation ;D

Title: Re: Newsletter Plugin
Post by: antisa33 on March 20, 2007, 04:56:34 pm

Hello
The newsletter module seems good but i don't want to install the MOD pack, how can i do ?
Best regards

Title: Re: Newsletter Plugin
Post by: Joachim Müller on March 20, 2007, 05:51:30 pm

Not at all. Just read the posting just two above yours (posted by HJein): this mod will only work with the modpack. That's it. If you need it as standalone mod, go ahead and code it.

Title: Quest about list of users
Post by: natalina on March 23, 2007, 05:58:21 am

Hi, Stramm, Thank u very much for this plugin :) It works fine, just one question. When I send mail it is sent only to users who registered AFTER installig your mod. Can I manually insert others to Mysql table? If yes, please name the table & the field. Thanks.

Title: Re: Newsletter Plugin
Post by: Stramm on March 23, 2007, 07:56:58 am

not after installing the mod but after installing the modpack. Your users need to tick in their profile the checkbox 'allow admin email'.
Auto checked when registering with the modpack

It's possible to use phpmyadmin to set that for all users. But it's not the purpose of this functionality

Title: Re: Newsletter Plugin
Post by: natalina on March 23, 2007, 08:37:27 am

Thank u, Stramm :) I'll try to do it -the aim is to let all users know that the gallery has new services. Then they will be able to uncheck this box & I'll explain this in my admin letter.

Title: Re: Newsletter Plugin
Post by: PlymWS on April 05, 2007, 03:18:02 pm

Any ideas how I could code this function to add the content of the 'lastalb' window from the index page.

I have coded the lastalb function to only display albums created / modified in the last 5 days. I want a newsletter function to mail all my users once a week with this content to show them what's new on the site.

Title: Re: Newsletter Plugin
Post by: natalina on April 05, 2007, 04:08:16 pm

As for me I've done it manually by PHPmyadmin. Would u share the code (lastup)? It seems useful :)

Title: Re: Newsletter Plugin
Post by: 08154711 on July 16, 2007, 12:29:45 pm

Hi STRAMM,

absolutely gorgeous plugin.... almost exactly what I've been looking for !!!!
The little detail I would love to see would be to select the the GROUP of users (as defined in Coppermine). Any possibility to incorporate this in the Plugin or a small modification I could do myself ??
I have not much ideas about PHP but could do instructed changes in the plugin phps.... (find, add, replace, etc ??? ??? ;D ;D - and that's about it unfort... ::) )

Thank's already ...

Oliver

Title: Re: Newsletter Plugin
Post by: jlove on August 19, 2007, 12:32:31 am

Edit: Forget it, the modpack keeps messing up my gallery, so I just won't install it.

I get an error:

Quote

Critical error

There was an error while processing a database query.

With debug mode on it says:

Code: [Select]

While executing query "SELECT count(user_id) AS num FROM `jarlylov_media`.cpg1411_users  WHERE user_email <> '' AND  = '1' AND user_active = 'YES'" on 

mySQL error: 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 '= '1' AND user_active = 'YES'' at line 1

Code: [Select]

http://media.jarlylove.com/index.php?file=newsletter/newsletter

(And yes, modpack is installed.)

Title: Re: Newsletter Plugin
Post by: fotoyuz on September 02, 2007, 04:24:57 pm

:)
I was planning to use Xoops2 bridging to use this feature. It seams Coppermine became complete CMS solution or at least now using an other cms is not necessary for me.
Thank you very much for this plugin.

Title: Re: Newsletter Plugin Problem
Post by: tinorebel on January 17, 2008, 03:02:55 pm

Hy to all !

I just downloaded the mod and installed it copying the folder in my plugin folder.
Then whent to pluginmanager and installed.
It broiught me to a page saying database updating.... cliked on OK and....

now I get a fatal error when I try to connect to any page of my gal.... >:( :( >:(

Fatal error: require() [function.require]: Failed opening required 'plugins/newsletter/include/init.inc.php' (include_path='.:/usr/local/lib/php/') in /mounted-storage/home31b/sub001/sc204/www/website/gal/plugins/newsletter.1/codebase.php on line 137

.... I'm shure I have made a mistake, possibly couse I have not installed the full plugin pack......
....could you pleas give me a suggestion on how to restore my gallery / database????

Please Help!
I'm really in trouble!

Title: Re: Newsletter Plugin
Post by: Stramm on January 17, 2008, 03:15:57 pm

have you read the first sentence in the first post of this thread...

Quote

This one is pretty much a pluginized version of the 1.3 mod I posted ~ 2 years ago. Therefore the code isn't that pretty but works. No code cleanup or improvements added except that it only works with the modpack.

Title: Re: Newsletter Plugin
Post by: tinorebel on January 17, 2008, 03:24:00 pm

I understand perfectly..... I made the mistake.
I made a mess and dont have no idea on how to solve it.

I just tryed to install the modepack by copying the folder in plugin folder and running update... but gives no solution.

My gallery is down.....

Please if you have any idea on how can i get back my gallery I would really apreciate.
I hav more than 10.000 photos on the gallery.... and 20 photographers.

www.tripodart.net

Maby I can install again a new version of the gallery?

Title: Re: Newsletter Plugin
Post by: tinorebel on January 17, 2008, 03:28:59 pm

;)
Ok nop problem-......

I got my gallery back.

Sorry for my messages. I just descovered i had a folder called newsletter1 instead of newsletter.

So I correct this and now my gallery is on again!!! ::) ::) ::)

Thanks aniway for your answer!

Title: Re: Newsletter Plugin
Post by: Stramm on January 17, 2008, 03:31:52 pm

OK, glad to hear all is working for you now.

Title: Re: Newsletter Plugin
Post by: FDSFVN on February 22, 2008, 11:24:05 pm

Hello, I've installed the newsletter plugin. When i click on newsletter i get following error message:

While executing query "SELECT count(user_id) AS num FROM `ecchi`.cpg148_users WHERE user_email <> '' AND = '1' AND user_active = 'YES'" on

mySQL error: 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 '= '1' AND user_active = 'YES'' at line 1

And below this this message:

Code: [Select]

Title: Re: Newsletter Plugin
Post by: Nibbler on February 23, 2008, 02:10:23 am

Do you have the modpack installed?

Title: Re: Newsletter Plugin
Post by: FDSFVN on February 23, 2008, 05:35:37 pm

That was the reason for the error, i've updated the gallery to the latest version and installed the mod update and now it works, thank you very much!

Title: Re: Newsletter Plugin
Post by: chalky6666 on March 30, 2008, 09:48:05 am

Hi.

I hope this is down to my error rather than any thing else but I cant seem to go forward on this any more with out help.

I have installed mod-pack, newsletter plugin and now have the button showing but when I click it I get this.

Quote

Critical error
There was an error while processing a database query

My site is http://www.fazer-mania.co.uk/coppermine/index.php (http://www.fazer-mania.co.uk/coppermine/index.php)

I hope you can help.

Cheers

Chalky

Title: Re: Newsletter Plugin
Post by: Stramm on March 30, 2008, 09:52:01 am

enable debug mode and post the actual error message (but not the debug output itself)

Title: Re: Newsletter Plugin
Post by: chalky6666 on March 30, 2008, 09:54:34 am

Quote

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

=> 7195
[1] => 7194
[2] => 7185
[3] => 7183
)

[uid] => 459
[lap] => 1
[search] => Array
(
[search] => miss
[album] => search
[title] => on
[newer_than] =>
[caption] => on
[older_than] =>
[keywords] => on
[owner_name] => on
[type] => AND
[params] => Array
(
[title] => on
[caption] => on
[keywords] => on
[owner_name] => on
)

)

)

==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => chalky
[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 cpg_filetypes; (0s)
[1] => select * from cpg_plugins order by priority asc; (0s)
[2] => delete from `andrewa1_copp1`.cpg_sessions where time<1206860041 and remember=0; (0s)
[3] => delete from `andrewa1_copp1`.cpg_sessions where time<1205654041; (0s)
[4] => select user_id from `andrewa1_copp1`.cpg_sessions where session_id=md5("bb77b20a810ad39438b2cfa72cc13761e850cb293168515bb8ebd6a0da14f000"); (0.001s)
[5] => select user_id as id, user_password as password from `andrewa1_copp1`.cpg_users where user_id=1 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `andrewa1_copp1`.cpg_users AS u INNER JOIN `andrewa1_copp1`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `andrewa1_copp1`.cpg_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
[8] => 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 cpg_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg_usergroups WHERE group_id= 1 (0s)
[10] => update `andrewa1_copp1`.cpg_sessions set time='1206863641' where session_id=md5('bb77b20a810ad39438b2cfa72cc13761e850cb293168515bb8ebd6a0da14f000'); (0.001s)
[11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0s)
[12] => DELETE FROM cpg_banned WHERE expiry < '2008-03-30 08:54:01' (0s)
[13] => SELECT * FROM cpg_banned WHERE (ip_addr='81.102.158.250' OR ip_addr='81.102.158.250' OR user_id=1) AND brute_force=0 (0s)
[14] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '' ORDER BY name (0s)
[15] => SELECT aid FROM cpg_albums as a WHERE category>=10000 (0s)
[16] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category >= 10000 (0s)
[17] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1' ORDER BY name (0s)
[18] => SELECT aid FROM cpg_albums as a WHERE category = '0' (0s)
[19] => SELECT count(*) FROM cpg_albums as a WHERE 1 (0s)
[20] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 (0s)
[21] => SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 (0s)
[22] => SELECT count(*) FROM cpg_categories WHERE 1 (0s)
[23] => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1 (0s)
[24] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
[25] => SELECT count(*) FROM cpg_albums as a WHERE category = '0' (0s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.8 - OK
------------------
mySQL version: 5.0.45-community-log
------------------
Coppermine version: 1.4.2(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
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
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/php4/lib/php:/usr/local/php4/lib/php | .:/usr/php4/lib/php:/usr/local/php4/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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.1 seconds - 26 queries in 0.002 seconds - Album set : ; Meta set: ;

Title: Re: Newsletter Plugin
Post by: Stramm on March 30, 2008, 10:05:40 am

Quote from: Stramm on March 30, 2008, 09:52:01 am

enable debug mode and post the actual error message (but not the debug output itself)

Title: Re: Newsletter Plugin
Post by: chalky6666 on March 30, 2008, 10:19:19 am

Sorry, didnt read that properly did I.

Quote

While executing query "SELECT count(user_id) AS num FROM `andrewa1_copp1`.cpg_users WHERE user_email <> '' AND = '1' AND user_active = 'YES'" on

mySQL error: 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 '= '1' AND user_active = 'YES'' at line 1

Title: Re: Newsletter Plugin
Post by: Stramm on March 30, 2008, 10:23:17 am

Contrary to what you've said, you haven't installed the modpack. Without the plugin won't work. Also you're using the outdated CPG version 1.4.2. The actual one is 1.4.16. So you're 14 versions behind. Upgrade asap.

Title: Re: Newsletter Plugin
Post by: chalky6666 on March 30, 2008, 10:33:02 am

I'm being a bit thick here.

I have uploaded the Zip file.

Unzipped it which gave me this dir.

/stramm_mod1.4.16.bridge

I'm obviously missing soemthing really simple.

Title: Re: Newsletter Plugin
Post by: Stramm on March 30, 2008, 10:54:08 am

Have you read the modpack docs??? If not, please do so now. Also upgrade first before you install the modpack.

And modpack realted questions should be asked on the modpack board.

Title: Re: Newsletter Plugin
Post by: ist on June 16, 2008, 11:30:50 pm

Hi
I have added a danish lang file.

When sending mails, Subject is populated with Gallery name. Could you point out for me where to update if also Gallery Descriptions should be in subject?

regards Ist

Title: Re: Newsletter Plugin
Post by: Stramm on June 17, 2008, 07:56:21 am

Just tested it and I do not get the gallery name as subject.I even don't know where this should come from! Use as 'How to send the mails' php_mail. It's using what you set as mailing method in config... therefore the additional setting sendmail is redundant (I've tested with php_mail)

Title: Re: Newsletter Plugin
Post by: ist on June 17, 2008, 07:35:14 pm

My mistake :-\
It is not subject but in <From:> where Gallery description is written., sorry for that mistake.

regards ist

Title: Re: Newsletter Plugin
Post by: Stramm on June 17, 2008, 07:54:26 pm

As sender name the entry from
config -> General settings -> Gallery name
is taken into account... if you need it to be something else, just change it there

Title: Re: Newsletter Plugin
Post by: djghostdj on June 21, 2008, 01:46:49 am

Hi,

Thanks for great mod ,

like I understand the code, the newsletter is send to ALL users including banned and non active?

Sorry, I'm not familiar with PHP but is there a possibility to select:

Groups
active or not
banned or not

and

Can i post html code as email with this mode ?

tnx ;)

Title: Re: Newsletter Plugin
Post by: Fabricio Ferrero on June 21, 2008, 03:27:41 am

Very nice plug in...

Spanish file attached.

Title: Re: Newsletter Plugin
Post by: nointerest on August 05, 2008, 03:21:33 am

I have translated the Plug-In into German.

(Edit: I forgot to save the file as UTF-8. I have done so now. I hope the edit of the post will also update the attachment. If not - please contact me, I will post it again).

Title: Re: Newsletter Plugin
Post by: Joachim Müller on August 05, 2008, 07:56:53 am

Thanks for coming up with the translation. I went through the file and corrected the whitespace and double line breaks. Additionally, I corrected the <br>-tag. The file is encoded in utf-8. Attached it.

Title: Re: Newsletter Plugin
Post by: matyrojo666 on September 29, 2008, 08:33:06 pm

I installed Newsletter plugin and Easy_RSS. When I log in as Administrator and go to Newsletter button says:

"there was an error" and bellow shows add to google, add to my yahoo, rss...

Also I reinstalled my plugin but it´s the same...

What can I do?

Thanks!
Matias

Title: Re: Newsletter Plugin
Post by: Stramm on September 29, 2008, 08:54:04 pm

Quote from: matyrojo666 on September 29, 2008, 08:33:06 pm

... "there was an error" and bellow shows add to google, add to my yahoo, rss...

Looks like a problem with the RSS plugin

Title: Re: Newsletter Plugin
Post by: matyrojo666 on September 29, 2008, 09:05:59 pm

Quote from: Stramm on September 29, 2008, 08:54:04 pm

Looks like a problem with the RSS plugin

No, the problem is Newsletter plugin, EASY RSS plugin now is uninstalled...

Title: Re: Newsletter Plugin
Post by: Stramm on September 29, 2008, 09:46:16 pm

The newsletter plugin doesn't contain anything about rss, google, yahoo. Maybe the rss plugin doesn't uninstall properly. If you don't believe that, search through the plugins code for eg. yahoo

Title: Re: Newsletter Plugin
Post by: matyrojo666 on September 29, 2008, 09:51:20 pm

Quote from: Stramm on September 29, 2008, 09:46:16 pm

The newsletter plugin doesn't contain anything about rss, google, yahoo. Maybe the rss plugin doesn't uninstall properly. If you don't believe that, search through the plugins code for eg. yahoo

This is my error

"There was an error while processing a database query"

Title: Re: Newsletter Plugin
Post by: Stramm on September 30, 2008, 12:02:48 am

enable debug mode and post the more detailed error message (but not the debug output)

Title: Re: Newsletter Plugin
Post by: terrorhawk on October 01, 2008, 10:48:34 pm

Hi Stramm

I'm testing this plugin and it looks very cool
but is there a way to paste html code's in it?

Title: Re: Newsletter Plugin
Post by: bobby5959 on October 05, 2008, 10:34:32 am

I found this plugin, it seem nice, but it is not working

I have a problem

pls help, thank you!!

greating Bobby

after installing I get follow error:

While executing query "SELECT count(user_id) AS num FROM `usr_web236_2`.cpg14x_users WHERE user_email <> '' AND = '1' AND user_active = 'YES'" on

mySQL error: 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 '= '1' AND user_active = 'YES'' at line 1

File: /var/www/web236/html/gallery/include/functions.inc.php - Line: 249

Here the full debug info:

USER:
------------------
Array
(
[ID] => 17327446241f285c423740d96e433d21
[am] => 1
[lang] => english_gb
[liv] => Array
(

=> 11

[sort] => pa
)

==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => admin
[groups] => Array
(

=> 1

)

[disk_max] => 10240
[disk_min] => 10240
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 1
[num_file_upload] => 7
[num_URI_upload] => 5
[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] => 10240
[can_see_all_albums] => 1
[group_id] => 1
)

==========================
Queries:
------------------
Array
(

=> SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)

[file] => newsletter/newsletter
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.0-8+etch10 - OK
------------------
mySQL version: 5.0.32-Debian_7etch4-log
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: 2.0 or higher
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support:
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.32
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
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.1
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | /var/www/empty/ | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /var/www/empty/ | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | . | .:/usr/share/php:/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 | 0 | 30
max_input_time | 60 | 60
upload_max_filesize | 8M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.149 seconds - 18 queries in 0 seconds - Album set : ; Meta set: ;

Title: Re: Newsletter Plugin
Post by: Stramm on October 05, 2008, 10:42:45 am

read the first post of this thread to find the answer why it's not working for you

Title: Re: Newsletter Plugin
Post by: bobby5959 on October 05, 2008, 10:55:48 am

I have also installed modpack
http://stramm.st.funpic.org/albums/userpics/10001/stramm_mod1_4_19_bridge.zip
and was copying this code in my template:


<td><img name="spacer" src="images/spacer.gif" width="5" height="25" border="0" alt="" /></td>
<td><img name="buttonleftmy" src="themes/hardwired/images/buttonleftmy.gif" width="17" height="25" border="0" alt="" /></td>
<td style="background: url(themes/hardwired/images/buttoncenter.gif);">
<a href="{MY_BUDDY_TGT}" title="{MY_BUDDY_LNK}">{MY_BUDDY_LNK}</a>
</td>
<td><img name="buttonright" src="themes/hardwired/images/buttonright.gif" width="7" height="25" border="0" alt="" /></td>


but nothing is working

PLs help

thx you

Bobby

Title: Re: Newsletter Plugin
Post by: bobby5959 on October 05, 2008, 11:41:16 am

after trying hard Newslette ris working now

dont need support!

thxs for mod

Bobby

Title: Re: Newsletter Plugin
Post by: soraya95610 on November 23, 2008, 09:06:20 pm

I have a problem with the newsletter. When I send a newsletter to members of my gallery does not receive except administrators. I'd like to know what was the problem? Thank you

Title: Danish language file for Newsletter Plugin
Post by: Mimer on June 01, 2009, 12:47:02 am

Danish language file for Newsletter Plugin 1.0
Revision 1.0

Mimer 8)

Title: Re: Newsletter Plugin
Post by: phill104 on January 08, 2010, 12:13:13 am

Split and created new thread regarding the problems of Vinicius Machado (http://forum.coppermine-gallery.net/index.php?action=profile;u=59302).

http://forum.coppermine-gallery.net/index.php/topic,63136.0.html