I installed SMF RC3 and Coppermine. After that I successfully bridged those two together but after this I have a problem with trying to set album properties and batch add file. I used debug mode to get more specific info here.
I get the following Critical error when trying to set album properties:
There was an error while processing a database query.
While executing query "SELECT aid, CONCAT('(', memberName, ') ', a.title) AS title
FROM cpg_albums AS a
INNER JOIN `gweop_kanta`.smf_members AS u
ON category = (10000 + ID_MEMBER)
ORDER BY title" on 0
mySQL error: Illegal mix of collations for operation 'concat'
File: /home/gweop/domains/gweop.arkku.net/public_html/cpg/include/functions.inc.php - Line: 249
And the following Critical Error after trying batch add files:
There was an error while processing a database query.
While executing query "SELECT aid, CONCAT('(', memberName, ') ', a.title) AS title
FROM cpg_albums AS a
INNER JOIN `gweop_kanta`.smf_members AS u
ON category = (10000 + 2) AND ID_MEMBER = 2 ORDER BY title" on 0
mySQL error: Illegal mix of collations for operation 'concat'
File: /home/gweop/domains/gweop.arkku.net/public_html/cpg/include/functions.inc.php - Line: 249
These errors don't appear, if the bridge is off. So is there some bug somewhere in the database or is the bridge-file corrupted?
Coppermine install: http://gweop.arkku.net/cpg/
Forum install: http://gweop.arkku.net/smf/
Coppermine version: CPG1.4.9 (stable)
Forum version: SMF RC3
Test user account: test / testtest
BridgeManager settings:
Forum URL: http://gweop.arkku.net/smf
Relative path to your BBS's config file: ../smf/
Use post-based groups?: 0
Thanks beforehand - ^Phantom
http://forum.coppermine-gallery.net/index.php?topic=35927.0
Ok.. Thanks for the help.
BTW where can I find the MySQL command to correct the problem? I don't know php or MySQL so much to do it just by myself and I couldn't find any info from the net...
This is not related to coppermine
Here is what i've got from mysql.org :
ALTER TABLE tbl_name
[[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]
something like this should work for you
ALTER TABLE cpg_albums DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
you need run this query for each table that has different collation or you could simply change database collation by running this query
ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name]
Got the problem solved... ;D
Thanks for the help.. :)