OK - I was misunderstanding the instruction to delete the files under the database folder.
I'm sure that will move me on. Many thanks. On Oct 17, 5:44 pm, billf <[EMAIL PROTECTED]> wrote: > I believe that the metadata is available for most if not all db > engines but they don't all follow the INFORMATION_SCHEMA standard so I > don't blame anyone for side-stepping this issue. > > However, I have a ....newsitem.table in my databases folder so why > isn't web2py using that? > > On Oct 17, 5:14 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > web2py cannot query the data the database for the table structures. > > Hence it can do migrations if and only if web2py created the tables in > > the first place. In this case it maintains a local representation of > > the table structure in the .table files. > > > You cannot do a migration on a table that was pre-existing > > (migrate=False) > > > Massimo > > > On Oct 17, 10:33 am, "Phyo Arkar" <[EMAIL PROTECTED]> wrote: > > > > This usually happens to me too (only on MySQL, ok with SQLlite) > > > > If that happens what i have to do is Delete all database files under > > > Databases folder and Drop the table. > > > > And retry again.. > > > > How to make it work under web2py? > > > > On Fri, Oct 17, 2008 at 3:25 PM, yarko <[EMAIL PROTECTED]> wrote: > > > > > what does your sql.log show? > > > > > On Oct 17, 10:08 am, billf <[EMAIL PROTECTED]> wrote: > > > > > I'm a bit confused re migrate. > > > > > > I thought that if changes had been made to a table in the model and > > > > > migrate=True, whether specific or by default, then web2py would > > > > > magically alter the table. And I could have sworn that this is what > > > > > had happened when I made some changes in the past(?) > > > > > > However, having just made a change, I get an ticket because the table > > > > > already exists! BTW this is MySQL. > > > > > > So for web2py to change the table I have to delete it first? Is that > > > > > correct? > > > > > > Bill --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
