Kapil's Blog

Posts

April 06, 2025

MySQL - ERROR 1118 (42000): 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.

September 10, 2024

ActiveRecord::StatementInvalid (Mysql2::Error: SELECT list is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by):

July 29, 2024

error An unexpected error occurred certificate has expired" while install yarn package

February 27, 2023

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.

January 24, 2023

Setup EC2 with Ruby on Rails

October 31, 2022

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

September 16, 2022

fatal: Need to specify how to reconcile divergent branches.

September 16, 2022

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

July 14, 2022

MYSQL - RDS - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

August 03, 2021

cannot load such file -- mysql2/mysql2 (LoadError)

June 03, 2021

macOS failing install Ruby 2.6.7 implicit-function-declaration error

May 25, 2021

Downgrade to node version on MAC

May 20, 2021

Could not find a JavaScript runtime. See https://github.com/rails/execjs for a list of available runtimes. (ExecJS::RuntimeUnavailable)

May 06, 2021

pg_dump: aborting because of server version mismatch

May 06, 2021

pg_restore: [archiver] unsupported version (1.14) in file header

October 23, 2020

Search This Blog

Kapil's Blog

Posts

MySQL - ERROR 1118 (42000): 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.

ActiveRecord::StatementInvalid (Mysql2::Error: SELECT list is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by):

error An unexpected error occurred certificate has expired" while install yarn package

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.

Setup EC2 with Ruby on Rails

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

fatal: Need to specify how to reconcile divergent branches.

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

Make sql full_group_by compatible sql_mode=only_full_group_by

Enable Git Tab Autocomplete for Zsh

[Webpacker] Compilation failed: node:internal/crypto/hash:67

Open secured URL in the browser

MYSQL - RDS - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

cannot load such file -- mysql2/mysql2 (LoadError)

macOS failing install Ruby 2.6.7 implicit-function-declaration error

Downgrade to node version on MAC

Could not find a JavaScript runtime. See https://github.com/rails/execjs for a list of available runtimes. (ExecJS::RuntimeUnavailable)

pg_dump: aborting because of server version mismatch

pg_restore: [archiver] unsupported version (1.14) in file header

Removed null elements from array in Ruby on Rails request