CanadaAirVirtual Posted December 1, 2018 Report 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
Administrators ProAvia Posted December 1, 2018 Administrators Report 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
CanadaAirVirtual Posted December 4, 2018 Author Report Posted December 4, 2018 Thanks for the reply ProAvia. The issue was on our end and has now been resolved. Quote
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.