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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
