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’;

Share This:

  • Comments Off on Prestashop 1.7 on mysql 8 latest and php 7.4.1

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: except you will change the repo command from:

$ sudo add-apt-repository \
   "deb [arch=amd64] \
   $(lsb_release -cs) \


$ sudo add-apt-repository \
   "deb [arch=amd64] \
   bionic \

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

$ sudo apt-get install docker-ce docker-ce-cli

Share This:

  • Comments Off on Installing docker on Ubuntu 19.04 (disco)

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:

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: (|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…


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.


Share This:

  • Comments Off on How to download a youtube playlist free

February 16, 2019 | In: Nepotriedené

Prestashop 1.7.5 – nginx


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:

Hope it helps someone…

Share This:

  • Comments Off on Prestashop 1.7.5 – nginx

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.


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

Share This:

  • Comments Off on Xiaomi Mi Mix 2S – black screen after unlocking

September 2, 2018 | In: Programovanie

Postgresql pridanie usera

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

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

Share This:

  • Comments Off on Postgresql pridanie usera

August 30, 2018 | In: Programovanie

mysql natural sort

Natural sort in mysql

select alphanum ORDER BY LENGTH(alphanum), alphanum


Share This:

  • Comments Off on mysql natural sort

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.


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

Share This:

  • Comments Off on svn:needs-lock disable

August 20, 2018 | In: Správa linuxu, Video-Audio

mp3 gain

Increase the volume of an mp3 on linux

aptitude install easymp3gain-gtk

nacitate mp3 zmenite z 89db na trebars 100 original

Share This:

  • Comments Off on mp3 gain

August 18, 2018 | In: Správa linuxu, Video-Audio

mp3 cut

How to cut mp3 on linux?


aptitude install mpgtx

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

Share This:

  • Comments Off on mp3 cut