OXID 4.5.0 Can't create views. Please check your database user privileges

English forums
1

Hello everybody,

I trying to install oxid 4.5.0, but I have a little problem…
Once it’s time to create tables, I get a message like:

"ERROR: Can't create views. Please check your database user privileges. CREATE VIEW command denied to user 'db_user'@'localhost' for table 'oxviewtest'

But my db_user has all the privileges, he need, because I success to install the 4.4.8 without any trouble. But… Then I tried to update 4.4.8 with 4.5.0 with this file:
http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-release-another

But I got my shop “offline” and impossible to get it online again.

Any idea?
Thank you,

2

[QUOTE=jerome;56144]
But my db_user has all the privileges, he need, because I success to install the 4.4.8 without any trouble. [/QUOTE]

Oxid 4.4.8 don’t use views. Oxid 4.5 use views and for create a view you need special privileges.

http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html

3

You right,

I had this privileges:

SELECT CREATE
INSERT ALTER
UPDATE DROP
DELETE LOCK TABLES
INDEX REFERENCES
CREATE TEMPORARY TABLES CREATE ROUTINE
EXECUTE

But I also needed “CREATE VIEW”… I though it will be included in “CREATE” or "CREATE TEMPORARY TABLES"
I will have to ask to my webhosting provider…

Thank you very much for your reply.
I hope to be able to use Oxid soon.
best regards,

4

i got all needed privileges and no problem during update or new install, but afterwards base configs in the backend cant be loaded or saved (also my themes dont seem to have settings) and phpmyadmin says all the view-tables are “in use” and or corrupted.
the update-view-button in the backend tells me the view update worked fine, but this didnt change anything at all as it seems