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)
QuoteThere 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 ?
What collations are you using?
Quote from: Nibbler on September 06, 2006, 10:38:57 PM
What collations are you using?
what do you mean ? (sorry i don't know what is it :-\)
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
ok i will check it (it seems collation are note same :-\)
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.
Ok i will do so
Thanks for your help (I hope i find how to do this ;))
[edit] it works :D[/edit]