Error When upgrading from version 3 to version 4 [development]

Frappe Framework Bug
1


This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
2

On Mon, May 12, 2014 at 12:33 PM, Anirvan Mandal
an...@gmail.com wrote:

This is the stacktrace for the error.

Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘version’)
#2014-02-21 in erpnext
Traceback (innermost last):
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”,
line 63, in execute_patch
exec patchmodule.split(“execute:”)[1] in globals()
File “”, line 1, in
File “/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/init.py”,
line 343, in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/init.py”,
line 35, in reload_doc
return import_files(module, dt, dn, force=force)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 17, in import_files
return import_file(module, dt, dn, force=force)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 22, in import_file
ret = import_file_by_path(path, force)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 50, in import_file_by_path
import_doc(doc)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 110, in import_doc
doc.insert()
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 139, in insert
self.run_post_save_methods()
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 394, in run_post_save_methods
self.run_method(“on_update”)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 367, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 432, in composer
return composed(self, method, *args, **kwargs)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 415, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py”,
line 365, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args,
**kwargs)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,
line 78, in on_update
updatedb(self.name)
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py”,
line 376, in updatedb
tab.sync()
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py”,
line 169, in sync
self.create()
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py”,
line 89, in create
CHARACTER SET=utf8"“” % (self.name, add_text))
File “/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py”,
line 118, in sql
self._cursor.execute(query)
File
“/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”,
line 205, in execute
self.errorhandler(self, exc, value)
File
“/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”,
line 36, in defaulterrorhandler
raise errorclass, errorvalue
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(40),\n\t\t\towner varchar(60),\n’ at line 3”)

execute:frappe.reload_doc(‘core’, ‘doctype’, ‘version’) #2014-02-21: failed:
STOPPED
Traceback (most recent call last):
File “scripts/3to4.py”, line 33, in
migrate(args.site)
File “scripts/3to4.py”, line 27, in migrate
latest()
File “/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py”, line
63, in new_fn
return fn(*args, **new_kwargs)
File “/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py”, line
368, in latest
frappe.modules.patch_handler.run_all()
File
“/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”,
line 27, in run_all
raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc(‘core’,
‘doctype’, ‘version’) #2014-02-21

–
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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Anirvan,

Are you running MariaDB? Also, please delay migration till the next v4 release.

Thanks,

–
Pratik
erpnext

3
Have you upgraded to MariaDB?


On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

–

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/93E2C3F4-B76B-4CC7-9D21-89CDDE4D7947%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
4
There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
https://github.com/frappe/erpnext/wiki/Installing-ERPNext-4

On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:
Have you upgraded to MariaDB?


On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

–

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/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
5
Use Frappe Bench

https://github.com/frappe/frappe-bench



@rushabh_mehta
https://erpnext.org

On 12-May-2014, at 12:45 pm, Anirvan Mandal <an...@gmail.com> wrote:

There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
https://github.com/frappe/erpnext/wiki/Installing-ERPNext-4

On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:
Have you upgraded to MariaDB?


On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.


–

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/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

–

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/7CF2D139-CE45-4634-8A2F-5874B09FEEDC%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
6
Hello,
I am trying to migrate Erpnext3 to 4, using below mentioned link, but got error:
Wrote sites/assets/js/canvasResize.min.js - 22k
Traceback (most recent call last):
  File "scripts/3to4.py", line 3, in <module>
    from frappe.website import rebuild_config
ImportError: cannot import name rebuild_config
ro...@novierpnext:/home/erpnext/erpnext/frappe-bench#

Pls. advise!

Thank You,
Ferenc

On Monday, May 12, 2014 9:19:12 AM UTC+2, rushabh wrote:
Use Frappe Bench

https://github.com/frappe/frappe-bench



@rushabh_mehta

On 12-May-2014, at 12:45 pm, Anirvan Mandal <an...@gmail.com> wrote:

There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:
Have you upgraded to MariaDB?


On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.


–

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/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

–

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/f5da3cfd-165b-4fc1-a9cc-be60fe5cab1d%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
7
Hi Ferenc,

Remove that line from 3to4.py and you should be good to go.

-Anand.


On Mon, Jun 30, 2014 at 7:12 PM, Ferenc <fe...@gmail.com> wrote:
Hello,
I am trying to migrate Erpnext3 to 4, using below mentioned link, but got error:

Wrote sites/assets/js/canvasResize.min.js - 22k


Traceback (most recent call last):
File "scripts/3to4.py", line 3, in <module>
from frappe.website import rebuild_config

ImportError: cannot import name rebuild_config
ro…@novierpnext:/home/erpnext/erpnext/frappe-bench#


Pls. advise!

Thank You,
Ferenc


On Monday, May 12, 2014 9:19:12 AM UTC+2, rushabh wrote:

Use Frappe Bench

On 12-May-2014, at 12:45 pm, Anirvan Mandal <an...@gmail.com> wrote:

There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:

Have you upgraded to MariaDB?



