Update error

Hi

I have been trying to update ERPnext but i keep getting this error.

File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks



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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 

Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi

I always use the command:
lib/wnf.py --update origin master

After running the update thats when the error comes up, and then i fail to log in.

let me post line by line so you have a better idea:

[start]

From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Updating 441c1dd…25e4a93
Fast-forward
 core/page/data_import_tool/data_import_tool.py |    4 +±-
 1 files changed, 2 insertions(+), 2 deletions(-)
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.

/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 405, in run
    update_erpnext(options.update[0], options.update[1])
  File “lib/wnf.py”, line 77, in update_erpnext
    patch_sync_build()
  File “lib/wnf.py”, line 80, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 91, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 12, in sync_all
    sync_for(“lib”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)

[end]



On Thursday, 7 March 2013 09:10:10 UTC+2, Anand Doshi wrote:

Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ObA3OWBHVFUJ.

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

 

 

Hi Joseph,

Have you tried updating again?

Sometimes, the wnframework files are updated, but the update process still refer to the old files. Second update will refer to the new changes and should work out.

-Anand.

On 07-Mar-2013, at 12:49 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I always use the command:
lib/wnf.py --update origin master

After running the update thats when the error comes up, and then i fail to log in.

let me post line by line so you have a better idea:

[start]

From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Updating 441c1dd..25e4a93
Fast-forward
 core/page/data_import_tool/data_import_tool.py |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.

/usr/local/lib/python2.6/dist-packages/pytz/__init__.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Traceback (most recent call last):
  File "lib/wnf.py", line 494, in <module>
    run()
  File "lib/wnf.py", line 405, in run
    update_erpnext(options.update[0], options.update[1])
  File "lib/wnf.py", line 77, in update_erpnext
    patch_sync_build()
  File "lib/wnf.py", line 80, in patch_sync_build
    patch_sync()
  File "lib/wnf.py", line 91, in patch_sync
    sync_all()
  File "lib/wnf.py", line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 12, in sync_all
    sync_for("lib", force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 18, in sync_for
    folder), force, sync_everything)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File "/var/www/erpnext/lib/webnotes/modules/__init__.py", line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 35, in import_files
    return import_file(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 45, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 63, in import_file_by_path
    import_doclist(doclist)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 110, in import_doclist
    new_bean.insert()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 268, in insert
    return self.save()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 279, in save
    self.save_main()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 426, in save
    keep_timestamps=keep_timestamps)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 380, in _update_values
    (self.doctype, ', '.join(update_str), "%s"), values)
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")

[end]



On Thursday, 7 March 2013 09:10:10 UTC+2, Anand Doshi wrote:
Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 





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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ObA3OWBHVFUJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi

I tried the update more than once, but let me try again and I will let you know how it goes?



On Thursday, 7 March 2013 09:23:22 UTC+2, Anand Doshi wrote:

Hi Joseph,

Have you tried updating again?

Sometimes, the wnframework files are updated, but the update process still refer to the old files. Second update will refer to the new changes and should work out.

-Anand.

On 07-Mar-2013, at 12:49 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I always use the command:
lib/wnf.py --update origin master

After running the update thats when the error comes up, and then i fail to log in.

let me post line by line so you have a better idea:

[start]

From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Updating 441c1dd…25e4a93
Fast-forward
 core/page/data_import_tool/data_import_tool.py |    4 +±-
 1 files changed, 2 insertions(+), 2 deletions(-)
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.

/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module mysql was already imported from /usr/lib/pymodules/python2.6/mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 405, in run
    update_erpnext(options.update[0], options.update[1])
  File “lib/wnf.py”, line 77, in update_erpnext
    patch_sync_build()
  File “lib/wnf.py”, line 80, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 91, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 12, in sync_all
    sync_for(“lib”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)

[end]



On Thursday, 7 March 2013 09:10:10 UTC+2, Anand Doshi wrote:
Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 





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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ObA3OWBHVFUJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ntgpiN8ecAcJ.

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

 

 

Hi

I am still getting the same error, so i’m stuck now, will have to try and rollback to an earlier version that worked.

Thanks

On Thursday, 7 March 2013 09:28:40 UTC+2, Joseph Siame wrote:

Hi

I tried the update more than once, but let me try again and I will let you know how it goes?



