On Tuesday, March 29, 2011 7:29:41 AM UTC-4, Omri wrote:
>
> I have found my problem - it was some stupid configuration problem.
> But I will still want to leave the question open - What is the best way to
> create a new 'clean' copy of the database file, resetting all the
> auto-increment fields?
>
If you're using SQLite, you could just delete the old database (and
migration files) from the 'databases' folder of your copied application (or
just don't copy that folder), and web2py will create a new SQLite database
for you. If using another database, you'd have to manually create a new
database, but then web2py will create all the tables for you (assuming you
haven't disabled migrations).
Anthony