Attila Fricz

PHP
Mysql
Linux
Photographer

Search

svn update not works, not update file

africz · Posted on June 27, 2018June 27, 2018

If svn update not works, need to revert first

svn revert -R .
svn update

Git local and remote repository on Linux server

africz · Posted on 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 …

Nginx Laravel setup to eliminate 404 error

africz · Posted on 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; # }

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

africz · Posted on 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 · Posted on 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 · Posted on 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’;

Force install kept back packages Ubuntu Linux Debian

africz · Posted on 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 · Posted on 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 · Posted on 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.

Back to Home Page

© 2024 Attila Fricz

Tags

config Database Debian git Laravel Linux Mysql Mysql error Nginx package install php php debugger remote debug repository setup slow boot source code ssh svn Ubuntu visual studio code vs code webserver xdebug

WordPress Theme by RichWP