2020-04-27

css how to expand an element to the whole web page

It could be not enough to set the height to 100%, or 100vw, you could try with
position: relative; height: auto; min-height: 100% !important;
It worked for me(cfr here)

w3c validation UTF-8 encoding error

With w3c validator you could get this error:
«Sorry, I am unable to validate this document because on line 3400 it contained one or more bytes that I cannot interpret as utf-8 (in other words, the bytes found are not valid values in the specified Character Encoding). Please check both the content of the file and the character encoding indication.» 
That could be because you have some files included in the php file checked by w3c validator, like an .inc one, not encodeed as UTF-8.
To fix this oproblem you have to encode all the components of a php file as UTF-8.

2020-04-21

search and replace in a mysql table

This is the code:

UPDATE `table_name`
SET `field_name` = replace(field_name, 'old_text', 'new_text')

2020-04-20

how to avoid #1265 error changing a value in a table structure

That is avoiding "data truncated" error. You must avoid to replace a value in use.
The right way, if a given value is already applied to some items, is
  1. to add the new value (supposed similar to the old) to the table structure
  2. search for all the items with old value
  3. replace in each item the old value with the new one
  4. delete the old value in the table structure

2020-04-13

batch change encoding to UTF-8 for several text (php) files

You can use recode
recode UTF-8 *.php -v
provided that all the files have the same encoding.
Otherwise you can try with something like
iconv -f US-ASCII -t UTF-8 *.php

a minor problem

It could be an apparent problem if there aren't non-ascii characters in a file: then these files are yet recognized, with
file -i --mime-encoding *
as us-ascii.
So you can add a non ascii character, like è:
sed -i -e "\$aè" *.php
and afterwards redo the command "recode" as above and replace some ascii expression, like agrave; with UFT-8 à character.
Eventually you will delete the "è" from the end of the files.

How to change encodig of ".srt" Subtitle File in UTF-8


To encode your SRT file in UTF-8 (for instance: "video.srt"), please follow this process:

1. Rename (F2) the "video.srt" file with your PC in "video.srt.txt".
2. Launch a text app, like Kate.
3. Click on the "File" menu then select "Save the file as...".
4. In coding option, select "UTF-8". Then save your file.
5. Rename (F2) the file "video.srt.txt" to "video.srt".
Done!

from: Zappiti Player 4K [EN]

svg editor

Inkscape is in my opinion too complicated (and Sodipodi very difficult to install, because of its dipendecies), a very interesting project is SVG-edit, at https://github.com/SVG-Edit/svgedit.
Without any installation on your PC, you can edit on-line your svg files. The resulting code is very clean, even though we have found some problem in setting colors.

permission denied

If you get rhis error message even you have all the rights, probably you are trying to run the command on a mounted partition that had the "noexec" flag on.
So change partition, .f.e. try your /home.

2020-04-11

tag object in firefox

It's probably a bug, but you couldn't manage to view an svg object tag with firefox, unless is setted as image/svg (and not a text/svg).

2020-04-09

amule: how get an "almost" high-ID

If you can't get a real high-ID with aMule you can try this trick (in an executable bash script):

#!/bin/sh

while :; do
   amule &     # run in background
   sleep 240
   killall amule
      # or   wmctrl -c aMule
   wait         # in case amule needs time to close
done
This script close aMule after 240 sec, and then restart aMule, indefinitely, so that his speed remains acceptably high.

2020-04-03

mysql wrong autoincrement number

It can happen that the ID autoincrement goes wrong; in this case my solution is very simple: I delete the ID column, and afterwards I re-create it (with the same parametres). It works.

ancient greek in LibreOffice

Some days ago I wrote this:

a simple maquillage, unfortunately

I mean ancient greek font so that you can, typing 'a' get immediatly 'α'. So far the free most interesting true type font (the only recognised by LibreOffice) is SPIonic.
You can see more details here.
With this font you can tranform the word "Nomos" in "Nomov", with few mouse clics (basically with the font menu, even though in this case you have to convert the final sigma as well).

caveat

Absolutely to avoid the "AncientGreek" extension: cumbersome, useless and very aggressive (after removing leaves you with modified shortcuts, including some basic like ctrl + z, ctrl + b and F3).Vey bad!

 a new solution

I noticed that the above solution works only within LibreOffice: if you copy a greek word in another program, you get a no-greek text (with latin encoding). That's why I call it now a maquillage.
A possible, better solution is go to a website that easyly encode your text in ancient greek, such as this.

keeping updated your custom css (in Calibre viewer or in markdown-viewer browser extension)

You can link within the css (in Calibre it is within the file "viewer-webengine.json", in markdown-viewer browser extension is the css file you yourself have chosen) your external css file, with something like
 @import url(http://localhost/path-to-your-css-file/your-css-file.css)
Provided you have a apache/php server in localhost, of course.

2020-04-01

mysql change column encoding

You can use this syntax (to change encoding a TEXT column to utf8):
ALTER TABLE name-of-the-table MODIFY name-of-the-column TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci

Blog Archive