Copper Ad ! First advertisement plugin for coppermine

[Sami]

Yes the link goes to this thread but it goes to this actual post :

- Romove xxx_plugin_copperad from db
- Remove plugin from xxx_plugins
- Remove cpa_enable from xxx_config table
and then install it again

[edit]
Side note:
For everyone how have this issue:
- if you want to use new version of plugin , first uninstall the old one by using plugin manager and then copy new plugin and install it
- Never unistall a plugin manualy (by removing it from xxx_plugins table) unless requested

And your orginal question was not here , you've posted that to plugin pack annoncment thread, I merged your post with this thread

[BikiniPhotoBank]

Oh sorry about that
Ok i have uninstalled the plugin from the config/manage plugins/copperad
however it still shows up in the list even after i confirmed the "yes i want to delete this"
So then i went into mysql control panel on my server and deleted it from there and deleted it through ftp.
I have no idea what xxx_plugin_copperad from db means or the other 2 options i hope i did it right.

now i have uploaded a fresh copy and copper_adv145 then changed the name to copper_ad as suggested and as soon as i change that name i get the same critical error!
I am so lost and confused!

[Sami]

okey
- Enable debug to see the actual error message
- Post a link to your site

[BikiniPhotoBank]

Ok debugg mode on,
http://www.bikiniphotobank.com

What files are affected when you install the plugin that are outside the plugin folder? maybe i have a corrupt file or something i can upload the original coppermine files or folders but want to be careful not to screw up the site anymore than it is.

As the site stands now the copperad plugin is not installed

[BikiniPhotoBank]