On Thursday, 7 March 2013 09:23:22 UTC+2, Anand Doshi wrote:
Hi Joseph,

Have you tried updating again?

Sometimes, the wnframework files are updated, but the update process still refer to the old files. Second update will refer to the new changes and should work out.

-Anand.

On 07-Mar-2013, at 12:49 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I always use the command:
lib/wnf.py --update origin master

After running the update thats when the error comes up, and then i fail to log in.

let me post line by line so you have a better idea:

[start]

From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Updating 441c1dd…25e4a93
Fast-forward
 core/page/data_import_tool/data_import_tool.py |    4 +±-
 1 files changed, 2 insertions(+), 2 deletions(-)
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.

/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module mysql was already imported from /usr/lib/pymodules/python2.6/mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 405, in run
    update_erpnext(options.update[0], options.update[1])
  File “lib/wnf.py”, line 77, in update_erpnext
    patch_sync_build()
  File “lib/wnf.py”, line 80, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 91, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 12, in sync_all
    sync_for(“lib”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)

[end]



On Thursday, 7 March 2013 09:10:10 UTC+2, Anand Doshi wrote:
Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 





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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ObA3OWBHVFUJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/oWHSleFgJiwJ.

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

 

 

Hi Joseph,

We have written a patch which should solve this issue.

Please update again.

Thanks,
Anand.

On 07-Mar-2013, at 1:05 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I am still getting the same error, so i'm stuck now, will have to try and rollback to an earlier version that worked.

Thanks

On Thursday, 7 March 2013 09:28:40 UTC+2, Joseph Siame wrote:
Hi

I tried the update more than once, but let me try again and I will let you know how it goes?



On Thursday, 7 March 2013 09:23:22 UTC+2, Anand Doshi wrote:
Hi Joseph,

Have you tried updating again?

Sometimes, the wnframework files are updated, but the update process still refer to the old files. Second update will refer to the new changes and should work out.

-Anand.

On 07-Mar-2013, at 12:49 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I always use the command:
lib/wnf.py --update origin master

After running the update thats when the error comes up, and then i fail to log in.

let me post line by line so you have a better idea:

[start]

From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Updating 441c1dd..25e4a93
Fast-forward
 core/page/data_import_tool/data_import_tool.py |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.

/usr/local/lib/python2.6/dist-packages/pytz/__init__.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Traceback (most recent call last):
  File "lib/wnf.py", line 494, in <module>
    run()
  File "lib/wnf.py", line 405, in run
    update_erpnext(options.update[0], options.update[1])
  File "lib/wnf.py", line 77, in update_erpnext
    patch_sync_build()
  File "lib/wnf.py", line 80, in patch_sync_build
    patch_sync()
  File "lib/wnf.py", line 91, in patch_sync
    sync_all()
  File "lib/wnf.py", line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 12, in sync_all
    sync_for("lib", force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 18, in sync_for
    folder), force, sync_everything)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File "/var/www/erpnext/lib/webnotes/modules/__init__.py", line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 35, in import_files
    return import_file(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 45, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 63, in import_file_by_path
    import_doclist(doclist)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 110, in import_doclist
    new_bean.insert()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 268, in insert
    return self.save()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 279, in save
    self.save_main()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 426, in save
    keep_timestamps=keep_timestamps)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 380, in _update_values
    (self.doctype, ', '.join(update_str), "%s"), values)
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")

[end]



On Thursday, 7 March 2013 09:10:10 UTC+2, Anand Doshi wrote:
Hi Joseph,

Did you use this command:
lib/wnf.py --update origin master

or did you just pull the git updates and start using the app?

When and where are you getting this error?

-Anand.

On 07-Mar-2013, at 12:38 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I have been trying to update ERPnext but i keep getting this error.

File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")


What do you think could be the problem. Please let me know how i can pass this error because i ma failing to update.

Thanks




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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/czJsVdJNI_UJ.

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

 

 





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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ObA3OWBHVFUJ.

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

 

 





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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/oWHSleFgJiwJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi’

This is the new error i am getting, plus its not updating at all.

[start]

ro…@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Updating 704d5f0…b96fef9
error: Untracked working tree file ‘hr/report/init.py’ would be overwritten by merge.  Aborting

