Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

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

0 Members and 1 Guest are viewing this topic.

baba12345

  • Coppermine newbie
  • Offline Offline
  • Posts: 16

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: 16
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: 16
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: 16
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: 16
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: 16
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: 47843
  • 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: 16
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.02 seconds with 19 queries.