Jump to content

Pireps not showing up


infidel

Recommended Posts

I have been having an issue for a week or more where one of my pilot will submit PIREPS, I approve them and they never show up on his PIREP list.

It now appears that this has extended to another pilot. The appear in my recent pireps list in the admin center but not in their recent pireps list in their profile.  Both pilots have had no problem until recently.

Any ideas on that one?

Link to comment
Share on other sites

Nothing has changes as far as our aircraft go (have not added any new ones) and ignore the airfield. I was having a stupid moment and adding it incorectly.

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=7

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT * FROM phpvms_aircraft

WHERE `id`=L-100-30

Unknown column 'L' in 'where clause'

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=1

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=7

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=7

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT * FROM phpvms_aircraft

WHERE `id`=L-100-30

Unknown column 'L' in 'where clause'

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=1

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

INSERT INTO phpvms_airports

( `icao`, `name`, `country`, `lat`, `lng`, `hub`, `chartlink`, `fuelprice`)

VALUES (

'MTPX', 'Port', 'Haiti',

N19 56.30, W072 50.48, 0, '', .85)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '56.30, W072 50.48, 0, '', .85)' at line 5

INSERT INTO phpvms_airports

( `icao`, `name`, `country`, `lat`, `lng`, `hub`, `chartlink`, `fuelprice`)

VALUES (

'MTPX', 'Port-de-paix', 'Haiti',

N19 56.30, W072 50.48, 0, '', .85)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '56.30, W072 50.48, 0, '', .85)' at line 5

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=1

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=1

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=1

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours,

FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilotid=13

GROUP BY a.name

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a

WHERE p.aircraft = a.id p.AND pilot' at line 2

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...