Re: Is data sanitization required in setting $this->Model->id = $id?

2013-06-11 Thread Simon Males
I think that is a fair call.


On Tue, Jun 11, 2013 at 1:22 AM, John  wrote:

> Say I get the $id from a url, /controller/action/id and want to use it to
> do a $this->Model->id = $id.
>
> Is it safe to pass it as it's coming in or do I need to call Sanitize::
> clean first? The book mentions that if you use cake's ORM you're safe,
> but I couldn't follow the code enough to find out how it is sanitized :)
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
Simon Males

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: why (and where) is my data disappearing?

2013-06-11 Thread lowpass
Resolved. The problem was that the Upload array of course wasn't yet
modified by the behavior: Upload => file => [file upload details] so
saveAssociated didn't like it. I've changed to calling save() and then
populating the Upload array in afterSave and then saving the Upload
(actually aliased as Resume)

function afterSave() {
if (isset($this->data['Resume'])) {
$this->data['Resume']['model'] = $this->alias;
$this->data['Resume']['foreign_key'] = $this->id;
$this->Resume->create();
$this->Resume->save($this->data);
}
return true;
}

Also, I forgot that I'd just upgraded to 2.3.6 (And you all should too if
you haven't!)


On Tue, Jun 11, 2013 at 9:30 PM, lowpass  wrote:

> using 2.3.5
>
> I have an 'uploads' table, with columns 'model' and 'foreign_key'. The
> Upload model uses the behavior in Nick Baker's FileUpload plugin. This
> isn't the first time I've used it, and in fact I've used the
> model/foreign_key approach for quite a lot of other things with Cake. But
> for some reason in this latest app the 'model' key is being unset from the
> data.
>
> I'm logging the data in several places. Here it is after the associated
> model has been saved, where the model and f_k values are saved to
> Upload->data. That is, I used $this->log($this->Upload->data);
>
> 2013-06-11 20:50:02 Error: JobApplication::afterSave
> 2013-06-11 20:50:02 Error: Array
> (
>   [Upload] => Array
> (
>   [file] => Array
> (
>   [name] => snu.txt
>   [type] => text/plain
>   [tmp_name] => /tmp/phpE3aWNC
>   [error] => 0
>   [size] => 2340
> )
>   [model] => JobApplication
>   [foreign_key] => 8
> )
> )
>
> But then right after that, in the behavior:
>
> 2013-06-11 20:50:02 Error: FileUploadBehavior::beforeSave
> 2013-06-11 20:50:02 Error: Array
> (
>   [Upload] => Array
> (
>   [foreign_key] => 8
>   [file] => Array
> (
>   [name] => snu.txt
>   [type] => text/plain
>   [tmp_name] => /tmp/phpE3aWNC
>   [error] => 0
>   [size] => 2340
> )
>   [created] => 2013-06-11 20:50:02
> )
> )
>
> I've explicitly included the 'model' key in the fieldList:
>
> public function persist($data) {
>   $options = array(
> 'fieldList' => array(
>   $this->alias => array(
> 'created',
> 'job_id',
> 'first_name',
> 'last_name',
> 'email',
> 'msg'
>   ),
>   'Upload' => array(
> 'created',
> 'model',
> 'foreign_key',
> 'file_name',
> 'file_type',
> 'file_size'
>   )
> )
>   );
>   return $this->saveAssociated($data, $options);
> }
>
> I've even changed 'model' to 'foo' -- in both $data and the fieldList --
> but it too is removed.
>
> What else could it be?
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Cannot access empty property in View.php on line 854

2013-06-11 Thread lowpass
Not without:

- your Cake version
- some context
- some code



On Mon, Jun 10, 2013 at 7:20 PM, alfredo davila <
davilaassadalfr...@gmail.com> wrote:

> I can´t stop dealing with this problem in my cakephp :S I think it´s
> problem of the Model or the View.
> Can anyone help me? :S
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: How to call a postgresql stored procedure with cakephp

