ERROR 1118 (42000) at line 55: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

 RUN

SET GLOBAL innodb_strict_mode = 0;

Setup EC2 with Ruby on Rails

sudo apt update

sudo apt install gnupg2

gpg2 --keyserver hkp://keyserver.ubuntu.com --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3 7D2BAF1CF37B13E2069D6956105BD0E739499BDB

\curl -sSL https://get.rvm.io -o rvm.sh

nano rvm.sh

cat rvm.sh | bash -s stable --rails

source ~/.rvm/scripts/rvm

ruby -v

rvm install 2.7.5

rvm remove 3.0.0

rvm use 2.7.5 --default

cd /var/

sudo mkdir www

cd www/

sudo mkdir AppName

cd AppName/

sudo mkdir current

sudo chmod -R 777 /var/www/

sudo apt install postgresql libpq-dev

sudo -u postgres createuser root -s

sudo -u postgres psql

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 561F9B9CAC40B2F7

sudo sh -c 'echo deb https://oss-binaries.phusionpassenger.com/apt/passenger focal main > /etc/apt/sources.list.d/passenger.list'

sudo apt-get update

sudo apt-get install -y nginx-extras libnginx-mod-http-passenger

if [ ! -f /etc/nginx/modules-enabled/50-mod-http-passenger.conf ]; then sudo ln -s /usr/share/nginx/modules-available/mod-http-passenger.load /etc/nginx/modules-enabled/50-mod-http-passenger.conf ; fi

sudo ls /etc/nginx/conf.d/mod-http-passenger.conf

sudo nano /etc/nginx/conf.d/mod-http-passenger.conf

sudo service nginx restart

sudo rm /etc/nginx/sites-enabled/default

sudo nano /etc/nginx/sites-enabled/AppName

sudo apt-get install redis-server

invalid active developer path (/Library/Developer/CommandLineTools) After upgrading macOS

 xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun

Solution:

xcode-select --install

fatal: Need to specify how to reconcile divergent branches.

 git config --global pull.ff true

Uncaught (in promise) TypeError: Cannot convert undefined or null to object companion bubble

 Remove Loom Chrome Extension and install it again will fix it.

Make sql full_group_by compatible sql_mode=only_full_group_by

select @@global.sql_mode;

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Enable Git Tab Autocomplete for Zsh

Add the following line to the ~/.zshrc file and restart your Terminal application:

autoload -Uz compinit && compinit