Some caveats and errors (but nothing horrible)

from 7.4 to 7.4.1 -> fatal error if you don’t define opcache user so be aware of that

Mysql 8 is using a new recommended auth and you should probably use it as well, however, prestashop will not like it.
When installing mysql 8 you can still use the new native auth and change prestashop users to use the old (sha2) password:

ALTER USER ‘user’@” IDENTIFIED WITH caching_sha2_password BY ‘xxxxxxx’;

At the time of writing, docker does not have repository for disco (ubuntu 19.04), so we have to use the previous version (18.04 – bionic).

You will do all the steps as mentioned in the official docker doc: https://docs.docker.com/install/linux/docker-ce/ubuntu/ except you will change the repo command from:

$ sudo add-apt-repository \
   "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
   $(lsb_release -cs) \
   stable"

to:

$ sudo add-apt-repository \
   "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
   bionic \
   test"

And that’s really it. You can now install docker with all the tools:

$ sudo apt-get install docker-ce docker-ce-cli containerd.io

Well, to be honest, I’m still in a shock after I found out that there is no “wget” on window$, so here we are… explaining a safe way to download all YouTube videos in a playlist.

First, you need to generate all the URLs via this nice and simple online tool: https://youtubemultidownloader.net/playlists.html

Once it populates the text box, copy the results and store in notepad++ or something similar for later.

If you are on windows 10, you can download free software (unbelievable :O) called “Batch Downloader” from the windows store: (https://www.microsoft.com/en-us/p/batch-downloader/9nblggh625v6?activetab=pivot%3Aoverviewtab|pivot%3Areviewstab)

Install it (obviously), and now you can paste the previously generated URLs from the online tool above. Voila, you have your hard copy…

EDIT:

as one would (and should) expect, the shitty widows batch downloader was not really up to the task, so I had to download wget and use that.

If you want to use wget on windows, just google and download wget.exe, copy it to the text file where you keep all the links generated by the online tool and run the command: wget -i your_list.txt

Now, you probably want to rename all the files with some mass tool such as totalcmd. Go to Files->Multi-rename tool (or Ctrl+M) and fill the “Search for:” with the portion of the file name which you want to “delete”, and leave the “Replace with” empty and hit “Start”.

If you know any better way of how to do it on window$ crap I’m all ears.

enjoy

WHAT A PAIN IN THE NECK!!!

Just a quick to save someone from cursing… a lot… I mean A F….. LOT

A working nginx configuration with latest php 7.3 and prestashop 1.7.5:

https://github.com/kukoman/prestashop

Hope it helps someone…

Do you get a black screen on your Xiaomi phone as I did? I tried google but people gave many devices that did not work, ranging from rebooting the phone to flashing a different ROM.

In my case, the phone was just a few hours old, so obviously if the carrier did not drop the package, I did not consider it a hardware problem. Then I realized, it is doing “sometimes”, meaning, only after the phone was locked for more than a minute.

As tried to unlock the phone with a fingerprint, the sound suggested the phone was indeed unlocked, however, the screen was black. So I had to manually press the side on/off button once or twice to really get the screen working.

Then I had finally my revelation… what if… it is locking more than once. After going to settings, finding the period after which the phone “auto-locked” the screen (15 sec, 1 minute, …) and turning it off, it finally started to work… better…

It MOSTLY works now. I’ll keep testing it and see if it gets better or I’ll have to return it :/

If anyone has a working solution, please leave down in the comments.

edit:

actually, I had to return it, as after extensive testing the firmware seemed to be really badly broken…

Pred spustenim servera, treba zmenit ownera na subore : server.key

chown postgres.postgres /var/lib/postgresql/8.4/main/server.key

V novsich verziach to mozno netreba.

potom prihlasit sa na psql

1. su – postgres
psql

vytvorenie noveho superuser

CREATE ROLE mysuperuser2 WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD ‘mysuperpass2’; // heslo musi byt v uvodzovkach

a potom sa da zvysok upravit v pgadmine

Natural sort in mysql

select alphanum ORDER BY LENGTH(alphanum), alphanum

result:
a1
a2
a9
a10
a11

How to remove svn needs-lock in all files in folders and subfolders

Use the check-for-modifications dialog, show all files (including not
modified ones).
Select all files, right-click, choose “properties”. Then remove the
svn:needs-lock property.

.svn-base 
entries

find ./ -iname 'foo' -or  -iname 'bar'
find ./ -type f -print | xargs sed -i 's/svn:needs-lock//g' {};

Increase the volume of an mp3 on linux

aptitude install easymp3gain-gtk

nacitate mp3 zmenite z 89db na trebars 100

public.webperfection.net/ringtone.mp3 original
public.webperfection.net/ringtone2.mp3

How to cut mp3 on linux?

simple:

aptitude install mpgtx

public.webperfection.net/ringtone3.mp3

mpgsplit ringtone2.mp3 [00:00:10.60-00:01:00] -o ringtone3.mp3