On Thursday, March 22, 2012 6:27:03 PM UTC-4, Derek wrote: > > Well, it appears to have been caused by me manually deleting the tables in > the database, hoping that web2py will recreate them. Apparently, web2py > does not know if the tables exist or not, and assumes that they do, since > it has a log that it created the tables in the first place. That's why I > get the error. It was assuming that my customers table was already created, > and that assumption was incorrect. >
Yes, web2py stores metadata about the tables in the *.table files in the /databases folder of the application. You can use web2py to drop the table via db.mytable.drop(). If you delete the table manually, you might just be able to delete the associated *.table from the /databases folder to get web2py to re-create it (I'm not sure about that, though). Anthony
