I have a similar problem. Different table but same process/scenario.
The only additional data point I can add is that this only occurs if I
try to use the automagic UUID feature, that is if I specify the id
column as char(36) not null primary key. When I use int(11) not null
auto_increment primary key, it works as expected.
Roger
On Jan 14, 2:34 pm, JTTACJ1 <[EMAIL PROTECTED]> wrote:
> I'm getting ready to explore AJAX so I created what I thought was the
> most basic application possible. It is a task manager with one table
> consisting of two columns. Just to get things up and running quickly
> I created the model and a controller using scaffolding. When creating
> a new entry int the task table I get the error:
>
> Warning (512): SQL Error: 1110:Column'id'specifiedtwice[CORE\cake
> \libs\model\datasources\dbo_source.php, line 440]
>
> Checked trac and didn't find it listed. This makes me think I did
> something wrong even if the application to this point seems to simple
> to have any problems. Is this an unreported bug or something I am
> doing wrong?
>
> James
>
> CREATE TABLE `tasks` (
> `id` char(36) NOT NULL,
> `name` varchar(50) NOT NULL,
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>
> class Task extends AppModel {
>
> public $name = 'Task';
>
> }
>
> class TasksController extends AppController {
> public $scaffold;
>
> }
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
