CanadaAirVirtual Posted December 1, 2018 Report Share Posted December 1, 2018 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 Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted December 1, 2018 Administrators Report Share Posted December 1, 2018 (edited) Is this the payware version of kACARSI or kACARSII? If so, best to contact the developer through his website forums - http://forum.fs-products.net/ Edited December 2, 2018 by ProAvia Quote Link to comment Share on other sites More sharing options...
CanadaAirVirtual Posted December 4, 2018 Author Report Share Posted December 4, 2018 Thanks for the reply ProAvia. The issue was on our end and has now been resolved. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.