New installation Database error

Hi everyone,

I am installing new instance of the ERP on MacOS BugSur using manual installation.

On creating a new site with bench new-site

I am getting this error.

(env) waqastariq@Waqass-MacBook-Pro erpnextdir % bench new-site erpnext.erp

WARN: bench is installed in editable mode!

This is not the recommended mode of installation for production. Instead, install the package from PyPI with: `pip install frappe-bench`

MySQL root password:

ERROR 4047 (HY000) at line 10: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Table 'tabDefaultValue' missing in the restored site. Database not installed correctly, this can due to lack of permission, or that the database name exists. Check your mysql root password, validity of the backup file or use --force to reinstall

My my.cnf file:

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4

default-character-set = utf8mb4

Try running this command in MySQL
SET GLOBAL innodb_read_only_compressed=OFF;

1 Like

Never mind i was able to use Postgres SQL for installation of frappe.

Using this

1 Like