[web2py] Re: Using a recursive select but encountered a broken reference

[Leonel Câmara]

So you're indeed using common filters because that's how record versioning 
is implemented. In this case you can solve it by removing the reference 
before deleting, however if you still want to be able to see the deleted 
record on the one referencing it you can set the versioned table 
_common_filter to None when you get the record referencing it.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ea493272-12f8-45d6-8285-c457fe83a0d4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Using a recursive select but encountered a broken reference

[Carlos Cesar Caballero Díaz]

No, I have just found the issue, I am using record versioning in tables, 
and the child record was removed, this does not trigered the cascade, 
so, the parent record was not removed and the recursive select was 
failing when tries to access to a "deleted" record.


Greetings.

El 22/5/19 a las 11:51 a.m., Leonel Câmara escribió:

Are you using common filters?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google 
Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to web2py+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/d2596552-b707-4b80-8688-2ceedabbea51%40googlegroups.com 
.

For more options, visit https://groups.google.com/d/optout.


--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups "web2py-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/df89be08-f45d-8115-518d-a7cc08f00705%40cfg.jovenclub.cu.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Using a recursive select but encountered a broken reference

[Leonel Câmara]

Are you using common filters?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/d2596552-b707-4b80-8688-2ceedabbea51%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Using a recursive select but encountered a broken reference

[Joe Magaro]

Hi, Im also having the same issue, and the fix above seemed to work --  I'm 
wondering if there is an official fix for this?

On Saturday, March 2, 2013 2:55:17 PM UTC-5, Marin Pranjić wrote:

 This happened to an user multiple times. No idea why it happens.

 Error ticket doesn't show much, this is everything I can get from there:

 Traceback (most recent call last):
  File /home/www-data/web2py/gluon/main.py, line 571, in wsgibase
  session._try_store_in_cookie_or_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 738, in 
 _try_store_in_cookie_or_file
  self._try_store_in_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 745, in 
 _try_store_in_file
  if not response.session_id or self._forget or self._unchanged():
  File /home/www-data/web2py/gluon/globals.py, line 700, in _unchanged
  session_pickled = cPickle.dumps(dict(self))
  File /usr/lib/python2.7/copy_reg.py, line 74, in _reduce_ex
  getstate = self.__getstate__
  File /home/www-data/web2py/gluon/dal.py, line 7355, in __getattr__
  self.__allocate()
  File /home/www-data/web2py/gluon/dal.py, line 7350, in __allocate
  raise RuntimeError, Using a recursive select but encountered a broken 
 reference: %s %d%(self._table, int(self))
 RuntimeError: Using a recursive select but encountered a broken reference: 
 auth_group 5



 However, auth_group record with id=5 exists. I have no idea why it raises an 
 error.

 I'm using web2py 2.2.1, this is production instance so I can't test with 
 other versions right now.


 Marin



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Oliver]

Hi Marin,

we've found a temporary solution for this problem until they fix it in 
web2py.

Here are some code excerpts from gluon/tools.py

def login_user(self, user):

login the user = db.auth_user(id)

from gluon.settings import global_settings
if global_settings.web2py_runtime_gae:
user = Row(self.db.auth_user._filter_fields(user, id=True))
delattr(user,'password')
else:
user = Row(user)
for key,value in user.items():
if callable(value) or key=='password':
delattr(user,key)
current.session.auth = Storage(
user = user,
last_visit=current.request.now,
expiration=self.settings.expiration,
hmac_key=web2py_uuid())
self.user = user
self.update_groups()

def update_groups(self):
if not self.user:
return
user_groups = self.user_groups = {}
if current.session.auth:
current.session.auth.user_groups = self.user_groups
table_group = self.table_group()
table_membership = self.table_membership()
memberships = self.db(
table_membership.user_id == self.user.id).select()
for membership in memberships:
group = table_group(membership.group_id)
if group:
user_groups[membership.group_id] = group.role



Function update_groups raises the error, we don't know why.
It stores the user's groups in a dict, this dict is used only by wiki 
functions in gluon/tools.py.

has_membership doesn't use this dict, it creates a new select query.

So the simplest solution is to comment out or remove self.update_groups() 
from login_user function.

Or like we did, create a new Auth class with an empty load_user function.

modules/auth2.py

#!/bin/python
# -*- coding: utf-8 -*-

from gluon.tools import Auth

class Auth2(Auth):

def __init__(self, 
environment, 
db=None, 
controller='default'):

super(Auth2, self).__init__(environment, db, controller)

def update_groups(self):
return



And in db.py

