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)
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 ?
post a real url, don't rename the folder name 'newsletter'
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
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...
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
Great work Stramm!! thank you ;D
finally one newsletter!
I've traslated in italian language
Thanks for the translation, much appreciated
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
<?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é 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è 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 è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 :)
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? :)
Enable debug mode and post the mysql error message (not the entire debug output) you get when you replicate the error.
have you read the very first post of this thread? Especially that part...
Quoteit only works with the modpack
Goodmorning!
dutch.php added as zip.
Hein
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?
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)
Hein, thank you for the translation ;D
Hello
The newsletter module seems good but i don't want to install the MOD pack, how can i do ?
Best regards
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.
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.
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
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.
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.
As for me I've done it manually by PHPmyadmin. Would u share the code (lastup)? It seems useful :)
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
Edit: Forget it, the modpack keeps messing up my gallery, so I just won't install it.
I get an error:
QuoteCritical error
There was an error while processing a database query.
With debug mode on it says:
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 1USER:
------------------
Array
(
[ID] => 0291ad1a67d7653acb9a9788175899fe
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => Corinne
[groups] => Array
(
[0] => 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
(
[0] => SELECT extension, mime, content, player FROM cpg1411_filetypes; (0.001s)
[1] => select * from cpg1411_plugins order by priority asc; (0.001s)
[2] => delete from `jarlylov_media`.cpg1411_sessions where time<1187472496 and remember=0; (0.001s)
[3] => delete from `jarlylov_media`.cpg1411_sessions where time<1186266496; (0.001s)
[4] => select user_id from `jarlylov_media`.cpg1411_sessions where session_id=md5("a0df2952e9731f55ea64f0379828dd318035629e06cf20bb51f49e23c08ca5f5"); (0.001s)
[5] => select user_id as id, user_password as password from `jarlylov_media`.cpg1411_users where user_id=1 (0.001s)
[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 `jarlylov_media`.cpg1411_users AS u INNER JOIN `jarlylov_media`.cpg1411_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
[7] => SELECT user_group_list FROM `jarlylov_media`.cpg1411_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
[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 cpg1411_usergroups WHERE group_id in (1) (0.011s)
[9] => SELECT group_name FROM cpg1411_usergroups WHERE group_id= 1 (0.002s)
[10] => update `jarlylov_media`.cpg1411_sessions set time='1187476096' where session_id=md5('a0df2952e9731f55ea64f0379828dd318035629e06cf20bb51f49e23c08ca5f5'); (0s)
[11] => SELECT user_favpics FROM cpg1411_favpics WHERE user_id = 1 (0.003s)
[12] => DELETE FROM cpg1411_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE (0.001s)
[13] => REPLACE INTO cpg1411_mod_online (user_id, user_name, user_ip, last_action) VALUES ('1', 'Corinne', '70.18.137.103', NOW()) (0.001s)
[14] => DELETE FROM cpg1411_banned WHERE expiry < '2007-08-18 18:28:16' (0.001s)
[15] => SELECT * FROM cpg1411_banned WHERE (ip_addr='70.18.137.103' OR ip_addr='70.18.137.103' OR user_id=1) AND brute_force=0 (0.001s)
[16] => SELECT COUNT(*) FROM cpg1411_pictures WHERE approved = 'NO' (0.001s)
[17] => SELECT count(user_id) AS num FROM `jarlylov_media`.cpg1411_users WHERE user_email <> '' AND = '1' AND user_active = 'YES' (0.001s)
)
==========================
GET :
------------------
Array
(
[file] => newsletter/newsletter
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 5.2.2 - OK
------------------
mySQL version: 4.1.16-standard-log
------------------
Coppermine version: 1.4.12 modpack v2(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 1
Client API version 5.0.16
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.2
Linked Version 1.2.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/local/php5/lib/php:/usr/local/lib/php | .:/usr/local/php5/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 | 0 | 30
max_input_time | 60 | 60
upload_max_filesize | 7M | 7M
post_max_size | 8M | 8M
==========================
Page generated in 0.363 seconds - 18 queries in 0.03 seconds - Album set : ; Meta set: ;http://media.jarlylove.com/index.php?file=newsletter/newsletter
(And yes, modpack is installed.)
:)
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.
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!
have you read the first sentence in the first post of this thread...
QuoteThis 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.
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?
;)
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!
OK, glad to hear all is working for you now.
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:
USER:
------------------
Array
(
[ID] => 05a8dbab24165defc88017d85dd17814
[am] => 1
[lang] => german
[liv] => Array
(
[0] => 1936
[1] => 3281
[2] => 4266
[3] => 4166
[4] => 1446
)
[lap] => 4
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => EcchiMaster
[groups] => Array
(
[0] => 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
(
[0] => SELECT extension, mime, content, player FROM cpg148_filetypes; (0.001s)
[1] => select * from cpg148_plugins order by priority asc; (0s)
[2] => delete from `ecchi`.cpg148_sessions where time<1203715233 and remember=0; (0.003s)
[3] => delete from `ecchi`.cpg148_sessions where time<1202509233; (0.002s)
[4] => select user_id from `ecchi`.cpg148_sessions where session_id=md5("dffd7387f904ac273921180605950e57183fc716cdfe70a2f4f4867da2f4c7b6"); (0.001s)
[5] => select user_id as id, user_password as password from `ecchi`.cpg148_users where user_id=1 (0.001s)
[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 `ecchi`.cpg148_users AS u INNER JOIN `ecchi`.cpg148_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
[7] => SELECT user_group_list FROM `ecchi`.cpg148_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 cpg148_usergroups WHERE group_id in (1) (0.001s)
[9] => SELECT group_name FROM cpg148_usergroups WHERE group_id= 1 (0s)
[10] => update `ecchi`.cpg148_sessions set time='1203718833' where session_id=md5('dffd7387f904ac273921180605950e57183fc716cdfe70a2f4f4867da2f4c7b6'); (0.001s)
[11] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 1 (0.001s)
[12] => DELETE FROM cpg148_banned WHERE expiry < '2008-02-22 22:20:33' (0.001s)
[13] => SELECT * FROM cpg148_banned WHERE (ip_addr='89.14.103.155' OR ip_addr='89.14.103.155' OR user_id=1) AND brute_force=0 (0.001s)
[14] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0.006s)
[15] => SELECT count(user_id) AS num FROM `ecchi`.cpg148_users WHERE user_email <> '' AND = '1' AND user_active = 'YES' (0.001s)
)
==========================
GET :
------------------
Array
(
[file] => newsletter/newsletter
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 5.1.2 - OK
------------------
mySQL version: 5.0.41-Debian_1-log
------------------
Coppermine version: 1.4.8(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.22
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.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | On
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 | .: | .:
open_basedir | /var/www/vhosts/ecchi.at/httpdocs:/tmp | 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.303 seconds - 16 queries in 0.021 seconds - Album set : ; Meta set: ;
Do you have the modpack installed?
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!
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.
QuoteCritical 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
enable debug mode and post the actual error message (but not the debug output itself)
QuoteUSER:
------------------
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: ;
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)
Sorry, didnt read that properly did I.
QuoteWhile 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
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.
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.
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.
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
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)
My mistake :-\
It is not subject but in <From:> where Gallery description is written., sorry for that mistake.
regards ist
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
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 ;)
Very nice plug in...
Spanish file attached.
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).
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.
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
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
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...
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
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"
enable debug mode and post the more detailed error message (but not the debug output)
Hi Stramm
I'm testing this plugin and it looks very cool
but is there a way to paste html code's in it?
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
[1] => 4
[2] => 12
[3] => 7
[4] => 6
)
[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)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
[2] => delete from `usr_web236_2`.cpg14x_sessions where time<1223189955 and remember=0; (0s)
[3] => delete from `usr_web236_2`.cpg14x_sessions where time<1221983955; (0s)
[4] => select user_id from `usr_web236_2`.cpg14x_sessions where session_id = '99950bfd5caeed7f402d6ae0050f21a7' (0s)
[5] => select user_id as id, user_password as password from `usr_web236_2`.cpg14x_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 `usr_web236_2`.cpg14x_users AS u INNER JOIN `usr_web236_2`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `usr_web236_2`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg14x_usergroups WHERE group_id= 1 (0s)
[10] => update `usr_web236_2`.cpg14x_sessions set time='1223193555' where session_id = '99950bfd5caeed7f402d6ae0050f21a7' (0s)
[11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
[12] => SHOW TABLES LIKE 'cpg14x_cms_config' (0s)
[13] => SELECT * FROM cpg14x_cms_config (0s)
[14] => DELETE FROM cpg14x_banned WHERE expiry < '2008-10-05 09:59:15' (0s)
[15] => SELECT * FROM cpg14x_banned WHERE (ip_addr='86.59.81.202' OR ip_addr='86.59.81.202' OR user_id=1) AND brute_force=0 (0s)
[16] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
[17] => SELECT count(user_id) AS num FROM `usr_web236_2`.cpg14x_users WHERE user_email <> '' AND = '1' AND user_active = 'YES' (0s)
)
==========================
GET :
------------------
Array
(
[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: ;
read the first post of this thread to find the answer why it's not working for you
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:
<!-- BEGIN my_friends -->
<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>
<!-- END my_friends -->
but nothing is working
PLs help
thx you
Bobby
after trying hard Newslette ris working now
dont need support!
thxs for mod
Bobby
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
Danish language file for Newsletter Plugin 1.0
Revision 1.0
Mimer 8)
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