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
-~----------~----~----~----~------~----~------~--~---
