Log message #113885

# At Username Text
# Aug 9th 2008, 14:56 jaredhoyt 'mailing_address' is tinytext and 'country' is varchar
# Aug 9th 2008, 14:56 barduck althought I never used it since
# Aug 9th 2008, 14:56 barduck AD7six: that once was fixed for findCount -> https://trac.cakephp.org/ticket/2445
# Aug 9th 2008, 14:55 jaredhoyt i did a pr($this->data) right before the return true; and the 'mailing_address' and 'country' fields are present and contain the correct values... they're just not ending up in the db
# Aug 9th 2008, 14:55 barduck AD7Six: yes, that would work, of course. I thought there might be some parameter that I can just pass to find('count') to make it cleaner
# Aug 9th 2008, 14:55 jaredhoyt http://bin.cakephp.org/view/1205572484
# Aug 9th 2008, 14:54 jaredhoyt the rest of the data is, just not these two particular fields i'm changing
# Aug 9th 2008, 14:54 AD7six barduck: doesn't find('first', array('fields' => 'COUNT(DISTINCT....) AS count' ..?
# Aug 9th 2008, 14:54 jaredhoyt hmm, my beforeSave() doesn't seem to be working correctly ... i'm formating some fields before saving and i've done a pr($this->data) just to make sure it's coming out correctly (which it is) ... they're just not showing up in the db
# Aug 9th 2008, 14:54 barduck I guess I can just do a find('all', 'COUNT(...)') myself but I thought there might be a more elegant way
# Aug 9th 2008, 14:52 barduck TheBig: not sure what you mind but I have a query with some complicated joins in it and in order to get the result I need, I need to use DISTINCT on the main model. That works well in the find('all') model but I also need a total count of these items (for pagination)
# Aug 9th 2008, 14:51 TheBig you should do Post->find('count', by user)
# Aug 9th 2008, 14:50 TheBig instead of doing User->find('count', bla bla posts)
# Aug 9th 2008, 14:50 TheBig it hangs on what you need, but let's say you need post of a user
# Aug 9th 2008, 14:49 barduck TheBig: what do you mean ?
# Aug 9th 2008, 14:49 TheBig barduck, why don you make a find('count') of that model?
# Aug 9th 2008, 14:49 jaredhoyt except i'd imagine it wouldn't even let the fields pass into $this->data
# Aug 9th 2008, 14:48 barduck hey, how can I tell find('count') to count DISTINCT Model.* instead of * ?
# Aug 9th 2008, 14:48 jaredhoyt i've never used it
# Aug 9th 2008, 14:48 jaredhoyt is SecurityComponent::disabledFields like the opposite of the $whiteList in save()?
# Aug 9th 2008, 14:43 DrBacchus Glad to help in what small ways I can.
# Aug 9th 2008, 14:43 DrBacchus Better now?
# Aug 9th 2008, 14:40 klaasjan man you are a legend
# Aug 9th 2008, 14:38 klaasjan i 'll try
# Aug 9th 2008, 14:34 DrBacchus Now your .htaccess files should work fine.
# Aug 9th 2008, 14:34 klaasjan Ok i'v changed that to all
# Aug 9th 2008, 14:34 DrBacchus AllowOverride is set per directory.
# Aug 9th 2008, 14:34 DrBacchus And then inside that block, you'll see another AllowOverride directive
# Aug 9th 2008, 14:34 DrBacchus so you should see <Directory "C:/Program Files/php/apache2/htdocs">
# Aug 9th 2008, 14:33 DrBacchus ok good
# Aug 9th 2008, 14:33 klaasjan i guess
# Aug 9th 2008, 14:33 klaasjan C:/Program Files/php/apache2/htdocs">
# Aug 9th 2008, 14:33 markstory Anon323: its controller wide.
# Aug 9th 2008, 14:32 DrBacchus What directory contains your cake files?
# Aug 9th 2008, 14:32 DrBacchus It'll refer to your document root.
# Aug 9th 2008, 14:32 DrBacchus You'll see <Directory /var/www/html> or something like that
# Aug 9th 2008, 14:32 klaasjan ok
# Aug 9th 2008, 14:32 DrBacchus Then look a little further down in the configuration file.
# Aug 9th 2008, 14:32 DrBacchus klaasjan: Change that back to allowoverride none.
# Aug 9th 2008, 14:32 klaasjan Deny from
# Aug 9th 2008, 14:32 DrBacchus klaasjan: Ok, that's the wrong place.