[web2py] Important! web2py forzen and master py3 only

2024-10-17 Thread Massimo Di Pierro
Hello everybody. As announced some time ago web2py for python 2 will be frozen to version 2.27.1. The latest master has been 100% ported to python3.11 and there is no more python2 code. It uses the latest yatl, latest pydal, latest pymysql. Many bugs have been fixed in the process and some hav

[web2py] Re: define_table fails with IS_IN_SET() -- barfs an exception

2024-10-17 Thread Dave S
Never mind ... I forgot the "requires =" /dps On Thursday, October 17, 2024 at 4:10:03 PM UTC-7 Dave S wrote: > Trying to define a table with IS_IN_SET() on a string field, we get the > exception > near "<": syntax error > > sql.log shows why: > CREATE TABLE "badqpic"( > "id" INTEGER PRI

[web2py] define_table fails with IS_IN_SET() -- barfs an exception

2024-10-17 Thread Dave S
Trying to define a table with IS_IN_SET() on a string field, we get the exception near "<": syntax error sql.log shows why: CREATE TABLE "badqpic"( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "isrl" CHAR(512), "isrl_short" CHAR(512), "tmpname" CHAR(512), "tmppext" CHAR(512),