2026-04-20 11:59:23 250 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(security,char),convert(status,char),convert(roles,char) from dform_module where name = 'home'

2026-04-20 11:59:23 250 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - id=6

2026-04-20 11:59:25 277 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - /evergreen/home/newView.do

2026-04-20 11:59:25 277 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - id=442&workflow=true

2026-04-20 11:59:25 278 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - home

2026-04-20 11:59:25 278 [info] (com.smarteform.spring.mvc.interceptor.SecurityInterceptor) - newView

2026-04-20 11:59:25 278 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(security,char),convert(status,char),convert(roles,char) from dform_module where name = 'home'

2026-04-20 11:59:25 283 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-04-20 11:59:25 283 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-04-20 11:59:25 284 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-04-20 11:59:25 284 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-04-20 11:59:25 284 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-04-20 11:59:25 285 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-04-20 11:59:25 285 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-04-20 11:59:25 285 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-04-20 11:59:25 286 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(javascript,char),convert(css,char),convert(header,char) from dform_sitethemes where type='website'

2026-04-20 11:59:25 286 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT a.site_theme, a.site_logo, a.show_site_logo, a.show_site_slogan, a.show_language_link, a.show_log_in_link, a.show_quick_links, a.show_site_name, b.site_name, b.site_name_french, b.slogan, b.slogan_french, b.footer, b.footer_message_french, a.show_home_link, c.Log_Level, b.CustomScript, a.bilingual, s.show_new_registration_link, s.show_forget_password_link, s.new_user_registration_link_text, s.new_user_registration_link_text_french, s.forget_password_link_text, s.forget_password_link_text_french, s.force_ssl_login FROM dform_site_themes a, dform_site_information b, dform_system_log_setting c, dform_security_setting s where a.recordid = 1 and b.recordid = 1 and c.recordid = 1 and s.recordid = 1

2026-04-20 11:59:25 287 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid in (1) order by weight

2026-04-20 11:59:25 287 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT convert(Default_Theme,char),convert(Default_Theme,char),convert(Default_Theme,char) from dform_role where recordid = 2 order by weight

2026-04-20 11:59:25 288 [info] (com.smarteform.hibernate.LookUpDAO) - sql: SELECT showsigninname FROM dform_site_themes where recordid = 1

2026-04-20 11:59:25 303 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select title,content,link,icon,postion from dform_web23headban3box order by postion

2026-04-20 11:59:25 318 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select title,content from dform_topmenubutton where recordid=1

2026-04-20 11:59:25 333 [info] (com.smarteform.hibernate.LookUpDAO) - sql: select m.title, case m.contenturl when '' then case when m.page='None' then '#' else concat('/evergreen/home/',m.Page) end else concat('/evergreen/home/',m.ContentURL,'.do?id=',substring_index(m.contentid,'<',1)) end,n.title, case n.contenturl when '' then concat('',n.title,'') else concat('
  • ',n.title,'
  • ') end,case when n.title is null then '' else '' end,case when n.title is null then '' else '' end,case when n.title is null then '' else ' ' end, case when n.title is null then '' else '