[opencms-dev] empty workspace - solved

[Martin Kuba]

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
--------------------------------------------------------------