Remodell Piro

[tonkepen100]

Ysurac Hello again, now after my eventful journey with rasperris, I'm updating the web radar pyro, and uploaded the last repository, and put install, gives me error, I do not see him leaving 3d map.

I leave photos by if you see any idea.

Gracias

[Ysurac]

For 3D map you must have $globalMap3D set to TRUE in require/settings.php or using install/index.php.

For the Internal Server Error I don't have enough info: where ? when ? log ?

[tonkepen100]

if the problem is that when I try to put install / index.php, that error comes not let me see the installation, I'll see.

[Ysurac]

I think that install script use a function that is forbidden on your server. If it's _getheaders, should be ok with latest commit.

[tonkepen100]

Nope, still doing the same.

http://airpiro.ovh/install/index.php

[tonkepen100]

and deleted the .htaccess and now let me

[Ysurac]

which one ?

[tonkepen100]

Which it is inside the folder Install

[tonkepen100]

looks can be for this .......?

[Ysurac]

I've updated the .htaccess, should work if your server allow only SetEnv that begin with _HTTP__. The error is not the same, I try to check if rewrite work: I try to download page like /search.

[tonkepen100]

hahaha, glup, as there

[Ysurac]

Your server disallow all SetEnv directive. I removed this check.

[tonkepen100]

Humps, now also opens, to see how we might see the error logs pulling.

[tonkepen100]

Nothing there is no way to put ysurac, some new idea? Thank you

[Ysurac]

What is the problem ?

[tonkepen100]

The problem is that when I run install / index.php file with the .httpacces shoot me wrong, if I delete that file and lets me see the installation page, but of course goes wrong.

also I get perfect data db, and always pulls this ....

[Ysurac]

.htaccess and the check is removed in latest commit. The error seems to say that the password/or rights are wrong.

[tonkepen100]

Well, and tested by active and passive.

I put everything back, create new database, with all permits. and by telling you install, all the while pulling it ....

....

Both names Db, as the password is well put, here's something wrong.

[Ysurac]

Does the base airpiro_nueva exist ? Created by the script or by you ?

[tonkepen100]

It is created through Cpanel ......

[tonkepen100]

for, for, for what it is, it is that told me to do the database, and was already made clear. Well I think it works, without saying he does not believe the db.

[Ysurac]

If you check Create database in install script and DB already exist, this will not erase DB. If this not work check DB settings in require/settings.php.

[tonkepen100]

Okay, but realize that this attention. the database of the previous version that was working. to happen ?, the update, delete it, or I have to create a new to work.

[Ysurac]

As you want. You can try to update it if you want, but if you don't want to keep old data, it's better to delete it and create a new one.

[tonkepen100]

Error : parsererror - SyntaxError: Unexpected token S in JSON at position 0

[Ysurac]

Not enough info.

[tonkepen100]

Byyyyyyyyyyyyy Enndddddddddddddddddddddd...

[tonkepen100]

Ysurac in the temp folder, put my zip, zip or content ?. I mean, the two folders, or entire zip, as is low. Thank you.

Install VATSIM airlines...Done ! You have to download the file ivae_feb2013.zip from https://www.ivao.aero/softdev/mirrors.asp?software=IvAeDataUp and put it in install/tmp directory

[Ysurac]

The entire zip file.

[tonkepen100]

Install VATSIM airlines...Done ! Install IVAO airlines and logos...Unzip...Add to DB...Copy airlines logos to airlines images directory...Done Done ! doneeeeeeeeeeeeee.

If I'm the best, best, almost I beat Ysurac. Already it is.

Super thanks for everything dear friend, I know I'm a clumsy, but without your help it would be impossible for me, I feel all the hassles. but I think I have the two mounts up.

Thanks again Ysurac.

[tonkepen100]

Ysurac, how can I put this type of map, which comes by default?

[Ysurac]

By choosing it in map provider from install/index.php

