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
Enable debug mode and post the mysql error message that you get (not the entire debug output).
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
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_misc
I have enabled the Encoding and i got this messages:
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
Can you look in bridge/udb_base.inc.php towards the end of the file, find the query
$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
$result = cpg_db_query($query);
i have tried it and it is working well thank you