#auth = Auth(db)
exec('from applications.%s.modules.auth2 import Auth2' % request.application
)
auth=Auth2(globals(),db)

Regards,
Oliver


On Saturday, March 2, 2013 8:55:17 PM UTC+1, Marin Pranjić wrote:

 This happened to an user multiple times. No idea why it happens.

 Error ticket doesn't show much, this is everything I can get from there:

 Traceback (most recent call last):
  File /home/www-data/web2py/gluon/main.py, line 571, in wsgibase
  session._try_store_in_cookie_or_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 738, in 
 _try_store_in_cookie_or_file
  self._try_store_in_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 745, in 
 _try_store_in_file
  if not response.session_id or self._forget or self._unchanged():
  File /home/www-data/web2py/gluon/globals.py, line 700, in _unchanged
  session_pickled = cPickle.dumps(dict(self))
  File /usr/lib/python2.7/copy_reg.py, line 74, in _reduce_ex
  getstate = self.__getstate__
  File /home/www-data/web2py/gluon/dal.py, line 7355, in __getattr__
  self.__allocate()
  File /home/www-data/web2py/gluon/dal.py, line 7350, in __allocate
  raise RuntimeError, Using a recursive select but encountered a broken 
 reference: %s %d%(self._table, int(self))
 RuntimeError: Using a recursive select but encountered a broken reference: 
 auth_group 5



 However, auth_group record with id=5 exists. I have no idea why it raises an 
 error.

 I'm using web2py 2.2.1, this is production instance so I can't test with 
 other versions right now.


 Marin



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Anthony]

 exec('from applications.%s.modules.auth2 import Auth2' % request.
 application)


Side note -- why not just:

from auth2 import Auth2

Anthony 

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Tamas]

Hello Marin,

sorry for the late reply. I don't have your e-mail (this list doesn't show 
e-mails), but I am also not sure I can provide a lot more extra info on 
this.

Did you manage to look into it? Did you find anything?

Thanks!
Tamas

On Friday, March 8, 2013 4:00:24 PM UTC+1, Marin Pranjić wrote:

 Would you mind emailing me the details?
 I won't promise, but I plan to look into it next week.

 Dana petak, 8. ožujka 2013. 15:49:42 UTC+1, korisnik Tamas napisao je:



 On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:

 True, but... Apache is not raising errors, web2py is. The error message 
 is strange. At least we could have a nicer error if this can't be fixed.
 However in my example, both instances work until i try to log in. I can 
 use the site without database i/o. Both instances work.

 Now, why would web2py (1) raise an exception when working with database 
 (2) because the apache (3) configuration is bad ?

 Sometimes the testing instance fails on login, sometimes it is 
 production instance...

 I'd like to see more about Tamas's problem.


 Well, we're running a very busy WSGI Python sctipt alongside a few web2py 
 instances, and just like with your setup the only error that happens is 
 when we try to log in on a w2p instance that uses the same mysql database 
 as the other WSGI script.

 I've e-mailed Massimo with more details a couple of months ago, and he 
 promised to look into the problem, but he never checked back, and my 
 further inquiries had no answer, so I guess it's not an easy fix :(



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Tamas]

Hello,

I've been having this exact same problem for a long, long time.

I would also be interested in a solution, but I doubt there will be one. I 
think it might be a design issue with Web2py.

Tamas

On Saturday, March 2, 2013 9:48:38 PM UTC+1, Marin Pranjić wrote:

 It seems that the problem is because I run two web2py instances.
 One runs on domain.com and the other is on testing.domain.com.

 When I turn off testing instance, everything works as it should. With 
 testing instance turned on, production instance fails.

 So... Can someone help me configure two web2py instances on the same port? 
 Domains are different.

 I'm using apache virtual hosts.

 Marin

 Dana subota, 2. ožujka 2013. 20:55:17 UTC+1, korisnik Marin Pranjić 
 napisao je:

 This happened to an user multiple times. No idea why it happens.

 Error ticket doesn't show much, this is everything I can get from there:

 Traceback (most recent call last):
  File /home/www-data/web2py/gluon/main.py, line 571, in wsgibase
  session._try_store_in_cookie_or_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 738, in 
 _try_store_in_cookie_or_file
  self._try_store_in_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 745, in 
 _try_store_in_file
  if not response.session_id or self._forget or self._unchanged():
  File /home/www-data/web2py/gluon/globals.py, line 700, in _unchanged
  session_pickled = cPickle.dumps(dict(self))
  File /usr/lib/python2.7/copy_reg.py, line 74, in _reduce_ex
  getstate = self.__getstate__
  File /home/www-data/web2py/gluon/dal.py, line 7355, in __getattr__
  self.__allocate()
  File /home/www-data/web2py/gluon/dal.py, line 7350, in __allocate
  raise RuntimeError, Using a recursive select but encountered a broken 
 reference: %s %d%(self._table, int(self))
 RuntimeError: Using a recursive select but encountered a broken reference: 
 auth_group 5



 However, auth_group record with id=5 exists. I have no idea why it raises an 
 error.

 I'm using web2py 2.2.1, this is production instance so I can't test with 
 other versions right now.


 Marin



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Niphlod]

