I think most of those bugreports are related with the problem removing
foreign key relations in MySQL. If I remove a reference field in models
file I get a error stating that MySQL cannot remove the foreign key.
After that I usually backup the database, drop it, remove all files in
/databases/, create the database, reload the application and then
restore data from the backup. After that everything works except that
MySQL database and models file are not in sync.
I´ll have to study MySQL little bit to learn how to remove a foreign key.
Kenneth
I went through the treads. I cannot quite identify a bug. some of the
issues are most likely be related to web2py and db models being out of
sync. Are you using a legacy table? Do you have migrate=False?
On Jan 14, 2:41 pm, Kenneth Lundström<kenneth.t.lundst...@gmail.com>
wrote:
https://groups.google.com/group/web2py/browse_thread/thread/9e3e43b49...
I m not sure this is a
bug.https://groups.google.com/group/web2py/browse_thread/thread/2300767db...
https://groups.google.com/group/web2py/browse_thread/thread/226113dea...
https://groups.google.com/group/web2py/browse_thread/thread/6ea777cd6...
Here are those that was refering to. I ll use Google code if I get ticket.
Kenneth
Hi Kenneth,
I apologize. A couple of them I bookmarked and I am working ont them.
Yet I cannot find 3-4. Please open tickets on googlecode so I can keep
track of them more easily. Thanks for your help.
Massimo
On Jan 13, 2:24 am, Kenneth Lundstr m<kenneth.t.lundst...@gmail.com>
wrote:
Hello everybody,
for the past month I have sent maybe 3-4 bugreports to this list, but so
far only 1 of them have been answered. It feels a litte bit stupid to
send those reports without getting any responce. Am I sending them to
the wrong place or are they so simple that I should be able to solve
them myself?
Maybe a bug?
Should the underlying database and web2pys database model files be in
sync? In one applications I have a table defined to have 14 fields. But
if I look at att the table on database level it has 15 fields?
A question. What is the correct way to remove a foreign key
relationsship between two tables? If I in a model file define a field
like Field('group', db.group, required=true) and then remove it I get a
error telling that mysql could not remove the foreign key. So far I have
deleted the whole database and deleted all files in /databases/ so
web2py has created all tables again. It s not a problem on my
development system, but might become a problem on the production server.
Kenneth
