Re: Database management commands

2011-10-28 Thread Ian Clelland
On Fri, Oct 28, 2011 at 2:35 AM, Daniele Procida wrote: > COuld it still be the case that the issue is the result of the older Django > database having used one engine by default, and the new one the other? > > That is possible -- in a MySQL shell, run "SHOW TABLE STATUS", and

Re: Database management commands

2011-10-28 Thread Daniele Procida
On Fri, Oct 28, 2011, Russell Keith-Magee wrote: >On Fri, Oct 28, 2011 at 12:49 AM, Leonardo Giordani > wrote: >> This is a problem related to Innodb and MyISAM. Django uses this >> latter, > >Incorrect. Django doesn't have any built in

Re: Database management commands

2011-10-28 Thread Leonardo Giordani
You are right, thanks. 2011/10/28 Russell Keith-Magee : > On Fri, Oct 28, 2011 at 12:49 AM, Leonardo Giordani > wrote: >> This is a problem related to Innodb and MyISAM. Django uses this >> latter, > > Incorrect. Django doesn't have any built

Re: Database management commands

2011-10-27 Thread Russell Keith-Magee
On Fri, Oct 28, 2011 at 12:49 AM, Leonardo Giordani wrote: > This is a problem related to Innodb and MyISAM. Django uses this > latter, Incorrect. Django doesn't have any built in preference for InnoDB or MyISAM -- it uses the system default table type. On most

Re: Database management commands

2011-10-27 Thread Leonardo Giordani
ql-51b_4a8' (errno: 150)") > > when running database management commands (syncdb, south migrate). > > Sometimes those commands work, sometimes they don't; it happens across a > variety of apps. > > I am working on a database that was exported from one system and has been &g

Re: Database management commands

2011-10-27 Thread Daniele Procida
estra_medic_dev.#sql-51b_4a8' (errno: 150)") >> >> when running database management commands (syncdb, south migrate). >errno 150 indicates that you tried to create an innodb table with an >incorrectly formed foreign key constraint. > >http://dev.mysql.com/doc/refman/

Re: Database management commands

2011-10-27 Thread Tom Evans
On Thu, Oct 27, 2011 at 12:33 PM, Daniele Procida <dani...@vurt.org> wrote: > I keep getting errors like this: > > _mysql_exceptions.OperationalError: (1005, "Can't create table > 'arkestra_medic_dev.#sql-51b_4a8' (errno: 150)") > > when running database manageme

Database management commands

2011-10-27 Thread Daniele Procida
I keep getting errors like this: _mysql_exceptions.OperationalError: (1005, "Can't create table 'arkestra_medic_dev.#sql-51b_4a8' (errno: 150)") when running database management commands (syncdb, south migrate). Sometimes those commands work, sometimes they don't; it happens across