Nightly Build 24/04 Install

Nightly Build 24/04 Install, a forum discussion on Jojo CMS. Join us for more discussions on Nightly Build 24/04 Install on our Installation forum.

Back to Forum Index : Back to Installation   RSS
Alex

25 Apr 2008
Posts: 28

Hi, i've tried to install the nightly build on my linux server and the installaton was ok now! Only thing is that when i am in the config and try to edit content there's a problem,

I am seeing this:

SELECT languageid AS id, IF(english_name!='',english_name,name) AS display, '0' AS parent, '0' AS categoryfield, '' AS rollover FROM `language` WHERE 1 ORDER BY english_name, name, display Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'if'array(8) { [0]=> array(6) { ["file"]=> string(72) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/field/dblist.php" ["line"]=> int(91) ["function"]=> string(11) "selectQuery" ["class"]=> string(4) "Jojo" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &string(192) "SELECT languageid AS id, IF(english_name!='',english_name,name) AS display, '0' AS parent, '0' AS categoryfield, '' AS rollover FROM {language} WHERE 1 ORDER BY english_name, name, display" } } [1]=> array(6) { ["file"]=> string(72) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/field/dblist.php" ["line"]=> int(40) ["function"]=> string(8) "populate" ["class"]=> string(17) "Jojo_Field_dblist" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(78) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/classes/Jojo/Field.php" ["line"]=> int(196) ["function"]=> string(11) "displayedit" ["class"]=> string(17) "Jojo_Field_dblist" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(78) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/classes/Jojo/Table.php" ["line"]=> int(165) ["function"]=> string(7) "getHTML" ["class"]=> string(10) "Jojo_Field" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(4) "edit" } } [4]=> array(6) { ["file"]=> string(70) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/admin_edit.php" ["line"]=> int(140) ["function"]=> string(7) "getHTML" ["class"]=> string(10) "Jojo_Table" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(4) "edit" } } [5]=> array(6) { ["file"]=> string(79) "/home/yvalni5/domains/jojocms.nl/jojo/plugins/jojo_core/classes/Jojo/Plugin.php" ["line"]=> int(116) ["function"]=> string(11) "_getContent" ["class"]=> string(22) "Jojo_Plugin_Admin_Edit" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(55) "/home/yvalni5/domains/jojocms.nl/jojo/includes/jojo.php" ["line"]=> int(364) ["function"]=> string(10) "getContent" ["class"]=> string(11) "Jojo_Plugin" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(4) { ["file"]=> string(54) "/home/yvalni5/domains/jojocms.nl/public_html/index.php" ["line"]=> int(36) ["args"]=> array(1) { [0]=> string(55) "/home/yvalni5/domains/jojocms.nl/jojo/includes/jojo.php" } ["function"]=> string(12) "require_once" } }

I also cannot get in the multilanguage options, is there a fix? I really want to see the new Jojo, i've seen so many changes in the svn! One other question, how is it going with the language files any progress yet?
mikec

Lead Developer

mikec

27 Apr 2008
Posts: 67

Hi Alex,
I ran the same query here and it worked for me. The error "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'if'" is not one i've seen before.

Can you have a look at your database structure nd see if you can locate where those two collations have come from and change one so they match and see if that helps.

- Mike
Alex

30 May 2008
Posts: 28

Hi, been a while but when i build a database (direct admin) the standard collation = latin1_swedish_ci,IMPLICIT

Problem is --> = SELECT languageid AS id, IF(english_name!='',english_name,name) AS display, '0' AS parent, '0' AS categoryfield, '' AS rollover FROM `language` WHERE 1 ORDER BY english_name, name, display Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'if'array(8) { [0]=> array(6)

When editing an article or news.

The table 'language' has the latin1_swedish_ci but one and thats the 'name ' field. That field has a utf8_general_ci . I can change it to latin and then the problem does not show anymore but with a /setup it gives a failure with a fix button.

I will install the rc1 complete, how should i build a new database, with latin or utf?

tom

Developer

tom

11 Jun 2008
Posts: 379

MySQL select doesn't like it when you mix collations, and foreign characters don't store properly when you use the latin collation (which is the default when you set up a new database), so the language name fields should be explicitly set to utf-8.

Mostly i forget to set the collation at the beginning so end up re-setting all the relevant fields to utf8-general.

This applies to the content fields too, if you want to use a mixture of english and foreign characters in page or article text for example, and be able to search across all of them.

It's something I've been meaning to tidy up and check for more comprehensively for a while but that keeps getting bumped out by more exciting stuff :p
Back to Forum Index : Back to Installation   RSS
You must be logged in to post a reply



You need to Register or Log In before posting on these forums.