Pireps not showing up

[infidel]

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?

[Nabeel]

Do you see it in phpmyadmin? I'm not sure why they're show up in one place and not the other. Anything special/different about those flights?

[infidel]

Nothing special at all and yes I see them in the PHPadmin section and in the "recent news section" they show up at the bottom of the recent flights list.

Also am having an issue where someone can not remove a BID from his list of BIDs

[Nabeel]

In local.config.php, set DEBUG_MODE to true, and set /core/logs/log.txt file to writeable. And then after a bit see if anything shows up in that file, and then post it here

[infidel]

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

[Nabeel]

Interesting... can you paste the results from running:

/install/checkdb.php

/install/checkinstall.php

[infidel]

I cant seem to find the install/ folder

Also, we had no issues until a week or so ago.

[Nabeel]

You'd have to re-upload the install folder from the zip file

[infidel]

ok.

I am wondering if doing the upgrade would solve these problems. I hadn't done it as my version was working perfectly.

[Nabeel]

I think you're on the latest? What version are you on now?

[infidel]

The one just before the newest update came out.

[Nabeel]

I would try the update then