yes and no.
on any dbs but sqlite web2py would have tried to port the data and
would have failed (because an int cannot contain a date, etc). Thus
you have been forded to drop the column and recreate it.
on SQLite this succeeds (storing an int in a date field or a date in
an int field) because SQLite does not check for column type when
inserting the data.
Massimo
On Jan 20, 11:46 am, "Sebastian E. Ovide" <sebastianov...@gmail.com>
wrote:
> yes, you are right. I did.... If I remember well I changed from datatime to
> integer... but I have to check at home... but... should not be web2py to fix
> it automagicaly ?
>
> On Tue, Jan 20, 2009 at 11:00 AM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > Somehow your data got corrupted. Did you change the type of a date/
> > datetime field from string after inserting data in it? One of your
> > date/datetime fields is not in the proper iso format yyyy-mm-dd.
>
> > If you did not do that, would you send me the content of you databases/
> > * and models/* folders? There is a possbility this is due to the
> > internationalization settings affecting the driver.
>
> > Massimo
>
> > On Jan 20, 5:50 am, "Sebastian E. Ovide" <sebastianov...@gmail.com>
> > wrote:
> > > the weird thing is that the error is thrown when I try to access
>
> > > *design -> database_administration -> db.position*
>
> > > (I have not change any web2py py file !)
>
> > > therefore I cannot access to the table !!!!
>
> > > it throws an error in *views/generic.html *(I have not touched it !)...
> > and
> > > exactly in the *BEAUTIFY*. So to narrow the error, I've comment out *
> > > BEAUTIFY* and discover that the error come from *records*... (records is
> > the
> > > result from a simple query copied from the cookbook)
>
> > > before it was working *perfectly*... then, after I've add an entity (with
> > > geo data) it broken out...
>
> > > tonight when I'll be at home I will try to discover which value inside
> > > records breaks the application...
>
> > > On Tue, Jan 20, 2009 at 2:10 AM, mdipierro <mdipie...@cs.depaul.edu>
> > wrote:
>
> > > > what is records? Can I see the action?
>
> > > > Anyway, try not to use response._vars since that is a private
> > > > variables.
> > > > {{=records}}
> > > > same errors?
>
> > > > Massimo
>
> > > > On Jan 19, 7:46 pm, "Sebastian E. Ovide" <sebastianov...@gmail.com>-
> > Hide quoted text -
>
> > > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
