I'm trying to updateall for coloursets. When I read the data into the form, the table is added, but when I try to write back to it, the table isn't joined.
Warning (512): SQL Error: 1054: Unknown column 'Fanpage.Colourset' in 'field list' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query:
UPDATE `fanpages` AS `Fanpage`
LEFT JOIN `users` AS `User` ON (`Fanpage`.`user_id` = `User`.`id`)
LEFT JOIN `accounts` AS `Account` ON (`Fanpage`.`account_id` = `Account`.`id`)
SET `Fanpage`.`Colourset` = Array, `Fanpage`.`Fanpage` = Array
WHERE 1 = 1
code for models, controllers, tables etc here: http://bin.cakephp.org/view/1132666511
When I had used SaveAll(), the records were added to the colourset table, but when I try updateAll(), the colourset table doesn't seem to be available.
(sorry for the messy code - I'm new :) )
Any help is appreciated - I've been googling for 2 days and I can't figure out what the problem is. I've tried changing the relationship etc.
that's not what updateAll is used for, use saveAll.