Author Topic: phpMyAdmin SQL Error  (Read 37 times)

Ignis555

  • Newbie
  • *
  • Posts: 1
    • View Profile
phpMyAdmin SQL Error
« on: April 29, 2021, 12:59:03 AM »
Followed the tutorial for installation:
. He then uploads the sql chema file at 11:16m.
When I do it I receive the following error in red:
SQL Query:


create view v_flights_pilots as
select count(report_id) as c ,DATE_FORMAT(date, '%Y-%m-%d') as flight_date, pilot_id as pilot, 'fsacars' as type from reports group by pilot, date
union
select count(pirep_id) as c ,DATE_FORMAT(date, '%Y-%m-%d') as flight_date, gvauser_id as pilot, 'manual' as type  from pireps group by pilot, date
union
select count(pirepfsfk_id) as c ,DATE_FORMAT(CreatedOn, '%Y-%m-%d') as flight_date, gvauser_id as pilot, 'fskeeper' as type  from pirepfsfk
group by pilot, flight_date

MySQL returned the message:

#1142 - CREATE VIEW command denied to user 'epiz_26213922'@'192.168.0.6' for table 'v_flights_pilots'
.
Could Somebody please help me?
Stay safe and enjoy the sky,
Ignis555
« Last Edit: April 29, 2021, 08:44:32 PM by Ignis555 »