Thanks Dr. Massimo, I deleted the database, however had to made some extra entries before populating the database. And it worked!!
On Wednesday, November 5, 2014 12:53:22 AM UTC+5:30, Massimo Di Pierro wrote: > > 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.
