Author Topic: Problems and Errors in Database Sql files  (Read 197 times)

Capt.SkyMarshal41

  • Newbie
  • *
  • Posts: 2
    • View Profile
Problems and Errors in Database Sql files
« on: April 11, 2019, 02:15:09 PM »
importing db_schema

Error

SQL query: Documentation

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 said: Documentation
#1142 - CREATE VIEW command denied to user 'epiz_23741984'@'192.168.0.6' for table 'v_flights_pilots'

and

importing db_data2

Error

SQL query:

UPDATE `user_types` SET `access_administration_panel` = '1',
`access_va_parameters` = '1',
`access_hub_manager` = '1',
`access_fleet_type_manager` = '1',
`access_fleet_manager` = '1',
`access_rank_manager` = '1',
`access_pilot_manager` = '1',
`access_route_manager` = '1',
`access_route_assignator` = '1',
`access_user_type_manager` = '1',
`access_jump_validator` = '1',
`access_flight_validator` = '1',
`access_event_manager` = '1',
`access_notam_manager` = '1',
`access_email_manager` = '1',
`access_language_manager` = '1',
`access_vam_acars_manager` = '1',
`access_financial_parameters` = '1',
`access_tour_manager` = '1',
`access_award_manager` = '1' WHERE `user_types`.`user_type_id` =3;

MySQL said: Documentation
#1054 - Unknown column 'access_administration_panel' in 'field list'

How to fix this? can someone help? thanks :-)