Newsletter Plugin

[natalina]

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]

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.

[natalina]

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

[08154711]

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    - and that's about it  unfort... )

Thank's already ...

Oliver

[jlove]

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


I get an error:

Critical error

There was an error while processing a database query.

With debug mode on it says:

Code Select Expand

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 Expand

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.)

[fotoyuz]

 
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.

[tinorebel]

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!

[Stramm]

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

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.

[tinorebel]

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?

[tinorebel]

 
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!

[Stramm]

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

[FDSFVN]

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 Expand


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: ;


[Nibbler]

Do you have the modpack installed?

[FDSFVN]

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!

[chalky6666]

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.

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

[Stramm]

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

[chalky6666]

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: ;

[Stramm]

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

[chalky6666]

Sorry, didnt read that properly did I.

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

[Stramm]

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.