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
Make sure you are using the correct version of the bridge for your IPB version.
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.
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?
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
$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:
$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...
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. :-[
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.
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?
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!
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?
enable debug mode in coppermine config to see what query actually fails.
Joachim
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?!?! :P :P IT WORKS!!
Thankyou so much GauGau. If I hadnt set it to debug mode, I would have never figured that out!
sorry not to have replied earlier to your replies. works for me. thanks
Guys,
I've had a same problem.
I went thought all steps of this topic and I'm getting the same error:
Fatal error :
There was an error while processing a database query
What else can I do?
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
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?
Quotedo 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)
log in as admin, admin mode, config, debug mode
Please look through the documentation at the top of the page: FAQ and Documentation
Quote from: Shurik_A on November 06, 2004, 01:51:08 PMHow 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
as
I just opened another thread