OSX: Error when trying to install app in site

Hi,

I get the following error when tying to install an app to a site in OSX.
When I check in mariadb, the database “9ce28be659” exists but the table “tabdefaultvalue” does not.

My my.cnf is in /etc

Please assist.

Regards,
cksgb

home$ bench --site estate_management install-app estate_management.dev
Traceback (most recent call last):
File “/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/commands.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/commands.py”, line 163, in install_app
_install_app(app, verbose=context.verbose)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/installer.py”, line 92, in install_app
frappe.clear_cache()
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/init.py”, line 416, in clear_cache
for fn in frappe.get_hooks(“clear_cache”):
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/init.py”, line 703, in get_hooks
hooks = _dict(cache().get_value(“app_hooks”, load_app_hooks))
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 68, in get_value
val = generator()
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/init.py”, line 671, in load_app_hooks
for app in [app_name] if app_name else get_installed_apps(sort=True):
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/init.py”, line 656, in get_installed_apps
installed = json.loads(db.get_global(“installed_apps”) or “”)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/database.py”, line 641, in get_global
return self.get_default(key, user)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/database.py”, line 653, in get_default
d = self.get_defaults(key, parent)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/database.py”, line 659, in get_defaults
defaults = frappe.defaults.get_defaults(parent)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/defaults.py”, line 72, in get_defaults
globald = get_defaults_for()
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/defaults.py”, line 177, in get_defaults_for
where parent = %s order by creation"“”, (parent,), as_dict=1)
File “/Users/chudeosiegbu/frappe-bench/apps/frappe/frappe/database.py”, line 135, in sql
self._cursor.execute(query, values)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/Users/chudeosiegbu/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘9ce28be659.tabdefaultvalue’ doesn’t exist”)

@Chude_Osiegbu it sounds that you database have no tables,

Hi @max_morais_dmm,

Yes, it doesn’t. What I don’t understand is why the tables are not being created and no error is being reported. Is it possibly something wrong with how maria_db is installed?

Regards,
cksgb

@Chude_Osiegbu, maybe something wrong occurred in a reinstall, or install process, and that exited with the bank blank.

Try to reinstall everything again with bench reinstall

Hi,

bench reinstall doesn’t seem to be a valid command.

@rmehta could you please help? I’ve never been able to succeed setting frappe up on OSX.

Regards,
cksgb

The framework has been developed on a Mac :smile: Since 2005 on an 11’ iBook

I think the install was okay, you just need reinstall your site.

@rmehta

Thanks. Sorted.

Regards,
cksgb