/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
setup | doctype | sales_person
setup | doctype | sales_partner
Traceback (most recent call last):
  File “lib/wnf.py”, line 493, in <module>
    run()
  File “lib/wnf.py”, line 404, in run
    update_erpnext(options.update[0], options.update[1])
  File “lib/wnf.py”, line 77, in update_erpnext
    patch_sync_build()
  File “lib/wnf.py”, line 80, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 91, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 13, in sync_all
    sync_for(“app”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 415, in save
    make_autoname, keep_timestamps = keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 276, in _insert
    self._set_name(autoname, istable)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 218, in _set_name
    n = self.fields[autoname[6:]]
KeyError: u’report_name’
[end]




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/h3-NIj5c-lsJ.

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

 

 

On 07-Mar-2013, at 4:11 PM, Joseph Siame <th...@gmail.com> wrote:

error: Untracked working tree file 'hr/report/__init__.py' would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use "git status" in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven't made any changes, you can run "git stash" in app and lib folders to remove all the code changes which might've happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi

Ok so, i installed a fresh copy of ERPNEXT and without making any changes i tried updating and kept getting this error. what could th elikely cause be.

[start]

ro…@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Executing execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07 in erpnext
Traceback (innermost last):
  File “/var/www/erpnext/lib/webnotes/modules/patch_handler.py”, line 72, in execute_patch
    exec patchmodule.split(“execute:”)[1] in globals()
  File “<string>”, line 1, in <module>
  File “/var/www/erpnext/lib/webnotes/init.py”, line 328, in reload_doc
    return webnotes.modules.reload_doc(module, dt, dn)
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 280, in save
    self.save_children()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 246, in save_children
    d.save(check_links=False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
 OperationalError: (1054, “Unknown column ‘in_list_view’ in ‘field list’”)

execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07: failed: STOPPED
Building js and css files…
Wrote public/js/report-legacy.min.js - 43k
Wrote public/css/all-web.css - 150k
Wrote public/css/all-app.css - 196k
Wrote public/js/all-web.min.js - 28k
Wrote public/js/all-app.min.js - 535k
Wrote public/js/slickgrid.min.js - 98k
ro…@erpserver:/var/www/erpnext#

[end]

Thanks

On Thursday, 7 March 2013 12:52:58 UTC+2, Anand Doshi wrote:

On 07-Mar-2013, at 4:11 PM, Joseph Siame <th…@gmail.com> wrote:

error: Untracked working tree file ‘hr/report/init.py’ would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use “git status” in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven’t made any changes, you can run “git stash” in app and lib folders to remove all the code changes which might’ve happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/APy6iX5AKnsJ.

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

 

 

Hi Joseph,

Please update now. I've removed that patch.

Thanks,
Anand.

On 07-Mar-2013, at 8:36 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

Ok so, i installed a fresh copy of ERPNEXT and without making any changes i tried updating and kept getting this error. what could th elikely cause be.

[start]

ro...@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
/usr/local/lib/python2.6/dist-packages/pytz/__init__.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Executing execute:webnotes.reload_doc('core', 'doctype', 'report') # 2013-03-07 in erpnext
Traceback (innermost last):
  File "/var/www/erpnext/lib/webnotes/modules/patch_handler.py", line 72, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/var/www/erpnext/lib/webnotes/__init__.py", line 328, in reload_doc
    return webnotes.modules.reload_doc(module, dt, dn)
  File "/var/www/erpnext/lib/webnotes/modules/__init__.py", line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 35, in import_files
    return import_file(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 45, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 63, in import_file_by_path
    import_doclist(doclist)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 110, in import_doclist
    new_bean.insert()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 268, in insert
    return self.save()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 280, in save
    self.save_children()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 246, in save_children
    d.save(check_links=False, ignore_fields = self.ignore_fields)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 426, in save
    keep_timestamps=keep_timestamps)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 380, in _update_values
    (self.doctype, ', '.join(update_str), "%s"), values)
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
 OperationalError: (1054, "Unknown column 'in_list_view' in 'field list'")

execute:webnotes.reload_doc('core', 'doctype', 'report') # 2013-03-07: failed: STOPPED
Building js and css files...
Wrote public/js/report-legacy.min.js - 43k
Wrote public/css/all-web.css - 150k
Wrote public/css/all-app.css - 196k
Wrote public/js/all-web.min.js - 28k
Wrote public/js/all-app.min.js - 535k
Wrote public/js/slickgrid.min.js - 98k
ro...@erpserver:/var/www/erpnext#

[end]

Thanks

On Thursday, 7 March 2013 12:52:58 UTC+2, Anand Doshi wrote:
On 07-Mar-2013, at 4:11 PM, Joseph Siame <th...@gmail.com> wrote:

error: Untracked working tree file 'hr/report/__init__.py' would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use "git status" in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven't made any changes, you can run "git stash" in app and lib folders to remove all the code changes which might've happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/APy6iX5AKnsJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi,
I’ve tried to update using  lib/wnf.py --update origin master and got same error:
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 408, in run
    patch_sync_build()
  File “lib/wnf.py”, line 81, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 92, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 12, in sync_all
    sync_for(“lib”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)

Pls advise,
Ferenc


Dana četvrtak, 7. ožujka 2013. 16:54:14 UTC+1, korisnik Anand Doshi napisao je:

Hi Joseph,

Please update now. I’ve removed that patch.

Thanks,
Anand.

On 07-Mar-2013, at 8:36 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

Ok so, i installed a fresh copy of ERPNEXT and without making any changes i tried updating and kept getting this error. what could th elikely cause be.

[start]

ro…@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module mysql was already imported from /usr/lib/pymodules/python2.6/mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Executing execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07 in erpnext
Traceback (innermost last):
  File "/var/www/erpnext/lib/webnotes/modules/patchhandler.py", line 72, in execute_patch
    exec patchmodule.split(“execute:”)[1] in globals()
  File “<string>”, line 1, in <module>
  File “/var/www/erpnext/lib/webnotes/init.py”, line 328, in reload_doc
    return webnotes.modules.reload_doc(module, dt, dn)
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 280, in save
    self.save_children()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 246, in save_children
    d.save(check_links=False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keeptimestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
 OperationalError: (1054, “Unknown column ‘in_list_view’ in ‘field list’”)

execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07: failed: STOPPED
Building js and css files…
Wrote public/js/report-legacy.min.js - 43k
Wrote public/css/all-web.css - 150k
Wrote public/css/all-app.css - 196k
Wrote public/js/all-web.min.js - 28k
Wrote public/js/all-app.min.js - 535k
Wrote public/js/slickgrid.min.js - 98k
ro…@erpserver:/var/www/erpnext#

[end]

Thanks

On Thursday, 7 March 2013 12:52:58 UTC+2, Anand Doshi wrote:
On 07-Mar-2013, at 4:11 PM, Joseph Siame <th…@gmail.com> wrote:

error: Untracked working tree file ‘hr/report/init.py’ would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use “git status” in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven’t made any changes, you can run “git stash” in app and lib folders to remove all the code changes which might’ve happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/APy6iX5AKnsJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/pBjr0lb535QJ.

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

 

 

Hi Ferenc,

I was unable to replicate the problem. We have added a patch that might fix the issue. Can you try updating again.

Thanks,
Anand.

On 08-Mar-2013, at 1:53 PM, Ferenc <fe...@gmail.com> wrote:

Hi,
I've tried to update using  lib/wnf.py --update origin master and got same error:
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
Traceback (most recent call last):
  File "lib/wnf.py", line 494, in <module>
    run()
  File "lib/wnf.py", line 408, in run
    patch_sync_build()
  File "lib/wnf.py", line 81, in patch_sync_build
    patch_sync()
  File "lib/wnf.py", line 92, in patch_sync
    sync_all()
  File "lib/wnf.py", line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 12, in sync_all
    sync_for("lib", force)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 18, in sync_for
    folder), force, sync_everything)
  File "/var/www/erpnext/lib/webnotes/model/sync.py", line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File "/var/www/erpnext/lib/webnotes/modules/__init__.py", line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 35, in import_files
    return import_file(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 45, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 63, in import_file_by_path
    import_doclist(doclist)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 110, in import_doclist
    new_bean.insert()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 268, in insert
    return self.save()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 279, in save
    self.save_main()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 426, in save
    keep_timestamps=keep_timestamps)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 380, in _update_values
    (self.doctype, ', '.join(update_str), "%s"), values)
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
_mysql_exceptions.OperationalError: (1054, "Unknown column 'report_type' in 'field list'")

