[web2py] Re: web2py 2.24.1 released

2023-05-06 Thread Peter
Thanks

četvrtak, 23. mart 2023. u 06:20:20 UTC+1 Massimo Di Pierro je napisao/la:

> Hello everybody,
>
> web2py 2.24.1 has been released.
>
> Thanks to Leonel, Cem, and Mark for bug fixes including:
> - handling corrupt disk cache
> - broken application packaging
> - compare function logic
>
>
>

-- 
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/fd5b9cc8-f61a-4d28-813a-fe9c9f474be6n%40googlegroups.com.


[web2py] Re: Messy views in Chrome after crash

2023-05-06 Thread Dave S
Weird copy-paste error on the first paragraph, which should read:

Every now and then, my older laptop says it can't handle umpteen dozen tabs 
any more, it's done swapping, and it nosedives into a blue screen.  This 
laptop is also hosting the dev versions of my sites, using the in-box 
rocket server.   Window 10+ environment.

On Saturday, May 6, 2023 at 4:31:28 PM UTC-7 Dave S wrote:

> Every now and then, my older laptop says it can't handle umpteen dozen 
> tabs any more, it's done swapping, and it nosedives into a blue screen.  
> This laptop is also hosting the dev versions of my sites, using the in-box 
> rocket server.   Window 10+ environment.
>
> After this happens and I restart the system, the server, and the browser, 
> Opera (and Firefox, too, I think) are happy to resume and everything 
> appears fine.  Chrome resumes, but many of the tabs from my web2py instance 
> display messed up ... bits appear in scambled places, like a jigsaw puzzle 
> waiting to be assembled, and there are black blocks in various places.  
> Sometimes I can see the appropriate contents by highlighting a region, and 
> a field in a form usually behaves normally while I'm entering data, but 
> often is glitched as soon as I change focus.
>
> This happens to relatively simple pages where I use SQLFORM or SQLTABLE, 
> and it happens to the admin pages (include viewing a ticket).
>
> Clearing the browser cache doesn't fix this.  Is there a place where 
> rocket has cached data that I should be clearing?  Oh, Chrome does have the 
> most tabs open, and Opera a lot fewer, but about the same number of tabs 
> from my sites.
>
> Thanks
>
> Dave S
> /dps
>

-- 
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/d4a65ec2-366c-4754-9f88-d58444abee08n%40googlegroups.com.


[web2py] Messy views in Chrome after crash

2023-05-06 Thread Dave S
Every now and then, my older laptop says it can't handle umpteen dozen tabs 
any more, it's done swapping, and it nosedives into a blue screen.  This 
laptop is also hosting the dev versions of my sites, using the in-box 
rocket server.   Window 10+ environment.

After this happens and I restart the system, the server, and the browser, 
Opera (and Firefox, too, I think) are happy to resume and everything 
appears fine.  Chrome resumes, but many of the tabs from my web2py instance 
display messed up ... bits appear in scambled places, like a jigsaw puzzle 
waiting to be assembled, and there are black blocks in various places.  
Sometimes I can see the appropriate contents by highlighting a region, and 
a field in a form usually behaves normally while I'm entering data, but 
often is glitched as soon as I change focus.

This happens to relatively simple pages where I use SQLFORM or SQLTABLE, 
and it happens to the admin pages (include viewing a ticket).

Clearing the browser cache doesn't fix this.  Is there a place where rocket 
has cached data that I should be clearing?  Oh, Chrome does have the most 
tabs open, and Opera a lot fewer, but about the same number of tabs from my 
sites.

Thanks

Dave S
/dps

-- 
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/bce21d64-e67b-454e-908e-fbfe32283c60n%40googlegroups.com.


[web2py] Re: Exceptional oddity in query processing

2023-05-06 Thread Dave S
Added missing frame info

On Saturday, May 6, 2023 at 3:51:43 PM UTC-7 Dave S wrote:

Why does this


   - 
   
   *File 
   
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
 
   in _select_aux at line 865* code arguments variables
   Function argument list
   
   (self=, sql='SELECT "badlist"."id", 
   "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", 
   "badlist"."burl";', fields=[, 
   , , 
   ], attributes={'orderby': 
   }, colnames=['badlist.id', 
   'badlist.burl', 'badlist.tags', 'badlist.PostDate'])
   - 
   
   turn into this?
   

   - 
   
   *File 
   
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
 
   in _select_aux_execute at line 859* code arguments variables
   Function argument list
   
   (self=, sql='SELECT "badlist"."id", 
   "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", 
   "badlist"."burl";')
   
 

The relevant controller code is 

r = db(db.badlist.PostDate != None)
rows=db(r).select(orderby=db.badlist.tags|db.badlist.burl)

The exception is


File 
"C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py",
 
line 468, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
sqlite3.OperationalError: near "<": syntax error

-- 
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/d82b85b9-8ec9-4cb9-807b-a3b364cec75en%40googlegroups.com.


[web2py] Exceptional oddity in query processing

2023-05-06 Thread Dave S
Why does this


   - 
   
   *File 
   
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
 
   in _select_aux at line 865* code arguments variables
   Function argument list
   
   (self=, sql='SELECT "badlist"."id", 
   "badlist"."burl", "badlis...LL)> ORDER BY "badlist"."tags", 
   "badlist"."burl";', fields=[, 
   , , 
   ], attributes={'orderby': 
   }, colnames=['badlist.id', 'badlist.burl', 
   'badlist.tags', 'badlist.PostDate'])
   - 
   
   turn into this?
   
The relevant controller code is 

r = db(db.badlist.PostDate != None)
rows=db(r).select(orderby=db.badlist.tags|db.badlist.burl)

The exception is


File 
"C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py",
 
line 468, in execute
rv = self.cursor.execute(command, *args[1:], **kwargs)
sqlite3.OperationalError: near "<": syntax error

-- 
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/e2be99a7-d08f-4400-a921-d195df4a71d8n%40googlegroups.com.