upload by ftp after bridging with SMF and Joomla

[François Keller]

Hi,
after bridgin Coppermine with SMF and Joomla, i have the folowing error message when i try to upload files by batch add:
The error commes after clicking on the folder where i uploaded mi files (in the album folder of course)

There was an error while processing a database query.
While executing query "SELECT aid, CONCAT('(', memberName, ') ', a.title) AS title
                                                        FROM cpg149_albums AS a
                                                        INNER JOIN `tailledepierresavern`.smf_members AS u
                                                        ON category = (10000 + 1) AND ID_MEMBER = 1 ORDER BY title" on 0

mySQL error: Illegal mix of collations for operation 'concat'

Coppermine install: http://mysite.com/cpg149/
Forum install: http://mysite.com/Smf/
Joomla Install: http://mysite.com/
Coppermine version: cpg1.4.9
Joomla version:joomla 1.0.11
Forum version: SMF 1.1 RC3 
Test user account: N/A local site

BridgeManager settings:
Forum URL:  http://mysite.com/Smf/
Relative path to your BBS's config file:  ../Smf/
Use post-based groups?:  0

Can somone help me ?

[Nibbler]

What collations are you using?

[François Keller]

What collations are you using?

what do you mean ? (sorry i don't know what is it  :-\)

[Sami]

collation is related to Character setting of table and used to compare text and sort columns,
Check thoes tables properties and take a look at their collations setting, that should be the same

[François Keller]

ok i will check it  (it seems collation are note same  :-\)

[Nibbler]

You need to either convert the tables to the same collation (ideally utf-8), convert them on the fly in the query, or take the CONCAT out of the query and handle it in php instead.

[François Keller]

Ok i will do so
Thanks for your help (I hope i find how to do this  )
[edit] it works  [/edit]