Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Properties, editing pictures  (Read 1829 times)

0 Members and 1 Guest are viewing this topic.

Kajoke

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
[Solved]: Properties, editing pictures
« on: April 20, 2008, 06:22:33 pm »

I get an error when i try to edit album files, edit album properties and edit a singel picture.

Error under searcing in data base.

Quote
While executing query "SELECT aid, CONCAT('(', user_name, ') ', a.title) AS title
                                                        FROM cpg14x_albums AS a
                                                        INNER JOIN `harmonien`.cpg14x_users AS u
                                                        ON category = (10000 + user_id)
                                                        ORDER BY title" on 0

mySQL error: Illegal mix of collations for operation 'concat'
Fil: /usr/local/psa/home/vhosts/homepage/httpdocs/galleri/include/functions.inc.php - Linie: 249

Quote
While executing query "SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM cpg14x_albums, cpg14x_categories WHERE category < '10000' AND (category = 0 OR category = cid) ORDER BY cat_title" on 0

mySQL error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'concat'
Fil: /usr/local/psa/home/vhosts/homepage/httpdocs/galleri/include/functions.inc.php - Linie: 249

Quote
While executing query "SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM cpg14x_albums LEFT JOIN cpg14x_categories ON category = cid WHERE category < '10000' ORDER BY cat_title" on 0

mySQL error: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'concat'
Fil: /usr/local/psa/home/vhosts/homepage/httpdocs/galleri/include/functions.inc.php - Linie: 249
« Last Edit: April 22, 2008, 07:18:09 am by Joachim Müller »
Logged

Kajoke

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Properties, editing pictures
« Reply #1 on: April 21, 2008, 10:01:28 pm »

I have found out what was wrong.

My CMS and coppermine had the same data base, and that was the reason for the problems.

To day i got 2 data bases an coppermine is running with no problems.

So this tread is solved.
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 19 queries.