CanadaAirVirtual

Thanks for the reply ProAvia. The issue was on our end and has now been resolved.

Good Day, We use phpVMS Version simpilot 5.5.2 It seems our CAVacars has stopped communicating with our website. The "Live Flight Board" and "Live Flights" on our homepage are empty and there are no "Top 10 Landings" being displayed. PIREPs submissions have stopped coming into the Admin Panel as well. In the Maintenance options I have tried "Reset ACARS" with no luck and "Optimize Tables" gives the following errors... canadaai_phpvms.phpvms_acarsdata - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_acarsdata - Invalid default value for 'lastupdate' canadaai_phpvms.phpvms_acarsdata - Operation failed canadaai_phpvms.phpvms_adminlog - Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastupdate' at row 1 canadaai_phpvms.phpvms_adminlog - Invalid default value for 'lastupdate' canadaai_phpvms.phpvms_adminlog - Table is already up to date canadaai_phpvms.phpvms_aircraft - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_aircraft - OK canadaai_phpvms.phpvms_airlines - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_airlines - OK canadaai_phpvms.phpvms_airports - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_airports - OK canadaai_phpvms.phpvms_awards - Table is already up to date canadaai_phpvms.phpvms_awardsgranted - Table is already up to date canadaai_phpvms.phpvms_bids - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_bids - OK canadaai_phpvms.phpvms_customfields - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_customfields - OK canadaai_phpvms.phpvms_downloads - Table is already up to date canadaai_phpvms.phpvms_expenselog - Table is already up to date canadaai_phpvms.phpvms_expenses - Table is already up to date canadaai_phpvms.phpvms_fieldvalues - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_fieldvalues - OK canadaai_phpvms.phpvms_financedata - Table is already up to date canadaai_phpvms.phpvms_fuelprices - Table is already up to date canadaai_phpvms.phpvms_groupmembers - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_groupmembers - OK canadaai_phpvms.phpvms_groups - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_groups - OK canadaai_phpvms.phpvms_navdata - Table is already up to date canadaai_phpvms.phpvms_news - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_news - Invalid default value for 'postdate' canadaai_phpvms.phpvms_news - Operation failed canadaai_phpvms.phpvms_pages - Incorrect datetime value: '0000-00-00 00:00:00' for column 'postdate' at row 1 canadaai_phpvms.phpvms_pages - Invalid default value for 'postdate' canadaai_phpvms.phpvms_pages - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pages - Invalid default value for 'postdate' canadaai_phpvms.phpvms_pages - Operation failed canadaai_phpvms.phpvms_pilots - Incorrect datetime value: '0000-00-00 00:00:00' for column 'postdate' at row 1 canadaai_phpvms.phpvms_pilots - Invalid default value for 'postdate' canadaai_phpvms.phpvms_pilots - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pilots - Invalid default value for 'lastlogin' canadaai_phpvms.phpvms_pilots - Operation failed canadaai_phpvms.phpvms_pirepcomments - Incorrect date value: '0000-00-00' for column 'lastlogin' at row 1 canadaai_phpvms.phpvms_pirepcomments - Invalid default value for 'lastlogin' canadaai_phpvms.phpvms_pirepcomments - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pirepcomments - OK canadaai_phpvms.phpvms_pirepfields - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pirepfields - OK canadaai_phpvms.phpvms_pireps - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pireps - Invalid default value for 'submitdate' canadaai_phpvms.phpvms_pireps - Operation failed canadaai_phpvms.phpvms_pirepvalues - Incorrect datetime value: '0000-00-00 00:00:00' for column 'submitdate' at row 1 canadaai_phpvms.phpvms_pirepvalues - Invalid default value for 'submitdate' canadaai_phpvms.phpvms_pirepvalues - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_pirepvalues - OK canadaai_phpvms.phpvms_ranks - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_ranks - OK canadaai_phpvms.phpvms_schedules - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_schedules - OK canadaai_phpvms.phpvms_sessions - OK canadaai_phpvms.phpvms_settings - Table does not support optimize, doing recreate + analyze instead canadaai_phpvms.phpvms_settings - OK canadaai_phpvms.phpvms_updates - Table is already up to date Any help/guidance to resolve this issue would be greatly appreciated

