Trying to define a table with IS_IN_SET() on a string field, we get the
exception
<class 'sqlite3.OperationalError'> 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),
"tags" CHAR(<pydal.validators.IS_IN_SET object at 0x000001290744CD30>),
"originalid" INTEGER,
"postdate" DATE
);
and the exception traceback shows
[...]
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\base.py
in define_table at line 679*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\base.py
in lazy_define_table at line 716*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
in create_table at line 943*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\migrator.py
in create_table at line 337*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
in create_sequence_and_triggers at line 1027*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\__init__.py
in wrap at line 69*
-
*File
C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py
in execute at line 468*
(self=<pydal.adapters.sqlite.SQLite object>, *args=('CREATE TABLE
"babbleqpic"(\n "id" INTEGER PRIMARY...\n "originalid" INTEGER,\n
"postdate" DATE\n);',), **kwargs={})
-
Function argument list
-
(self=<pydal.adapters.sqlite.SQLite object>, *args=('CREATE TABLE
"babbleqpic"(\n "id" INTEGER PRIMARY...\n "originalid" INTEGER,\n
"postdate" DATE\n);',), **kwargs={})
web2py™
Version 2.22.5-stable+timestamp.2022.06.04.18.13.51
Python
Python 3.10.7:
C:\Users\Dave\AppData\Local\Programs\Python\Python310\python.exe (prefix:
C:\Users\Dave\AppData\Local\Programs\Python\Python310)
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/0a2962f8-1dd4-426f-aff2-03dc18c84d90n%40googlegroups.com.
