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
-~----------~----~----~----~------~----~------~--~---
