ERPNext.com Frappe Cloud Support Partners Foundation

Table 'tabDefaultValue' missing Error When creating new site

Hi Dears,
I keep getting this error “Table ‘tabDefaultValue’ missing” and here is the full error body

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

The command I was running is: bench new-site library.test inside the bench folder.

I’ve tried to find a similar issue opened but couldn’t

My os is MacOS BigSur 11.4 - using Mac Air M1

@Hamdon_Gunner have a similar issue, but if you do docker installation of ERP it works like charm, please let me know if you find a solution.

what’s the mariadb version?

I face this error with 10.6.3-MariaDB

In case of docker it is using MariaDB 10.3

❯ bench new-site testdevelop.localhost --install-app erpnext --admin-password admin --force
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

I replaced ROW_FORMAT=COMPRESSED to ROW_FORMAT=DYNAMIC everywhere and it worked.

1 Like