MYSQL: how to fix error #1364 – Field ‘name’ doesn’t have a default value
Step 1: check sql_mode You see STRICT_TRANS_TABLES in that value. Step 2: use as root account then use this command: Done
Latest Topics
List HTTP and HTTPS live streaming for testing
HTTP live streaming for testing: HTTPS live streaming for testing: HTTP live TV HTTPS live TV
How to get real client IP address when you use Cloudflare
In almost all case, we can get real client IP address with $_SERVER[“HTTP_CF_CONNECTING_IP”] and $_SERVER[“REMOTE_ADDR”] But in some special cases we will get proxy IP…
Some errors when using puppeteer on Linux
Error 1: Fix: Error 2: Fix: Error 3: Fix: Use –no-sandbox Error 4: or Check version: Fix: Now version is 7.5.1804
Angular lesson 5: Parent component listens for child event
The child component exposes an EventEmitter property with which it emits events when something happens. The parent binds to that event property and reacts to…
Angular lesson 4: Intercept input property changes with ngOnChanges()
We can detect and act upon changes to input property values with the ngOnChanges() method of the OnChanges interface. Child component: src/app/child/child.component.html src/app/child/child.component.css src/app/child/child.component.ts Parent…
How to install php-pgsql on CentOS
Step 1: find PHP version Step 2: Step 3: in this case we install php56-php-pgsql Or you can use this repo: http://rpms.famillecollet.com/enterprise/7/test/x86_64//php56-php-pgsql-5.6.30-2.el7.remi.x86_64.rpm Then you will…
How to setup phpPgAdmin on CentOS
Suppose that we have a server with nginx and php-fpm installed. Step 1: Result: Step 2: create PostgreSQL user First login as the postgres user…
How to Install PostgreSQL on CentOS
Step 1: Step 2: Data Directory: /var/lib/pgsql/data Step 3: Step 4: Note: You can install other version e.g: 11 by using this repo: https://download.postgresql.org/pub/repos/yum/testing/11/redhat/rhel-7-x86_64/pgdg-centos11-11-1.noarch.rpm (You…
Angular lesson 3: pass data from parent component to child with input binding
In lesson 2, we learnt about Component. Now, we continue learn about component. Step 1: Create file school.ts in src/app Step 2: edit some files…