DisposableHero
-
Posts
620 -
Joined
-
Last visited
-
Days Won
97
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by DisposableHero
-
-
Yeah, exactly what I though
Below that part, at line 406 you have the passenger and cargo counts of accepted pireps, which uses laravel's whereIn() function and fails because your placeholders passing the maria/mysql 65k limit.
If you check the latest update/version of my Disposable Basic module, you will see that I limited it and now it should pass that line, do not cause an exception and work without pax and cgo counts.
BTW, my idea reversing the logic causes inaccurate results due to cancelled, deleted, rejected pireps.
Hope it helps. (at least until we find a better solution)
-
1
-
-
Another solution can be reversing the logic for the stats, instead of using whereIn(...) , I can use whereNotIn(...) with rejected pirep id's array
That will be much less and below 65k I think for everyone.
-
48 minutes ago, SKD said:
Ok i fill my database again and start the migration. I will write back until the migration is done.
Probably you will be hitting MySQL/MariaDB's placeholder limits with my module's stat service, it tries to read all accepted pireps and pirep fares to get the pax/cargo counts.
If this is the case we can look further to improve that logic with only laravel relationships. Looping thought 170k pireps to get the total count may take some server time though, but we will see how it goes.
Another solution would be limiting that feature with 65k pireps, so pax/cgo counts will not work on your setup but will be present on others until they hit 65k pireps
-
Checked flight import code, if the distance is not supplied (empty, null) importer is designed to auto calculate @nobleord ... If it is not working please open a bug report instead of a feature request
Safe flights
-
5 hours ago, nobleord said:
Drat.
I looked in v5 and there is an option to "recalculate" the distances of each in the flight admin page but didn't see something similar while poking around in v7. (It also did the calculation during the import)
Is there a feature request wish list to add a "recalculate" option?
Thanks,
Bryan
Of course, there is a Feature Request option at GitHub, also bug reporting is possible, both being tracked and discussed there.
https://github.com/nabeelio/phpvms/issues/new/choose
https://github.com/nabeelio/phpvms/issues
Safe flights
-
It is auto calculated when creating a new flight via admin interface but not during import as far as I remember.
-
2 hours ago, Nabeel said:
I think I put in there how much time they were stopped as a field? If not, I think I can add that pretty easily
Yeah we already have "Total Pause Time" in pirep field values, but the OP's question was not about pause, also pause is not counted as flight time as expected. What he wants is simply eliminating sandbaggers with some automation.
-
Did somebody claimed that being an admin would be fun (or not boring, not time consuming) ?
You are trying to go the same path with some others, I should not do anything, everything should be automatic, why I am working for this etc. etc.
Then I would ask the above question
After all, you can have some code to auto reject pireps by comparing planned (scheduled) flight times with actual flight times (side questions; what will happen to free flights, flights without simbrief plans to precisely check times, flights planned for different aircraft types). In the end, this will have side effects though, then you will work to fix the mis-identified ones 'cause a code will never know the difference between sandbagging and real holding (as it is not an AI with tons of resources). It will only look to your schedule and reject a non matching pirep.
And when this happens, you will come here again to ask for another feature for inspecting and identifying, correcting those to reduce your workload
Still my advise is same, punish and fire them, this will greatly reduce sandbaggers and you will have a clean roster after a while.
Safe flights
-
1
-
-
1 hour ago, CSJCB said:
Hi everyone
Is there any possibility of STOP pilots doing unnecessary holdings which only purpose is to be AFK, nothing against with that, but question here is that such holding time ( in some cases of 1 & 2 hours ) are counting as flying hours which is not fare in my opinion.
regards
What kind of possibility you are after ? If someone is doing unnecessary holdings, waiting at the gate for hours after landing (gaming term : sandbagging) only option is to reject their pireps (as ProAvia suggested) manually and kick them from your VA (if you are really sure about their actions).
You can NOT automate this with a software (here in this forum it is phpvms and vmsacars), so it will NOT be possible unless you come up with an AI, reading your pilots mind, getting all other info (like online traffic, IVAO/VATSIM ATC chatter, weather etc.) and decide if he is sandbagging or holding for something really necessary.
Safe flights
-
10 hours ago, nfinger said:
I have the same issue, nobody can register and have 3 airports as home/Hubs saved to get started. Only recently installed v7 for testing and eventual production.
my register page link is here: https://icrew7.nobleairaus.com/register
any help would be greatly appreciated as it is a showstopper at this early stage.You are getting mixed content errors because your .env is set to use http (insecure content) but your register page uses https (secure content). Fix it and your early stage showstopper will be gone. (Or you can allow cross origin scripting for your domains.)
And thanks for replying to a 3 year old topic
-
1
-
-
3 hours ago, SKD said:
All pireps were imported. The error was shown in the dispobable Basic module (theme).
Which part ?
Send the log please if it is something Disposable related , either theme or module, I need full error details with stacktrace (your laravel log) to find it out (and solve if possible)
-
On 10/10/2023 at 12:45 AM, SKD said:
Is there a limit of 65k pireps ?
Depends on what you are asking, 65k limit is applicable for queries not database entries... So if the above query contains more than 65k entries in that IN (...) statement then yes it may fail, but this can be handled with batch inserts or optimized queries etc.Anyway, database can handle way more than 170k entries, so your pirep count will not be a problem but importing (handling : reading - processing - saving them with php and queries) can be a real pain.
I would suggest opening a bug report via GitHub or tag @Nabeel, he was improving the import code, maybe he can check this issue too.
-
He may be switching his install to v7, or maybe working on a navdata package for v7
Hope he continues to support v5 though, it is nice to keep the community rolling.
-
56 minutes ago, mattsmith said:
Where is the file located to edit the skin? i.e dropdown menus etc
Please check readme
https://github.com/FatihKoz/DisposableTheme#customizing-va-logo-images-and-menu-items
-
1
-
-
Good luck, hope the end result will be as you wish.
-
Great
Thanks for the clarification.
For the news, you can use
{!! ... !!}instead of
{{ ... }}blade feature to have basic html tags/formatting
https://laravel.com/docs/10.x/blade#displaying-unescaped-data
-
I do not see any attribution to phpVMS according to license conditions on your theme/skin.
Apart from this it looks nice.
-
Dear Zabeed, you should contact AVA staff for support, we can not help you to configure their acars software... They will know airline specific details, not us.
If they are using vmsAcars, you can find detailed docs here : https://docs.phpvms.net/acars/user-guide
Hope you can get support from your airline, safe flights.
-
No, there is not.
-
1
-
-
Sorry ? What you are trying to achieve and what is the error, could you be a little bit specific...
Normally, you download the software from vmsHost.io, it will be under your account and accessible only by you (if you are the user at vmsHost.io who bought the license for the VA)... then you upload that package to your server, somewhere which can be accessed by your pilots publicly. Then you get that new link and insert it to anywhere you need, distribute via your discord or use that link in vmsAcars module as the download link, or you can add it as a file/link for your VA's downloads etc.
No need to define redirects etc.
Hope this helps
-
Which part you need help with? Maybe we can guide you... Docs are pretty clear, we had some step by step instruction with screenshots at Discord too (needs some search).
Also you can check Paid Services section to find someone if you are willing to pay of course.
Good luck
-
How ? By editing the files you bought or by requesting the change from the provider ?
Either way, glad to hear the result
-
Technically, that sites should update their export systems and be compatible with latest changes...
This was discussed many times before, most of the time it is just a new field being introduced in v7 due to requests or system changes, but the schedule support selling sites fall behind of the current changes and their files fail.
So, what you can do is simple...
Export files (for example subfleets or aircraft) from your updated v7, compare the exported file against the file they provided. You can easily spot the difference, edit your file to follow latest changes/additions and import.
Even after this change you are getting errors, double check your edits and file structure, also double check the import you are trying. Many time I saw people trying to import aircraft to subfleet or vice versa (which will fail even with 100% legit files).
Good luck
-
Block the ip range @William, as Google's ReCaptcha was broken by bots many times in the past, you may be witnessing another time this is happening.
How many pireps are allowed in table pireps
in Support
Posted · Edited by DisposableHero
What is the `submitted_at` date of your pireps ? I am not asking the v5 pireps, we should check v7 tables from now on. As I am pretty sure those stats do work fine, we need to find the difference between an "imported old pirep" and a fresh v7 one to provide a solution (if it is possible of course)