Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error : 'There was an error while processing a database query'  (Read 26974 times)

0 Members and 1 Guest are viewing this topic.

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13

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

Nibbler

  • Guest
Re: Error : 'There was an error while processing a database query'
« Reply #1 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.
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #2 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

Logged

Nibbler

  • Guest
Re: Error : 'There was an error while processing a database query'
« Reply #3 on: March 10, 2006, 07:55:06 pm »

Are SMF and Coppermine installed in the same database ?
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #4 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
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #5 on: March 10, 2006, 08:16:28 pm »

smf_settings table is in DIWAN database not in BAASK db.
Logged

Nibbler

  • Guest
Re: Error : 'There was an error while processing a database query'
« Reply #6 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.
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #7 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.

Logged

Nibbler

  • Guest
Re: Error : 'There was an error while processing a database query'
« Reply #8 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.
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #9 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Error : 'There was an error while processing a database query'
« Reply #10 on: March 12, 2006, 01:21:18 pm »

please stop shouting!
Logged

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Error : 'There was an error while processing a database query'
« Reply #11 on: August 02, 2011, 09:02:44 am »

I stopped now. I was a teenager that time  :-[
Logged
Pages: [1]   Go Up
 

Page created in 0.028 seconds with 21 queries.