forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: baba12345 on March 10, 2006, 05:18:11 pm

Title: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 05:18:11 pm

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]

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

and

Code: [Select]

// 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'

Title: Re: Error : 'There was an error while processing a database query'
Post by: Nibbler on March 10, 2006, 05:46:36 pm

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

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 07:26:39 pm

HI THANKS FOR THE RESPONSE

I DID AS WHAT YOU SAID

THIS IS WHAT APPEARS

Code: [Select]

Fatal error :

There was an error while processing a database query.
THEN IN AN IFRAME

Code: [Select]

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

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



Title: Re: Error : 'There was an error while processing a database query'
Post by: Nibbler on March 10, 2006, 07:55:06 pm

Are SMF and Coppermine installed in the same database ?

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 08:10:35 pm

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

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 08:16:28 pm

smf_settings table is in DIWAN database not in BAASK db.

Title: Re: Error : 'There was an error while processing a database query'
Post by: Nibbler on March 10, 2006, 08:17:38 pm

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.

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 08:23:53 pm

oh  :(

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

Title: Re: Error : 'There was an error while processing a database query'
Post by: Nibbler on March 10, 2006, 08:27:16 pm

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

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on March 10, 2006, 08:36:42 pm

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

Title: Re: Error : 'There was an error while processing a database query'
Post by: Joachim Müller on March 12, 2006, 01:21:18 pm

please stop shouting!

Title: Re: Error : 'There was an error while processing a database query'
Post by: baba12345 on August 02, 2011, 09:02:44 am

I stopped now. I was a teenager that time  :-[