Print

[CuTe_MaN]

i have finished integrating CPG1.4 with SMF and i got all users from my forum registered in the gallery database

but i wanted to enter the Admin Tools again but I get this problem

"There was an error while processing a database query"

if any body can help

thx

[Nibbler]

Enable debug mode and post the mysql error message that you get (not the entire debug output).

[CuTe_MaN]

how i can do that?

and i have posted the error message that i am getting and it is

"There was an error while processing a database query"

thx

[Nibbler]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_misc

[CuTe_MaN]

I have enabled the Encoding and i got this messages:

Code: [Select]

While executing query "SELECT aid, category, IF(memberName IS NOT NULL,
CONCAT('(', memberName, ') ', a.title),
CONCAT(' - ', a.title)) AS title
FROM cpg140_albums AS a
LEFT JOIN `sabouni_uaeu`.smf_members AS u
ON category = (10000 + ID_MEMBER)
ORDER BY category, title" on Resource id #23

mySQL error: No Database Selected

and it says that the problem is in
("\include\functions.inc.php - Line: 248")

file

 i hope that you can help me in the problem

thx

[Nibbler]

Can you look in bridge/udb_base.inc.php towards the end of the file, find the query

Code: [Select]

$query = "SELECT aid, category, IF({$this->field['username']} IS NOT NULL,
CONCAT('(', {$this->field['username']}, ') ', a.title),
CONCAT(' - ', a.title)) AS title
FROM {$CONFIG['TABLE_ALBUMS']} AS a
LEFT JOIN {$this->usertable} AS u
ON category = (" . FIRST_USER_CAT . " + {$this->field['user_id']})
ORDER BY category, title";

$result = cpg_db_query($query, $this->link_id);

and change that last bit to

Code: [Select]

$result = cpg_db_query($query);


[CuTe_MaN]

i have tried it and it is working well thank you