Pls advise,
Ferenc


Dana četvrtak, 7. ožujka 2013. 16:54:14 UTC+1, korisnik Anand Doshi napisao je:
Hi Joseph,

Please update now. I've removed that patch.

Thanks,
Anand.

On 07-Mar-2013, at 8:36 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

Ok so, i installed a fresh copy of ERPNEXT and without making any changes i tried updating and kept getting this error. what could th elikely cause be.

[start]

ro...@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
/usr/local/lib/python2.6/dist-packages/pytz/__init__.py:35: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Executing execute:webnotes.reload_doc('core', 'doctype', 'report') # 2013-03-07 in erpnext
Traceback (innermost last):
  File "/var/www/erpnext/lib/webnotes/modules/patch_handler.py", line 72, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/var/www/erpnext/lib/webnotes/__init__.py", line 328, in reload_doc
    return webnotes.modules.reload_doc(module, dt, dn)
  File "/var/www/erpnext/lib/webnotes/modules/__init__.py", line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 35, in import_files
    return import_file(module, dt, dn, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 45, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 63, in import_file_by_path
    import_doclist(doclist)
  File "/var/www/erpnext/lib/webnotes/modules/import_file.py", line 110, in import_doclist
    new_bean.insert()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 268, in insert
    return self.save()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 280, in save
    self.save_children()
  File "/var/www/erpnext/lib/webnotes/model/bean.py", line 246, in save_children
    d.save(check_links=False, ignore_fields = self.ignore_fields)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 426, in save
    keep_timestamps=keep_timestamps)
  File "/var/www/erpnext/lib/webnotes/model/doc.py", line 380, in _update_values
    (self.doctype, ', '.join(update_str), "%s"), values)
  File "/var/www/erpnext/lib/webnotes/db.py", line 115, in sql
    raise e
 OperationalError: (1054, "Unknown column 'in_list_view' in 'field list'")

