The problem still exists...
I found out that I can get around it when I first execute this query:
$temp = $this->Workshop->WorkshopDescription->find('all');
Looks like the find-method builds the joins correctly, so the
following delete-method works as expected. When I delete that line, I
still get the error. Looks like a bug...
Also I tried the following:
$temp = $this->Workshop->WorkshopDescription->find('count');
$temp = $this->Workshop->WorkshopDescription->find('all');
$temp = $this->Workshop->WorkshopDescription->find('count');
The results:
SELECT COUNT(*) AS `count` FROM `cosy_workshop_descriptions` AS
`WorkshopDescription` LEFT JOIN `description_categories` AS
`DescriptionCategory` ON
(`WorkshopDescription`.`description_category_id` =
`DescriptionCategory`.`id`) LEFT JOIN `cosy_workshops` AS `Workshop`
ON (`WorkshopDescription`.`workshop_id` = `Workshop`.`id`) WHERE 1 = 1
1146: Table 'cosynt.description_categories' doesn't exist
SELECT `WorkshopDescription`.`id`,
`WorkshopDescription`.`conference_id`,
`WorkshopDescription`.`workshop_id`,
`WorkshopDescription`.`description_category_id`,
`WorkshopDescription`.`text`, `WorkshopDescription`.`created`,
`WorkshopDescription`.`modified`, `DescriptionCategory`.`id`,
`DescriptionCategory`.`conference_id`, `DescriptionCategory`.`name`,
`DescriptionCategory`.`highlight_red`,
`DescriptionCategory`.`highlight_bold`,
`DescriptionCategory`.`highlight_italic`,
`DescriptionCategory`.`created`, `DescriptionCategory`.`modified`,
`Workshop`.`id`, `Workshop`.`conference_id`, `Workshop`.`number`,
`Workshop`.`title`, `Workshop`.`lecturer`, `Workshop`.`price`,
`Workshop`.`show_in_confirmation`, `Workshop`.`show_in_workshop_list`,
`Workshop`.`enables_discount`, `Workshop`.`created`,
`Workshop`.`modified` FROM `cosy_workshop_descriptions` AS
`WorkshopDescription` LEFT JOIN `cosy_description_categories` AS
`DescriptionCategory` ON
(`WorkshopDescription`.`description_category_id` =
`DescriptionCategory`.`id`) LEFT JOIN `cosy_workshops` AS `Workshop`
ON (`WorkshopDescription`.`workshop_id` = `Workshop`.`id`) WHERE 1 = 1
SELECT COUNT(*) AS `count` FROM `cosy_workshop_descriptions` AS
`WorkshopDescription` LEFT JOIN `cosy_description_categories` AS
`DescriptionCategory` ON
(`WorkshopDescription`.`description_category_id` =
`DescriptionCategory`.`id`) LEFT JOIN `cosy_workshops` AS `Workshop`
ON (`WorkshopDescription`.`workshop_id` = `Workshop`.`id`) WHERE 1 = 1
So: the problem also arises when doing find('count').
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
