What I’m seeing is: Since i had some errors with my previous account, i tried to create a new one account with a new email account. (it means im doing from scratch in order to have 0 errors and comfusion). after creating database and importing all the files, so time to FTP
The reason you see this error is because your code tries to interact with the database table vampireps, but no table with that name exists in your database.
This could either mean that there is an error in your code (the query should be executed on another table) or with your database (an important table is missing from it). Unfortunately, I don’t know enough about your software to know which of the two is the case.
I think its somehow importing files to the database since some files get errors. I tried to use Xammp to upload the files to the database and all files works fine.
I’m sorry, but I cannot access a website located only on your computer. Can you please upload it to your account and see if you can get it running there?
CREATE VIEW v_flights_pilots AS SELECTcount( 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 SELECTcount( 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 SELECTcount( 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:
#1142 - CREATE VIEW command denied to user 'epiz_23741984'@'192.168.0.6' for table 'v_flights_pilots'
i got some error here but i don’t see any issues. any suggestions or fixes?