execute:webnotes.reload_doc('core', 'doctype', 'report') # 2013-03-07: failed: STOPPED
Building js and css files...
Wrote public/js/report-legacy.min.js - 43k
Wrote public/css/all-web.css - 150k
Wrote public/css/all-app.css - 196k
Wrote public/js/all-web.min.js - 28k
Wrote public/js/all-app.min.js - 535k
Wrote public/js/slickgrid.min.js - 98k
ro...@erpserver:/var/www/erpnext#

[end]

Thanks

On Thursday, 7 March 2013 12:52:58 UTC+2, Anand Doshi wrote:
On 07-Mar-2013, at 4:11 PM, Joseph Siame <th...@gmail.com> wrote:

error: Untracked working tree file 'hr/report/__init__.py' would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use "git status" in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven't made any changes, you can run "git stash" in app and lib folders to remove all the code changes which might've happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/APy6iX5AKnsJ.

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

 

 





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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/pBjr0lb535QJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

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

 

 

Hi Anand, 

after re-installing, update goes fine.

Thanks,
Ferenc

Dana petak, 8. ožujka 2013. 10:02:26 UTC+1, korisnik Anand Doshi napisao je:
Hi Ferenc,

I was unable to replicate the problem. We have added a patch that might fix the issue. Can you try updating again.

Thanks,
Anand.

On 08-Mar-2013, at 1:53 PM, Ferenc <fe…@gmail.com> wrote:

