CPG 1.3.2 and IPB 2.0

[bhoang]

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]

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

[Laibeus Lord]

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]

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]

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 Expand


$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 Expand


$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]

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]

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]

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]

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]

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]

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

Joachim

[MaTTyBoI]

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]

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

[Shurik_A]

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

Code Select Expand

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

What else can I do?

[Joachim Müller]

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]

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

Joachim

How do I exactly anabling the debug mode?

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]

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]

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

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]

as

[zacoo]

I just opened another thread