search

avs-code / PREM-Podium-race-E-manager

Description PREM (Podium race e manager) is management software for races and race leagues. It can be used to create overviews of race results. Based on Paddock 7.10beta by: demontpx
https://arv187.github.io/PREM-Podium-race-E-manager/
GNU General Public License v3.0
5 stars 1 forks source link

#1142 - CREATE VIEW command denied #57

Open avs-code opened 5 years ago

avs-code commented 5 years ago

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: https://github.com/arv187/PREM-Podium-race-E-manager/pull/44/commits/4946582ae18fd3d0048ea3a87e2cd63e77d9e450

rearley commented 5 years ago

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

avs-code commented 5 years ago

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.