I’am getting the following error after update.
_mysql_exceptions.ProgrammingError: (1146, "Table 'a46003081c.tabdefaultvalue' doesn't exist")
First time i solve it, but now i don’t know what i did to “fix” last time. But every time i do
bench update i get the same error.
What should i do?
Please check the table name it should be “tabDefaultValue” instead of “tabdefaultvalue”.
Thanks for your answer. But the problem was with permissions to database folder.
I had to change other permission to a46003081c database folder in mysql folder. I think this was because an update i made to mariadb.
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.
Your site was probably not created correctly
I used this command to create site
bench new-site site1.local
after that I run above command and got error.
Any problem with my installation ?
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):
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
default-character-set = utf8mb4
On Ubuntu 16.04:
# sudo systemctl restart mysqld
Reinstall the site:
bench --site site1.local --force reinstall