Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Closed]: CPGMark installation error  (Read 6711 times)

0 Members and 1 Guest are viewing this topic.

panhead

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 108
[Closed]: CPGMark installation error
« on: June 17, 2009, 01:23:50 pm »

I installed CPGmark, got the following messages:

CREATE TABLE `cpg11d_mark_watermark` ( `pid` INT NOT NULL, `watermarked` TINYINT NOT NULL, PRIMARY KEY (`pid`) ) TYPE=MyISAM   OK
CREATE TABLE `cpg11d_mark_users` ( `user_id` int(11) NOT NULL default '0', `use_watermark_img` tinyint(4) NOT NULL default '0', `img_vpos` varchar(10) NOT NULL default '', `img_hpos` varchar(10) NOT NULL default '', `use_watermark_txt` tinyint(4) NOT NULL default '0', `watermark_text` varchar(255) NOT NULL default '', `watermark_text_size` tinyint(4) NOT NULL default '0', `large_watermark_text_size` tinyint(4) NOT NULL default '0', `watermark_text_color` varchar(6) NOT NULL default '', `txt_vpos` varchar(10) NOT NULL default '', `txt_hpos` varchar(10) NOT NULL default '', PRIMARY KEY (`user_id`) ) TYPE=MyISAM   OK
CREATE TABLE `cpg11d_mark_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM   OK
INSERT INTO `cpg11d_mark_config` VALUES ('watermark_path', 'watermarks/')   OK
INSERT INTO `cpg11d_mark_config` VALUES ('small_watermark_image', 'watermark.png')   OK
INSERT INTO `cpg11d_mark_config` VALUES ('large_watermark_image', 'watermark_large.png')   OK
INSERT INTO `cpg11d_mark_config` VALUES ('display_image_mark', '0')   OK
INSERT INTO `cpg11d_mark_config` VALUES ('upload_mark', '1')   OK
INSERT INTO `cpg11d_mark_config` VALUES ('user_watermark', '0')


But next:

Critical error
There was an error while processing a database query

What went wrong? I downloaded the most recent verion and have the most recent coppermine version.
« Last Edit: June 17, 2009, 07:27:53 pm by Joachim Müller »
Logged

Nibbler

  • Guest
Re: CPGMark installation error
« Reply #1 on: June 17, 2009, 02:13:17 pm »

Enable debug mode and post the actual error.

http://coppermine-gallery.net/tutorial/debug_mode.php
Logged

panhead

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 108
Re: CPGMark installation error
« Reply #2 on: June 17, 2009, 02:23:01 pm »

This is was I got:

USER:
------------------
Array
(
    [ID] => b26cf9f44f2bd90ab8414117dfd49c4b
    [am] => 1
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 3
    [user_name] => panhead
    [group_name] => Administrators
    [groups] => Array
        (
           
  • => 2
  • [1] => 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
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg11d_filetypes; (0s)
  • [1] => select * from cpg11d_plugins order by priority asc; (0s)
        [2] => SELECT * FROM cpg11d_bridge (0s)
        [3] => SET NAMES 'utf8' (0s)
        [4] => SELECT
             config_name,
             config_value
          FROM
             `CN20051124_pan`.phpbb_config
          WHERE
             config_name IN ('cookie_name', 'session_length', 'allow_autologin', 'max_autologin_time') (0s)
        [5] => SELECT
                   u.*, s.*
                FROM
                   `CN20051124_pan`.phpbb_users u,
                   `CN20051124_pan`.phpbb_sessions s
                WHERE
                   u.user_id = s.session_user_id AND
                   u.user_type != 2 AND
                   u.user_type != 1 AND
                   s.session_id = '17da2449361d34e9037bd640595e40a4' (0.001s)
        [6] => SELECT
                *
             FROM
                `CN20051124_pan`.phpbb_user_group ug,
                `CN20051124_pan`.phpbb_acl_groups ag,
                `CN20051124_pan`.phpbb_acl_roles_data ard,
                `CN20051124_pan`.phpbb_acl_options ao
             WHERE
                ug.user_id = 3 AND
                ug.group_id = ag.group_id AND
                ag.auth_role_id = ard.role_id AND
                ard.auth_setting = 1 AND
                ard.auth_option_id = ao.auth_option_id AND
                (ao.auth_option = 'a_cpgadmin' OR ao.auth_option = 'm_cpgadmin') (0s)
        [7] => SELECT
                   *
                FROM
                   `CN20051124_pan`.phpbb_user_group ug,
                   `CN20051124_pan`.phpbb_acl_groups ag,
                   `CN20051124_pan`.phpbb_acl_options ao
                WHERE
                   ug.user_id = 3 AND
                   ug.group_id = ag.group_id AND
                   ag.auth_option_id = ao.auth_option_id AND
                   ag.auth_setting = 1 AND
                   (ao.auth_option = 'a_cpgadmin' OR ao.auth_option = 'm_cpgadmin') (0s)
        [8] => SELECT
               group_name
            FROM
               `CN20051124_pan`.phpbb_groups
            WHERE
               group_id = 2370 (0s)
        [9] => 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 cpg11d_usergroups WHERE group_id in (2,1) (0s)
        [10] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 1 (0s)
        [11] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 3 (0s)
        [12] => SELECT * FROM cpg11d_mark_users WHERE user_id = 3 (0s)
        [13] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0s)
    )

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

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 5.2.6-2ubuntu4 - OK
    ------------------
    mySQL version: 5.0.51a-3ubuntu5.4-log
    ------------------
    Coppermine version: 1.4.23(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 2
    Client API version 5.0.51a
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/run/mysqld/mysqld.sock
    MYSQL_INCLUDE -I/usr/include/mysql
    MYSQL_LIBS -L/usr/lib -lmysqlclient_r 
    ==========================
    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.3
    ==========================
    Server restrictions (safe mode)?
    ------------------
    Directive | Local Value | Master Value
    safe_mode | Off | Off
    safe_mode_exec_dir | no value | no value
    safe_mode_gid | On | On
    safe_mode_include_dir | /home/contracts | /home/contracts
    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/share/php:/usr/share/pear | .:/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 | 30 | 30
    max_input_time | 60 | 60
    upload_max_filesize | 100M | 100M
    post_max_size | 100M | 100M
    ==========================
    Page generated in 0.037 seconds - 14 queries in 0.001 seconds - Album set : ; Meta set: ;
Logged

panhead

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 108
Re: CPGMark installation error
« Reply #3 on: June 17, 2009, 02:26:07 pm »

And this one:

While executing query "SELECT * FROM cpg11d_mark_users WHERE user_id = 3" on 0

mySQL error:
Logged

panhead

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 108
Re: CPGMark installation error
« Reply #4 on: June 17, 2009, 03:20:04 pm »

I solved the problem by deleting CPGmark from the plugin folder.

Can you please delete CPGMark form the plugins download list?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CPGMark installation error
« Reply #5 on: June 17, 2009, 07:27:41 pm »

Can you please delete CPGMark form the plugins download list?
Certainly not - just because you have no idea how to use it we certainly won't remove it for others. What a silly request.
Logged

panhead

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 108
Re: [Closed]: CPGMark installation error
« Reply #6 on: June 17, 2009, 08:38:02 pm »

What makes you suggest I have no idea how to use it? Just following the description gave this result.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: [Closed]: CPGMark installation error
« Reply #7 on: June 17, 2009, 08:46:58 pm »

Sure, whatever ::). I'm not going to argue with you. Case closed, thread locked.
Logged
Pages: [1]   Go Up
 

Page created in 0.041 seconds with 20 queries.