it create tables fine now. I did not use value timestamp now so i don't know it is correct value or not. I looked at sqlite, datetime value is stored as integer. Of course i am not sure because of i am new to Python. :D
On Mar 10, 10:20 pm, mdipierro <[email protected]> wrote: > what is now? > > the default must be of the same type as the field. You cannot insert a > date into an integer > > On Mar 10, 9:59 am, NguyendHEX <[email protected]> wrote: > > > > > Yes, i just change datetime field into integer. It works file at GAE. > > > FROM => SQLField('timestamp', 'datetime', default=now), > > TO: SQLField('timestamp', 'integer', default=now) > > > But i don't know while it failed with datime field > > > On Mar 10, 9:45 pm, mdipierro <[email protected]> wrote: > > > > I think somewhere you have wrong default for a datetime field, for > > > example you are passing date field to a datetime field. > > > > On Mar 10, 4:58 am, NguyendHEX <[email protected]> wrote: > > > > > I see errors both at locally GAE and online GAE. I see there is not > > > > some tables that i defined in GAE datasource (via admin CP). > > > > > At logging screen and online logs at GAE admin place, i found > > > > > gluon/contrib/gql.py", line 492, in obj_represent > > > > (y, m, d) = [int(x) for x in str(obj)[:10].strip().split('-')] > > > > > It meets error when code insert new row into non exist table. > > > > > FYI: sometimes, i meet the same problem when viewing a table that has > > > > only one row via web2py admin app. > > > > > On Mar 10, 3:22 pm, Yarko Tymciurak <[email protected]> wrote: > > > > > > Are you testing first locally with Google AppEngine SDK? Is this > > > > > where you > > > > > are seeing the problem?http://code.google.com/appengine/downloads.html > > > > > > On Tue, Mar 10, 2009 at 1:43 AM, NguyendHEX <[email protected]> > > > > > wrote: > > > > > > > Thank Yarko, > > > > > > > I meet error only when uploading the app into Google App Engine. > > > > > > web2py is ok when it works by it self. > > > > > > > I am new to Google App Engine/web2py so i don't know how to execute > > > > > > web2py shell at google host. > > > > > > > On Mar 10, 1:27 pm, Yarko Tymciurak <[email protected]> wrote: > > > > > > > You can create the tables from the shell: > > > > > > > python web2py.py -S myapp -M > > > > > > > > This will load the models. It may give you error messages too. > > > > > > > > You can then try to define the tables - but note: the tables are > > > > > > > created > > > > > > if > > > > > > > they don't exist the first time - UNLESS there was an error in > > > > > > > the code > > > > > > > defining the table. > > > > > > > > For example, > > > > > > > > try this simple definition: > > > > > > > > db.define_table('test1', SQLField('name')) > > > > > > > > and then run the shell. From the shell, if you type db.test1, > > > > > > > you > > > > > > should > > > > > > > get a listing that starts with <SQLTable,{'ALL": > > > > > > > <gluon.sp.,SQLALL object > > > > > > at > > > > > > > ..... > > > > > > > > if you repeat, but make a mistake (put a leading space or two), > > > > > > > like > > > > > > this: > > > > > > > > db.define_table('test2', SQLField('name')) > > > > > > > > You will get no error, and no table. > > > > > > > > Check that you do not have an error first. Try to enter by hand > > > > > > > from the > > > > > > > web2py shell. > > > > > > > > Let us know how it goes. > > > > > > > > Yarko > > > > > > > > On Tue, Mar 10, 2009 at 12:36 AM, NguyendHEX > > > > > > > <[email protected]> > > > > > > wrote: > > > > > > > > > My db.py has 10 tables but the app did not create all table for > > > > > > > > me > > > > > > > > when i update into GAE (even local development of GAE). > > > > > > > > > Please tell me how to manual create missing tables. > > > > > > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
