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 you can see the eng

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 preference for InnoDB or >MyISAM -- it uses the system defau

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 in preference for InnoDB or > MyISAM -- it uses the sy

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 systems, MyISAM is the default, but

Re: Database management commands

2011-10-27 Thread Leonardo Giordani
(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 >

Re: Database management commands

2011-10-27 Thread Daniele Procida
On Thu, Oct 27, 2011, Tom Evans wrote: >On Thu, Oct 27, 2011 at 12:33 PM, Daniele Procida wrote: >> I keep getting errors like this: >> >> _mysql_exceptions.OperationalError: (1005, "Can't create table >'arkestra_medic_dev.#sql-51b_4a8' (errno: 1

Re: Database management commands

2011-10-27 Thread Tom Evans
On Thu, Oct 27, 2011 at 12:33 PM, Daniele Procida 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 management comm

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