[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-04 Thread José Leite
When the code was initially done we were not sure if we needed more than one entry in the list but we really ended up needing just one in this case. Thanks for your explanation. sexta-feira, 4 de Agosto de 2017 às 23:38:15 UTC+1, Anthony escreveu: > > On Friday, August 4, 2017 at 11:03:04 AM UTC

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-04 Thread Anthony
On Friday, August 4, 2017 at 11:03:04 AM UTC-4, José Leite wrote: > > I changed the Syntax to: > > db.intro_lifestyles.tourism_segment_id.contains(segment.id) > I assumed you wanted to find records that include segment.id as the one and only element in the list, in which case you should use my qu

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-04 Thread Massimo Di Pierro
Yes this is correct. The other syntax worked by accident. On Friday, 4 August 2017 10:03:04 UTC-5, José Leite wrote: > > I changed the Syntax to: > > db.intro_lifestyles.tourism_segment_id.contains(segment.id) > > and it is now working. > > Thanks a lot that would be a solution too... > > quinta-f

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-04 Thread José Leite
Hello Dave, no this problem appeared on the production environment (Ubuntu 14.04, Apache 2 mod_wsgi and now with web2py 2.15.2). But it is already solved with contains() instead of ==. It seems a few things changes in version 2.15.2 and some syntaxes are no longer supported. I've had the help of

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-04 Thread José Leite
I changed the Syntax to: db.intro_lifestyles.tourism_segment_id.contains(segment.id) and it is now working. Thanks a lot that would be a solution too... quinta-feira, 3 de Agosto de 2017 às 23:18:23 UTC+1, Anthony escreveu: > > Have you tried: > > db.intro_lifestyles.tourism_segment_id == [segm

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-03 Thread Dave S
On Thursday, August 3, 2017 at 2:57:45 PM UTC-7, José Leite wrote: > > I have just updated to web2py 2.15.2 and my site www.holidaysenses.com became > unstable (unusable). > > Line codes like: > image = db(db.intro_lifestyles.tourism_segment_id == segment.id > ).select().first() > or > image = d

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

2017-08-03 Thread Anthony
Have you tried: db.intro_lifestyles.tourism_segment_id == [segment.id] Your original code may have worked in the older version, but I don't think that syntax was officially supported. Anthony On Thursday, August 3, 2017 at 5:57:45 PM UTC-4, José Leite wrote: > > I have just updated to web2py 2