Attila Fricz – Software developer, photographer

Incorrect datetime value error 1292 in MySQL 5.7, allow to use empty value in date fields.

africz · February 16, 2020February 16, 2020

Original my.cnf had sql_model set as follows: sql_mode=STRICT_TRANS_TABLES,ALLOW_INVALID_DATE…etc Remove STRICT_TRANS_TABLES and restart service, it will allow to use empty values in date fields. Use ” ALLOW_INVALID_DATE ” seems not enough to eliminate error message.

UBUNTU 18 slow boot after upgrade

africz · April 12, 2019February 16, 2020

I did upgrade my favorite Linux virtual box and was very slow and finally did boot only to Emergency mode. I did usual fsck game on all harddisk , but still no joy.. I did launch systemd-analyze blame command and here we go I saw it was stuck on network with daily update service.. damn …

Log all mysql queries above version 5.6

africz · July 31, 2018July 31, 2018

Turn on log all queries to table SET global general_log = ‘ON’; SET global log_output = ‘table’; View the log select * from mysql.general_log Turn off log all queries to table SET global general_log = ‘OFF’;

Git local and remote repository on Linux server

africz · July 7, 2018April 3, 2019

Create an empty shared repository git clone –bare git path/to/repos/project_name project_name.git Initialized empty Git repository in git path/to/repos/project_name.git or clone from your existing repository on your server in your future remote repository folder git clone –bare git path/to/existing/local/repository project_name.git Finally issue next in your local empty folder git clone you@your_server.com:/repository_folder/project_name.git Add remote repository to existing …

svn update not works, not update file

africz · June 27, 2018June 27, 2018

If svn update not works, need to revert first svn revert -R . svn update

Force install kept back packages Ubuntu Linux Debian

africz · June 22, 2018

Issue sudo aptitude command in terminal window. Kept back packages are visible on top of the list in Upgradable Packages section Hit g twice and follow on-screen orders.

Image output with PHP to browser strange error, image not display

africz · May 17, 2018

Image didn’t display in the browser as should have to display. After several hours test by multiple people, we did find the source code just right, no bugs.. We didn’t find what causes the error in the browser, why just blank screen comes out. The reason was an invisible control character in source code before …

Find big tables in MySQL

africz · April 5, 2018February 16, 2020

Original my.cnf had sql_model set as follows: sql_mode=STRICT_TRANS_TABLES,ALLOW_INVALID_DATE,ERROR_FOR_DIVISION_BY_ZERO …etc Remove STRICT_TRANS_TABLES and restart service, it will allow to use empty values in date fields on use ” ALLOW_INVALID_DATE ” seems not enough to eliminate error message.

Nginx Laravel setup to eliminate 404 error

africz · April 1, 2018April 5, 2018

In site configuration replace next lines /etc/nginx/sites-available/default location / { try_files $uri $uri/ /index.php; } #location / { # First attempt to serve request as file, then # as directory, then fall back to displaying a 404. #try_files $uri $uri/ =404; try_files $uri $uri/ /index.php; # }

Xdebug remotely thru SSH with Visual Studio Code

africz · March 12, 2018April 5, 2018

SSH passwordless login setup First log in on A as user a and generate a pair of authentication keys. Do not enter a passphrase: a@A:~> ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/a/.ssh/id_rsa): Created directory ‘/home/a/.ssh’. Enter passphrase (empty for no passphrase): Enter same passphrase again: …