Advanced search  

News:

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

Pages: 1 [2] 3 4   Go Down

Author Topic: Newsletter Plugin  (Read 109603 times)

0 Members and 1 Guest are viewing this topic.

natalina

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 96
    • Interior & Architecture
Re: Newsletter Plugin
« Reply #20 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.

PlymWS

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 11
Re: Newsletter Plugin
« Reply #21 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.
Logged

natalina

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 96
    • Interior & Architecture
Re: Newsletter Plugin
« Reply #22 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 :)

08154711

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Newsletter Plugin
« Reply #23 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
Logged

jlove

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 41
Re: Newsletter Plugin
« Reply #24 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]
USER:
------------------
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.)
« Last Edit: August 19, 2007, 03:45:41 pm by jlove »
Logged

fotoyuz

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Newsletter Plugin
« Reply #25 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.
Logged

tinorebel

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 87
  • live long and prosper!
    • www.tripodart.net
Re: Newsletter Plugin Problem
« Reply #26 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!
Logged
Live long and prosper!
www.tripodart.net

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 6006
Re: Newsletter Plugin
« Reply #27 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.
Logged
my CPG sandbox: Version 1.4.18 with modpack running my Tentacle theme:
http://stramm.st.funpic.org/

tinorebel

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 87
  • live long and prosper!
    • www.tripodart.net
Re: Newsletter Plugin
« Reply #28 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?
Logged
Live long and prosper!
www.tripodart.net

tinorebel

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 87
  • live long and prosper!
    • www.tripodart.net
Re: Newsletter Plugin
« Reply #29 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!

Logged
Live long and prosper!
www.tripodart.net

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 6006
Re: Newsletter Plugin
« Reply #30 on: January 17, 2008, 03:31:52 pm »

OK, glad to hear all is working for you now.
Logged
my CPG sandbox: Version 1.4.18 with modpack running my Tentacle theme:
http://stramm.st.funpic.org/

FDSFVN

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Newsletter Plugin
« Reply #31 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]
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: ;
« Last Edit: February 23, 2008, 02:10:46 am by Nibbler »
Logged

Nibbler

  • Guest
Re: Newsletter Plugin
« Reply #32 on: February 23, 2008, 02:10:23 am »

Do you have the modpack installed?
Logged

FDSFVN

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Newsletter Plugin
« Reply #33 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!
Logged

chalky6666

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Newsletter Plugin
« Reply #34 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

I hope you can help.

Cheers

Chalky
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 6006
Re: Newsletter Plugin
« Reply #35 on: March 30, 2008, 09:52:01 am »

enable debug mode and post the actual error message (but not the debug output itself)
« Last Edit: March 30, 2008, 10:06:12 am by Stramm »
Logged
my CPG sandbox: Version 1.4.18 with modpack running my Tentacle theme:
http://stramm.st.funpic.org/

chalky6666

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Newsletter Plugin
« Reply #36 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: ;
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 6006
Re: Newsletter Plugin
« Reply #37 on: March 30, 2008, 10:05:40 am »

enable debug mode and post the actual error message (but not the debug output itself)
Logged
my CPG sandbox: Version 1.4.18 with modpack running my Tentacle theme:
http://stramm.st.funpic.org/

chalky6666

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
Re: Newsletter Plugin
« Reply #38 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

Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 6006
Re: Newsletter Plugin
« Reply #39 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.
Logged
my CPG sandbox: Version 1.4.18 with modpack running my Tentacle theme:
http://stramm.st.funpic.org/
Pages: 1 [2] 3 4   Go Up
 

Page created in 0.032 seconds with 21 queries.