Skip to content
This repository has been archived by the owner on Nov 3, 2021. It is now read-only.

#1142 - CREATE VIEW command denied #57

Open
avs-code opened this issue Oct 7, 2018 · 2 comments
Open

#1142 - CREATE VIEW command denied #57

avs-code opened this issue Oct 7, 2018 · 2 comments

Comments

@avs-code
Copy link
Owner

avs-code commented Oct 7, 2018

Describe the bug
#1142 - CREATE VIEW command denied to user 'b17_xxxxxxxx'@'192.xxx.x.x' for table 'team_driver_top3'
No drivers page working:
MySQL Error: Table 'b17_xxxxxxxx_prem1.team_driver_top3' doesn't exist

To Reproduce
Create DB

Expected behavior
No errors

Screenshots
drivers

Cause
The error is due to the lack of hosting permissions, to create a view in mysql you need advanced administration permissions and normally these permissions are not accessible in free hostings.

Resolution
Find an alternative to create a table view
Issue #28
Fixes: #44
Commit: 4946582

@avs-code avs-code added this to the v1.1.0 milestone Oct 7, 2018
@rearley
Copy link
Contributor

rearley commented Nov 23, 2018

How about removing the view as it is very hard to predict what hosting companies will allow?

@avs-code
Copy link
Owner Author

Most hostings do not allow it since they are shared hosting.
VPS or dedicated I think they do not have this problem.
It would be to find an option based on php or another that does not require advanced administration permissions.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants