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

[Cool Surfer]

Hi all friends
I have installed coppermine 1.33, and previously had 1.31.

If I edit file > include/init.inc.php. and uncomment the invision line, I get the

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

and if i dont uncomment it, then the gallery works but does not pick up the members from
invision sql.

the other parameters and cookies are same for both coppermine and invsion2 forum .

Pl suggest me where I am faultering.

Regards

James

[kegobeer]

Enable debug mode and post the actual error message you get.

[Incite]

I am actually having the same problem, however with phpBB. I have read over to forums for about the past 5 hours.. and I think i may have found the problem. I have my phpBB and coppermine in different databases but on the same server, do they need to be in one DB? and is this possibly the reason for the error? My next question would be.. how do I integrate the DB's without loosing all my information on one or the other. I hope that I am being clear.. I appologise if it doesn't make sense.

[kegobeer]

I am actually having the same problem, however with phpBB. I have read over to forums for about the past 5 hours.. and I think i may have found the problem. I have my phpBB and coppermine in different databases but on the same server, do they need to be in one DB? and is this possibly the reason for the error? My next question would be.. how do I integrate the DB's without loosing all my information on one or the other. I hope that I am being clear.. I appologise if it doesn't make sense.

Without the error message, I can't be certain you have the same problem.  You also must enable debug mode and post the error message.  Regarding databases, from the documentation:

5.2.5 Keep Coppermine and bbs tables in the same database
It is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

So, you must have your tables in the same database.  Either move your Coppermine tables to your forum database, or the other way around.  You just have to change Coppermine's config.inc.php to reflect the new database, username, and password, or you have to change your forum's configuration file.

[Voltus]

This is the exact error message that I got. Please help. All this are just confusing to me. 

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

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

[kegobeer]

5.2.5 Keep Coppermine and bbs tables in the same database
It is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

So, you must have your tables in the same database.  Either move your Coppermine tables to your forum database, or the other way around.  You just have to change Coppermine's config.inc.php to reflect the new database, username, and password, or you have to change your forum's configuration file.

So, do SMF and Coppermine share the same database?

[Incite]

While executing query "SELECT COUNT(*) FROM **ERROR**" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '**ERROR**' at line 1


This is the error MSG that I recieved.

[kegobeer]

5.2.5 Keep Coppermine and bbs tables in the same database
It is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

So, you must have your tables in the same database.  Either move your Coppermine tables to your forum database, or the other way around.  You just have to change Coppermine's config.inc.php to reflect the new database, username, and password, or you have to change your forum's configuration file.

So, do SMF and Coppermine share the same database?

[Nibbler]

While executing query "SELECT COUNT(*) FROM **ERROR**" on 0

That means you are trying to use a mod written for unbridged coppermine with a bridged version of coppermine.

[Incite]

So I guess the best thing to do would be remove all the mods untill I find the one that doesn't work?

[Incite]

Ok, I upgraded from 1.3.1 to 1.3.3 and it seemed to be workinf ok, I tried to integrate again.. and this is the error MSG's I am recieving now.

While executing query "SELECT user_name, user_id, group_name, COUNT(*) AS numcom FROM cpg11d_comments, **ERROR**, cpg11d_usergroups WHERE user_id = author_id AND user_group = group_id GROUP BY author_id ORDER BY numcom DESC LIMIT 5" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '**ERROR**, cpg11d_usergroups WHERE user_id = author_id AND user

[kegobeer]

You are trying to use mods written for an unbridged version of Coppermine in a bridged environment.  They obviously aren't working.  Reply to the mod threads with your problems.

[Incite]

Ok, I have no switched my forum to IPB from phpBB.. However after bridging I am once again running into a database error. Sorry for the trouble, I just don't understand this stuff.. so your help is greatly appreciated 

here is the error msg I am getting in debug mode

Code Select Expand

While executing query "SELECT id as user_id, name as user_name, mgroup FROM `*****`.ibf_members WHERE id='2' AND password='******'" on 0

mySQL error: Unknown column 'password' in 'where clause'

[Joachim Müller]

do as kegobeer suggested. There's nothing more to say in this thread. Locking it.