Hi, I am trying to bench update --reset
however I get this error below
cryptography is already v3.3.2
$ pip3 list |grep cryptography
cryptography 3.3.2
$ pip --version
pip 23.2.1 from /usr/local/lib/python3.7/dist-packages/pip (python 3.7)
$ python --version
Python 2.7.16
Would appreciate help on how to solve
Thank you
ERROR: Could not find a version that satisfies the requirement cryptography==3.3.2 (from frappe)
ERROR: No matching distribution found for cryptography==3.3.2
ERROR: /home/bobotto/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /home/bobotto/frappe-bench/apps/frappe
subprocess.CalledProcessError: Command '/home/bobotto/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /home/bobotto/frappe-bench/apps/frappe ’ returned non-zero exit status 1.
Which version of frappe/erpnext are you using?
Current
erpnext v12.9.4
frappe v12.6.1
Trying to upgrade to v13 and then to v14
Please try below command
bench switch-to-branch version-13 frappe erpnext --upgrade
bench setup requirements
bench update --patch
Hi, I got this error when bench switch-to-branch version-13 frappe erpnext --upgrade
ERROR: Could not find a version that satisfies the requirement google-api-python-client~=2.2.0 (from frappe)
ERROR: No matching distribution found for google-api-python-client~=2.2.0
ERROR: /home/bobotto/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /home/bobotto/frappe-bench/apps/frappe
subprocess.CalledProcessError: Command '/home/bobotto/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e /home/bobotto/frappe-bench/apps/frappe ’ returned non-zero exit status 1.
It seems the /apps/frappe/requirements.txt file is saying I do not have the versions they require in the requirements.txt
I have already
$ sudo pip install -r ~/frappe-bench/apps/frappe/requirements.txt
but still facing the same error
How do I solve it?
Thank you
This is the content of my /apps/frappe/requirements.txt
Babel==2.6.0
beautifulsoup4==4.8.1
bleach-whitelist==0.0.10
bleach==3.3.0
boto3==1.10.18
braintree==3.57.1
chardet==3.0.4
Click==7.0
coverage==4.5.4
croniter==0.3.30
cryptography==3.3.2
dropbox==9.1.0
email-reply-parser==0.5.9
Faker==2.0.4
future==0.18.2
GitPython==2.1.15
gitdb2==2.0.6;python_version<‘3.4’
google-api-python-client==1.9.3
google-auth-httplib2==0.0.3
google-auth-oauthlib==0.4.1
google-auth==1.19.1
googlemaps==3.1.1
gunicorn==19.10.0
html2text==2016.9.19
html5lib==1.0.1
ipython==5.8.0
Jinja2~=2.11.3
MarkupSafe<2.1.0
ldap3==2.7
markdown2==2.3.9
maxminddb-geolite2==2018.703
ndg-httpsclient==0.5.1
num2words==0.5.10
oauthlib==3.1.0
openpyxl==2.6.4
passlib==1.7.1
pdfkit==0.6.1
Pillow==6.2.2
premailer==3.6.1
psycopg2-binary==2.8.4
pyasn1==0.4.7
PyJWT==1.7.1
PyMySQL==0.9.3
pyOpenSSL==19.0.0
pyotp==2.3.0
PyPDF2==1.26.0
pypng==0.0.20
PyQRCode==1.2.1
python-dateutil==2.8.1
pytz==2019.3
PyYAML==5.3.1
rauth==0.7.3
redis==2.10.6
requests-oauthlib==1.3.0
requests==2.22.0
RestrictedPython==5.0
rq==0.12.0
schedule==0.6.0
selenium==3.141.0
semantic-version==2.8.2
six==1.13.0
sqlparse==0.2.4
stripe==2.40.0
terminaltables==3.1.0
Unidecode==1.1.1
unittest-xml-reporting==2.5.2
urllib3==1.25.11
watchdog==0.8.0
Werkzeug==0.16.1
xlrd==1.2.0
zxcvbn-python==4.4.24
wrapt==1.10.11
Try this
pip3 install virtualenv
virtualenv <your-env>
source <your-env>/bin/activate
<your-env>/bin/pip install google-api-python-client
Thanks for the input Suresh
crypto issue is solved
When run bench switch-to-branch version-13 frappe erpnext --upgrade,
now I get this error
Executing erpnext.patches.v13_0.add_default_interview_notification_templates in test.site
File “/home/frappe/frappe-bench/apps/frappe/frappe/email/doctype/email_template/email_template.py”, line 17, in validate
if self.use_html:
AttributeError: ‘EmailTemplate’ object has no attribute ‘use_html’
How can we solve this?
Or is this a bug from the latest branch version? (erpnext v13.52.8), so we need to wait for core team to fix?
Try this command
bench --site your_site console
frappe.reload_doc('email', 'doctype', 'email_template')
frappe.db.commit()
OR
bench --force reload-doc email doctype email_template
then run
bench --site your_site clear-cache
bench --site your_site clear-website-cache
bench --site your_site migrate
Hi Suresh,
when input this command, bench --force reload-doc email doctype email_template
error msg is
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘migration_hash’ in ‘field list’”)
I have tried with the command, but also get the same error
bench --site your_site console
frappe.reload_doc(‘email’, ‘doctype’, ‘email_template’)
Hi, i think you have to delete manually the ligration_hash column in mysql/mariadb, be sure to backup data before testing it.
Sincerely yours,
Marty
