jluc2808
commented
7 years ago look at the stage_file
Open dav1170 opened 7 years ago
jluc2808
commented
7 years ago look at the stage_file
dav1170
commented
7 years ago Hello Jluc,
Would you mind explain what is the stage file means?
Regards
jluc2808
commented
7 years ago in the db doesn't request with videodata but with stage_file , which is the db where jetty store the file from the scanner , and the status of the file done, deleted, updated
jluc2808
commented
7 years ago select count(*) from stage_file where status = 'DELETED
jluc2808
commented
6 years ago @dav1170 is that issue still alive ?
dav1170
commented
6 years ago hello @jluc2808
I'm currently doing some tests on a rebuilded database. I'll give you a feedback soon.
dav1170
commented
6 years ago hello @jluc2808
I still have the same issue:
Additionally I've tried to deleted this unexisting movie in database, (delete from videodata where id = 12 limit 1;), but a foreign key constraint does allow this kind of request:
Cannot delete or update a parent row: a foreign key constraint fails (db.artwork, CONSTRAINT FK_ARTWORK_VIDEODATA FOREIGN KEY (videodata_id) REFERENCES videodata (id))
regards
jluc2808
commented
6 years ago rem: as i said i my previous message don't request or update on videodata table , only on stage_file table
what version yamj3 are you using ?
to delete a movie from the referenced table (stage_file) , use bikini ,
otherwise : start jetty, start the filescanner with the right library , wait till the filescanner tells Watching directory ''Your library" for changes... [17.09.2017 18:33:18]INFO org.yamj.filescanner.tools.Watcher - Register Watcher for: "Your folder" [17.09.2017 18:33:18]INFO org.yamj.filescanner.tools.Watcher - Enabling the watch process then delete the movie from the folder or subfolder you are watching the process should keep this info and it the jetty's task , then perform the delete action in jetty's process.
dav1170
commented
6 years ago Hello,
my yamj version is the following one: 2017-03-12 18:13:21 +0100 (It could be interesting to generate a new log file when the core instead of rotate log files according with size ?: it would be helpful to find the startup information).
I'm not able to use bikini: when I use it, even if I try to update or delete something (firefox 55 and chrome linux, I think the latest version of bikini), the confirm popin does nothing (I means, there is nothing added in the core log file). additionally, interface is very poor with my browser (I can't access to many menus and can"t display many things). This is the reason I try to update the database.
I've already tried to start the core and launch the filescanner, but if I search for "register watcher" in ALL my logs files, "register watcher" NEVER appear.
Additionally, after trying to update database, I think it could be interesting to use "ON DELETE CASCADE" for the foreign keys to avoid errors when trying to delete some wrong seasons or series.
Regards
jluc2808
commented
6 years ago hi, your version seems to be 282ecdb and is an old one , install the lastest 006e995 (del lib folder before)
to restart a new log (it's a day log) , stop jetty , delete logs and restart jetty
when using bikini , the delete action should show an api/update request
as you havn't the last version the "register watcher" shouldn't appeared
i'm using firefox 55 and chrome too and have no problem to access all menu , make sure you have setted a bikini_skin_0 or bikini_skin_1 in the configuration menu and in the style parameter select frame which is the more usefull with a windows OS (remove all cache too)
dav1170
commented
6 years ago Hello @jluc2808
I'm not sure but it seems that when I restart jetty it does not rotate the log file. I'll check.
regarding bikini, yes, I have a a confirmation popup displayed when I click on the delete button. But all the request made when I click on this confirmation popup failed in a 404 error.
I suppose that the Bikini configuration menu is the menu displayed when we click on the "i" button? Because when I click on this button button, nothing happen too. Is there a way to manage configuration differently?
regards
jluc2808
commented
6 years ago the log rotate when you're in an other day , follow my recommendation, rename the log when you stop jetty , you will get a brand new one
for bikini, it's like you didn't connect bikini and jetty to start bikini , you have to launch yamj3's html with /ip_of_jetty_machine:8888/yamj3 then enter the skin entry , then launch bikini with the bikini entry Inside the page
if the bikini configuration icon doesn't work, the left frame let you enter the skin configuration menu
everything is in the tittle.
here's the beginning of the log core log file
after running enqueue delete task from the %ip%:8888
both before and after running task a select count(*) from videodata where status = 'DELETED' return result above 0 and they are deleted files are still displayed on the eversion skin (even if after a restart of the jukebox).
regards