Shop offline when updating DB views

English forums
1

Hello, I made an update of my oxid eshop. If I’m trying to update DB views it writes me Shop offline!. What could be wrong? Many thanks for your help.

2

Check exception log and error log

3

thank you. I checked exception log and writes me following text :

oxConnectionException-oxException (time: 2020-03-08 09:38:56): [1142]: mysql error: [1142: CREATE VIEW command denied to user ‘videohrylevne’@‘localhost’ for table ‘oxv_oxarticles’] in EXECUTE (CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_oxarticles AS SELECT oxarticles.OXID,… , Array) with user videohrylevne

any suggestion what could be wrong? Many thanks!

4

The important part of the error message is:
“CREATE VIEW command denied to user ‘videohrylevne’”

Your database user videohrylevne seems not to have the permission for creating views.
You either need to grant missing rights to this database user, of if this is the only user your hoster provided for you, you might need to ask your hoster to grant this user permissions for creating views.

5

thank you so much!

6

Are you trying to import the database after updating the shop? If yes, then

You can find and replace in .sql file

Find this: CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_articles (and the rest of the query)

Replace with: CREATE VIEW oxv_articles (and the rest of the query)