On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:

 Hello,

 I've been having this exact same problem for a long, long time.

 I would also be interested in a solution, but I doubt there will be one. I 
 think it might be a design issue with Web2py.

 Tamas


I'm correct when I think that what you're asking is for two different 
programs to bind to the same socket ? I don't think that's possibile with 
whatever program, not only web2py. 

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Tamas]

On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:



 On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:

 Hello,

 I've been having this exact same problem for a long, long time.

 I would also be interested in a solution, but I doubt there will be one. 
 I think it might be a design issue with Web2py.

 Tamas


 I'm correct when I think that what you're asking is for two different 
 programs to bind to the same socket ? I don't think that's possibile with 
 whatever program, not only web2py. 

  
Not quite, we're using Apache WSGI, which in fact can run multiple 
instances of web2py on the same port, along with other python scripts as 
well.
 

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Niphlod]

wait a sec who binds to that socket is apache, not web2py :D

On Friday, March 8, 2013 1:29:23 PM UTC+1, Tamas wrote:


 On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:



 On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:

 Hello,

 I've been having this exact same problem for a long, long time.

 I would also be interested in a solution, but I doubt there will be one. 
 I think it might be a design issue with Web2py.

 Tamas


 I'm correct when I think that what you're asking is for two different 
 programs to bind to the same socket ? I don't think that's possibile with 
 whatever program, not only web2py. 

  
 Not quite, we're using Apache WSGI, which in fact can run multiple 
 instances of web2py on the same port, along with other python scripts as 
 well.
  


-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Marin Pranjić]

True, but... Apache is not raising errors, web2py is. The error message is 
strange. At least we could have a nicer error if this can't be fixed.
However in my example, both instances work until i try to log in. I can use 
the site without database i/o. Both instances work.

Now, why would web2py (1) raise an exception when working with database (2) 
because the apache (3) configuration is bad ?

Sometimes the testing instance fails on login, sometimes it is production 
instance...

I'd like to see more about Tamas's problem.

Dana petak, 8. ožujka 2013. 15:05:01 UTC+1, korisnik Niphlod napisao je:

 wait a sec who binds to that socket is apache, not web2py :D

 On Friday, March 8, 2013 1:29:23 PM UTC+1, Tamas wrote:


 On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:



 On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:

 Hello,

 I've been having this exact same problem for a long, long time.

 I would also be interested in a solution, but I doubt there will be 
 one. I think it might be a design issue with Web2py.

 Tamas


 I'm correct when I think that what you're asking is for two different 
 programs to bind to the same socket ? I don't think that's possibile with 
 whatever program, not only web2py. 

  
 Not quite, we're using Apache WSGI, which in fact can run multiple 
 instances of web2py on the same port, along with other python scripts as 
 well.
  



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Tamas]

On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:

 True, but... Apache is not raising errors, web2py is. The error message is 
 strange. At least we could have a nicer error if this can't be fixed.
 However in my example, both instances work until i try to log in. I can 
 use the site without database i/o. Both instances work.

 Now, why would web2py (1) raise an exception when working with database 
 (2) because the apache (3) configuration is bad ?

 Sometimes the testing instance fails on login, sometimes it is production 
 instance...

 I'd like to see more about Tamas's problem.


Well, we're running a very busy WSGI Python sctipt alongside a few web2py 
instances, and just like with your setup the only error that happens is 
when we try to log in on a w2p instance that uses the same mysql database 
as the other WSGI script.

I've e-mailed Massimo with more details a couple of months ago, and he 
promised to look into the problem, but he never checked back, and my 
further inquiries had no answer, so I guess it's not an easy fix :(

-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Niphlod]

yep, got that part: I don't use apache and never had any problems with 
multiple version running concurrently,  but I guess there's a ton of users 
out there using apache...I don't think that is a problem related to having 
multiple web2py instances responding to the same port because that's what 
apache is there for. Maybe some weird transaction isolation problem on the 
db part ?