2013-06-11 Thread lowpass
$data = $this->query($raw_sql_string);

debug($data); // it won't have the usual Cake structure


On Sat, Jun 8, 2013 at 2:37 AM, victor carcamo wrote:

> Hi, i'm suing cakePhp i need to call l a postgresql stored procedure with
> cakephp, somebody ?
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




why (and where) is my data disappearing?

2013-06-11 Thread lowpass
using 2.3.5

I have an 'uploads' table, with columns 'model' and 'foreign_key'. The
Upload model uses the behavior in Nick Baker's FileUpload plugin. This
isn't the first time I've used it, and in fact I've used the
model/foreign_key approach for quite a lot of other things with Cake. But
for some reason in this latest app the 'model' key is being unset from the
data.

I'm logging the data in several places. Here it is after the associated
model has been saved, where the model and f_k values are saved to
Upload->data. That is, I used $this->log($this->Upload->data);

2013-06-11 20:50:02 Error: JobApplication::afterSave
2013-06-11 20:50:02 Error: Array
(
  [Upload] => Array
(
  [file] => Array
(
  [name] => snu.txt
  [type] => text/plain
  [tmp_name] => /tmp/phpE3aWNC
  [error] => 0
  [size] => 2340
)
  [model] => JobApplication
  [foreign_key] => 8
)
)

But then right after that, in the behavior:

2013-06-11 20:50:02 Error: FileUploadBehavior::beforeSave
2013-06-11 20:50:02 Error: Array
(
  [Upload] => Array
(
  [foreign_key] => 8
  [file] => Array
(
  [name] => snu.txt
  [type] => text/plain
  [tmp_name] => /tmp/phpE3aWNC
  [error] => 0
  [size] => 2340
)
  [created] => 2013-06-11 20:50:02
)
)

I've explicitly included the 'model' key in the fieldList:

public function persist($data) {
  $options = array(
'fieldList' => array(
  $this->alias => array(
'created',
'job_id',
'first_name',
'last_name',
'email',
'msg'
  ),
  'Upload' => array(
'created',
'model',
'foreign_key',
'file_name',
'file_type',
'file_size'
  )
)
  );
  return $this->saveAssociated($data, $options);
}

I've even changed 'model' to 'foo' -- in both $data and the fieldList --
but it too is removed.

What else could it be?

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Order Tree output

2013-06-11 Thread Jeremy Burns
I solved this - it works but might be either brilliant or stupid.

I added a new field called path. In that field I store the full path from 
the top level of the tree through all children to 'this' one - something 
like this:

   - Top Level Department > Parent Department > Child Department > This 
   Department
   

I can now report the hierarchy by doing a straight sort on this field 
without doing any Tree stuff or parsing.

I have a beforeSave function that identifies if the save is going to change 
the title field or the parent_id. If so, it sets a global variable. The 
afterSave function looks for that variable, and if found it clears the 
variable (to prevent an endless save loop), gets the full path from this 
node back to the root, implodes it with ' > ' and updates the 'path' field 
with a long string. It then finds all children of this node (between its 
lft and rght values) and updates those too.

It works nicely and is quite snappy. I also built a temporary function to 
populate the file for migration.

