Table 'a46003081c.tabdefaultvalue' doesn't exist

Frappe Framework
1

Hi.

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?

Thanks,

Luis.

2

Hi @luisfmfernandes,

Please check the table name it should be “tabDefaultValue” instead of “tabdefaultvalue”.

Thanks,
Makarand Bauskar

1 Like
3

@makarand_b:

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.

Luis.

1 Like
4

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.

Thanks,
Heng

5

Your site was probably not created correctly

6

@rmehta
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 ?

Thanks,
Heng

7

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

2 Likes