grigri, I tried this an got this SQL query:
SELECT Array, 1, COUNT(DISTINCT User.id) AS count, `User`., `User`.`id` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `genders` AS `Gender` ON (`User`.`gender_id` = `Gender`.`id`) LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `gender_prefferences_users` AS `GenderPrefferenceUser` ON (`GenderPrefferenceUser`.`user_id` = `User`.`id`) WHERE count LIMIT 1 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `User`.`id` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`gr' at line 1 In addition the following notices were thrown: Notice (8): Undefined offset: 0 [CORE\cake\libs\model\datasources \dbo_source.php, line 1424] Notice (8): Undefined offset: 0 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 0 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 0 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 0 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Undefined offset: 1 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 1 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 1 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 1 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Undefined offset: 2 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 2 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 2 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 2 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Undefined offset: 3 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 3 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 3 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 3 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Undefined offset: 4 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 4 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 4 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 4 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Undefined offset: 5 [CORE\cake\libs\model\datasources \dbo_source.php, line 1426] Notice (8): Undefined offset: 5 [CORE\cake\libs\model\datasources \dbo_source.php, line 1429] Notice (8): Undefined offset: 5 [CORE\cake\libs\model\datasources \dbo_source.php, line 1433] Notice (8): Undefined offset: 5 [CORE\cake\libs\model\datasources \dbo_source.php, line 1436] Notice (8): Array to string conversion [CORE\cake\libs\model \datasources\dbo_source.php, line 1186] On 11 Фев, 12:33, grigri <[EMAIL PROTECTED]> wrote: > try implementing User::paginateCount and changing the query: > > class User extends AppModel { > function paginateCount($conditions, $recursive) { > return $this->find('count', array('conditions' => $conditions, > 'recursive' => $recursive, 'fields' => 'COUNT(DISTINCT User.id) AS > count')); > } > > } > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---