New installation Database error

Install / Update
1

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:

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
innodb_default_row_format=DYNAMIC
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4

[mysql]
default-character-set = utf8mb4
2

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

1 Like
3

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

Using this

1 Like