bump... there must be someone who's tried this before, I'm sure
there's a simple fix for this I just can't figure it out on my own,
help is appreciated.
On Apr 8, 6:30 pm, jelmer <[EMAIL PROTECTED]> wrote:
> Hello guys,
>
> I'm trying to use countercache to count the number of visible comments
> a post has. This means that the count should only be added when the
> active field is set to 1 (it's a sort of comment moderation system),
> it's not a problem to set that up using counterScope.
>
> So of course I've added a function to approve comments, the code is
> below:
> part of comments_controller.php:
>
> function admin_approve($post_id,$id)
> {
> //tried to set the post id with this, but no luck..
> $this->Comment->id = $id;
> $this->Comment->post_id = $post_id;
> $this->Comment->Post->id = $post_id;
> //save the visible field to approve it, counterCache should be
> handled automatically.
> if($this->Comment->saveField('visible',1))
> $this->Session->setFlash('This comment has been approved');
> $this->redirect(array('controller' => 'comments', 'action' =>
> 'admin_index'));
> }
>
> Unfortunately it doesn't work properly, the post is approved but
> counter cache doesn't update and throws some error messages :(, it
> seems to post_id is undefined.. I've tried setting it but that didn't
> change anything, I hope you can do something with the error code:
>
> Notice (8): Undefined index: post_id [CORE\cake\libs\model\model.php,
> line 1346]
>
> Code | Context
>
> $keys = array(
> "visible" => 1,
> "modified" => "2008-04-08 18:27:51"
> )
> $created = false
> $assoc = array(
> "counterCache" => "comment_count",
> "counterScope" => array(
> "visible" => 1
> ),
> "className" => "Post",
> "foreignKey" => "post_id",
> "conditions" => "[empty string]",
> "fields" => "[empty string]",
> "order" => "[empty string]"
> )
> $parent = "Post"
>
> }
> if ($this->{$parent}->hasField($assoc['counterCache'])) {
>
> $conditions = array($this-
>
> >escapeField($assoc['foreignKey']) => $keys[$assoc['foreignKey']]);
>
> Model::updateCounterCache() - CORE\cake\libs\model\model.php, line
> 1346
> Model::save() - CORE\cake\libs\model\model.php, line 1243
> Model::saveField() - CORE\cake\libs\model\model.php, line 1105
> CommentsController::admin_approve() - APP\controllers
> \comments_controller.php, line 86
> Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 265
> Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 237
> [main] - CORE\public_html\index.php, line 93
>
> and a second error, pretty much the same?
>
> Notice (8): Undefined index: post_id [CORE\cake\libs\model\model.php,
> line 1352]
>
> Code | Context
>
> $keys = array(
> "visible" => 1,
> "modified" => "2008-04-08 18:27:51"
> )
> $created = false
> $assoc = array(
> "counterCache" => "comment_count",
> "counterScope" => array(
> "visible" => 1
> ),
> "className" => "Post",
> "foreignKey" => "post_id",
> "conditions" => "[empty string]",
> "fields" => "[empty string]",
> "order" => "[empty string]"
> )
> $parent = "Post"
> $conditions = array(
> "`Comment`.`post_id`" => null,
> "visible" => 1
> )
>
> $this->{$parent}->updateAll(
> array($assoc['counterCache'] =>
> intval($this->find('count', compact('conditions')))),
>
> array($this->{$parent}->escapeField() =>
> $keys[$assoc['foreignKey']])
>
> Model::updateCounterCache() - CORE\cake\libs\model\model.php, line
> 1352
> Model::save() - CORE\cake\libs\model\model.php, line 1243
> Model::saveField() - CORE\cake\libs\model\model.php, line 1105
> CommentsController::admin_approve() - APP\controllers
> \comments_controller.php, line 86
> Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 265
> Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 237
> [main] - CORE\public_html\index.php, line 93
>
> and the queries:
>
> SELECT `User`.`id`, `User`.`username`, `User`.`password`,
> `User`.`fname`, `User`.`lname`, `User`.`email`, `User`.`group_id`,
> `User`.`active`, `User`.`created`, `User`.`modified` FROM `users` AS
> `User` WHERE `username` = 'jelmer' AND `password` =
> '69284a3bda59fd34c23065ccb06902d015bb7b7e' LIMIT 1 1 1
> 1
> 2 SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` WHERE
> `Comment`.`id` = 85 1 1 1
> 3 UPDATE `comments` SET `visible` = 1, `modified` = '2008-04-08
> 18:27:51' WHERE `comments`.`id` = 85 1 1
> 4 SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN
> `posts` AS `Post` ON (`Comment`.`post_id` = `Post`.`id`) WHERE
> `Comment`.`post_id` IS NULL AND `visible` = 1 1 1 1
> 5 UPDATE `posts` AS `Post` LEFT JOIN `categories` AS `Category` ON
> (`Post`.`category_id` = `Category`.`id`) SET `Post`.`comment_count` =
> 0 WHERE `Post`.`id` IS NULL
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
