search

shopizer-ecommerce / shopizer-admin

MIT License
51 stars 142 forks source link

New Admin accounts with ADMIN authorization having trouble accessing forms. #34

Open darrengeary opened 2 years ago

darrengeary commented 2 years ago

Backend is throwing the following exception: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "MERCHANT_STORE" not found; SQL statement: select * from MERCHANT_STORE m where (m.STORE_CODE = ? or (? is null or m.PARENT_ID = ?)) and (? is null or m.STORE_NAME like ?) limit ? [42102-200]

image

I created a new Admin account and selected the admin authorizations. Then I logged in as this new user but I am unable to access most pages on the Admin dashboard. For example I am able to view Category List but not Product List.

shopizer-ecommerce commented 2 years ago

This is an issue with h2 dayabase. Looking at it

Strongly recommended to use mysql