OpenEMM Technical Support Forum

I am getting this error message when trying to log into OpenEmm.

Cause: javax.servlet.ServletException: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select emmlayout0_.layout_id as layout1_6_, emmlayout0_.company_id as company2_6_, emmlayout0_.header_url as header3_6_, emmlayout0_.footer_url as footer4_6_, emmlayout0_.base_url as base5_6_, emmlayout0_.normal_color as normal6_6_, emmlayout0_.highlight_color as highlight7_6_ from emm_layout_tbl emmlayout0_ where emmlayout0_.company_id=0 and emmlayout0_.layout_id=?]; nested exception is java.sql.SQLException: Table 'openemm.emm_layout_tbl' doesn't exist


I have checked that I have created the database. Please help.

sorted now. I hadn't loaded the database layout.

I entered the command "mysql -u root -p openemm <openemm.sql" and that sorted the probem out.

Craig.