Update error

[Joseph Siame]

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

[Anand Doshi]

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.

--
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...@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.
 
 

[Joseph Siame]

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 <thatdu...@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+unsub...@googlegroups.com.

[Anand Doshi]

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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@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.

[Joseph Siame]

Hi

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

[Joseph Siame]

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

[Anand Doshi]

Hi Joseph,

We have written a patch which should solve this issue.

Please update again.

Thanks,

Anand.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@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/-/oWHSleFgJiwJ.

[Joseph Siame]

Hi'

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

[start]

root@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]

[Anand Doshi]

On 07-Mar-2013, at 4:11 PM, Joseph Siame <thatdu...@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.

[Joseph Siame]

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]

root@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
root@erpserver:/var/www/erpnext#

[end]

Thanks

[Anand Doshi]

Hi Joseph,

Please update now. I've removed that patch.

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...@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.

[Ferenc]

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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

[Anand Doshi]

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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@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.

[Ferenc]

Hi Anand, 

after re-installing, update goes fine.

Thanks,

Ferenc