Pratik Vyas於 2014年7月19日星期六UTC+8下午6時53分26秒寫道:
On Sat, Jul 19, 2014 at 4:10 PM, 'Kenneth K' via ERPNext Developer
Forum <erpnext-dev...@googlegroups.com> wrote:
> Hi Pratik,
>
> I've got the error during upgrading.
>>
>> [ro...@ip-172-31-0-5 frappe-bench]# ./scripts/install.sh migrate_3_to_4
>> /home/erpnext/erpnext
>>
>> New python executable in env/bin/python2.7
>> Also creating executable in env/bin/python
>> Installing setuptools, pip...done.
>> remote: Reusing existing pack: 56374, done.
>> remote: Counting objects: 93, done.
>> remote: Compressing objects: 100% (93/93), done.
>> remote: Total 56467 (delta 40), reused 0 (delta 0)
>> Receiving objects: 100% (56467/56467), 22.38 MiB | 4.03 MiB/s, done.
>> Resolving deltas: 100% (39646/39646), done.
>> remote: Reusing existing pack: 114207, done.
>> remote: Counting objects: 92, done.
>> remote: Compressing objects: 100% (91/91), done.
>> remote: Total 114299 (delta 54), reused 2 (delta 1)
>> Receiving objects: 100% (114299/114299), 35.93 MiB | 5.58 MiB/s, done.
>> Resolving deltas: 100% (81397/81397), done.
>> remote: Reusing existing pack: 904, done.
>> remote: Total 904 (delta 0), reused 0 (delta 0)
>> Receiving objects: 100% (904/904), 260.24 KiB | 129 KiB/s, done.
>> Resolving deltas: 100% (622/622), done.
>> Wrote sites/assets/js/frappe-web.min.js - 63k
>> Wrote sites/assets/js/shopping-cart-web.min.js - 1k
>> Wrote sites/assets/js/erpnext.min.js - 12k
>> Wrote sites/assets/css/frappe.css - 211k
>> Wrote sites/assets/css/frappe-web.css - 162k
>> Wrote sites/assets/css/shopping-cart-web.css - 0k
>> Wrote sites/assets/js/editor.min.js - 26k
>> Wrote sites/assets/css/erpnext.css - 0k
>> Wrote sites/assets/js/frappe.min.js - 608k
>> Wrote sites/assets/js/erpnext-web.min.js - 0k
>> Wrote sites/assets/js/slickgrid.min.js - 102k
>> Wrote sites/assets/js/canvasResize.min.js - 22k
>> Executing execute:frappe.db.sql("""update `tabPatch Log` set
>> patch=replace(patch, '.4_0.', '.v4_0.')""") #2014-05-12 in erpnext
>> (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'doctype',
>> force=True) #2014-01-24 in erpnext (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'docfield',
>> force=True) #2014-03-01 in erpnext (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'docperm')
>> #2014-06-04 in erpnext (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'page') #2013-13-26
>> in erpnext (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'report')
>> #2014-06-03 in erpnext (hpharmerp)
>> Success
>> Executing execute:frappe.reload_doc('core', 'doctype', 'version')
>> #2014-02-21 in erpnext (hpharmerp)
>>
>> Traceback (most recent call last):
>> File "scripts/3to4.py", line 32, in <module>
>> migrate(args.site)
>> File "scripts/3to4.py", line 26, in migrate
>> latest()
>> File "/var/www/frappe-bench/apps/frappe/frappe/cli.py", line 67, in
>> new_fn
>> return fn(*args, **new_kwargs)
>> File "/var/www/frappe-bench/apps/frappe/frappe/cli.py", line 417, in
>> latest
>> frappe.modules.patch_handler.run_all()
>> File
>> "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line
>> 25, in run_all
>> if not run_single(patchmodule = patch):
>> File
>> "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line
>> 50, in run_single
>> return execute_patch(patchmodule, method, methodargs)
>> File
>> "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line
>> 64, in execute_patch
>> exec patchmodule.split("execute:")[1] in globals()
>> File "<string>", line 1, in <module>
>> File "/var/www/frappe-bench/apps/frappe/frappe/__init__.py", line 364,
>> in reload_doc
>> return frappe.modules.reload_doc(module, dt, dn, force=force)
>> File "/var/www/frappe-bench/apps/frappe/frappe/modules/__init__.py",
>> line 35, in reload_doc
>> return import_files(module, dt, dn, force=force)
>> File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py",
>> line 17, in import_files
>> return import_file(module, dt, dn, force=force)
>> File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py",
>> line 22, in import_file
>> ret = import_file_by_path(path, force)
>> File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py",
>> line 50, in import_file_by_path
>> import_doc(doc, force=force)
>> File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py",
>> line 111, in import_doc
>> doc.insert()
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 147, in insert
>> self.run_post_save_methods()
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 419, in run_post_save_methods
>> self.run_method("on_update")
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 392, in run_method
>> return Document.hook(fn)(self, *args, **kwargs)
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 468, in composer
>> return composed(self, method, *args, **kwargs)
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 451, in runner
>> add_to_return_value(self, fn(self, *args, **kwargs))
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line
>> 386, in <lambda>
>> fn = lambda self, *args, **kwargs: getattr(self, method)(*args,
>> **kwargs)
>> File
>> "/var/www/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py",
>> line 86, in on_update
>> updatedb(self.name)
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line
>> 390, in updatedb
>> tab.sync()
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line
>> 170, in sync
>> self.create()
>> File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line
>> 90, in create
>> CHARACTER SET=utf8""" % (self.name, add_text))
>> File "/var/www/frappe-bench/apps/frappe/frappe/database.py", line 118,
>> in sql
>> self._cursor.execute(query)
>> File
>> "/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py",
>> line 205, in execute
>> self.errorhandler(self, exc, value)
>> File
>> "/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py",
>> line 36, in defaulterrorhandler
>> raise errorclass, errorvalue
>> _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL
>> syntax; check the manual that corresponds to your MySQL server version for
>> the right syntax to use near '(6),\n\t\t\tmodified
>> datetime(6),\n\t\t\tmodified_by varchar(255),\n\t\t\towner varchar(255)' at
>> line 3")
>
>
> May I ask how to make it possible to upgrade? Thanks so much.
>
> Thanks,
> Kenneth
>
> --
> Note:
>
> If you are posting an issue,
> 1. We should be able to replicate it at our end. So please give us as much
> information as you can. Please see it from the point of view of the person
> receiving the communication.
> 2. Paste your code at http://pastebin.com or http://gist.github.com and send
> only the URL via email
> 3. For sending images, use http://imgur.com or other similar services. Do
> not send images as attachments. Links are good. Same goes for any file you
> are going to send.
>
> End of Note
> ---
> You received this message because you are subscribed to the Google Groups
> "ERPNext Developer Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to erpnext-developer-forum+un...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/erpnext-developer-forum/79e4e3e9-a1a6-46a4-a5b2-a8ffbfad0b75%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.
Hi Kenneth,
Have you upgraded to MariaDB 5.5?
Thanks,
--
Pratik
erpnext
–
Note:
If you are posting an issue,
- We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
- Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
- For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ea295dc6-a2a7-4209-a701-d1beeda34200%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.