coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: François Keller on September 06, 2006, 10:36:08 PM

Title: upload by ftp after bridging with SMF and Joomla
Post by: François Keller on September 06, 2006, 10:36:08 PM
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 ?
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: Nibbler on September 06, 2006, 10:38:57 PM
What collations are you using?
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: François Keller on September 06, 2006, 10:41:33 PM
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  :-\)
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: Sami on September 07, 2006, 12:23:20 AM
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
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: François Keller on September 07, 2006, 07:31:53 AM
ok i will check it  (it seems collation are note same  :-\)
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: Nibbler on September 07, 2006, 12:13:27 PM
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.
Title: Re: upload by ftp after bridging with SMF and Joomla
Post by: François Keller on September 07, 2006, 09:04:12 PM
Ok i will do so
Thanks for your help (I hope i find how to do this  ;))
[edit] it works  :D[/edit]