Just thought we should explore all options for our VA's Web Hosting/Support Services Who does everyone use? Are there any that stand out above the rest? All thoughts and views are appreciated!

Hello, I noticed our VA's disk usage increased from 2.15 GB to 2.24 GB in 7 days. We can have anywhere between 300 to 500 pireps in a week. Is it normal to use 92.16 MB in a week? Thanks

Awesome, I have now setup a cron-job to run the maintenance script once a day, thank you for the assistance ProAvia!

Did I do something wrong?...28 hours and not 1 reply, how disappointing. How are we (newbies) supposed to learn anything?

I followed this tutorial , Airport - Look up now works! Airport info API https://www.virtualairlines.eu/index.php/Blog

Has anyone yet achieved a cron job that archives pireps older than 3 month and removes them from the main table?

I think I figured it out. Would I not just navigate to /core/local.config.php, then replace the following script Config::Set('USE_CRON', false); with this Config::Set('USE_CRON', true); then add the following command to a cron job php /home/canadaai/public_html/admin/maintenance.php Any help/assistance would be greatly appreciated.

How would I go about setting up the below cron job, or can anyone direct myself to any tutorials on how. Our VA runs phpVMS Version simpilot 5.5.2 Cron If you have the ability, it's best to setup a cron-job to run the maintenance script. The command to add is: php -f /home/canadaai/public_html/admin/maintenance.php It's recommended to run this sometime between 2-6am (pick an artibrary time when you would least-likely have any flights). Also, remember to change in local.config.php, USE_CRON to true, so phpVMS doesn't try to automatically schedule these tasks to run. Note: If you setup the cron to run, it's recommended to also run it by hand once to ensure data is populated, unless you want to wait for it to run automatically.

Our vision at Canada Air Virtual is simply to return enjoyment to your hobby of flight simulation. Just as our slogan says "It's your time to fly" so enjoy yourself and have fun! Canada Air Virtual offers a professional and friendly environment with a active yet relaxed staff team structure and welcomes all virtual pilots regardless of skill level. Canada Air Virtual is a fictional virtual airline that simulates the operations of a fictitious airline company "Canada Air". We base our operations on real world scenarios but our pilots are free to explore the whole world as we only exist in the fictional virtual world of flight simulation and are not tied to real world airline hubs, fleets and schedules. Pilots of Canada Air Virtual enjoy the flexibility to fly any aircraft, livery, and route or charter flight at any time. All accumulated proven hours from a virtual airline, VATSIM or IVAO networks are accepted at Canada Air Virtual We fully support Microsoft Flight Simulator X, Microsoft Flight Simulator 2004, Microsoft Flight Simulator Steam Edition, Prepar3D, and X-Plane. SOME OF OUR FEATURES* Fly online VATSIM / IVAO or offline in your own private virtual world.* Our custom built ACARS (CAVacars) from FS Products takes the trouble out of setting up each flight and capable of recording "multiple landings" in the same flight.* Over 10,000 scheduled routes and constantly growing.* Unlimited charter flights (which allows you the freedom to create your own route from any airport in the world to your favorite payware scenery destinations)* Over 130 airline partners from around the world and growing* Fly our scheduled routes, any of our airline partners or simply make up your own custom charter flight.* Regular online group flights / fly-in events.* New tours created monthly.* Pilot Awards.* Fleet Downloads* Custom pilot dashboard* TeamSpeak 3 server* Pilot community forum (Auto forum registration when registering at Canada Air Virtual) * Pilots % discount for Simaddons scenery * Visit us at: http://canadaairvirtual.ca