Critical error in album properties and batch add file after bridge

[^Phantom]

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.

Code Select Expand


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.

Code Select Expand


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

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=35927.0

[^Phantom]

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...

[Sami]

This is not related to coppermine
Here is what i've got from mysql.org :

Code Select Expand


ALTER TABLE tbl_name
    [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]

something like this should work for you

Code Select Expand


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

Code Select Expand


ALTER DATABASE db_name
    [[DEFAULT] CHARACTER SET charset_name]
    [[DEFAULT] COLLATE collation_name]


[^Phantom]

Got the problem solved... 

Thanks for the help..