Table 'a46003081c.tabdefaultvalue' doesn't exist

Frappe Framework
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

3 Likes
Update error: _mysql_exceptions.ProgrammingError: (1146, "Table '1bd3e0294da19198.tabPatient' doesn't exist")