SeAT - forum: Ajax / loss of info? - Page 1

hi so i tried adding few modules they worked fine for most of a day then we started getting issues where extractions tab would no longer show whats in the moons toggle ore button no longer works, and they have lost system info too, when i try to re-add the scan nothing happens or i get the below error the Tools moons reporter is also blank and shows as the pic DataTables warning: table id=dataTableBuilder - Ajax error. For more information about this error, please see https://datatables.net/tn/7

ive tried looking for the file with 0 luck

is it docker?

I think it is

okay

cd /opt/seat-docker

docker exec -it seat-docker-front-1 bash

cd /var/www/seat/vendor/eveseat/web/src/Http/DataTables/Tools/
ls -l

you should see this

total 20
-rw-r--r-- 1 seat seat 3506 Feb 11 20:46 MarketOrderDataTable.php
-rw-r--r-- 1 seat seat 7535 Feb 11 20:46 MoonsDataTable.php
-rw-r--r-- 1 seat seat 4169 Feb 11 20:46 StandingsDataTable.php

nano MoonsDataTable.php

Check Line 45 of MoonsDataTable.php Look at the code on line 45 where the error is occurring.

Just in case this is what I have and you should have.

see if yours is correct

if it is you can try few things. Before that I would like to ask if the ajax error was caused since the begining of your server or after some time? like some update etc?

Optionally you could test it... save your old MoonsDataTable.php replace code with mine and do restart of front container

Do you have an SDE installed?

and up to date?

wont this update on its own if its left out of date for too long? eve:update:sde this is in the schedule by default

the last one was Installed: sde-20241218-TRANQUILITY

so by now he should have it up to date even if he didnt update it.

It should yes... But having the region object being null is odd and not something I'd expect to see failing that we may have to dive into the DB and check for moons with bad location data

I thought about this but first I would like to see if the MoonsDataTable.php is not corrupted. If the ajax error happened at some point after some update / change? I don't see how DB could have that data corrupted without anyone touching it. It is possible but very rare I guess.

This error is weird 😄

before i mess with anything

Good, in your db can you run the follwoing query for me select count(*) from moons left join regions on moons.region_id=regions.region_id where regions.name is null;

On my machine it returns a count of 0 which is expected;

my moonsdatatable

i couldnt see anything obvious different. ive copy pasted yours in, and it still errror'd

might need to tell me how to find it

MariaDB [seat]> select count(*) from moons left join regions on moons.region_id=regions.region_id where regions.name is null;
ERROR 1146 (42S02): Table 'seat.moons' doesn't exist

Umm.... Can you guve me the output of show tables;

And also select value from global_settings where name = "installed_sde_tables";

Also as a shortuct if you need access to the db you can use the command docker compose exec front php artisan db

well... that will help lol

been trying to get at stuff without doing the docker exec

MariaDB [seat]> select value from global_settings where name = "installed_sde_tables";
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| value                                                                                                                                                                                                                                                                                                                                                                                |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ["chrFactions","dgmTypeAttributes","dgmTypeEffects","invCategories","invContrabandTypes","invControlTowerResourcePurposes","invControlTowerResources","invFlags","invGroups","invItems","invMarketGroups","invMetaGroups","invMetaTypes","invNames","invPositions","invTypeMaterials","invTypeReactions","invTypes","invUniqueNames","mapDenormalize","ramActivities","staStations"] |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Interesting...

If you use the command docker compose exec front php artisan sde --force then follow the prompts to refresh your sde does the problem persist?

worth a try

Yeah I can never remember the full command so I just lete laravel figure it out 😛

YAAY fixed

Thank you

No probs. Something happened to your SDE tables that meant they were missing data.. Unsure how that happens

probably me adding too many mods

Shouldnt matter really.. Those tables are provided as part of core.. But maybe partial backups / restores?

As far as I know of the public plugins none will overwrite any of core

mention of backup... i need to be in the docker exec to do the backup? since anytime i do it out side it either seems to fail or takes hours

nvm the files there 🙂 i can see it at last

nice so it was SDE after all hehe

Hehe yeah..

i did interrupt a backup. i thought it had crashed/frozen

just ran one now and it took 17 mins

well it depends how many tokens you have and how much there is to dump to a backup so yeah in bigger servers it will take a while 🙂

4495 char's.

jesus...

the all corps button shows 1461 corps