problem bridging phpbb2.0.18 + with coppermine problem bridging phpbb2.0.18 + with coppermine
 

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

Main Menu

problem bridging phpbb2.0.18 + with coppermine

Started by anime-me, September 02, 2006, 02:51:19 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

anime-me

I am getting this error when completing the bridge wizard:
There was an error while processing a database query.

and this is the error when debug mod is enbaled:
While executing query "SELECT * FROM `anime-me_com___forum `.phpbb_groups WHERE group_single_user = 0" on 0

mySQL error: Access denied for user: 'admin_anime@127.0.0.1' to database 'anime-me_com___forum '


also this is right below the previous message:
File: C:\Program Files\Ensim\WEBppliance\SiteData\Domains\anime-me.com\ROOT\Inetpub\wwwroot\cpg149\include\functions.inc.php - Line: 249

This is the debug info:
USER:
------------------
Array
(
    [ID] => 5f9473c86b4ca79393b0d303dbef97ee
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => venom
    [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.307s)
    [1] => select * from cpg149_plugins order by priority asc; (0.311s)
    [2] => delete from `anime-me_com___jos`.cpg149_sessions where time<1157154348 and remember=0; (0.294s)
    [3] => delete from `anime-me_com___jos`.cpg149_sessions where time<1155948348; (0.297s)
    [4] => select user_id from `anime-me_com___jos`.cpg149_sessions where session_id=md5("b550371f0702f67b6c99ef3696f68ff4872afe57225d53d969161bb87097c9ad"); (0.296s)
    [5] => select user_id as id, user_password as password from `anime-me_com___jos`.cpg149_users where user_id=1 (0.307s)
    [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 `anime-me_com___jos`.cpg149_users AS u INNER JOIN `anime-me_com___jos`.cpg149_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.302s)
    [7] => SELECT user_group_list FROM `anime-me_com___jos`.cpg149_users AS u WHERE user_id='1' and user_group_list <> ''; (0.302s)
    [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.292s)
    [9] => SELECT group_name FROM  cpg149_usergroups WHERE group_id= 1 (0.182s)
    [10] => update `anime-me_com___jos`.cpg149_sessions set time='1157157950' where session_id=md5('b550371f0702f67b6c99ef3696f68ff4872afe57225d53d969161bb87097c9ad'); (0.147s)
    [11] => SELECT user_favpics FROM cpg149_favpics WHERE user_id = 1 (0.138s)
    [12] => DELETE FROM cpg149_banned WHERE expiry < '2006-09-02 00:45:51' (0.31s)
    [13] => SELECT * FROM cpg149_banned WHERE (ip_addr='82.167.33.127' OR ip_addr='82.167.33.127' OR user_id=1) AND brute_force=0 (0.312s)
    [14] => SELECT COUNT(*) FROM cpg149_pictures WHERE approved = 'NO' (0.169s)
    [15] => SELECT * FROM cpg149_bridge (0.297s)
    [16] => UPDATE cpg149_bridge SET value = '1' WHERE name = 'use_post_based_groups' (0.306s)
    [17] => UPDATE cpg149_config SET value = '1' WHERE name = 'bridge_enable' (0.296s)
    [18] => SELECT * FROM cpg149_bridge (0.281s)
    [19] => SELECT * FROM cpg149_config (0.324s)
    [20] => SELECT * FROM `anime-me_com___forum `.phpbb_groups WHERE group_single_user = 0 (0.295s)
)

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

==========================
POST :
------------------
Array
(
    [use_post_based_groups] => 1
    [hide_unused_fields] => 1
    [submit] => next»
    [step] => finalize
)

==========================
VERSION INFO :
------------------
PHP version: 4.2.3 - OK
------------------
mySQL version: 4.0.12-max-nt
------------------
Coppermine version: 1.4.9(stable)
==========================
Module: gd
------------------
GD Supportenabled
GD Version2.0 or higher
FreeType Supportenabled
FreeType Linkagewith freetype
JPG Supportenabled
PNG Supportenabled
WBMP Supportenabled
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links0
Active Links1
Client API version3.23.39
==========================
Module: zlib
------------------
module doesn't exist
==========================
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 | 1 | 1
include_path | .;c:\php4\pear | .;c:\php4\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | anime@anime-me.com | anime@anime-me.com
sendmail_path | no value | no value
SMTP | localhost | localhost |  |
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30 |  |
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 6.216 seconds - 21 queries in 5.765 seconds - Album set : ; Meta set: ;


Coppermine install: http://anime-me.com/cpg149
Forum install: http://anime-me.com/forum
Coppermine version: cpg1.4.9
Forum version: PHPBB 2.0.19
Test user account: NA

BridgeManager settings:
Forum URL:  http://anime-me.com/forum
Relative path to your BBS's config file:  ../forum/
Use post-based groups?:  1 

thanks to everone who takes the time to help ^^

Nibbler

Do you have a space at the end of your database name in phpbb's config.php file? If so try removing it.

anime-me

#2
NVM, problem solved :D
thx nibbler for ur kind help.