Jump to content

infidel

Members
  • Content Count

    62
  • Joined

  • Last visited

Community Reputation

0 Neutral

About infidel

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling
  1. infidel

    Can't add more than 30 pilots

    I am the site admin for SouthernAirVirtual and we started out pilot numbers at 9501 so that's how they got up there. I have not manually modified anyone's pilot ID number and am unable to find the PILOTID_OFFSET to look further. Where can I find this? Chris Pollard
  2. infidel

    Pireps not showing up

    The one just before the newest update came out.
  3. infidel

    Pireps not showing up

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

    Pireps not showing up

    I cant seem to find the install/ folder Also, we had no issues until a week or so ago.
  5. infidel

    Pireps not showing up

    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
  6. infidel

    Pireps not showing up

    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
  7. infidel

    Pireps not showing up

    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?
  8. infidel

    Pilot roster not showing up

    Woke up this morning and everything was back to normal.. Freaking odd
  9. infidel

    Pilot roster not showing up

    Sorta vauge- do you think it is a host error that is causing the roster page not to show?
  10. infidel

    Pilot roster not showing up

    Also just noticed this at the bottom of all the pages: " Warning: Unknown: open(/tmp/sess_gsm14vgpqciqha1e6pfhpljpe0, O_RDWR) failed: Permission denied (13) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0 " I dont think that was there yesterday as I would have noticed it
  11. infidel

    Pilot roster not showing up

    Added a new member and approved 3 pireps and one route.
  12. infidel

    Pilot roster not showing up

    Also a buddy just reported that they are failign the human test when signing up. They are asked 10+8= ? and when responding 18 they are told wrong.
  13. infidel

    Pilot roster not showing up

    My VA's pilot roster no longer shows up. It was there last night, but today it says no pilots in our HUBs Anyone have any suggestions???
  14. infidel

    schedule spacing issues

    ok in a stroke of blind luck I was able to accidently put int he float code so it worked. now having issues with this page: http://southernairvirtual.com/phpvms/index.php/schedules/brief/19 (and the other briefing pages) is this a table width issue? Also in firefox all of the schedule pages run off the bottom of the template -any ideas there?
  15. infidel

    schedule spacing issues

    After looking at the code and trying to find references on what code to use where I come back to still not know what I am doing. I am not a programer and am learning this as I am going along. An example of the float stuff and instructions on where to put it would help a ton. Maybe I am just not smart enough for this stuff LOL
×