Hi all,

Grahack asked me if I could take a look at GrooverWiki and see why he
was getting an error on start up, it's because the text fields are
blob and need to be text. In your db.py file delete it all and replace
with:

Here is a pastie of it http://paste.pocoo.org/show/90274/ that might
be dead after a while so I'll also paste below.

# try something like
import datetime
now=datetime.datetime.today()

db=SQLDB("sqlite://db.db")

db.define_table('category', SQLField('name'))

db.category.name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'category.name')]

db.define_table('WikiPage',
                SQLField('title'),
                SQLField('category', db.category),
                SQLField('text', 'text'),
                SQLField('author'),
                SQLField('created', 'datetime', default=now))

db.WikiPage.title.requires=IS_NOT_EMPTY()
db.WikiPage.category.requires=IS_IN_DB(db,'category.id','category.name')
db.WikiPage.text.requires=IS_NOT_EMPTY()
db.WikiPage.author.requires=IS_NOT_EMPTY()

db.define_table('Editor',
                SQLField('name'),
                SQLField('WikiPage', db.WikiPage),
                SQLField('modified', 'datetime', default=now))

db.Editor.name.requires=IS_NOT_EMPTY()
db.Editor.WikiPage.requires=IS_IN_DB(db, 'WikiPage.id')

db.define_table('comment',
                SQLField('user'),
                SQLField('WikiPage', db.WikiPage),
                SQLField('text', 'text'),
                SQLField('created', 'datetime', default=now))

db.comment.user.requires=IS_NOT_EMPTY()
db.comment.WikiPage.requires=IS_IN_DB(db,
'WikiPage.id','WikiPage.title')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to