_csv.Error: iterator should return strings, not bytes

Hello, i get this error when i go to the created site
localhost:8000

bench --version
4.1.0

any help resolving the error ?

hi oderao!

Post the full traceback - check in frappe-bench/logs

and ‘bench version’ is what matters more

cheers

bench version
erpnext 10.1.25
frappe 10.1.25

[ERROR] 2018-04-25 03:29:17,838 | /home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py:
Could not take error snapshot: module ‘types’ has no attribute ‘ClassType’
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 39, in render
data = render_page_by_language(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 133, in render_page_by_language
return render_page(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 149, in render_page
return build(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 156, in build
return build_page(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 169, in build_page
context = get_context(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/context.py”, line 28, in get_context
context = build_context(context)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/context.py”, line 77, in build_context
context.update(get_website_settings())
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/doctype/website_settings/website_settings.py”, line 77, in get_website_settings
{“label”: _(“My Account”), “url”: “/me”},
File “/home/nigma/frappe-bench/apps/frappe/frappe/init.py”, line 56, in _
return get_full_dict(lang).get(msg) or msg
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 189, in get_full_dict
frappe.local.lang_full_dict = load_lang(lang)
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 215, in load_lang
out.update(get_translation_dict_from_file(path, lang, app) or {})
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 231, in get_translation_dict_from_file
csv_content = read_csv_file(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 549, in read_csv_file
newdata = [[text_type(val, ‘utf-8’) for val in row] for row in data]
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 549, in
newdata = [[text_type(val, ‘utf-8’) for val in row] for row in data]
_csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/app.py”, line 76, in application
response = frappe.website.render.render()
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 72, in render
data = render_page(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 149, in render_page
return build(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 156, in build
return build_page(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/render.py”, line 169, in build_page
context = get_context(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/context.py”, line 28, in get_context
context = build_context(context)
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/context.py”, line 77, in build_context
context.update(get_website_settings())
File “/home/nigma/frappe-bench/apps/frappe/frappe/website/doctype/website_settings/website_settings.py”, line 77, in get_website_settings
{“label”: _(“My Account”), “url”: “/me”},
File “/home/nigma/frappe-bench/apps/frappe/frappe/init.py”, line 56, in _
return get_full_dict(lang).get(msg) or msg
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 189, in get_full_dict
frappe.local.lang_full_dict = load_lang(lang)
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 215, in load_lang
out.update(get_translation_dict_from_file(path, lang, app) or {})
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 231, in get_translation_dict_from_file
csv_content = read_csv_file(path)
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 549, in read_csv_file
newdata = [[text_type(val, ‘utf-8’) for val in row] for row in data]
File “/home/nigma/frappe-bench/apps/frappe/frappe/translate.py”, line 549, in
newdata = [[text_type(val, ‘utf-8’) for val in row] for row in data]
_csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py”, line 36, in make_error_snapshot
snapshot = get_snapshot(exception)
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py”, line 52, in get_snapshot
if isinstance(etype, types.ClassType):
AttributeError: module ‘types’ has no attribute ‘ClassType’
[ERROR] 2018-04-25 09:01:52,788 | /home/nigma/frappe-bench/apps/frappe/frappe/utils/scheduler.py:
Site: site1.local
Exception in Enqueue Events for Site site1.local
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line 88, in enqueue_events_for_site
if is_scheduler_disabled():
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/scheduler.py”, line 227, in is_scheduler_disabled
return not frappe.utils.cint(frappe.db.get_single_value(“System Settings”, “enable_scheduler”))
File “/home/nigma/frappe-bench/apps/frappe/frappe/database.py”, line 584, in get_single_value
tabSingles where doctype=%s and field=%s"“”, (doctype, fieldname))
File “/home/nigma/frappe-bench/apps/frappe/frappe/database.py”, line 166, in sql
self._cursor.execute(query, values)
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 165, in execute
result = self._query(query)
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py”, line 321, in _query
conn.query(q)
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 860, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1061, in _read_query_result
result.read()
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1349, in read
first_packet = self.connection._read_packet()
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 1018, in _read_packet
packet.check_error()
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py”, line 384, in check_error
err.raise_mysql_exception(self._data)
File “/home/nigma/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py”, line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, “Table ‘1bd3e0294da19198.tabSingles’ doesn’t exist”)
[ERROR] 2018-04-25 13:41:35,101 | /home/nigma/frappe-bench/apps/frappe/frappe/app.py:
Site: site1.local
Request Error
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 116, in init
self.set_user_info(resume=True)
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 146, in set_user_info
self.full_name = " ".join(filter(None, [self.info.first_name,
AttributeError: ‘NoneType’ object has no attribute ‘first_name’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/app.py”, line 59, in application
init_request(request)
File “/home/nigma/frappe-bench/apps/frappe/frappe/app.py”, line 121, in init_request
frappe.local.http_request = frappe.auth.HTTPRequest()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 53, in init
frappe.local.login_manager = LoginManager()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 120, in init
self.set_user_info()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 146, in set_user_info
self.full_name = " ".join(filter(None, [self.info.first_name,
AttributeError: ‘NoneType’ object has no attribute ‘first_name’
[ERROR] 2018-04-25 13:41:35,102 | /home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py:
Could not take error snapshot: module ‘types’ has no attribute ‘ClassType’
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 116, in init
self.set_user_info(resume=True)
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 146, in set_user_info
self.full_name = " ".join(filter(None, [self.info.first_name,
AttributeError: ‘NoneType’ object has no attribute ‘first_name’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/app.py”, line 59, in application
init_request(request)
File “/home/nigma/frappe-bench/apps/frappe/frappe/app.py”, line 121, in init_request
frappe.local.http_request = frappe.auth.HTTPRequest()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 53, in init
frappe.local.login_manager = LoginManager()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 120, in init
self.set_user_info()
File “/home/nigma/frappe-bench/apps/frappe/frappe/auth.py”, line 146, in set_user_info
self.full_name = " ".join(filter(None, [self.info.first_name,
AttributeError: ‘NoneType’ object has no attribute ‘first_name’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py”, line 36, in make_error_snapshot
snapshot = get_snapshot(exception)
File “/home/nigma/frappe-bench/apps/frappe/frappe/utils/error.py”, line 52, in get_snapshot
if isinstance(etype, types.ClassType):
AttributeError: module ‘types’ has no attribute ‘ClassType’

theses are the logs from frappe-bench/logs/frappe.log

@clarkej i solved this problem by doing a force reinstall of the site

bench --site [sitename] --force reinstall
bench --site site1.local --force reinstall

thanks