Migrate error please help!

Install / Update Deployment
1

when i try to migrate the site i faced the following error

frappe@server:~/frappe-bench$ bench --site site1.local migrate Migrating site1.local Updating frappe : [========================================] Updating erpnext : [========== ]Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main "__main__", fname, loader, pkg_name) File "/usr/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 79, in <module> main() File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 16, in main click.Group(commands=commands)(prog_name='bench') File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__ return self.main(*args, **kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke return callback(*args, **kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 24, in _func ret = f(frappe._dict(ctx.obj), *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 209, in migrate migrate(context.verbose, rebuild_website=rebuild_website) File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 32, in migrate frappe.model.sync.sync_all(verbose=verbose) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py", line 19, in sync_all sync_for(app, force, verbose=verbose, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py", line 44, in sync_for import_file_by_path(doc_path, force=force, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 57, in import_file_by_path reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 125, in import_doc doc.insert() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 200, in insert self.db_insert() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py", line 296, in db_insert ), d.values()) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 137, in sql self._cursor.execute(query, values) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1048, "Column 'allow_guest_to_view' cannot be null")

and i`v tried that

and it migrated successfully but after that the desk gaves me nothing like

Pasted image1366×768 42 KB

please help !!

2

Hi @Mahmoud_Ghoneem

Did you switched the application’s branch?

3

yes thats why the error come

i was trying to switch from master to develop and faced that error

4

Hi @Mahmoud_Ghoneem
can you share the content of web.error.log, web.log

5

u can download them from here

http://riadco.com.eg/files/web.log

http://riadco.com.eg/files/web.error.log

6

Hi @Mahmoud_Ghoneem

Frappe app is on master branch?
If yes,
run command bench console and run below code
frappe.reload_doc(“core”, ‘doctype’, “page”)
frappe.reload_doc(“core”, ‘doctype’, “report”)
frappe.reload_doc(“core”, ‘doctype’, “user”)
exit

After that run command bench migrate

7

In [1]: frappe.reload_doc(“core”, ‘doctype’, “page”)
Out[1]: False

In [2]: frappe.reload_doc(“core”, ‘doctype’, “report”)
Out[2]: False

In [3]: frappe.reload_doc(“core”, ‘doctype’, “user”)
Out[3]: False

In [4]: exit

8

Try below
frappe.reload_doctype(“Page”)
frappe.reload_doctype(“Report”)
frappe.reload_doctype(“User”)

If you are on master branch run below code in bench console
frappe.delete_doc(‘DocType’, ‘Has Role’)

9

`In [2]: frappe.reload_doctype(“Page”)

In [3]: frappe.reload_doctype(“Report”)

In [4]: frappe.reload_doctype(“User”)

In [5]: frappe.delete_doc(‘DocType’, ‘Has Role’)

In [6]: exit

frappe@server:~/frappe-bench$ bench migrate
Migrating site1.local
Updating frappe : [========================================]
Updating erpnext : [========== ]Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 209, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 32, in migrate
frappe.model.sync.sync_all(verbose=verbose)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
sync_for(app, force, verbose=verbose, reset_permissions=reset_permissions)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py”, line 44, in sync_for
import_file_by_path(doc_path, force=force, reset_permissions=reset_permissions)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 57, in import_file_by_path
reset_permissions=reset_permissions)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 125, in import_doc
doc.insert()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py”, line 200, in insert
self.db_insert()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 296, in db_insert
), d.values())
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 137, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1048, “Column ‘allow_guest_to_view’ cannot be null”)
`

10

Hi @Mahmoud_Ghoneem

Your applications are on which branch, master or develop?

11

how can i know

i`v tried bench switch-to-master before trying your solution

12

@Mahmoud_Ghoneem,

run git branch command from /apps/erpnext and /apps/frappe directory to know the current branch

Thanks,
Makarand

13

both are on master

14

If you were in develop and trying to switch to master, it is not possible in the current state. develop branch is much ahead from the master, you cant go back that long. Hence switch to master will not work. You can only switch to master after v8 release on 30th March

For now, try following get back you site:
bench switch-to-develop
bench --site <site_name> mariadb
Run the query: update tabDocType set allow_guest_to_view=0 where allow_guest_to_view is null;
Exit from the mysql/mariadb
bench --site <site_name> migrate

Let me know if it works.