It's an auth db with the student db - like in the book. I register -> put some data in auth_user <- then I log in and put some data in to the student fields and click submit and this error pops up as ticket.
I'm using an sqlite3 db on os x... I've even dropped the tables several times and retried - guess i'll need to poke in the crud.create with wingide to see what's up. -wes On Wed, Nov 18, 2009 at 3:55 PM, Thadeus Burgess <[email protected]> wrote: > It means you have a field that is expecting an integer, and the actual data > in the database is either Null or has characters in the string, more often > than not, it means this data is null. > > Try IS_NULL_OR(IS_IN_DB) as a solution? > > -Thadeus > > > > > On Wed, Nov 18, 2009 at 4:48 PM, Wes James <[email protected]> wrote: >> >> What does this mean: >> >> form=crud.create(db.student,next=URL(r=request)) >> File "/opt/cnrsa/gluon/tools.py", line 2101, in create >> deletable=False, >> File "/opt/cnrsa/gluon/tools.py", line 2048, in update >> keepvalues=self.settings.keepvalues): >> File "/opt/cnrsa/gluon/sqlhtml.py", line 865, in accepts >> fields[fieldname] = int(fields[fieldname]) >> ValueError: invalid literal for int() with base 10: '' >> >> I get it with this: >> >> SQLField("sid",db.auth_user, default=user_id), >> >> but not with this: >> >> SQLField("sid",default=user_id), >> >> >> -wes >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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 -~----------~----~----~----~------~----~------~--~---
