> I understand that Freetrade 2 is in development now, but I thought I'd
> take a look and see where it was headed. Recent changes to the DB
> schema include many indexes. However, MySQL seems to have a problem
> creating indexes on columns without the NOT NULL constraint. I can get
> the build script to work by setting each indexed column to NOT NULL,
> but that breaks Freetrade where it attempts to insert NULL values into
> those columns.
>
> Is there any other way to get the build script to work?
I'm running MySQL 3.23 on my dev box, so that may explain why it works for
me. The real solution is to add NOT NULL qualifiers to those columns. I
doubt any of those columns needs to accept NULL values.
Leon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