Ok just tried to install the copper_ad and here is what it said under the debugging thingy:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 89d73216528af42be6b8556ee5c2028a
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => spiroInc
    [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 cpg149_filetypes; (0.001s)
    [1] => select * from cpg149_plugins order by priority asc; (0s)
    [2] => delete from `SpiroIn_copper`.cpg149_sessions where time<1161200214 and remember=0; (0.001s)
    [3] => delete from `SpiroIn_copper`.cpg149_sessions where time<1159994214; (0.001s)
    [4] => select user_id from `SpiroIn_copper`.cpg149_sessions where session_id=md5("8482156f512f0ad6d807b8b220ab570c211368533cbe70becd54426bf81f7a94"); (0s)
    [5] => select user_id as id, user_password as password from `SpiroIn_copper`.cpg149_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 `SpiroIn_copper`.cpg149_users AS u INNER JOIN `SpiroIn_copper`.cpg149_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
    [7] => SELECT user_group_list FROM `SpiroIn_copper`.cpg149_users AS u WHERE user_id='1' and user_group_list <> ''; (0.005s)
    [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 cpg149_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  cpg149_usergroups WHERE group_id= 1 (0s)
    [10] => update `SpiroIn_copper`.cpg149_sessions set time='1161203814' where session_id=md5('8482156f512f0ad6d807b8b220ab570c211368533cbe70becd54426bf81f7a94'); (0.001s)
    [11] => SELECT user_favpics FROM cpg149_favpics WHERE user_id = 1 (0.001s)
    [12] => SELECT * FROM cpg149_copperad_config (0.01s)
    [13] => SELECT COUNT(*) FROM cpg149_pictures WHERE approved = 'NO' (0.005s)
)

==========================
GET :
------------------
Array
(
    [op] => install
    [p] => copperad
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.1.20-max-log
------------------
Coppermine version: 1.4.9(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 4.0.16
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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/lib/php:/usr/local/lib/php/PEAR:/usr/local/share/pear | .:/usr/local/lib/php:/usr/local/lib/php/PEAR:/usr/local/share/pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
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 | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 2.498 seconds - 14 queries in 0.028 seconds - Album set : ; Meta set: ;




File: /hsphere/local/home/spiroinc/bikiniphotobank.com/cpg149/include/functions.inc.php - Line: 249



While executing query "SELECT * FROM cpg149_copperad_config" on 0

mySQL error: Table 'SpiroIn_copper.cpg149_copperad_config' doesn't exist

[Sami]

The error indicate that you manually delete plugin ,that you shouldn't ,

As I said before you should
- Remove copper_ad from cpg149_plugins table
- Remove cpa_enable from cpg149_config table
and then install it again (use the orginal installation package attached to initial post of this thread )

[BikiniPhotoBank]

Ok Sami,
where do i find the cpg149_plugins table and the
cpg149_config table?
is that something i find in the config panel?
or thru ftp?

sorry for the stupid questions but i am very new to this!

[Sami]

No those are on mysql database

[BikiniPhotoBank]

Sami!!!!!! YOU DA MAN!!!
Finally got it working!
I did like you said and it works perfect! now to make all those banner ads and get the site makin a buck or 3

THANK YOU THANK YOU THANK YOU!!
John
http://www.bikiniphotobank.com

[Sami]

You're welcome

[Hein Traag]

Good evening Sami,

not using this plugin but i was bored out of my mind in my hotel room  so i got translating.

Cheers!
Hein

[Sami]

Thank you Hein for support and contribution

[yakamoz01]

sorry i have a problem

why banners move?   i cant like it. i dont want change banners

[Sami]

Then delete all others and keep one banner

[Joachim Müller]

If you want just one banner and no banner rotation, this plugin is not meant for you. Just add your banner to your custom theme (themes/yourtheme/template.html) using a plain text editor as suggested in the docs and discussed in many, many posting on the board "cpg1.4 themes/skins/templates". This plugin is not meant to add just one banner permanently to your pages.

[yakamoz01]

ok. thanks i will try

[NONAME_XALIAVA]

Please HELP! sorry for my English but...

I try to install Copper Adv1.2.4 (Stable) on 1.4.9 version of Copermine gallery and it`s "broket"

While executing query "SELECT * FROM cpg149_copperad_config" on 0

mySQL error: Table 'akinov.cpg149_copperad_config' doesn't exist



PHP info:
USER:
------------------
Array
(
    [ID] => e1b6b3723d58c1fd88440968cd80a7f7
    [am] => 1
    [lang] => russian
    [liv] => Array
        (
           

• => 134
              [1] => 8250
              [2] => 8287
              [3] => 8172
              [4] => 8593
          )
  
      [lap] => 2
      [sort] => td
      [theme] => igames
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => akinov
      [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] => 1
      [num_file_upload] => 10
      [num_URI_upload] => 10
      [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 cpg149_filetypes; (0.023s)
      [1] => select * from cpg149_plugins order by priority asc; (0.026s)
      [2] => delete from `akinov`.cpg149_sessions where time<1168966534 and remember=0; (0.002s)
      [3] => delete from `akinov`.cpg149_sessions where time<1167760534; (0.002s)
      [4] => select user_id from `akinov`.cpg149_sessions where session_id=md5("2aca187fe0b0f34fc5d9a44e3ce9835e8cd94d8b33b77a501878f7f2afcda001"); (0.004s)
      [5] => select user_id as id, user_password as password from `akinov`.cpg149_users where user_id=1 (0.005s)
      [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 `akinov`.cpg149_users AS u INNER JOIN `akinov`.cpg149_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.003s)
      [7] => SELECT user_group_list FROM `akinov`.cpg149_users AS u WHERE user_id='1' and user_group_list <> ''; (0.002s)
      [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 cpg149_usergroups WHERE group_id in (1) (0.008s)
      [9] => SELECT group_name FROM  cpg149_usergroups WHERE group_id= 1 (0.007s)
      [10] => update `akinov`.cpg149_sessions set time='1168970134' where session_id=md5('2aca187fe0b0f34fc5d9a44e3ce9835e8cd94d8b33b77a501878f7f2afcda001'); (0.002s)
      [11] => SELECT user_favpics FROM cpg149_favpics WHERE user_id = 1 (0.004s)
      [12] => SELECT * FROM cpg149_copperad_config (0.015s)
      [13] => SELECT COUNT(*) FROM cpg149_pictures WHERE approved = 'NO' (0.065s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.4 - OK
  ------------------
  mySQL version: 4.1.22
  ------------------
  Coppermine version: 1.4.9(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 4.1.22
  MYSQL_MODULE_TYPE none
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE no value
  MYSQL_LIBS no value
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  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 | .: | .:
  open_basedir | /home/akinov/data:. | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i -f  | /usr/sbin/sendmail -t -i 
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 10000 | 10000
  max_input_time | 60 | 60
  upload_max_filesize | 30M | 30M
  post_max_size | 16M | 16M
  ==========================
  Page generated in 2.089 seconds - 14 queries in 0.168 seconds - Album set : ; Meta set: ;
  

this is it www.akinov.ru

pleasy help!  :'( :'( :'(

[Sami]

Answer is right above this page ,
http://forum.coppermine-gallery.net/index.php?topic=33151.msg176358#msg176358

[bigarte]

Thanks so much Sami; works fine.

[skidpics]

Love the plug in, but what can you tell me what I need to change in order to make it work with the I feel Dirty theme (attached)?

The single banner rotation does not work correctly, but the multiple banners works fine, except for a positioning issue..

What can you tell me to fix in order to get it working correctly?

-- Skidpics

http://skidpics.com