Jump to content

infidel

Members
  • Posts

    62
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

infidel's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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. The one just before the newest update came out.
  3. ok. I am wondering if doing the upgrade would solve these problems. I hadn't done it as my version was working perfectly.
  4. I cant seem to find the install/ folder Also, we had no issues until a week or so ago.
  5. 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. 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. 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. Woke up this morning and everything was back to normal.. Freaking odd
  9. Sorta vauge- do you think it is a host error that is causing the roster page not to show?
  10. 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. Added a new member and approved 3 pireps and one route.
  12. 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. 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. 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. 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
×
×
  • Create New...