On Tuesday, 11 June 2013 16:02:01 UTC+1, Jeremy Burns wrote:
>
> I've got a multi-tenancy site that includes some tables that use the Tree 
> behaviour. By multi-tenancy I mean that several different clients all store 
> their data in the same database and they can only access and manage their 
> own data.
>
> For example, each client stores their departments in the 'departments' 
> table. Each department has a client_id field, as well as parent_id, lft and 
> rght. Each client will have one or more top level departments (where 
> parent_id is null and client_id = $theirClientId).
>
> My aim is to produce reports where the departments are ordered by parent 
> department name -> child department name down through the tree to whatever 
> level where the nodes at each level are also sorted. Ideally I'd user 
> Tree->reorder when departments are added or updated so they are stored in 
> the right order and I can simply sort by lft on find, but I'm finding that 
> performance is poor. This is partly because if a new top level department 
> is added I need to reorder where parent_id is null, and that impacts all 
> top level departments not just those belonging to this client. That can 
> trigger a lot of cascading updates.
>
> Is there a way to either:
> 1) use Tree->reorder but pass in extra criteria (parent_id = null AND 
> client_id = 123) or
> 2) Sort the data once it's been found - there plenty of examples using the 
> lft column but that isn't correct if the title field isn't also sorted 
> correctly when stored.
>
> If the answer is 1 (which sounds right) it can still trigger an update of 
> the complete tree if a new top level department is added that begins with 
> 'A', as all subsequent rows will have to be moved down.
>
> What's the recommended approach?
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Cakephp 1.3 Edit Action Not Populating Fields

2013-06-11 Thread Karl Smith
Yea I noticed that! Thanks!! Only thing now is my find method is not 
retrieving the correct records. I will post more later. Again thanks!

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread Safa Ksouri
and just a NB, i have the AppHelper.php on app/view/Helper
but not on lib/cake/view/Helper and even I tried to create it there the pb
doesn't resolved


2013/6/11 Safa Ksouri 

> yes, I did but i still don't know what's rong exactly, and what should i
> do?
>
>
> 2013/6/11 euromark 
>
>> Did you read the part about AppHelper being required in your APP
>> /View/Helper dir?
>>
>>
>> Am Dienstag, 11. Juni 2013 21:37:59 UTC+2 schrieb Safa Ksouri:
>>>
>>> And for the URL localhost/cakephp/Posts/index
>>> posts:controller
>>> index:action
>>>
>>> Le mardi 11 juin 2013 19:51:56 UTC+1, Safa Ksouri a écrit :
>>>
 I'm sorry about writing in French, and thank you for your answers, but
 i still have the same problem and i have all of these classes


 2013/6/11 euromark 

