Blog del sito MyDigitalia - Usare il Pc seriamente.
Non disdegnate di sbirciare anche la pagina di Facebook

sabato 14 dicembre 2019

edit views in phpmyadmin

You can go in view -> structure and find (below) "edit view". Then you can change something, i.g. adding a nuew field, not yet present when that view was created.

venerdì 13 dicembre 2019

test sddm screen, without logging out

this is the code (in terminal):
sddm-greeter --test-mode --theme /usr/share/sddm/themes/breeze

giovedì 12 dicembre 2019

phpmyadmin relations in views

You can create a relation between two tables, or better between a table and a view (more flexible), so that you can use data of related table/view in the table you are using.

But if you create a view from that table (a table whose structure is "related" to another one) you have to repeat (in structure view) the relation settings.

mercoledì 11 dicembre 2019

field name containing "-" not accepted in a mysql query

You have to put the field name into quotes "`" some-text (not working) -> `some-text` (working)

domenica 8 dicembre 2019

if Kodi doesn't resume your videos

You can try adding in .kodi/userdata a file named «advancedsetting.xml», whose content is something like:
 <advancedsettings>  
 <video>  
 <playcountminimumpercent>95</playcountminimumpercent>  
 <ignoresecondsatstart>60</ignoresecondsatstart>  
 <ignorepercentatend>1</ignorepercentatend>  
 </video>  
 </advancedsettings>  

batch convert absolute symlinks to relative

You can use the small program "symlinks" (i.e. in Kubuntu). Remember to indicate the complete path, i.g.
symlinks -rc /your/path

venerdì 6 dicembre 2019

jobs in avidemux

Load 1st video, When finished making changes:

Avidemux menu: File -> Queue
in window "Queue job to joblist"
 Job name   : Job1 (name for job in joblist)
 Output file: click [Open] and choose name for saved video
Close that video (unless you want append the next)

Load 2nd video, When finished making changes
Avidemux menu: File -> Queue
in window "Queue job to joblist"
 Job name   : Job2 (name for job in joblist)
 Output file: click [Open] and choose name for saved video

Exit avidemux

Then, to avoid a bug, go in usr/bin, open a terminal and do
sudo ln -s avidemux2.7_cli avidemux3_cli
sudo ln -s avidemux2.7_qt5 avidemux3_qt5 
Start avidemux jobs (separate executable, same location where avidemux sits)

mark [v] use QT4 version (bottom of window)
press [Run jobs]

Translate

Archivio blog