Hi guys,
i can´t add more than 30 planes in Admin, its normal?
I try add more and see this error message:
There was an error adding the aircraft
But in list i can add 30 planes without problems.
I use this version: phpvms_5.5.x
Any idea?
Thanks for help.
Regards,
Miguel
Maybe the aircraft table of your database is currepted or there is an issue the primary/foreign keys. Would you like to pm me your cpanel/phpvms details to check it out for you? As soon as I check it, I will post the solution so the community is aware of the issue and the resolution of it.
On 11/22/2020 at 1:19 PM, servetas said:
Maybe the aircraft table of your database is currepted or there is an issue the primary/foreign keys. Would you like to pm me your cpanel/phpvms details to check it out for you? As soon as I check it, I will post the solution so the community is aware of the issue and the resolution of it.
I have send PM to you.
Thanks
Miguel
Hi guys
My problem remains.
Below see photo from database of aircraft table (can’t add more 30 in admin, in database I can add)
And schedule database, can’t add flights.
Are you using phpVMS 5.5.2 or 5.5.2.72?
PHP version?
MySQL or MariaDB version?
Do you have error reporting on?
Any errors in the error_log files?
I’d be willing to bet it may be a strict mode issue - but need more info from you… see questions above.
19 hours ago, ProAvia said:
Are you using phpVMS 5.5.2 or 5.5.2.72?
PHP version?
MySQL or MariaDB version?
Do you have error reporting on?
Any errors in the error_log files?
I’d be willing to bet it may be a strict mode issue - but need more info from you… see questions above.
phpVMS versin: Version simpilot 5.5.2
PHP Version: 7.2
MySQL or MariaDB version: MySQL i think.
Im very sorry, but aircraft now works fine and i don´t know why..
In Admin:
Schedule continue don´t working.
After i add a flight, i see this message: Flight “xxx” Added, on green colour, but in table list (view Schedules) nothing apear.
In public area i see this message: “No routes have found!”
Any idea ?
Thanks very much for help.
Regards,
Miguel
One of your issues is using phpVMS 5.5.2 with PHP 7.2. That will certainly cause issues. That is why there is phpVMS 5.5.2.72 - which is compatible with PHP 7.0 thru 7.2 .
What version of MySQL? Is probably 5.6 or 5.7 . If MariaDB, is probably 10.1, 10.2 or 10.3.
Sounds lime you don’t have error reporting on. If it were on, you would see errors when using phpVMS 5.5.2 with PHP 7.2.
See if your host offers PHP 5.6 as it’s compatible with phpVMS 5.5.2
Im try PHP 5.6, and schedule no work neither.
I see this error:
There was an error adding the schedule, already exists DB error: Field ‘route_details’ doesn’t have a default value
and
There was an error adding the schedule, already exists DB error: Incorrect double value: ‘’ for column vpoaf_vms.phpvms_schedules.price at row 1
I have no ideas.
What do you suggest to install? From zero.
Thanks.
Miguel
Make sure every field in the schedule has something in it - even if that something is a ‘space’. I have had to do this for schedules before - if you don’t use departure or arrival times, or have other fields that are vlank… enter a space (press spacebar one time) or enter another alphanumeric character. For the pricefield, enter a 0 (zero) if you don’t have a price there. That will usually solve that issue.
Hi ProAvia,
Works fine now,strange things 
I do it equal like you said, spaces, etc and work wonderful.
Thanks very much my friend.
What acars program we must use?
Regards,
Miguel
Glad you got it working.
There are several freeware ACARS around - as well as a couple payware options.
Freeware - kACARS_Free, CCFTracker and others
Payware - smartCARS
These are the ones I know of. A forum search make provide additional options.
22 hours ago, ProAvia said:
Glad you got it working.
There are several freeware ACARS around - as well as a couple payware options.
Freeware - kACARS_Free, CCFTracker and others
Payware - smartCARS
These are the ones I know of. A forum search make provide additional options.
Hi ProAvia,
Im connected using cACARS but no see my plane in live map.
I make this changes like here https://gist.github.com/nabeelio/8b7ab29fb67dfe27284d63d7136388dc
But no traffic.
Any idea?
Thanks my friend.
Miguel
Did you install the cACARS module on your site?
I am not familiar with cACARS. Does cACARS show it is connected to your site?
Make sure error reporting it turned on in your hosting settings.
Check the local.config.php file and post the entry for error reporting here.
22 hours ago, ProAvia said:
1 - Did you install the cACARS module on your site?
2 - I am not familiar with cACARS. Does cACARS show it is connected to your site?
3 - Make sure error reporting it turned on in your hosting settings.
4 - Check the local.config.php file and post the entry for error reporting here.
Hi ProAvia,
1 - Yes and with kACARS happen the same problem.
I received emails from hosting or vms with report .
But in Admin nothing to accept and in pilot center no report exist
2 - yes both programs, cACARS and kACARS connect (in url we must put http://www.website.com/vms/ or http://www.website.com/ ???
3 - how i do it?
4 - what do you mean?
I see log (core/logs/log.txt) and see this error:
Time: 12.01.20 13:43:39
Backtrace: DB::write_debug > DB::query > ACARSData::updateFlightData > CCFTracker->posrep > call_user_func_array > MainController::RunAllActions
Query: INSERT INTO phpvms_acarsdata (pilotid,flightnum,pilotname,aircraft,lat,lng,heading,alt,gs,depicao,arricao,deptime,arrtime,route,distremain,timeremaining,phasedetail,online,client,depapt,arrapt,lastupdate) VALUES … all correct but at end i see this: Error: (1364) - Field ‘route_details’ doesn’t have a default value
in mysql table phpvms_schedules Default is NULL and are wright this inside field route_details a:0:{}
Thanks for your time.
Regards,
Miguel