coppermine-gallery.com/forum

Hi,

Right now I'm getting the error below whenever I try to access anything in my coppermine directory.

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

I have changed all the files I'm supposed to to make the bridge work, but it's not working right now.  If I change the init.inc.php and comment out the phpbb reference then everything is fine. 

Quotedefine('UDB_INTEGRATION', 'phpbb');

If remove the comment in front of the line above nothing works.  I try to go to the root directory (http://www.sitename.com/coppermine) of the gallery and look at any page I get the error above.  I get the same error even if I try to go to the site/coppermine/phpinfo.php.  So that's really got me weirded out. :)

I have read several post where someone references debug mode by saying, "It's at the bottom of the page." So I wanted to ask, what page?  What do I do when I find the page?

One more thing.  I was able to insert the tables to the same database the board is in.  I can see them when I access my SQL Database tool. I see the tables there.

Thank you for any assistance.

It's at the bottom of the config page which you would access while in admin mode.

Quote from: TranzNDance on January 10, 2005, 07:32:46 AM
It's at the bottom of the config page which you would access while in admin mode.

Hi,

What's the name of the config page? Is it the coppermine config.php, config.ini.php file? I've looked there and I can't see anything that says debug.

In the config.php all I see as far as debug mode is in here:

function form_lang_debug($text, $name)

and here

case 9 :
  form_lang_debug($element[0], $element[1]);
  break;

Other than than I don't see any link to a debug mode.  What do I need to do to turn it on there??

Thank you. :)

Log in as admin to the gallery. You will find a link 'Config', click on it and you will get the config page. Now scroll down the page and go to 'Miscellaneous settings' section. There you will find the option 'Enable Debug mode' with three radio buttons. Check the appropriate radio button

You can directly go to config page using following URL
http://www.yourdomaincom/cpgfolder/admin.php

The config page's url actually is http://www.yourdomaincom/cpgfolder/config.php for cpg1.3.x (it has been changed to http://www.yourdomaincom/cpgfolder/admin.php only in cpg1.4.x, the devel version, which goes unsupported).

Joachim

Sorry for the goof up.

hehe, no problem ;D - after all that's an error that can be easily adjusted by someone who has been around on this project for a longer time; you're doing excellent support work, don't get discouraged by the slight correction.

Joachim

Hi,

Thank you so much.  I was able to change the inc.inc.php file back to the original form (the one that had the line I listed above referring to phpbb commented out).  I then went in as you instructed and turned debug on at the bottom of the config.php page after clicking on the config button at the top of the page.

After I completed what you instructed me to do I put the newer inc.inc.php file back on the server. This file had the phpbb line uncommented again.  As expected I got the same error and just like you told me it had the SQL code there. :)

Quote
Fatal error :

There was an error while processing a database query

While executing query "SELECT user_id, username as user_name, user_level FROM `domain_phpbb`.phpbb_sessions INNER JOIN `domain_phpbb`.phpbb_users ON session_user_id = user_id WHERE session_id='bde9cc8542115e3319d0b002b09f475b' AND session_user_id ='2' AND user_active='1'" on 0

mySQL error: Table 'domain_phpbb.phpbb_sessions' doesn't exist

This kind of points to me doing something wrong in the setup.  When I set up the site the first time I used the install.php page.  I put in all of the info it requested and it told me it was successful. I then looked in the db and I see the tables that are labeled for the gallery database.  I know they are there because they all start with cfg132.

After I'd done that I tried to setup the bridge. :\'(  Was that part of my fatal flaw?

Thanks again for everyone's help. :)

SELECT * FROM `sessions`  LIMIT 0 , 30

session_id = bde9cc8542115e3319d0b002b09f475b
session_user_id = 2
session_start = 1105334219
session_time = 1105336826
session_ip = 44319e4e
session_page = 0
session_logged_in = 1

Here is the info I get from the sessions table when I did a query of it in the domain_phpbb.

I'm not sure if that helps.

Are coppermine and phpbb in the same database ?

Hi Nibbler,

Yes, I'm pretty sure I did.

Quote from: Beauty on January 10, 2005, 02:32:10 PM

... When I set up the site the first time I used the install.php page.  I put in all of the info it requested and it told me it was successful. I then looked in the db and I see the tables that are labeled for the gallery database.  I know they are there because they all start with cfg132.

After I'd done that I tried to setup the bridge. :\'(  Was that part of my fatal flaw? ...

Thank you for helping. :)

OK, so:

1) Is the database named domain_phpbb ?
2) Can you see the table phpbb_sessions in the database ?

Hi again, :D

1) I did modify the name it's domain_db_-_phpbb (i figured I'd take out the extra stuff)
2) I see a table named sessions and it's in the domain_db_-_phpbb database.  I do not see a table called phpbb_sessions however. :(

Thanks again (sorry if saying thanks gets too repetitive) :D

Hi,

I hate to bump this, but I was wondering if anyone has any clue what this may be or if I should just re-install after removing the cfg tables from the phpbb2 database?

Thanks in advance.

If you PM me FTP and phpmyadmin login details I'll take a look at it for you, I don't think I can offer any more suggestions.

Hi,

Ok. I think I've got it figured out.  For some reason the SQL query about is adding phpbb_ to the users table call in the query.  It should be "users" less the phpbb_ :(  Does anyone know what config file is being called to append the table name?

So in the SQL query the table name is coming out like this:
SELECT user_id, username as user_name, user_level FROM `domain_-_phpbb`.phpbb_users WHERE user_id='2' AND user_password='x' AND user_active='1'

I ran the SQL query without the phpbb_ and it successfully grabbed the information and would have logged me if i had the ability to remove the phpbb_.

Thanks :D

Hi,

Ok.  All solved. :D

I located the phpbb.inc.php page in the bridge directory and I removed phpbb_ from the line below
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables

When I did that everything worked fine and now my integration of phpbb and coppermine is now complete.

Thank you!