ICAO code is only 3 long ? [SOLVED]

phpVMS Legacy Support (v2/v5)
1

Hey again.

When I use the

<?php echo $schedule->depicao ?>

I only get the first 3 letters of the airport code.

When I entered CYAM I only got CYA,

So I changed all my airport entries to the last three letters,

HOWEVER

I am presently working on code that needs all four letters…CYAM

I have looked through the local config and cant find anything

Is their any place to make i four letters ?

Thanks

2

That’s strange, it should be 4. Was the column size in the database changed? Look in the airports table, what’s the length of the ICAO column

3

That’s strange, it should be 4. Was the column size in the database changed? Look in the airports table, what’s the length of the ICAO column

I will check that out however it seems to only be happening on some of the pages now…

eg. on the pilot profile page…only 3

but on the schedules details page its back to 4..I have looked at all the (I think they are called assests?) and it seems to call that info from the same table. I am not however a php or sql guy so I may be wrong.

I am on the road for the next couple of days, but if I understand you correctly it is a problem with the tables themselves (most likely) not the php. I will inventigate further on that premise. Thanks yet again for your help.

4

If its happening on some pages nad not others, it must be a problem with the pages its happening on then, not on the tables.

5

Ok so I dumped it all and tried again from scratch…

seems to be working again now, but unfortunately I can’t tell you what the cause was (bad table install or code) because I dumped everything and started from scratch.

you can mark this topic as solved if you like