When you delete (drop) tables you also have to delete the .table files in the databases folder. Did you do that? I think you are using two threads for the same problem.
Massimo On Oct 17, 11:18 am, billf <[EMAIL PROTECTED]> wrote: > Ok did the following: > 1) delete all tables > 2) select 'data administration': get ticket > File "/usr/local/web2py/gluon/sql.py", line 500, in define_table > raise e > ProgrammingError: (1146, "Table 'onestepbeyond.newsitem' doesn't > exist") > 3) sql.log contains: > timestamp: 2008-10-17T17:13:59.772235 > ALTER TABLE newsitem ADD author_id__tmp INT; > UPDATE newsitem SET author_id__tmp=author_id; > ALTER TABLE newsitem DROP COLUMN author_id; > ALTER TABLE newsitem ADD author_id INT; > UPDATE newsitem SET author_id=author_id__tmp; > ALTER TABLE newsitem DROP COLUMN author_id__tmp; > > S'not good is it? > > On Oct 17, 4: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 -~----------~----~----~----~------~----~------~--~---
