Whoops this is the correct schema: CREATE TABLE Tasks( id INTEGER SIGNED AUTO_INCREMENT, name TEXT, notes TEXT, due_date_month INTEGER(2), due_date_day INTEGER(2), due_date_year INTEGER(4), status_id INTEGER NOT NULL REFERENCES Statuses(id), project_id INTEGER NOT NULL REFERENCES Projects(id), project_position INTEGER(5), PRIMARY KEY ('id') );
On Jan 14, 2008 11:36 PM, franklin <[EMAIL PROTECTED]> wrote: > Hey guys and gals. > > Just switched from 1.1.19 to 1.2.0 and I'm having a little trouble > with sqlite. > > Using the debugging tool I notice that when I submit a new entry into > my 'Tasks' table: > > CREATE TABLE Tasks( > id INTEGER SIGNED AUTO_INCREMENT, > name TEXT, > notes TEXT, > due_date TEXT, > status_id INTEGER NOT NULL REFERENCES Statuses(id), > project_id INTEGER NOT NULL REFERENCES Projects(id), > project_position INTEGER(5), > PRIMARY KEY ('id') > ); > > The following statement is generated: > > Query: INSERT INTO > "tasks" > ("id","name","notes","due_date_month","due_date_day","due_date_year","project_position") > VALUES ('','testt','ests','1','1','1','1') > > Warning (512): SQL Error: 20: datatype mismatch [CORE/cake/libs/model/ > datasources/dbo_source.php, line 440] > > Basicaly I get datatype mismatch errors because CakePHP fails to > either: > > auto_increment the primary_id > -or- > neglect to insert the 'id' and just let sql do the work > > is anyone else having problems with this? Is there anything I can do > besides amend the source code? Any opinions? > > Thanks in advance. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---