On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:

 True, but... Apache is not raising errors, web2py is. The error message is 
 strange. At least we could have a nicer error if this can't be fixed.
 However in my example, both instances work until i try to log in. I can 
 use the site without database i/o. Both instances work.

 Now, why would web2py (1) raise an exception when working with database 
 (2) because the apache (3) configuration is bad ?

 Sometimes the testing instance fails on login, sometimes it is production 
 instance...

 I'd like to see more about Tamas's problem.

 Dana petak, 8. ožujka 2013. 15:05:01 UTC+1, korisnik Niphlod napisao je:

 wait a sec who binds to that socket is apache, not web2py :D

 On Friday, March 8, 2013 1:29:23 PM UTC+1, Tamas wrote:


 On Friday, March 8, 2013 11:57:39 AM UTC+1, Niphlod wrote:



 On Friday, March 8, 2013 11:06:00 AM UTC+1, Tamas wrote:

 Hello,

 I've been having this exact same problem for a long, long time.

 I would also be interested in a solution, but I doubt there will be 
 one. I think it might be a design issue with Web2py.

 Tamas


 I'm correct when I think that what you're asking is for two different 
 programs to bind to the same socket ? I don't think that's possibile with 
 whatever program, not only web2py. 

  
 Not quite, we're using Apache WSGI, which in fact can run multiple 
 instances of web2py on the same port, along with other python scripts as 
 well.
  



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Marin Pranjić]

Would you mind emailing me the details?
I won't promise, but I plan to look into it next week.

Dana petak, 8. ožujka 2013. 15:49:42 UTC+1, korisnik Tamas napisao je:



 On Friday, March 8, 2013 3:16:25 PM UTC+1, Marin Pranjić wrote:

 True, but... Apache is not raising errors, web2py is. The error message 
 is strange. At least we could have a nicer error if this can't be fixed.
 However in my example, both instances work until i try to log in. I can 
 use the site without database i/o. Both instances work.

 Now, why would web2py (1) raise an exception when working with database 
 (2) because the apache (3) configuration is bad ?

 Sometimes the testing instance fails on login, sometimes it is production 
 instance...

 I'd like to see more about Tamas's problem.


 Well, we're running a very busy WSGI Python sctipt alongside a few web2py 
 instances, and just like with your setup the only error that happens is 
 when we try to log in on a w2p instance that uses the same mysql database 
 as the other WSGI script.

 I've e-mailed Massimo with more details a couple of months ago, and he 
 promised to look into the problem, but he never checked back, and my 
 further inquiries had no answer, so I guess it's not an easy fix :(


-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] Re: Using a recursive select but encountered a broken reference

[Marin Pranjić]

It seems that the problem is because I run two web2py instances.
One runs on domain.com and the other is on testing.domain.com.

When I turn off testing instance, everything works as it should. With 
testing instance turned on, production instance fails.

So... Can someone help me configure two web2py instances on the same port? 
Domains are different.

I'm using apache virtual hosts.

Marin

Dana subota, 2. ožujka 2013. 20:55:17 UTC+1, korisnik Marin Pranjić napisao 
je:

 This happened to an user multiple times. No idea why it happens.

 Error ticket doesn't show much, this is everything I can get from there:

 Traceback (most recent call last):
  File /home/www-data/web2py/gluon/main.py, line 571, in wsgibase
  session._try_store_in_cookie_or_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 738, in 
 _try_store_in_cookie_or_file
  self._try_store_in_file(request, response)
  File /home/www-data/web2py/gluon/globals.py, line 745, in 
 _try_store_in_file
  if not response.session_id or self._forget or self._unchanged():
  File /home/www-data/web2py/gluon/globals.py, line 700, in _unchanged
  session_pickled = cPickle.dumps(dict(self))
  File /usr/lib/python2.7/copy_reg.py, line 74, in _reduce_ex
  getstate = self.__getstate__
  File /home/www-data/web2py/gluon/dal.py, line 7355, in __getattr__
  self.__allocate()
  File /home/www-data/web2py/gluon/dal.py, line 7350, in __allocate
  raise RuntimeError, Using a recursive select but encountered a broken 
 reference: %s %d%(self._table, int(self))
 RuntimeError: Using a recursive select but encountered a broken reference: 
 auth_group 5



 However, auth_group record with id=5 exists. I have no idea why it raises an 
 error.

 I'm using web2py 2.2.1, this is production instance so I can't test with 
 other versions right now.


 Marin



-- 

--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.