[opencms-dev] empty workspace - solved

[Alexander Kandzior]

This is good news. I was quite at a loss what may caused the error. Can
others confirm that? 

BTW, OpenCms usees "UTF-8" as default encoding. I recommend using this
encoding for MySQL also if possible.

You may try setting up with MySQL 4.1 (now that 4.1 is released as "stable"
this should be no problem). The handling of encoding is better in MySQL 4.1,
and we have attached the encoding to every table on creation. If you do set
up with 4.1, please let me know if an "out of the box" setup works or not.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Martin Kuba
> Sent: Monday, November 08, 2004 5:18 PM
> To: The OpenCms mailing list
> Subject: Re: [opencms-dev] empty workspace - solved 
> 
> Alexander Kandzior wrote:
> > The Workplace views are initialized in the class:
> > 
> > org.opencms.workplace.CmsWorkplaceManager
> > 
> > in the methods:
> > 
> > public void initialize(CmsObject cms)
> > private List initWorkplaceViews(CmsObject cms)
> 
> Hi Alexander and Andreas,
> 
> I have tracked the problem down. The problem is not in 
> OpenCMS itself, it is in MySQL. The SQL query which finds the 
> views contains:
> 
>   WHERE CMS_ONLINE_STRUCTURE.RESOURCE_PATH LIKE 
> '/system/workplace/views/_%'
> 
> and this found no rows in the database. It behaves very 
> strange, a clause LIKE '/_ystem/workplace/views/_%' finds the 
> resources without any problem. In the end, I found that this 
> odd behavior was caused by following line in my /etc/mysql/my.cnf:
> 
> default-character-set=czech
> 
> which specifies character coding, and this also explains why 
> other users don't experience this problem ! I solved it by 
> changing the line to
> 
> default-character-set=latin2
> 
> which should specify the same character set, just the 
> ordering rules will be different.
> 
> Martin
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Supercomputing Center Brno             Martin Kuba
> Institute of Computer Science    email: makub at ics.muni.cz
> Masaryk University             http://www.ics.muni.cz/~makub/
> Botanicka 68a, 60200 Brno, CZ     mobil: +420-603-533775
> --------------------------------------------------------------
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
>