Hi,
I got the same error when i run this command bench --site site1.local install-app erpnext
this is the error that i’ve got _mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294da19198.tabDefaultValue’ doesn’t exist”)
Any recommendation ?
Your quick action are appreciated.
I had the same error and was able to resolve as follows:
Make sure you can successfully log into mysql (mariaDB) as root: # mysql -u root -p
While logged into mysql as root, do the following:
Drop the database with the weird user name (e.g. ‘a46003081’), mysql> drop database a46003081;
Drop the user with the same name as the database mysql> drop user 'a46003081'@'localhost';
Add the following 2 sections in the my.cnf file (on Ubuntu 16.04 this is in /etc/mysql/my.cnf , which is actually a softlink):
[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[mysql]
default-character-set = utf8mb4
Restart mysqld
On Ubuntu 16.04: # sudo systemctl restart mysqld
Reinstall the site: bench --site site1.local --force reinstall