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 [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
-~----------~----~----~----~------~----~------~--~---
