error on the page - failed to lazily initialize a collection

[SherryX]

we just have servers migration for jira/confluence, and we have copied the whole instance and database to the new servers.

confluence started OK but some have the following error:

Error formatting macro: builder-hide: net.sf.hibernate.LazyInitializationException: Failed to lazily initialize a collection blog-posts: null Error formatting macro: builder-hide: net.sf.hibernate.LazyInitializationException: Failed to lazily initialize a collection

there is macro

{blog-posts:content=excerpts}

in the page, anyone can help?

[SherryX · Accepted solution]

I have done the following and it works now:

1.mysql config

[mysqld]
...
default-collation=utf8_bin
character-set-server=utf8
collation-server=utf8_bin
default-character-set=utf8

2.in confluence.cfg.xml, added

&useUnicode=true&characterEncoding=UTF8 within

<property name="hibernate.connection.url">

3. refresh data from production and works OK

Hope this will help others with the same problem.