Oh non sorry :)
personality_count fields are INT(11)

On 9 déc, 17:15, avairet <[email protected]> wrote:
> Like I said : TINYINT(1)
>
> On 9 déc, 17:11, Jeremy Burns | Class Outfit
>
> <[email protected]> wrote:
> > What's the data type and size of the counter fields?
>
> > Jeremy Burns
> > Class Outfit
>
> >http://www.classoutfit.com
>
> > On 9 Dec 2011, at 16:07:53, avairet wrote:
>
> > > Hi,
>
> > > I'm using Cake 1.3.13.
>
> > > I have an strange issue with counterCache, that I've never seen
> > > before.
>
> > > So, I have Personality belongsTo User and Personality belongsTo
> > > Category associations:
>
> > >    public $belongsTo = array(
> > >            'Category' => array(
> > >                    'className' => 'Category',
> > >                    'foreignKey' => 'category_id',
> > >                    'conditions' => '',
> > >                    'fields' => '',
> > >                    'order' => '',
> > >                    'counterCache' => true,
> > >                    'counterScope' => array('Personality.valid' => 1)
> > >            ),
> > >            'User' => array(
> > >                    'className' => 'User',
> > >                    'foreignKey' => 'user_id',
> > >                    'conditions' => '',
> > >                    'fields' => '',
> > >                    'order' => '',
> > >                    'counterCache' => true,
> > >                    'counterScope' => array('Personality.valid' => 1)
> > >            )
> > >    );
>
> > > In my personalities and categories tables, I have a
> > > "personality_count" field (TINYINT).
> > > When I add a Personality and I set "valid" to 1, all is right, the
> > > counters are updated.
>
> > > In my personality edit view, I have a checkbox to validate or
> > > invalidate the record (Personality.valid = 0 or 1).
> > > If I invalidate a personality, all is right, the counters are updated
> > > (- 1).
> > > But after that, if I validate the personality again, the counters
> > > don't change?!
>
> > > What's the mistake? Thank's fo any idea.
>
> > > By the way, why there is a "$created" param in
> > > Model::updateCounterCache() while it is never used inside the method??
>
> > > Avairet
>
> > > --
> > > Our newest site for the community: CakePHP Video 
> > > Tutorialshttp://tv.cakephp.org
> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp 
> > > others with their CakePHP related questions.
>
> > > To unsubscribe from this group, send email to
> > > [email protected] For more options, visit this group 
> > > athttp://groups.google.com/group/cake-php
>
>

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

Reply via email to