No. You never need to remove code. You need to erase the content of web2py/applications/<yourapp>/databases/*
On Monday, 3 November 2014 09:36:25 UTC-6, Ramashish Gaurav wrote: > > Thanks for addressing this issue. > > Actually this is the second time I am coding this reddit clone app and > this time I got stuck at the same point again. Do you mean I need to remove > all the code in db1.py and re write the code from beginning? > > On Monday, November 3, 2014 6:41:09 PM UTC+5:30, Massimo Di Pierro wrote: >> >> please deleted everything in databases/* something got corrupted and >> tries to redefined a column that exists. >> >> On Saturday, 1 November 2014 15:07:23 UTC-5, Ramashish Gaurav wrote: >>> >>> Hi all, >>> >>> I am following the second video tutorial for learning web2py by Mr. >>> Massimo, where he teaches to make clone of reddit. But I am stuck at this >>> error. Please help me debug it. >>> >>> Following is the error and my database model: >>> >>> Traceback >>> >>> 1. >>> 2. >>> 3. >>> 4. >>> 5. >>> 6. >>> 7. >>> 8. >>> 9. >>> 10. >>> 11. >>> 12. >>> >>> Traceback (most recent call last): >>> File "gluon/restricted.py", line 224, in restricted >>> File "C:/Users/Ramashish >>> Gaurav/Downloads/web2py_win/web2py/applications/reddit_clone/models/db1.py" >>> <http://127.0.0.1:8000/admin/default/edit/reddit_clone/models/db1.py>, line >>> 23, in <module> >>> auth.signature) >>> File "gluon/dal.py", line 8414, in define_table >>> File "gluon/dal.py", line 8450, in lazy_define_table >>> File "gluon/dal.py", line 1134, in create_table >>> File "gluon/dal.py", line 1246, in migrate_table >>> File "gluon/dal.py", line 1967, in execute >>> File "gluon/dal.py", line 1961, in log_execute >>> OperationalError: duplicate column name: parent_comm >>> >>> >>> >>> 1. >>> 2. >>> 3. >>> 4. >>> 5. >>> 6. >>> 7. >>> 8. >>> 9. >>> 10. >>> 11. >>> 12. >>> 13. >>> 14. >>> 15. >>> 16. >>> 17. >>> 18. >>> 19. >>> 20. >>> 21. >>> 22. >>> 23. >>> 24. >>> 25. >>> 26. >>> 27. >>> 28. >>> 29. >>> 30. >>> 31. >>> 32. >>> 33. >>> 34. >>> 35. >>> 36. >>> 37. >>> 38. >>> 39. >>> 40. >>> 41. >>> >>> # -*- coding: utf-8 -*- >>> db.define_table('category', >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('name', >>> requires=(IS_SLUG >>> <http://127.0.0.1:8000/examples/global/vars/IS_SLUG>(),IS_LOWER >>> <http://127.0.0.1:8000/examples/global/vars/IS_LOWER>(), IS_NOT_IN_DB >>> <http://127.0.0.1:8000/examples/global/vars/IS_NOT_IN_DB>(db,'category.name')))) >>> >>> db.define_table('post', >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('category', 'reference >>> category',writable=False, readable=False), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('title', >>> 'string',requires=IS_NOT_EMPTY >>> <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>()), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('url', >>> requires=IS_EMPTY_OR >>> <http://127.0.0.1:8000/examples/global/vars/IS_EMPTY_OR>(IS_URL >>> <http://127.0.0.1:8000/examples/global/vars/IS_URL>())), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('body','text',requires=IS_NOT_EMPTY >>> <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>()), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('votes', >>> 'integer',default=0,readable=False, writable=False), >>> auth.signature) >>> >>> db.define_table('vote', >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('post', 'reference >>> post'), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('score', 'integer', >>> default = +1), >>> auth.signature) >>> >>> db.define_table('comm', >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('post', 'reference >>> post'), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('parent_comm', >>> 'reference comm'), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('votes','integer'), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('body','text'), >>> auth.signature) >>> >>> db.define_table('comm_vote', >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('comm', 'reference >>> comm'), >>> Field >>> <http://127.0.0.1:8000/examples/global/vars/Field>('score', 'integer', >>> default=+1), >>> auth.signature) >>> >>> >>> from gluon.contrib.populate import populate >>> if db(db.auth_user).count()<2: >>> populate(db.auth_user,100) >>> db.commit() >>> if db(db.post).count()<2: >>> populate(db.post,500) >>> db.commit() >>> if db(db.comm).count()<2: >>> populate(db.comm,1000) >>> db.commit() >>> >>> >>> >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
