Re: [Semediawiki-user] Database Error due to non-ASCII characters

[Alex S. <sh...@gm...>]

This issue is caused by the use of an experimental charset support.
Disable it by setting $wgDBmysql5 = false; in your LocalSettings.php
file

Alex

On Tue, Jul 27, 2010 at 9:38 AM, Edward Swing <de...@vs...> wrote:
> MediaWiki 1.15.4
> PHP 5.3.2
> MySQL 5.1.42
> SMW 1.5.0
> Semantic Gardening extension v1 3.1_0
> Fedora Linux v12
>
>
> -----Original Message-----
> From: Joel Natividad [mailto:joe...@gm...]
> Sent: Monday, July 26, 2010 11:52 AM
> To: Edward Swing
> Cc: sem...@li...
> Subject: Re: [Semediawiki-user] Database Error due to non-ASCII characters
>
> Hi Edward,
> What exactly is your configuration?
>
> What version of SMW/SMW+, MySQL, Operating System, Web Server, etc?
>
> How did you go about installing SMW/SMW+?  Roll your own? Via
> ontoprise? Or Semantic Bundle?
>
> This is a MySQL character set configuration issue BTW, but more
> configuration info is required to diagnose your problem.
>
> Best,
> Joel
>
> =======================================================
> jo...@na... * wir...@na...
> Think Different! (http://en.wikipedia.org/wiki/Think_different#Text)
> Imagine Different! (http://www.youtube.com/watch?v=H5tOgRD4EqY)
>
>
>
> On Mon, Jul 26, 2010 at 8:54 AM, Edward Swing <de...@vs...> wrote:
>> I recently started including pages with non-ASCII characters in their title. Now I am getting an SQL error on some of my #ask queries:
>>
>>
>>
>> A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
>>
>> (SQL query hidden)
>>
>> from within function "SGAGardeningIssue::getGardeningIssues". Database returned error "1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' (localhost)".
>>
>>
>>
>> Is there something which needs to be done within the wiki to clean up the database table?
>>
>>
>>
>> Edward Swing
>> Principal Technology Consultant
>> Vision Systems & Technology, Inc.
>>
>> ________________________________
>>
>>
>>
>> 6021 University Boulevard, Suite 360 ▪ Ellicott City ▪ Maryland ▪ 21043
>>
>> Tel: 410.418.9919 ▪ Main: 410.418.5555 ▪ Fax: 410.418.8580
>>
>> Email: de...@vs...
>> Web: http://www.vsticorp.com/ <http://www.vsticorp.com/>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> The Palm PDK Hot Apps Program offers developers who use the
>> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
>> of $1 Million in cash or HP Products. Visit us here for more details:
>> http://ad.doubleclick.net/clk;226879339;13503038;l?
>> http://clk.atdmt.com/CRS/go/247765532/direct/01/
>> _______________________________________________
>> Semediawiki-user mailing list
>> Sem...@li...
>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>>
> ------------------------------------------------------------------------------
> The Palm PDK Hot Apps Program offers developers who use the
> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
> of $1 Million in cash or HP Products. Visit us here for more details:
> http://ad.doubleclick.net/clk;226879339;13503038;l?
> http://clk.atdmt.com/CRS/go/247765532/direct/01/
> _______________________________________________
> Semediawiki-user mailing list
> Sem...@li...
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>