Re: installatoin problem: ...A docBase {0} inside the host appBase has..

[ntran <ni...@hotmail.com>]

Thanks, Matt. I should have checked that first.

>From the roller.log it seems the exception that was causing the problem was
a "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation SQL exception.

I looked up this error in the forum to see if anyone had this problem before
and I ran across this post:
http://www.nabble.com/Roller-2.0-is-available-t617635c12275.html#a1675102

Which lead me to the roller wiki for setting up mysql with UTF8
instructions.
http://rollerweblogger.org/wiki/Wiki.jsp?page=SetupUTF8onMySQL 

Doing "default-character-set=utf8" in my.ini did not work for me but setting
up default encoding for the roller database did: CREATE DATABASE roller
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Everything seems to be working now.

Thanks,

Nick.
--
View this message in context: http://www.nabble.com/installatoin-problem%3A-...A-docBase-%7B0%7D-inside-the-host-appBase-has...-t1257641c12275.html#a3344308
Sent from the Roller - User forum at Nabble.com.

Re: installatoin problem: ...A docBase {0} inside the host appBase has..

[Anil Gangolli <an...@busybuddha.org>]

ntran wrote:
> Thanks, Matt. I should have checked that first.
>
> >From the roller.log it seems the exception that was causing the problem was
> a "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
> (utf8_general_ci,COERCIBLE) for operation SQL exception.
>
> I looked up this error in the forum to see if anyone had this problem before
> and I ran across this post:
> http://www.nabble.com/Roller-2.0-is-available-t617635c12275.html#a1675102
>
> Which lead me to the roller wiki for setting up mysql with UTF8
> instructions.
> http://rollerweblogger.org/wiki/Wiki.jsp?page=SetupUTF8onMySQL 
>
> Doing "default-character-set=utf8" in my.ini did not work for me but setting
> up default encoding for the roller database did: CREATE DATABASE roller
> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
>   

The default-character-set=utf8 setting in the ini file does work (I use 
it), but the way MySQL uses this is that the setting is applied on a 
per-database basis only when a new database is created.  So after 
setting that, one must restart the MySQL server AND re-create the Roller 
database  (if you had already created one) but one won't have to specify 
it per database.

The wiki says this, but not as emphatically.  I'll clarify.  Thanks for 
the feedback.

--a.