On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
exec patchmodule.split("execute:")[1] in globals()
File "<string>", line 1, in <module>
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
return import_files(module, dt, dn, force=force)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
return import_file(module, dt, dn, force=force)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
ret = import_file_by_path(path, force)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
import_doc(doc)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
doc.insert()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
self.run_post_save_methods()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
self.run_method("on_update")
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
return composed(self, method, *args, **kwargs)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
updatedb(self.name)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
tab.sync()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
self.create()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
CHARACTER SET=utf8""" % (self.name, add_text))
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
File "scripts/3to4.py", line 33, in <module>
migrate(args.site)
File "scripts/3to4.py", line 27, in migrate
latest()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
return fn(*args, **new_kwargs)
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
frappe.modules.patch_handler.run_all()
File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



–

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/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


–

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/f5da3cfd-165b-4fc1-a9cc-be60fe5cab1d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

–

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/CAAQzbF2tjA4DGpLsoTTWYL6XMaO551ADc0HWgLFtWef-v%3DdWHQ%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.
8
Hi Anand,
I am still trying to migrate Erpnext3 to 4, with no success...
Traceback (most recent call last):
  File "scripts/3to4.py", line 32, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 23, in migrate
    add_to_installed_apps('frappe', rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument 'rebuild_sitemap'
mi...@erpnext4:~/frappe-bench/apps/frappe-bench$

I am able to get separately Erpnext4 and I have also Erpnext3. The main problem is how to migrate data. Is it possible from backup?

Thank You,
Ferenc

On Monday, June 30, 2014 7:50:02 PM UTC+2, Anand Doshi wrote:
Hi Ferenc,

Remove that line from 3to4.py and you should be good to go.

-Anand.


On Mon, Jun 30, 2014 at 7:12 PM, Ferenc <fe...@gmail.com> wrote:
Hello,
I am trying to migrate Erpnext3 to 4, using below mentioned link, but got error:

Wrote sites/assets/js/canvasResize.min.js - 22k


Traceback (most recent call last):
  File “scripts/3to4.py”, line 3, in <module>
    from frappe.website import rebuild_config

ImportError: cannot import name rebuild_config
ro…@novierpnext:/home/erpnext/erpnext/frappe-bench#


Pls. advise!

Thank You,
Ferenc


On Monday, May 12, 2014 9:19:12 AM UTC+2, rushabh wrote:

Use Frappe Bench

On 12-May-2014, at 12:45 pm, Anirvan Mandal <an...@gmail.com> wrote:

There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:

Have you upgraded to MariaDB?



On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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+unsubscr…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



–

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+unsubscr…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


–

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/f5da3cfd-165b-4fc1-a9cc-be60fe5cab1d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

–

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/0def03db-3c40-48f0-9440-ed771cd7799e%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
9
Update script and run it again.


On 01-Jul-2014, at 5:38 pm, Ferenc <fe...@gmail.com> wrote:

Hi Anand,
I am still trying to migrate Erpnext3 to 4, with no success...
Traceback (most recent call last):
  File "scripts/3to4.py", line 32, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 23, in migrate
    add_to_installed_apps('frappe', rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument 'rebuild_sitemap'
mi...@erpnext4:~/frappe-bench/apps/frappe-bench$

I am able to get separately Erpnext4 and I have also Erpnext3. The main problem is how to migrate data. Is it possible from backup?

Thank You,
Ferenc

On Monday, June 30, 2014 7:50:02 PM UTC+2, Anand Doshi wrote:
Hi Ferenc,

Remove that line from 3to4.py and you should be good to go.

-Anand.


On Mon, Jun 30, 2014 at 7:12 PM, Ferenc <fe...@gmail.com> wrote:
Hello,
I am trying to migrate Erpnext3 to 4, using below mentioned link, but got error:

Wrote sites/assets/js/canvasResize.min.js - 22k


Traceback (most recent call last):
  File “scripts/3to4.py”, line 3, in <module>
    from frappe.website import rebuild_config

ImportError: cannot import name rebuild_config
ro…@novierpnext:/home/erpnext/erpnext/frappe-bench#


Pls. advise!

Thank You,
Ferenc


On Monday, May 12, 2014 9:19:12 AM UTC+2, rushabh wrote:

Use Frappe Bench

On 12-May-2014, at 12:45 pm, Anirvan Mandal <an...@gmail.com> wrote:

There is nothing related to maria db on the installation/upgrade notes. Can you point me to the right documentation.
On Monday, May 12, 2014 12:35:19 PM UTC+5:30, rushabh wrote:

Have you upgraded to MariaDB?



On 12-May-2014, at 12:33 pm, Anirvan Mandal <an...@gmail.com> wrote:



This is the stacktrace for the error.

Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext
Traceback (innermost last):
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 343, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 110, in import_doc
    doc.insert()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 139, in insert
    self.run_post_save_methods()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 394, in run_post_save_methods
    self.run_method("on_update")
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 367, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 432, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 415, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 365, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 78, in on_update
    updatedb(self.name)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 376, in updatedb
    tab.sync()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 169, in sync
    self.create()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 89, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/anirvan/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
 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(40),\n\t\t\towner varchar(60),\n' at line 3")

execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21: failed: STOPPED
Traceback (most recent call last):
  File "scripts/3to4.py", line 33, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 27, in migrate
    latest()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 63, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/cli.py", line 368, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/anirvan/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 27, in run_all
    raise PatchError(patch)
frappe.modules.patch_handler.PatchError: execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21

–

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+unsubscr…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/9f8dd19a-b032-42ef-ae45-54e47023c05a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



–

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+unsubscr…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/a9702d2a-4558-42be-8527-e875f8823d87%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



–

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/f5da3cfd-165b-4fc1-a9cc-be60fe5cab1d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


–

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/0def03db-3c40-48f0-9440-ed771cd7799e%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

–

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/A909FDD0-40A7-47DE-88E4-2C9B75735D1E%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.