Hi,
I’ve tried to update using  lib/wnf.py --update origin master and got same error:
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
Traceback (most recent call last):
  File “lib/wnf.py”, line 494, in <module>
    run()
  File “lib/wnf.py”, line 408, in run
    patch_sync_build()
  File “lib/wnf.py”, line 81, in patch_sync_build
    patch_sync()
  File “lib/wnf.py”, line 92, in patch_sync
    sync_all()
  File “lib/wnf.py”, line 73, in sync_all
    webnotes.model.sync.sync_all(force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 12, in sync_all
    sync_for(“lib”, force)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 18, in sync_for
    folder), force, sync_everything)
  File “/var/www/erpnext/lib/webnotes/model/sync.py”, line 39, in walk_and_sync
    if reload_doc(module_name, doctype, name, force):
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 279, in save
    self.save_main()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 229, in save_main
    self.doc.save(check_links = False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keep_timestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
mysql_exceptions.OperationalError: (1054, “Unknown column ‘report_type’ in ‘field list’”)

Pls advise,
Ferenc


Dana četvrtak, 7. ožujka 2013. 16:54:14 UTC+1, korisnik Anand Doshi napisao je:
Hi Joseph,

Please update now. I’ve removed that patch.

Thanks,
Anand.

On 07-Mar-2013, at 8:36 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

Ok so, i installed a fresh copy of ERPNEXT and without making any changes i tried updating and kept getting this error. what could th elikely cause be.

[start]

ro…@erpserver:/var/www/erpnext# lib/wnf.py --update origin master
From git://github.com/webnotes/wnframework
 * branch            master     -> FETCH_HEAD
Already up-to-date.
From git://github.com/webnotes/erpnext
 * branch            master     -> FETCH_HEAD
Already up-to-date.
/usr/local/lib/python2.6/dist-packages/pytz/init.py:35: UserWarning: Module mysql was already imported from /usr/lib/pymodules/python2.6/mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
  from pkg_resources import resource_stream
Executing execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07 in erpnext
Traceback (innermost last):
  File "/var/www/erpnext/lib/webnotes/modules/patchhandler.py", line 72, in execute_patch
    exec patchmodule.split(“execute:”)[1] in globals()
  File “<string>”, line 1, in <module>
  File “/var/www/erpnext/lib/webnotes/init.py”, line 328, in reload_doc
    return webnotes.modules.reload_doc(module, dt, dn)
  File “/var/www/erpnext/lib/webnotes/modules/init.py”, line 73, in reload_doc
    return import_files(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 35, in import_files
    return import_file(module, dt, dn, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 45, in import_file
    ret = import_file_by_path(path, force)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 63, in import_file_by_path
    import_doclist(doclist)
  File “/var/www/erpnext/lib/webnotes/modules/import_file.py”, line 110, in import_doclist
    new_bean.insert()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 268, in insert
    return self.save()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 280, in save
    self.save_children()
  File “/var/www/erpnext/lib/webnotes/model/bean.py”, line 246, in save_children
    d.save(check_links=False, ignore_fields = self.ignore_fields)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 426, in save
    keep_timestamps=keeptimestamps)
  File “/var/www/erpnext/lib/webnotes/model/doc.py”, line 380, in _update_values
    (self.doctype, ', '.join(update_str), “%s”), values)
  File “/var/www/erpnext/lib/webnotes/db.py”, line 115, in sql
    raise e
 OperationalError: (1054, “Unknown column ‘in_list_view’ in ‘field list’”)

execute:webnotes.reload_doc(‘core’, ‘doctype’, ‘report’) # 2013-03-07: failed: STOPPED
Building js and css files…
Wrote public/js/report-legacy.min.js - 43k
Wrote public/css/all-web.css - 150k
Wrote public/css/all-app.css - 196k
Wrote public/js/all-web.min.js - 28k
Wrote public/js/all-app.min.js - 535k
Wrote public/js/slickgrid.min.js - 98k
ro…@erpserver:/var/www/erpnext#

[end]

Thanks

On Thursday, 7 March 2013 12:52:58 UTC+2, Anand Doshi wrote:
On 07-Mar-2013, at 4:11 PM, Joseph Siame <th…@gmail.com> wrote:

error: Untracked working tree file ‘hr/report/init.py’ would be overwritten by merge.  Aborting

This error has caused the pulling of latest changes to abort. It seems that you might have written some code and these changes are uncommitted. Hence, it is not pulling the latest files and consequently, you cannot proceed.

Either commit or remove the changes.

You can use “git status” in app and lib folder to check for changes.
You will need to either commit or stash those changes.

If you haven’t made any changes, you can run “git stash” in app and lib folders to remove all the code changes which might’ve happened by mistake.

Then try updating.

Thanks,
Anand.



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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/APy6iX5AKnsJ.

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

 

 





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 post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/pBjr0lb535QJ.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/-yoXPwQBBp0J.

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