trouble integrating invision board 2.0.3 & coppermine 1.3.3

[mattpist]

hi, i bridged coppermine and my invision board and everything worked fine for about 24 hours. i could log into the message board, and then go to coppermine and administate the board. i set up a few albums and everything seemed fine.

today though, every time i clicked on the 'login' link on coppermine, it takes me to the forum login, i log in, but when i go back to coppermine, it didn't register that i was logged in (i.e. no admin buttons, and still displays the register/login link). i had a feeling that it was some kind of cookie problem, although i followed the instructions in the documentation to the letter.

but a few minutes later, im getting this error when going to coppermine:

Code Select Expand

Fatal error :
There was an error while processing a database query

now i cant get into coppermine at all, and can't get any debug info.

here's my bridge file (invisionboard.inc.php):

Code Select Expand

// ------------------------------------------------------------------------- //
// Modify the values below according to your Board installation              //
// ------------------------------------------------------------------------- //

// database configuration
define('IB_DB_NAME', '*****_wordpress'); // The name of the database used by the board
define('IB_BD_HOST', 'localhost'); // The name of the database server
define('IB_DB_USERNAME', '******'); // The username to use to connect to the database
define('IB_DB_PASSWORD', '******'); // The password to use to connect to the database

// The web path to your Invision Board directory
// In this example http://yoursite_name.com/ivboard/
define('IB_WEB_PATH', '/forums/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your installation is standard
// ------------------------------------------------------------------------- //
// The prefix for the Invision Board cookies
define('IB_COOKIE_PREFIX', ''); // The prefix used for board cookies

// Prefix and names for the database tables
define('IB_TABLE_PREFIX', 'ibf_'); // The prefix used for the DB tables
define('IB_USER_TABLE', 'members'); // The members table
define('IB_SESSION_TABLE', 'sessions'); // The sessions table
define('IB_GROUP_TABLE', 'groups'); // The groups table

// Group definitions (default values used by the board)
define('IB_VALIDATING_GROUP', 1);
define('IB_GUEST_GROUP', 2);
define('IB_MEMBERS_GROUP', 3);
define('IB_ADMIN_GROUP', 4);
define('IB_BANNED_GROUP', 5);

my website is http://www.squattheplanet.com/wordpress
the board url is: http://www.squattheplanet.com/forums
the cpg url is: http://www.squattheplanet.com/gallery

is my sql table corrupt? im not sure what's going on, as it seemed to be working fine for the first day.

edit: i just tried it again, and the error isn't coming up anymore. but it's still not registering that im logged into coppermine (like above). also, i created a user called "testuser1000" with password "testme" if you need to test anything. there's a link at the top of the forum page that will take you back to the gallery

thanks!

[Nibbler]

If you disable the bridge, enable debug mode, then re-enable the bridge you can get the actual error message that can tell us what the problem is.

[mattpist]

okay, so i disabled the bridge, turned on debug mode, and re-enabled the bridge. still the same problem with not showing up as logged in in coppermine, but there doesn't seem to be any error messages... but ill repost the debug info after logging in here:

Code Select Expand

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

==========================
USER DATA:
------------------
Array
(
    [0] => 2
    [group_id] => 2
    [1] => Guests
    [group_name] => Guests
    [2] => 1024
    [group_quota] => 1024
    [3] => 0
    [has_admin_access] => 0
    [4] => 1
    [can_rate_pictures] => 1
    [5] => 1
    [can_send_ecards] => 1
    [6] => 1
    [can_post_comments] => 1
    [7] => 0
    [can_upload_pictures] => 0
    [8] => 0
    [can_create_albums] => 0
    [9] => 1
    [pub_upl_need_approval] => 1
    [10] => 1
    [priv_upl_need_approval] => 1
    [11] => 0
    [upload_form_config] => 0
    [12] => 0
    [custom_user_upload] => 0
    [13] => 1
    [num_file_upload] => 1
    [14] => 1
    [num_URI_upload] => 1
    [groups] => Array
        (
            [0] => 2
        )

    [can_see_all_albums] => 0
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg133_filetypes;
    [1] => SELECT member_id as user_id, member_name as user_name, member_group as mgroup FROM `squat2_wordpress`.ibf_sessions WHERE id = '68c7aefe19873bf76b8415371545ad4a' AND ip_address = '66.45.222.65'
    [2] => SELECT * FROM cpg133_usergroups WHERE group_id = 2
    [3] => DELETE FROM cpg133_banned WHERE expiry < '2005-08-25 16:21:20'
    [4] => SELECT * FROM cpg133_banned WHERE ip_addr='66.45.222.65' OR ip_addr='66.45.222.65' OR user_id=0
    [5] => SELECT aid FROM cpg133_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (2)
    [6] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = ''  ORDER BY pos
    [7] => SELECT aid FROM cpg133_albums as a WHERE category>=10000
    [8] => SELECT count(*) FROM cpg133_pictures as p, cpg133_albums as a WHERE p.aid = a.aid AND category >= 10000
    [9] => SELECT cid, name, description, thumb FROM cpg133_categories WHERE parent = '1'  ORDER BY pos
    [10] => SELECT aid FROM cpg133_albums as a WHERE category = '0'
    [11] => SELECT count(*) FROM cpg133_albums as a WHERE 1
    [12] => SELECT count(*) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1
    [13] => SELECT count(*) FROM cpg133_comments as c LEFT JOIN cpg133_pictures as p ON c.pid=p.pid LEFT JOIN cpg133_albums as a ON a.aid=p.aid WHERE 1
    [14] => SELECT count(*) FROM cpg133_categories WHERE 1
    [15] => SELECT sum(hits) FROM cpg133_pictures as p LEFT JOIN cpg133_albums as a ON p.aid=a.aid WHERE 1
    [16] => SELECT count(*) FROM cpg133_albums as a WHERE category = '0'
    [17] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg133_albums as a LEFT JOIN cpg133_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,5
    [18] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (1, 2, 3, 4, 5) AND approved = 'YES' GROUP BY aid
    [19] => SELECT COUNT(*) from cpg133_pictures WHERE approved = 'YES'
    [20] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8
    [21] => SELECT COUNT(*) from cpg133_pictures WHERE approved = 'YES'
    [22] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg133_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
)

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

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

==========================
Page generated in 0.046 seconds - 23 queries in 0.002 seconds - Album set :

[Nibbler]

Code Select Expand

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `squat2_wordpress`.ibf_members WHERE id='0' AND password='*'" on 0

mySQL error: Unknown column 'password' in 'where clause'

This is a common error. It means you are using the wrong bridge file. An IPB2 bridge file is available on the mods board. Also you have some cookies set on squattheplanet.com and some set on www.squattheplanet.com which is confusing things.

[mattpist]

hey, thanks for the quick reply! ill check out that ipb2 bridge file... but how do i fix the cookies problem?

thanks again!

[mattpist]

i tried the v2 bridge file and everything works great! i can login/out fine, and it's showing that im logged in in the gallery. it took me a bit of looking though to find the file. if anyone's trying to find it, you can here:

http://forums.invisionize.com/index.php?showtopic=50849&hl=coppermine

you'll have to be registered for the forums though.

thanks again for the help!

p.s. the login redirection hack there works great for me too.

[Joachim Müller]

That's not the bridge file Nibbler was refering to - he was refering to INVISION 2.0 Bridge - v1.0. The stuff you are refering to is not an actual bridge file, but an unsupported port that is not recommended to be used, as it is known to cause issues.