OXID Community Forum

> International Forums > Installation and configuration > OXID 4.5.0 Can't create views. Please check your database user privileges.
Login
FAQ Members List Calendar Search Today's Posts Mark Forums Read

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


Reply
 
Thread Tools Search this Thread Display Modes
#Top   #1  
Old 04-29-2011, 07:55 PM
jerome jerome is offline
Junior Member
Join Date: Apr 2011
Posts: 5
jerome is on a distinguished road
Default OXID 4.5.0 Can't create views. Please check your database user privileges.

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:

Code:
"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/resour...elease-another

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

Any idea?
Thank you,
Reply With Quote
#Top   #2  
Old 04-30-2011, 10:12 AM
MBa MBa is offline
Senior Member
Join Date: Jun 2009
Posts: 773
MBa is on a distinguished road
Default Re: OXID 4.5.0 Can't create views. Please check your database user privileges.

Quote:
Originally Posted by jerome View Post
But my db_user has all the privileges, he need, because I success to install the 4.4.8 without any trouble.
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/...-provided.html
__________________
Schöne Grüße/Regards,
Markus
www.datame.com


If the only tool you have is a hammer, you tend to see every problem as a nail.
Reply With Quote
#Top   #3  
Old 04-30-2011, 11:02 AM
jerome jerome is offline
Junior Member
Join Date: Apr 2011
Posts: 5
jerome is on a distinguished road
Default Re: OXID 4.5.0 Can't create views. Please check your database user privileges.

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,
Reply With Quote
#Top   #4  
Old 05-12-2011, 03:19 PM
pl pl is offline
Member
Join Date: Aug 2010
Posts: 56
pl is on a distinguished road
Default Re: OXID 4.5.0 Can't create views. Please check your database user privileges.

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
Reply With Quote
Reply

Bookmarks

Tags
check, create, database, privileges, user, views

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Nicht Sichtbar
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign Admin Access Privileges Tokyoj Feature requests 1 12-04-2010 05:39 PM
EU VAT ID Check for OXID CE euroblaze Modules 12 08-03-2010 08:03 AM
oxchkversion v3: Konsistenz-Check-Tool für OXID eShop Upgrades Marco Steinhaeuser Allgemeines 0 01-14-2010 01:15 PM
Oxid Setup Stops in Step4 - Creating Database Oxid-Newbie Newbies 3 08-17-2009 11:38 AM
Database repair fix for OXID eShop 4.1.0-17976 released Marco Steinhaeuser OXID Announcements 0 04-17-2009 03:54 PM

All times are GMT +1. The time now is 07:41 PM.