Recent Posts

Pages: [1] 2 3 ... 10
Hi guys,

Id like to suggest making the mobile flight simulator InfiniteFlight  compatible with the VAM and Sim ASCARs. InfiniteFlight is a mobile flight simulator devloped by Flying Development Studio. I promise to you guys that iit s the best simulator available on IOS and Android it is certainly worth devloping flight tracking capability. I'd like to suggest that the developer of VAM/Sim ASCARs get in touch with them so that flight tracking can be made possible.

How InfiniteFlight can vvsintegrated with VAM on a deeper level? I'll leave that to between you guys at VAM and Flying Development Studio.

Here is a link to the community

And here is the game website:

Here is the YouTube:

Air Traffic Control Tutorials:

Sorry if i posted this wrong.
Errores e incidencias / Re: [AYUDA] Creación de Aeronaves
« Last post by Jose on July 19, 2017, 05:59:23 PM »

Veamos, el fallo esta en que al "comprar" la aeronave, el registro que ha de generarse para que ese aeronave se cobre a nuestra compañia, esta incompleto, en vuestro caso.

En muchos servidores de host, este valor que os falta toma como valor por defecto "0", pero en el vuestro eso no esta asi definido, de ahi el error.

Para corregirlo, y si estoy en lo cierto, debeis ir a:

VUESTRO HOST/vamcore/app/Controller

Buscad el archivo "FleetsController.php" y editar la linea 79 (aprox), que seria esta:

Code: [Select]
$sql = "insert into va_finances (finance_date,amount,description,report_type) values (now(),$aircraftvalue,'$description','New Aircraft')";

Y pegais esto:
Code: [Select]
$sql = "insert into va_finances (finance_date,amount,description,report_type,parameter_id) values (now(),$aircraftvalue,'$description','New Aircraft','1')";

Echo esto, volveis a intentar crear/comprar una aeronave a ver que tal.

Hablo en plural, porque se que hay mas de un usuario con este problema.

Support for Installation / Re: db_schema.sql causing errors
« Last post by 1Revenger1 on July 19, 2017, 07:50:42 AM »

Sorry for taking so long to respond, been having a few busy days.

Anyways I'll try doing editing the values then. It would be nice to confirm if it is only happening with MySQL 5.7, so I may go back to an earlier version to see.

Thanks for the help.
Bug reports / Re: Install problems
« Last post by OAV001 on July 18, 2017, 06:52:45 PM »
Common guys, use the search function of the forum please!!
Bug reports / Install problems
« Last post by EmberrFlys on July 18, 2017, 11:51:25 AM »
I have just tried to install vam onto a web server (and after my local machine via wamp), I uploaded all the files including the docs.
I go to localhost/vam (etc) and it says to me: Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'xxxxxx'@'localhost' (using password: YES) in C:\wamp64\www\vam\vam\languagesdd.php on line 13 & Warning: mysqli::set_charset(): Couldn't fetch mysqli in C:\wamp64\www\vam\vam\languagesdd.php on line 14 - says the same on the web server.

So, any fixes?

Suggestions to add to VAM and SIM ACARS / Generation of flight scaling
« Last post by LeeCley on July 17, 2017, 08:50:29 PM »
My suggestion is that the system reserve between 5 and 10 flights at a time that the pilot is going to generate a scale, and it will be obligatory to comply with the prescribed scale, this must be in sequence where the destination of the first flight is the exit of the second and so on!
Bug reports / Re: Install errors
« Last post by adanesh on July 17, 2017, 06:01:23 AM »
I had similar issues in my environment (Mysql 5.7 + PHP 7 on Ubuntu Xenial):

- Invalid date/time default values on datetime fields -- I adjusted default values to be within in allowed range or set to CURRENT_TIMESTAMP
- VARCHAR fields with lengths too long -- I changed fields to TEXT fields
- Same error in db_data_2.sql re allow_select_aircraft_for_charter -- I set a default value for the field in the schema to address this

But, once installed I have faced other errors in the application with a range of SQL errors getting thrown in other locations in the administration tools particularly. Usually these have been down to missing default values on fields specified with NOT NULL where INSERTs are being done in the code without specifying values for these fields.

Am I the only one seeing these sorts of issues?
Support for Installation / Re: Error adding new fleet
« Last post by adanesh on July 17, 2017, 05:50:58 AM »
Have dug into this a bit -- and found that parameter_id isn't specified on line 79 of /vamcore/app/Controllers/FleetsController.php:

Code: [Select]
$sql = "insert into va_finances (finance_date,amount,description,report_type) values (now(),$aircraftvalue,'$description','New Aircraft')";
So, I hacked this line to specify an arbitrary parameter_id just to see what happens and then I got the same error but for gvauser_id. I do see that in the table definition in db_schema.sql, these fields are specified NOT NULL but without default values so it doesn't surprise me these errors are thrown given the values are defined in the SQL query.

Are these know problems with this controller? Has somethings gone wrong with my installation? For reference -- I had a lot of problems with the db_schema not working -- for instance invalid default values on datetime fields and had to make small adjustments in the schema for it to work in my MySQL 5.7 environment. However, I didn't edit any of these tables/fields.
Support for Installation / Error adding new fleet
« Last post by adanesh on July 16, 2017, 02:51:28 PM »
I am just experimenting with VAM to set up a VA for my son who is an avid virtual aviator.

If I understand the data structure correctly, one needs to define fleet type and then specific fleet (i.e. aircraft) of specific types. I have created a couple of fleet types and have tried to add a New Fleet -- but every time I try I get this error:

There was an error running the query [Field 'parameter_id' doesn't have a default value]

This is being displayed (on an otherwise blank page) at this relative URL:


Before I start looking through the code to try to understand my mistake, has anyone experienced this and can offer a suggestion?
Support for Installation / Re: db_schema.sql causing errors
« Last post by adanesh on July 16, 2017, 12:49:22 PM »
I have had the same problem -- and others -- with db_schema.sql running on MySQL 5.7 and am not certain if they are tied to the version of MySQL or other settings/configuration.

That said, I took the step of editing my db_schema.sql file to resolve the issues. Took a few hours of trial and error to do this.

For the specific problem you encountered, the issue is default dates set to 0000-00-00 00:00:00 but the datetime field starts at year 1000, I believe and cannot accept an earlier date (timestamp, by comparison, starts in 1970). So, I edited these fields to default to 1000-01-01 00:00:00 and this worked. I also saw similar error on some timestamp fields so set those to CURRENT_TIMESTAMP.

Another thing I did was add "DROP TABLE ... IF EXISTS" for some of the tables where missing as this was inconsistent. This way I could re-apply the schema repeatedly ensuring all tables were dropped before recreating them.

There were also cases of VARCHAR defined with lengths 30000 and 60000 -- both of which MySQL reported as too long for the field type. I changed these to TEXT.

I was going to attach a copy of the revised schema I just used to get an instance VAM installed in my environment but I got an error back about not being able to access the upload path.

I haven't yet configured my airline so can't say if these changes have any down-stream negative impacts but I suspect none of the changes will negatively impact VAM. Time will tell once I start using this instance more thoroughly.
Pages: [1] 2 3 ... 10