bridge with phpbb3 bridge with phpbb3
 

News:

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

Main Menu

bridge with phpbb3

Started by spyro00, October 01, 2010, 05:36:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

spyro00

October 01, 2010, 05:36:26 PM
im getting an error after activating the bridge with custom groups, before it was working ok withou custom groups
now every time i create a new category it gives me this error


error
While executing query 'INSERT INTO cpg14x_categorymap (cid, group_id) VALUES (0, 2)' in catmgr.php on line 594

mySQL error: Duplicate entry '0-2' for key 'PRIMARY'




debug



USER:
------------------
Array
(
    [ID] => d58d245b99a2a90403f9cc3f297815ab
    [am] => 1
    [lang] => portuguese
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => admin
    [groups] => Array
        (
           
  • => 1
            )

        [disk_max] => 0
        [disk_min] => 0
        [can_rate_pictures] => 1
        [can_send_ecards] => 1
        [can_post_comments] => 1
        [can_upload_pictures] => 1
        [can_create_albums] => 1
        [has_admin_access] => 1
        [access_level] => 3
        [pub_upl_need_approval] => 0
        [priv_upl_need_approval] => 0
        [group_name] => Administrators
        [group_quota] => 0
        [can_see_all_albums] => 1
        [group_id] => 1
        [allowed_albums] => Array
            (
            )

    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT name, value FROM cpg14x_config [include/init.inc.php:178] (1 ms)
        [1] => SELECT * FROM cpg14x_plugins ORDER BY priority [include/plugin_api.inc.php:54] (0 ms)
        [2] => SELECT name, value FROM cpg14x_bridge [include/functions.inc.php:4408] (0 ms)
        [3] => SELECT user_id, user_password, group_id FROM `abaldaia_phbb1`.phpbb_sessions INNER JOIN `abaldaia_phbb1`.phpbb_users ON session_user_id = user_id WHERE session_id = '117a35ea07df14f2730aab9e8be8c498' [bridge/phpbb3.inc.php:131] (0 ms)
        [4] => SELECT u.user_id AS id, u.username AS username, user_password AS password, ug.group_id AS group_id FROM `abaldaia_phbb1`.phpbb_users AS u, `abaldaia_phbb1`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2' [bridge/udb_base.inc.php:70] (0 ms)
        [5] => 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(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, MAX(access_level) AS access_level, 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) [bridge/udb_base.inc.php:321] (0 ms)
        [6] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:325] (0 ms)
        [7] => SELECT lang_id FROM cpg14x_languages WHERE enabled='YES' [include/init.inc.php:326] (0 ms)
        [8] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 [include/init.inc.php:384] (0 ms)
        [9] => DELETE FROM cpg14x_banned WHERE expiry < '2010-10-01 10:25:08' [include/init.inc.php:440] (0 ms)
        [10] => SELECT null FROM cpg14x_banned WHERE (user_id=2 OR '195.23.96.28' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:456] (0 ms)
        [11] => INSERT INTO cpg14x_categories (pos, parent, name, description) VALUES (10000, 0, 'ss', '') [catmgr.php:587] (0 ms)
        [12] => INSERT INTO cpg14x_categorymap (cid, group_id) VALUES (0, 2) [catmgr.php:594] (0 ms)
        [13] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' [include/functions.inc.php:2402] (0 ms)
        [14] => SELECT lang_id, abbr FROM cpg14x_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
        [15] => DELETE FROM cpg14x_temp_messages WHERE time < 1285943108 [include/functions.inc.php:4903] (0 ms)
    )

    ==========================
    GET :
    ------------------
    Array
    (
        [op] => createcat
    )

    ==========================
    POST :
    ------------------
    Array
    (
        [parent] => 0
        [user_groups] => Array
            (
               
  • => 2
            )

        [name] => ss
        [description] =>
        [cat_submit] => Alterar/Criar categoria
        [form_token] => 3f5836408f176455913e9ca6bbb96684
        [timestamp] => 1285946664
        [cid] => 0
    )

    ==========================
    COOKIE :
    ------------------
    Array
    (
        [cpg15x_data] => YTozOntzOjI6IklEIjtzOjMyOiJkNThkMjQ1Yjk5YTJhOTA0MDNmOWNjM2YyOTc4MTVhYiI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czoxMDoicG9ydHVndWVzZSI7fQ==
        [7d0d147a665830c5739864edcd30f874] => c3a01604274508d6597dcf6b5a92c60c
        [style_cookie] => null
        [phpbb3_envrd_u] => 2
        [phpbb3_envrd_k] =>
        [phpbb3_envrd_sid] => c1f63edf0f91071172efd6f3ac1a2225
        [phpbb3_envr_k] =>
        [phpbb3_envr_u] => 2
        [phpbb3_envr_sid] => 117a35ea07df14f2730aab9e8be8c498
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version        5.2.14 OK   
    MySQL version      5.1.50 OK   
    Coppermine version 1.5.6  stable

    ==========================
    Module: GD
    ------------------
    Exact version                    2.0.34                     
    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                      1                         
    XBM Support                      1                         
    JIS-mapped Japanese Font Support                           

    ==========================
    Key config settings
    ------------------
    site_url             http://fotografar.com.pt/galeria/           
    charset              utf-8                                       
    allow_private_albums 1                                           
    cookie_name          cpg15x                                     
    cookie_path          /                                           
    impath               /usr/bin/                                   
    lang                 brazilian_portuguese                       
    main_page_layout     breadcrumb/catlist/alblist/random,2/lastup,2
    silly_safe_mode      0                                           
    smtp_host                                                       
    theme                curve                                       
    thumb_method         im                                         

    ==========================
    Plugins
    ------------------

    ==========================
    Server restrictions
    ------------------
    safe_mode                                                 
    safe_mode_exec_dir                                       
    safe_mode_gid                                             
    safe_mode_include_dir                                     
    sql.safe_mode                                             
    disable_functions        dl                               
    file_uploads             1                               
    include_path             .:/usr/lib/php:/usr/local/lib/php
    open_basedir                                             
    allow_url_fopen          1                               
    max_execution_time       30                               
    max_input_time           60                               
    upload_max_filesize      64M                             
    post_max_size            64M                             
    memory_limit             64M                             
    suhosin.post.max_vars                                     
    suhosin.request.max_vars                                 


    ==========================
    Page (performance)
    ------------------
    Parameter        Current Peak   
    Memory usage     2.66 MB 4.04 MB
    Page generation  90 ms   90 ms 
    Page query time  1 ms    1 ms   
    Page query count 16      16     


    ==========================
                   

Joachim Müller

#1
October 01, 2010, 07:22:35 PM
Not a valid bug report. Not even a valid support request. Moving from cpg1.5 Testing/Bugs to the corresponding support board. Provide the needed details as per documentation if you want help.

Nibbler

#2
October 01, 2010, 07:30:43 PM
Fix is to change include/functions.inc.php

Code Select

function cpg_db_last_insert_id()
{
    return mysql_insert_id();
}


to

Code Select

function cpg_db_last_insert_id()
{
    global $CONFIG;

    return mysql_insert_id($CONFIG['LINK_ID']);
}


Commited in 7947
Print
Go Up Pages1
User actions