Topic: CPG 1.3.2 and IPB 2.0 (Read 10543 times)

bhoang · « **on:** October 04, 2004, 03:46:47 am »

Hi there, when I try to integrate Coppermine with IPB, I get the following message:
Fatal error :

There was an error while processing a database query.

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `ghoang_cpg132`.ibf_members WHERE id='1' AND password='3d8dffde2e70a30573aab29448c0e6b6'" on 0

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

Can you help? Thanks

Nibbler · « **Reply #1 on:** October 04, 2004, 03:09:46 pm »

Make sure you are using the correct version of the bridge for your IPB version.

Laibeus Lord · « **Reply #2 on:** October 06, 2004, 04:43:48 am »

Open the IPB bridge and look for 'password' change it to 'legacy_password' (not including the ' ' ). IPB2 now use 'legacy_password' instead of 'password' in its mysql table.

Reply here if it worked, if not I'll give you another solution.

MaTTyBoI · « **Reply #3 on:** October 07, 2004, 03:41:35 pm »

Im getting the same error. I had IPB 1.3, and upgraded to 2.0 and now my gallery just says

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

And I tried the updating of the IPB bridge, but you didnt say which part to edit. There are 4 instances of 'password' in the Bridge file..

define('IB_DB_NAME', '*************'); // 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_legacy_password', '*************'); // The legacy_password to use to connect to the database

See those two legacy passwords? they were orignially just 'password'
is that what we are ment to change?

Laibeus Lord · « **Reply #4 on:** October 07, 2004, 09:53:05 pm »

sorry, was in a hurry last time...

change back IB_DB_legacy_password to IB_DB_PASSWORD, it is your password to the DB not to your users IPB password.

anyway here:

(for IPBv2 Final only and up)

look for

Code: [Select]

$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND password='$cookie_pass'";

and replace with:

Code: [Select]

$sql = "SELECT id as user_id, name as user_name, mgroup " . "FROM " . $UDB_DB_NAME_PREFIX . IB_TABLE_PREFIX . IB_USER_TABLE . " " . "WHERE id='$cookie_uid' AND member_login_key='$cookie_pass'";

i checked IPB2's table, it is stored in member_login_key and not in legacy_password.
you'll be fine

now i have to figure out how to add the secondary_group support for CPG...

MaTTyBoI · « **Reply #5 on:** October 07, 2004, 11:22:35 pm »

Thankyou very much for your help...

Unfortunately I am still getting that same error. Im afraid I will have to re-install Coppermine and start from the beginning..again.

Laibeus Lord · « **Reply #6 on:** October 08, 2004, 03:57:39 pm »

hmm... if you upgraded from IPB1.3 to IPB2... let's see... can you browse your IPB SQL table named "ibf_members"? check if you have the column named "member_login_key", if it has data in it then your passwords are stored there.

but I suggest you post the error here to be sure.

MaTTyBoI · « **Reply #7 on:** October 23, 2004, 03:11:01 pm »

I have done a complete new install of Invision. I installed Coppermine. It works fine as a standalone....

but once I do the IPB2 bridge

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

I am actually using IPB 2.0.1
would that be making the difference, should I only use 2.0.0?

MaTTyBoI · « **Reply #8 on:** October 23, 2004, 03:44:56 pm »

I figured it out.

By having Invision 2.0.1, thats why it didnt work. I now use 2.0.0 and it works perfectly!

MaTTyBoI · « **Reply #9 on:** October 24, 2004, 06:57:01 am »

I was wrong. Again.

I need to create extra groups for my forums, and as soon as you change from the default invision groups, to your new groups, coppermine just gives up and says

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

Thats all it says. Nothing else. Does anyone know why Coppermine cant handle extra groups in invision 2.0.0?

Joachim Müller · « **Reply #10 on:** October 24, 2004, 02:10:14 pm »

enable debug mode in coppermine config to see what query actually fails.

Joachim

MaTTyBoI · « **Reply #11 on:** October 25, 2004, 10:28:35 am »

HAHA! Thankyou for telling me to do that! I found the problem!! My invision board's database prefix is 'invision_' where as the invision board bridge file is looking for 'ibf_'
so, I replaced it with the right one, and guess what?!?!

IT WORKS!!

Thankyou so much GauGau. If I hadnt set it to debug mode, I would have never figured that out!

bhoang · « **Reply #12 on:** November 01, 2004, 11:52:24 pm »

sorry not to have replied earlier to your replies. works for me. thanks

Shurik_A · « **Reply #13 on:** November 05, 2004, 08:48:24 pm »

Guys,
I've had a same problem.
I went thought all steps of this topic and I'm getting the same error:

Code: [Select]

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

What else can I do?

Joachim Müller · « **Reply #14 on:** November 06, 2004, 07:30:24 am »

do what I suggested to the other posters on this thread, worked for them as well. You should read a thread entirely before replying to it, not just lazily dump your question and wait for someone else to fix your issues

.

Joachim

Shurik_A · « **Reply #15 on:** November 06, 2004, 01:51:08 pm »

Quote from: GauGau on October 24, 2004, 02:10:14 pm

enable debug mode in coppermine config to see what query actually fails.

Joachim

How do I exactly anabling the debug mode?

Quote

do what I suggested to the other posters on this thread, worked for them as well. You should read a thread entirely before replying to it, not just lazily dump your question and wait for someone else to fix your issues .

And, actually, that is what I did (almost)

Tranz · « **Reply #16 on:** November 06, 2004, 04:48:06 pm »

log in as admin, admin mode, config, debug mode

Please look through the documentation at the top of the page: FAQ and Documentation

Joachim Müller · « **Reply #17 on:** November 06, 2004, 05:48:17 pm »

Quote from: Shurik_A on November 06, 2004, 01:51:08 pm

How do I exactly anabling the debug mode?

I guess it should be quite clear that you should log in as coppermine admin if you want to change anything - you obviuoulsy wouldn't want other users to change your coppermine gallery's appearance and settings, that's why it's mandatory to log in as admin. Then my instructions given before

Quote from: GauGau on October 24, 2004, 02:10:14 pm

enable debug mode in coppermine config to see what query actually fails.

should be quite clear.
Like TranzNDance already said: the first place to look for help should always be the documentation. Read it, if you have questions: re-read it; and if there are more questions, search the board. Only if you don't manage to come up with an asnwer after having done so, you should post a question on the board.

Joachim

zacoo · « **Reply #18 on:** March 02, 2005, 12:38:23 am »

zacoo · « **Reply #19 on:** March 02, 2005, 01:15:07 am »

I just opened another thread

News:

Author Topic: CPG 1.3.2 and IPB 2.0 (Read 10543 times)

Nibbler