[web2py:36179] How can I avoid this error in pagination?

[drayco]

This is my function

@auth.requires_membership('Capturista')
def lee_notas():
    if len(request.args): page=int(request.args[0])
    else: page=0
    items_per_page=25
    limitby=(page*items_per_page,(page+1)*items_per_page+1)
    Capturista = db(db.capturistas.creadoPor==auth.user.id).select()
    notas=db((db.notas.entregado==False)&
(db.notas.vendedor==db.vendedores.id)&
(db.vendedores.regional==Capturista[0].regional)).select
(db.notas.id,db.notas.nota, \
 
db.notas.folio,db.notas.armazon1,db.notas.lente1,db.notas.lc4,db.notas.total,db.notas.anticipo,db.notas.pago,db.notas.saldo,db.notas.vendedor,db.notas.optometrista,db.notas.creadoEl,orderby=~db.notas.nota,limitby=limitby)
    return dict(notas=notas,page=page,items_per_page=items_per_page)

This is my view

{{extend 'layout.html'}}
<h4>Notas de Óptica Luz</h4>
[ {{=A('Crear 1(una) Nota de Venta', _href=URL(r=request,
f='crea_nota'))}} ]
<ul>{{for i,nota in enumerate(notas):}}
{{if i==items_per_page: break}}
{{=LI(A('Nota ',nota.nota,' Folio ',nota.folio,' [',db.armazones
[nota.armazon1].marca,' ',db.armazones[nota.armazon1].caract1,' &
',db.lentes[nota.lente1].material,' ',db.lentes[nota.lente1].tipo,'
',db.lentes[nota.lente1].tecnoVisual,' ',db.lentes
[nota.lente1].tratamiento,'] <',db.lentesContacto[nota.lc4].marca,'> T
$',nota.total,' - A$',nota.anticipo,' - P$',nota.pago,' = S
$',nota.saldo,' {',db.vendedores[nota.vendedor].names,' &
',db.optometristas[nota.optometrista].names,'}',' del ',nota.creadoEl,
_href=URL(r=request, f='show_nota', args=nota.id)))}}
{{pass}}</ul>
{{if page:}}
<a href="{{=URL(r=request,args=[page-1])}}">Anterior</a>
{{pass}}
{{if len(notas)>items_per_page:}}
<a href="{{=URL(r=request,args=[page+1])}}">Siguiente</a>
{{pass}}

When items_per_page=25 everything is ok
When I put items_per_page=50 Web2py give me this error:

Traceback (most recent call last):
  File "/media/RESPALDO/web2py/gluon/restricted.py", line 184, in
restricted
    exec ccode in environment
  File "/media/RESPALDO/web2py/applications/seccion36/views/default/
lee_notas.html", line 38, in <module>
  File "/media/RESPALDO/web2py/gluon/globals.py", line 112, in write
    self.body.write(xmlescape(data))
  File "/media/RESPALDO/web2py/gluon/html.py", line 103, in xmlescape
    return data.xml()
  File "/media/RESPALDO/web2py/gluon/html.py", line 517, in xml
    (fa, co) = self._xml()
  File "/media/RESPALDO/web2py/gluon/html.py", line 508, in _xml
    self.components])
  File "/media/RESPALDO/web2py/gluon/html.py", line 103, in xmlescape
    return data.xml()
  File "/media/RESPALDO/web2py/gluon/html.py", line 517, in xml
    (fa, co) = self._xml()
  File "/media/RESPALDO/web2py/gluon/html.py", line 508, in _xml
    self.components])
  File "/media/RESPALDO/web2py/gluon/html.py", line 103, in xmlescape
    return data.xml()
  File "/media/RESPALDO/web2py/gluon/sql.py", line 1370, in
__getattr__
    self.__allocate()
  File "/media/RESPALDO/web2py/gluon/sql.py", line 1365, in __allocate
    raise Exception, "undefined record"
Exception: undefined record

--

You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.