Virtual Airlines Manager

Buenas!

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:

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

Y pegais esto:
$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.

Saludos!

Common guys, use the search function of the forum please!!

http://virtualairlinesmanager.net/foro//index.php?topic=725.msg3279#msg3279

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!

Have dug into this a bit -- and found that parameter_id isn't specified on line 79 of /vamcore/app/Controllers/FleetsController.php:

$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.

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.