Error : 'There was an error while processing a database query'

[baba12345]

I've installed cpg 1.3 on www.baask.com/gallery

and using SMF 1.0.6 on www.baask.com/diwan

in smf.inc.php file, I made the following changes

Code Select Expand


// Set this to the location of your Settings file:
$path = '../diwan';


and

Code Select Expand


// database configuration
define('SMF_DB_NAME', 'diwan'); // The name of the database used by the board
define('SMF_DB_HOST', '66.116.221.1'); // The name of the database server
define('SMF_DB_USERNAME', 'admin'); // The username to use to connect to the database
define('SMF_DB_PASSWORD', '******'); // The password to use to connect to the database


Coppermine and SMF are on different databases.

I'm facing the following error

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

[Nibbler]

Disable the bridge, enable debug mode, re-enable the bridge. Then post the mysql error message you receive.

[baba12345]

HI THANKS FOR THE RESPONSE

I DID AS WHAT YOU SAID

THIS IS WHAT APPEARS

Code Select Expand

Fatal error :

There was an error while processing a database query.

THEN IN AN IFRAME

Code Select Expand


While executing query "
SELECT variable, value
FROM smf_settings" on 0

mySQL error: Table 'baask.smf_settings' doesn't exist



[Nibbler]

Are SMF and Coppermine installed in the same database ?

[baba12345]

No, they are not. Earlier I was using coppermine with phpBB, but recently I've moved to SMF.

Coppermine and phpBB were in same database, it was working great

[baba12345]

smf_settings table is in DIWAN database not in BAASK db.

[Nibbler]

For Coppermine 1.3, they must be in the same database. Either move them into the same database or update to 1.4 where they can work from different databases.

[baba12345]

oh 

CAN I MOVE COPPERMINE'S TABLES FROM 'BAASK' DB TO 'DIWAN' DB WITHOUT ANY PROBLEM? ANY HELP WOULD BE APPRECIATED.

[Nibbler]

If you move the tables you will need to update include/config.inc.php with the new db details.

[baba12345]

THANKS NIBBLER FOR YOUR GREAT HELP 

I'LL TRY TO EXPORT THE COPPERMINE TABLES THEN WILL TRY TO IMPORT IT TO THE DB WHERE SMF IS

THANKS ONCE AGAIN

[Joachim Müller]

please stop shouting!

[baba12345]

I stopped now. I was a teenager that time