[tonkepen100]

Yurac made an update to update db, but all aircraft models and all companies, please as I do so only out which grabs the radar appear.

// * Archive * //Archive all data $globalArchive = TRUE;

//Archive data olders than xx months (if globalArchive enabled, else delete) (0 to disable) $globalArchiveMonths = '12';

//Archive previous year (if globalArchive enabled, else delete) $globalArchiveYear = FALSE;

//Keep Archive track of flight for xx months (0 to disable) $globalArchiveKeepTrackMonths = '12';

//Keep Archive of flight for xx months (0 to disable) $globalArchiveKeepMonths = '12'; // ****

[Ysurac]

This time aircraft models update should be really fixed in latest commit. Companies can be filtered if I found at least a flight from a company in DB.

[tonkepen100]

Let's see if I explain not good before, the question is this ...

1. both aircraft tipe, and companies, the tables are full, I mean go all aircraft and all companies. Not being well in airports, which grabs only those pilots arriving or departing.

What I would like is to leave only those pilots fly both airlines and aircraft, and not to leave the entire table. that in the rasperri works well, in no pyro.

[Ysurac]

If I find at least one flight from an airline this page should be filtered. For aircraft type can you run this in SQL DB:

SELECT * FROM stats_aircraft ORDER BY aircraft_name ASC LIMIT 5;

[tonkepen100]

Yes. I agree but the problem is they are all those empty tables except the stats and stats_airport. the rest all empty.

oppss gooddd morninggg

[Ysurac]

Even stats_callsign ?

[tonkepen100]

if completely empty

[tonkepen100]

if completely empty

[Ysurac]

Strange... update_db.php run without problems ? nothing in log ?

[tonkepen100]

if every hour, and does not fail, I see

[Ysurac]

What table config have in ?

[tonkepen100]

[Ysurac]

Try to run this in phpmyadmin:

SELECT DISTINCT spotter_output.ident, COUNT(spotter_output.ident) AS callsign_icao_count, spotter_output.airline_name, spotter_output.airline_icao FROM spotter_output WHERE spotter_output.ident <> '' AND DATE > '2016-09-25 10:01:12' GROUP BY spotter_output.ident, spotter_output.airline_name, spotter_output.airline_icao ORDER BY callsign_icao_count DESC;

If there is no result, give me last data from table spotter_output.

[tonkepen100]

I did it, but they are empty, I send spotter_ouput ....

spotter_output.zip

[tonkepen100]

but I see now that the two tables of country , and the airspaces were not stuck, and stuck the hand now, not whether it could affect this, but the e post

[Ysurac]

This don't change anything for stats_callsign.

Could you try this SQL (I changed date part and month):

SELECT DISTINCT spotter_output.ident, COUNT(spotter_output.ident) AS callsign_icao_count, spotter_output.airline_name, spotter_output.airline_icao FROM spotter_output WHERE spotter_output.ident <> '' AND spotter_output.date > '2016-08-25 10:01:12' GROUP BY spotter_output.ident, spotter_output.airline_name, spotter_output.airline_icao ORDER BY callsign_icao_count DESC;

This should output something.

[tonkepen100]

This table does not contain a single column. Editing grid and links copying, deleting and editing are not available.

[Ysurac]

And this SQL:

SELECT DISTINCT spotter_output.ident, COUNT(spotter_output.ident) AS callsign_icao_count, spotter_output.airline_name, spotter_output.airline_icao FROM spotter_output WHERE spotter_output.ident <> '' AND spotter_output.date > '2016-09-25 10:01:12' GROUP BY spotter_output.ident, spotter_output.airline_name, spotter_output.airline_icao ORDER BY callsign_icao_count DESC;

If this is working, you can try latest commit and date was ambiguous else this is a problem with timezone of mysql server and I will have to find a solution...

[tonkepen100]

I put the last, and run the script, nothing goes all empty.

this may affect?