> please read
> http://book.cakephp.org/2.0/**en/appendices/2-1-migration-**
> guide.html#appcontroller-**apphelper-appmodel-and-**appshell
>
> PS: this channel is english only - please. Otherwise we cannot
> understand you
>
>
> Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:
>
>> salut, je suis debutante en cakephp , je suis entrin de suivre la
>> creation du Blog et j'ai rencontré cet erreur
>> 1 Fatal error: Class 'AppHelper' not found in
>> /home/safa/workspace/cakephp/**l**ib/Cake/View/Helper/**FormHelper**.php
>> on line 30
>> Nb: j'ai la version 2.3.5 de cakephp
>> merci de me répondre le plutot possible.
>>
>  --
> Like Us on FaceBook 
> https://www.facebook.com/**CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/**
> topic/cake-php/1NzcKSgeMTo/**unsubscribe?hl=en
> .
>  To unsubscribe from this group and all its topics, send an email to
> cake-php+u...@**googlegroups.com.
> To post to this group, send email to cake...@googlegroups.com.
>
> Visit this group at 
> http://groups.google.com/**group/cake-php?hl=en
> .
> For more options, visit 
> https://groups.google.com/**groups/opt_out
> .
>
>
>

  --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "CakePHP" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/cake-php/1NzcKSgeMTo/unsubscribe?hl=en.
>> To unsubscribe from this group and all its topics, send an email to
>> cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread Safa Ksouri
yes, I did but i still don't know what's rong exactly, and what should i do?


2013/6/11 euromark 

> Did you read the part about AppHelper being required in your APP
> /View/Helper dir?
>
>
> Am Dienstag, 11. Juni 2013 21:37:59 UTC+2 schrieb Safa Ksouri:
>>
>> And for the URL localhost/cakephp/Posts/index
>> posts:controller
>> index:action
>>
>> Le mardi 11 juin 2013 19:51:56 UTC+1, Safa Ksouri a écrit :
>>
>>> I'm sorry about writing in French, and thank you for your answers, but i
>>> still have the same problem and i have all of these classes
>>>
>>>
>>> 2013/6/11 euromark 
>>>
 please read
 http://book.cakephp.org/2.0/**en/appendices/2-1-migration-**
 guide.html#appcontroller-**apphelper-appmodel-and-**appshell

 PS: this channel is english only - please. Otherwise we cannot
 understand you


 Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:

> salut, je suis debutante en cakephp , je suis entrin de suivre la
> creation du Blog et j'ai rencontré cet erreur
> 1 Fatal error: Class 'AppHelper' not found in
> /home/safa/workspace/cakephp/**l**ib/Cake/View/Helper/**FormHelper**.php
> on line 30
> Nb: j'ai la version 2.3.5 de cakephp
> merci de me répondre le plutot possible.
>
  --
 Like Us on FaceBook 
 https://www.facebook.com/**CakePHP
 Find us on Twitter http://twitter.com/CakePHP

 ---
 You received this message because you are subscribed to a topic in the
 Google Groups "CakePHP" group.
 To unsubscribe from this topic, visit https://groups.google.com/d/**
 topic/cake-php/1NzcKSgeMTo/**unsubscribe?hl=en
 .
 To unsubscribe from this group and all its topics, send an email to
 cake-php+u...@**googlegroups.com.
 To post to this group, send email to cake...@googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/cake-php?hl=en
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_out
 .



>>>
>>>  --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/1NzcKSgeMTo/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread euromark
Did you read the part about AppHelper being required in your APP 
/View/Helper dir?


Am Dienstag, 11. Juni 2013 21:37:59 UTC+2 schrieb Safa Ksouri:
>
> And for the URL localhost/cakephp/Posts/index
> posts:controller
> index:action
>
> Le mardi 11 juin 2013 19:51:56 UTC+1, Safa Ksouri a écrit :
>>
>> I'm sorry about writing in French, and thank you for your answers, but i 
>> still have the same problem and i have all of these classes
>>
>>
>> 2013/6/11 euromark >
>>
>>> please read
>>>
>>> http://book.cakephp.org/2.0/en/appendices/2-1-migration-guide.html#appcontroller-apphelper-appmodel-and-appshell
>>>
>>> PS: this channel is english only - please. Otherwise we cannot 
>>> understand you
>>>
>>>
>>> Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:
>>>
 salut, je suis debutante en cakephp , je suis entrin de suivre la 
 creation du Blog et j'ai rencontré cet erreur
 1 Fatal error: Class 'AppHelper' not found in 
 /home/safa/workspace/cakephp/**lib/Cake/View/Helper/**FormHelper.php 
 on line 30 
 Nb: j'ai la version 2.3.5 de cakephp
 merci de me répondre le plutot possible.

>>>  -- 
>>> Like Us on FaceBook https://www.facebook.com/CakePHP
>>> Find us on Twitter http://twitter.com/CakePHP
>>>  
>>> --- 
>>> You received this message because you are subscribed to a topic in the 
>>> Google Groups "CakePHP" group.
>>> To unsubscribe from this topic, visit 
>>> https://groups.google.com/d/topic/cake-php/1NzcKSgeMTo/unsubscribe?hl=en
>>> .
>>> To unsubscribe from this group and all its topics, send an email to 
>>> cake-php+u...@googlegroups.com .
>>> To post to this group, send email to cake...@googlegroups.com
>>> .
>>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>  
>>>  
>>>
>>
>>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread Safa Ksouri
And for the URL localhost/cakephp/Posts/index
posts:controller
index:action

Le mardi 11 juin 2013 19:51:56 UTC+1, Safa Ksouri a écrit :
>
> I'm sorry about writing in French, and thank you for your answers, but i 
> still have the same problem and i have all of these classes
>
>
> 2013/6/11 euromark 
>
>> please read
>>
>> http://book.cakephp.org/2.0/en/appendices/2-1-migration-guide.html#appcontroller-apphelper-appmodel-and-appshell
>>
>> PS: this channel is english only - please. Otherwise we cannot understand 
>> you
>>
>>
>> Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:
>>
>>> salut, je suis debutante en cakephp , je suis entrin de suivre la 
>>> creation du Blog et j'ai rencontré cet erreur
>>> 1 Fatal error: Class 'AppHelper' not found in 
>>> /home/safa/workspace/cakephp/**lib/Cake/View/Helper/**FormHelper.php on 
>>> line 30 
>>> Nb: j'ai la version 2.3.5 de cakephp
>>> merci de me répondre le plutot possible.
>>>
>>  -- 
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>  
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "CakePHP" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/cake-php/1NzcKSgeMTo/unsubscribe?hl=en.
>> To unsubscribe from this group and all its topics, send an email to 
>> cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread Safa Ksouri
I'm sorry about writing in French, and thank you for your answers, but i
still have the same problem and i have all of these classes


2013/6/11 euromark 

> please read
>
> http://book.cakephp.org/2.0/en/appendices/2-1-migration-guide.html#appcontroller-apphelper-appmodel-and-appshell
>
> PS: this channel is english only - please. Otherwise we cannot understand
> you
>
>
> Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:
>
>> salut, je suis debutante en cakephp , je suis entrin de suivre la
>> creation du Blog et j'ai rencontré cet erreur
>> 1 Fatal error: Class 'AppHelper' not found in
>> /home/safa/workspace/cakephp/**lib/Cake/View/Helper/**FormHelper.php on
>> line 30
>> Nb: j'ai la version 2.3.5 de cakephp
>> merci de me répondre le plutot possible.
>>
>  --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/1NzcKSgeMTo/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread euromark
please read
http://book.cakephp.org/2.0/en/appendices/2-1-migration-guide.html#appcontroller-apphelper-appmodel-and-appshell

PS: this channel is english only - please. Otherwise we cannot understand 
you


Am Dienstag, 11. Juni 2013 18:57:27 UTC+2 schrieb Safa Ksouri:
>
> salut, je suis debutante en cakephp , je suis entrin de suivre la creation 
> du Blog et j'ai rencontré cet erreur
> 1 Fatal error: Class 'AppHelper' not found in 
> /home/safa/workspace/cakephp/lib/Cake/View/Helper/FormHelper.php on line 30 
> Nb: j'ai la version 2.3.5 de cakephp
> merci de me répondre le plutot possible.
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: class AppHelper not found

2013-06-11 Thread mike karthauser
Hi

On 11 Jun 2013, at 17:57, Safa Ksouri  wrote:

> salut, je suis debutante en cakephp , je suis entrin de suivre la creation du 
> Blog et j'ai rencontré cet erreur
> 1 Fatal error: Class 'AppHelper' not found in 
> /home/safa/workspace/cakephp/lib/Cake/View/Helper/FormHelper.php on line 30 
> Nb: j'ai la version 2.3.5 de cakephp
> merci de me répondre le plutot possible.

Can you repost with more details of the URL that you are hitting to get this 
error . Please also post in English as you'll get a better chance of reply.

> -- 
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>  
> --- 
> You received this message because you are subscribed to the Google Groups 
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




class AppHelper not found

2013-06-11 Thread Safa Ksouri
salut, je suis debutante en cakephp , je suis entrin de suivre la creation 
du Blog et j'ai rencontré cet erreur
1 Fatal error: Class 'AppHelper' not found in 
/home/safa/workspace/cakephp/lib/Cake/View/Helper/FormHelper.php on line 30 
Nb: j'ai la version 2.3.5 de cakephp
merci de me répondre le plutot possible.

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Created and Modified Dates don't auto populate on HABTM

2013-06-11 Thread Iñigo Garcia
How did you go around that finally? i am in the same point right now.

thanks

On Friday, February 18, 2011 3:33:35 PM UTC+1, rgreenphotodesign wrote:
>
> Thanks for taking a look guys. I knew there was reason why it made 
> sense to me that the dates weren't populating, just wasn't sure if 
> there was a work around. 
>
> Thanks for the advice, I'll get it set with the join model and go from 
> there. Thanks again. 
>
> On Feb 17, 3:10 pm, euromark  wrote: 
> > yep 
> > you will need to develop your own HABTM behavior that will take care 
> > of that 
> > because john is right, in the default HABTM table, only the primary 
> > keys of the two joined tables are allowed 
> > something I regretted as well in the past 
> > but you can easily work around it - manually :) 
> > 
> > On 17 Feb., 22:10, John Andersen  wrote: 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > > I do think that you need to take a look at The Join Model in the 
> > > CakePHP book at:
> http://book.cakephp.org/#!/view/1650/hasMany-through-The-Join-Model 
> > 
> > > as what you want is to have additional data in your intersection table 
> > > and CakePHP normal usage does not allow that. 
> > > Whether or not it will be able to automatically populate the created 
> > > and modified columns is not something I am sure about though! 
> > > Enjoy, 
> > >John 
> > 
> > > On Feb 17, 5:19 pm, rgreenphotodesign  
> > > wrote: 
> > 
> > > > Just for good measure here are my relationships in the models: 
> > 
> > > > Activity: 
> > 
> > > > var $hasAndBelongsToMany = array( 
> > > > 'Statustype' => array( 
> > > > 'className' => 'Statustype', 
> > > > 'joinTable' => 'activity_statuses', 
> > > > 'foreignKey' => 'activities_id', 
> > > > 'associationForeignKey' => 'statustypes_id', 
> > > > 'unique' => false, 
> > > > 'conditions' => '', 
> > > > 'fields' => '', 
> > > > 'order' => '', 
> > > > 'limit' => '', 
> > > > 'offset' => '', 
> > > > 'finderQuery' => '', 
> > > > 'deleteQuery' => '', 
> > > > 'insertQuery' => '' 
> > > > ), 
> > > > ); 
> > 
> > > > ActivityStatus: 
> > 
> > > > var $belongsTo = array( 
> > > > 'Statustype' => array( 
> > > > 'className' => 'Statustype', 
> > > > 'foreignKey' => 'statustypes_id', 
> > > > 'conditions' => '', 
> > > > 'fields' => '', 
> > > > 'order' => '' 
> > > > ), 
> > > > 'Activity' => array( 
> > > > 'className' => 'Activity', 
> > > > 'foreignKey' => 'activities_id', 
> > > > 'conditions' => '', 
> > > > 'fields' => '', 
> > > > 'order' => '' 
> > > > ), 
> > > > ); 
> > 
> > > > I don't define any relationships in the Statustype model. 
> > 
> > > [snip]

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: No response from PayPal sandbox server

2013-06-11 Thread prerna
Can u tell me how it can be done using codeigniter ...I am facing the same 
problem...

Getting Warning :
Message: fsockopen(): unable to connect to ssl://www.sandbox.paypal:443 
(php_network_getaddresses: getaddrinfo failed: Name or service not known)

On Wednesday, November 21, 2012 5:33:26 AM UTC+5:30, Daniel wrote:
>
> In the end I got "curl" working instead.
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Order Tree output

2013-06-11 Thread Jeremy Burns
I've got a multi-tenancy site that includes some tables that use the Tree 
behaviour. By multi-tenancy I mean that several different clients all store 
their data in the same database and they can only access and manage their 
own data.

For example, each client stores their departments in the 'departments' 
table. Each department has a client_id field, as well as parent_id, lft and 
rght. Each client will have one or more top level departments (where 
parent_id is null and client_id = $theirClientId).

My aim is to produce reports where the departments are ordered by parent 
department name -> child department name down through the tree to whatever 
level where the nodes at each level are also sorted. Ideally I'd user 
Tree->reorder when departments are added or updated so they are stored in 
the right order and I can simply sort by lft on find, but I'm finding that 
performance is poor. This is partly because if a new top level department 
is added I need to reorder where parent_id is null, and that impacts all 
top level departments not just those belonging to this client. That can 
trigger a lot of cascading updates.

Is there a way to either:
1) use Tree->reorder but pass in extra criteria (parent_id = null AND 
client_id = 123) or
2) Sort the data once it's been found - there plenty of examples using the 
lft column but that isn't correct if the title field isn't also sorted 
correctly when stored.

If the answer is 1 (which sounds right) it can still trigger an update of 
the complete tree if a new top level department is added that begins with 
'A', as all subsequent rows will have to be moved down.

What's the recommended approach?

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: connecting mssql 2005

2013-06-11 Thread John Sposato
Did you look here:

https://github.com/cakephp/datasources

This is what we're using

On Thursday, June 6, 2013 2:21:59 AM UTC-4, Nikunj Amipara wrote:
>
> hi,
> I am trying to connect to remote database which is on mssql server and i 
> am getting fallowing error can any one help? 
> tried to google this problem but nothing seems to work.
>
> A Database connection using "Sqlserver" was missing or unable to connect. 
> The database server returned this error: SQLSTATE[IMSSP]: This extension 
> requires the Microsoft SQL Server 2012 Native Client ODBC Driver to 
> communicate with SQL Server. Access the following URL to download the 
> Microsoft SQL Server 2012 Native Client ODBC driver for x86: 
> http://go.microsoft.com/fwlink/?LinkId=163712 
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Doubt regarding routing.

2013-06-11 Thread Nikunj Amipara
it got solved now turn out one one of form->create fun i did use action
instead of url which allows us to write url in array form..
thanks for reply btw:)


On Tue, Jun 11, 2013 at 9:16 AM, Gaurav Matta wrote:

> Can you provide a sample of urls which are not converting...
> i did that already it seems to work too but only at some places...i want
> photo/:action to be blocked completely
>
>
> On Mon, Jun 10, 2013 at 7:13 PM, Gaurav Matta wrote:
>
>> In routes.php
>>
>> On 10-Jun-2013 6:17 PM, "Nikunj Amipara"  wrote:
>> >
>> > hi all,
>> >
>> >  i have doubt regarding routing...
>> >  i want to replace
>> >
>> >  url :  /photo/* with /image/*   everywhere  basically i want name
>> of controller to be replaced.. in addition /photo url should no longer
>> work. or it should be renamed and redirected to /image/*
>> >
>> > is it possible... 
>> > if yes please give some guidance as i don't know much about routing.
>> >
>> > thanks.
>> > Nikunj
>> >
>> > --
>> > Like Us on FaceBook https://www.facebook.com/CakePHP
>> > Find us on Twitter http://twitter.com/CakePHP
>> >
>> > ---
>> > You received this message because you are subscribed to the Google
>> Groups "CakePHP" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> an email to cake-php+unsubscr...@googlegroups.com.
>>
>> > To post to this group, send email to cake-php@googlegroups.com.
>> > Visit this group at http://groups.google.com/group/cake-php?hl=en.
>> > For more options, visit https://groups.google.com/groups/opt_out.
>> >
>> >
>>
>>  --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "CakePHP" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/cake-php/FMMEsvc-d6Q/unsubscribe?hl=en.
>> To unsubscribe from this group and all its topics, send an email to
>> cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *
>..Nikunj.*
> *  (nikamipar...@gmail.com)
> **(nik_amip...@yahoo.in)*
> *(nikamip...@facebook.com )*
> ***(amipara_nik...@daiict.ac.in <201001...@daiict.ac.in>)*
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "CakePHP" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/cake-php/FMMEsvc-d6Q/unsubscribe?hl=en.
> To unsubscribe from this group and all its topics, send an email to
> cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*
 ..Nikunj.*
*  (nikamipar...@gmail.com)
**(nik_amip...@yahoo.in)*
*(nikamip...@facebook.com )*
***(amipara_nik...@daiict.ac.in <201001...@daiict.ac.in>)*

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: New field not being read

2013-06-11 Thread Reuben
Yeah, I'm finding that one out the hard way.

Still, even using find(first), the new field does not yet read into the 
database, until I specify it in the fields list.

I guess I have a work around, but it's something I'll be eyeing with a bit 
of suspicion.  Doesn't help that I updated to CakePHP 2.3.6, and the update 
to the license string means just about every lib/Cake program received an 
alteration.

On Tuesday, June 11, 2013 7:15:59 PM UTC+10, euromark wrote:
>
> dont use read(), use find(first)
> read() does too many thinks people are not aware of and possibly messing 
> things up in the long run
>
>
> Am Dienstag, 11. Juni 2013 05:52:04 UTC+2 schrieb Reuben:
>>
>> Hi
>>
>> I've put a new field on a table, and it's not being read as a part of a 
>> read(null, $id) operation.
>>
>> I have made sure I have delete the cache, and I can definitely see that 
>> the new field is there.
>>
>> Additionally, if I do a read(array('id', 'notify_email'), $id), the new 
>> field (which is notify_email), is present, just not when I do a read(null, 
>> $id).
>>
>> Regards
>> Reuben Helms
>>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Writing data and previous reads

2013-06-11 Thread euromark
Yes, you should always try to use find() instead read() to be on the safe 
side here.


Am Dienstag, 11. Juni 2013 05:49:16 UTC+2 schrieb Reuben:
>
> Hi 
>
> I'm having trouble with reading some data, and I think I sort why a 
> particular operation is happening at a technical level, but I'm left 
> wondering if it's the right behaviour.
>
> Here's what I'm doing.
>
> In one operation, I'm doing a read of a model for all fields 
>
>$this->Model->read(null, $id);
>
> Then I'm constructing a new $data variable that contains the $id, and any 
> changed fields.  Typically, this just has a changed status field. I end up 
> with :
>
> $data = array('id' => $id, 'status' => 'closed');
> $this->Model->save($data);
>
> However, when I look at the SqlLog, it would seem that all data is 
> retained from the previous read, and the new data is merged with the 
> existing data, and it is all saved.  The side effect is that the modified 
> field is not updated.
>
> Is this intentional behaviour?  I thought that if you were to specify the 
> primary key and data in the input of the save, then it would just save that 
> data, and not data from a previous read.
>
> Should I be doing a find('first') instead of a read() to avoid this?
>
> Regards
> Reuben Helms
>
>
>
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: Missing View

2013-06-11 Thread Julien Itard
Salut,
tu es sure et certaine que c'est crée ? la même extension .ctp ? même 
dossier Posts avec un s ?
Si tu veux plus de réponse tu dois parler anglais ici !

Julien

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Re: New field not being read

2013-06-11 Thread euromark
dont use read(), use find(first)
read() does too many thinks people are not aware of and possibly messing 
things up in the long run


Am Dienstag, 11. Juni 2013 05:52:04 UTC+2 schrieb Reuben:
>
> Hi
>
> I've put a new field on a table, and it's not being read as a part of a 
> read(null, $id) operation.
>
> I have made sure I have delete the cache, and I can definitely see that 
> the new field is there.
>
> Additionally, if I do a read(array('id', 'notify_email'), $id), the new 
> field (which is notify_email), is present, just not when I do a read(null, 
> $id).
>
> Regards
> Reuben Helms
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.