(dp1 S'output' p2 S" Set: no tables selected" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p5 sS'code' p6 S' at 0x7f7c905d9f30, file "/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py", line 2>' p7 sS'snapshot' p8 (dp9 S'exception' p10 (dp11 S'__getslice__' p12 S"" p13 sS'text' p14 S'None' p15 sS'__str__' p16 S"" p17 sS'__reduce__' p18 S'' p19 sS'__dict__' p20 S'{}' p21 sS'__sizeof__' p22 S'' p23 sS'message' p24 S"'Set: no tables selected'" p25 sS'__init__' p26 S"" p27 sS'__setattr__' p28 S"" p29 sS'__reduce_ex__' p30 S'' p31 sS'__new__' p32 S'' p33 sS'__format__' p34 S'' p35 sS'__class__' p36 S"" p37 sS'filename' p38 S'None' p39 sS'lineno' p40 S'None' p41 sS'msg' p42 S"'Set: no tables selected'" p43 sS'__doc__' p44 S"'Invalid syntax.'" p45 sS'__getitem__' p46 S"" p47 sS'__setstate__' p48 S'' p49 sS'__getattribute__' p50 S"" p51 sS'print_file_and_line' p52 S'None' p53 sS'args' p54 S"('Set: no tables selected',)" p55 sS'__subclasshook__' p56 S'' p57 sS'offset' p58 S'None' p59 sS'__unicode__' p60 S'' p61 sS'__delattr__' p62 S"" p63 sS'__repr__' p64 S"" p65 sS'__hash__' p66 S"" p67 ssS'evalue' p68 S'Set: no tables selected' p69 sS'request' p70 cgluon.html XML_unpickle p71 (S's\x05k\x00\x00
ajax:
False
application:
Multiform
args:
cid:
None
client:
127.0.0.1
controller:
default
cookies:
session_id_admin:
127.0.0.1-45f002ee-d673-4882-8232-a947f722f0cc
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_highways:
127.0.0.1-570ad9dc-d7c8-4390-a43e-9c3207ed2917
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_multiform:
127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_tiny_website:
2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_welcome:
127.0.0.1-7eb52914-6c77-4487-8920-cde8f07dbed3
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
env:
HTTP_ACCEPT:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING:
gzip, deflate
HTTP_ACCEPT_LANGUAGE:
en-US,en;q=0.5
HTTP_CONNECTION:
keep-alive
HTTP_COOKIE:
session_id_welcome=127.0.0.1-7eb52914-6c77-4487-8920-cde8f07dbed3; session_id_admin=127.0.0.1-45f002ee-d673-4882-8232-a947f722f0cc; session_id_multiform=127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359; session_id_tiny_website="2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2"; session_id_highways=127.0.0.1-570ad9dc-d7c8-4390-a43e-9c3207ed2917
HTTP_HOST:
127.0.0.1:8000
HTTP_REFERER:
http://127.0.0.1:8000/Multiform/default/search
HTTP_UPGRADE_INSECURE_REQUESTS:
1
HTTP_USER_AGENT:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:74.0) Gecko/20100101 Firefox/74.0
PATH_INFO:
/Multiform/default/results
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
35028
REQUEST_METHOD:
GET
SCRIPT_NAME:
SERVER_NAME:
Omen
SERVER_PORT:
8000
SERVER_PROTOCOL:
HTTP/1.1
SERVER_SOFTWARE:
Rocket 1.2.6
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/Multiform', '/home/jdalbey/Dropbox/web2py/applications/tiny_website', '/home/jdalbey/Dropbox/web2py/applications/Highways', '/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f7cbeceb9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
db_sessions:
set(['tiny_website'])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
http_accept:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
http_accept_encoding:
gzip, deflate
http_accept_language:
en-US,en;q=0.5
http_connection:
keep-alive
http_cookie:
session_id_welcome=127.0.0.1-7eb52914-6c77-4487-8920-cde8f07dbed3; session_id_admin=127.0.0.1-45f002ee-d673-4882-8232-a947f722f0cc; session_id_multiform=127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359; session_id_tiny_website="2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2"; session_id_highways=127.0.0.1-570ad9dc-d7c8-4390-a43e-9c3207ed2917
http_host:
127.0.0.1:8000
http_referer:
http://127.0.0.1:8000/Multiform/default/search
http_upgrade_insecure_requests:
1
http_user_agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:74.0) Gecko/20100101 Firefox/74.0
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
path_info:
/Multiform/default/results
query_string:
remote_addr:
127.0.0.1
remote_port:
35028
request_method:
GET
request_uri:
/Multiform/default/results
script_name:
server_name:
Omen
server_port:
8000
server_protocol:
HTTP/1.1
server_software:
Rocket 1.2.6
web2py_path:
/home/jdalbey/Dropbox/web2py
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
wsgi.errors:
<open file '<stderr>', mode 'w' at 0x7f7cc5d67270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f7cbed21980>
wsgi.input:
<socket._fileobject object at 0x7f7c905a2b50>
wsgi.multiprocess:
False
wsgi.multithread:
True
wsgi.run_once:
False
wsgi.url_scheme:
http
wsgi.version:
1
0
wsgi_errors:
<open file '<stderr>', mode 'w' at 0x7f7cc5d67270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f7cbed21980>
wsgi_input:
<socket._fileobject object at 0x7f7c905a2b50>
wsgi_multiprocess:
False
wsgi_multithread:
True
wsgi_run_once:
False
wsgi_url_scheme:
http
wsgi_version:
1
0
extension:
html
folder:
/home/jdalbey/Dropbox/web2py/applications/Multiform
function:
results
global_settings:
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/Multiform', '/home/jdalbey/Dropbox/web2py/applications/tiny_website', '/home/jdalbey/Dropbox/web2py/applications/Highways', '/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f7cbeceb9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
db_sessions:
set(['tiny_website'])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
is_https:
False
is_local:
True
is_restful:
False
is_scheduler:
False
is_shell:
False
method:
GET
now:
datetime.datetime(2020, 3, 19, 16, 1, 13, 562106)
raw_args:
raw_extension:
None
url:
/Multiform/default/results
utcnow:
datetime.datetime(2020, 3, 19, 23, 1, 13, 562153)
wsgi:
<gluon.main.LazyWSGI object at 0x7f7c913b6410>
' tRp72 sS'frames' p73 (lp74 (dp75 S'file' p76 S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py' p77 sS'dump' p78 (dp79 S'environment' p80 S"{'A': , 'ANY_OF': , 'ASSIGNJS': , 'B': , 'BEAUTIFY': , 'BODY': , 'BR': , 'BUTTON': , 'CAT': , 'CENTER': , ...}" p81 sS'ccode' p82 S' at 0x7f7c905d9f30, file "/...ations/Multiform/controllers/default.py", line 2>' p83 ssS'lnum' p84 I219 sS'lines' p85 (dp86 I214 S' if environment is None:' p87 sI215 S' environment = {}' p88 sI216 S" environment['__file__'] = layer" p89 sI217 S" environment['__name__'] = '__restricted__'" p90 sI218 S' try:' p91 sI219 S' exec(ccode, environment)' p92 sI220 S' except HTTP:' p93 sI221 S' raise' p94 sI222 S' except RestrictedError:' p95 sI223 S' # do not encapsulate (obfuscate) the original RestrictedError' p96 ssS'call' p97 S'(ccode= at 0x7f7c905d9f30, file "/...ations/Multiform/controllers/default.py", line 2>, environment={\'A\': , \'ANY_OF\': , \'ASSIGNJS\': , \'B\': , \'BEAUTIFY\': , \'BODY\': , \'BR\': , \'BUTTON\': , \'CAT\': , \'CENTER\': , ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py\', scode= at 0x7f7c905d9f30, file "/...ations/Multiform/controllers/default.py", line 2>)' p98 sS'func' p99 S'restricted' p100 sa(dp101 g76 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p102 sg78 (dp103 sg84 I209 sg85 (dp104 I198 S' return newID' p105 sI199 S' else:' p106 sI200 S" return 'T'+routeNum+'AA' # For a non-existing route" p107 sI201 S'' sI202 S'# Convert checkbox value to YES/NO' p108 sI203 S'def getCheckbox(ckBox):' p109 sI204 S' if (ckBox == "on"):' p110 sI205 S' return "YES"' p111 sI206 S' else:' p112 sI207 S' return "NO"' p113 ssg97 S'()' p114 sg99 S'' p115 sa(dp116 g76 S'/home/jdalbey/Dropbox/web2py/gluon/globals.py' p117 sg78 (dp118 S'self' p119 S'undefined' p120 sS'f' S'' p121 ssg84 I421 sg85 (dp122 I416 S" self.flash = '' # used by the default view layout" p123 sI417 S' self.meta = Storage() # used by web2py_ajax.html' p124 sI418 S' self.menu = [] # used by the default view layout' p125 sI419 S' self.files = [] # used by web2py_ajax.html' p126 sI420 S' self._vars = None' p127 sI421 S' self._caller = lambda f: f()' p128 sI422 S' self._view_environment = None' p129 sI423 S' self._custom_commit = None' p130 sI424 S' self._custom_rollback = None' p131 sI425 S" self.generic_patterns = ['*']" p132 ssg97 S'(f=)' p133 sg99 S'' p134 sa(dp135 g76 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p136 sg78 (dp137 S'global db' p138 S'' p139 sS'db.closures' p140 S'' p141 sS').select' p142 g120 sS'db.closures.ALL' p143 S'' p144 sS'hwy' p145 g120 ssg84 I53 sg85 (dp146 I48 S' msg = "route = " + session.route' p147 sI49 S' elif (len(session.startdate) == 10):' p148 sI50 S' hwy = db(db.closures.startdate >= session.startdate).select()' p149 sI51 S' msg = "Start Date >= " + session.startdate' p150 sI52 S' else:' p151 sI53 S' hwy = db(db.closures.ALL).select()' p152 sI54 S' msg = "ALL"' p153 sI55 S' count = len(hwy)' p154 sI56 S' # Show the results in table format. Get the radio call number from supervisor name lookup' p155 sI57 S" header = THEAD(TR(TH(''), TH('DTM',BR(),'Area'), TH('Closure ID/',BR(),'Log No.'),TH('Route & Dir/',BR(),'Type of Closure'),TH('Start Date/',BR(),'End Date/',BR(),'Est. Delay'),TH('Facility'),TH('Limits'),TH('Work'), TH('TMP:',BR(),'Cozeep/',BR(),'Detour'),TH('Requestor/',BR(),'Radio Call No.')))" p156 ssg97 S'()' p157 sg99 S'results' p158 sa(dp159 g76 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p160 sg78 (dp161 S'self.query' p162 S'' p163 sS'adapter.select' p164 S'>' p165 sS'fields' p166 S'[]' p167 sS'adapter' p168 S'' p169 sS'attributes' p170 g21 sS'self' p171 S'' p172 ssg84 I2395 sg85 (dp173 I2390 S" attributes.get('join', None)," p174 sI2391 S" attributes.get('left', None)," p175 sI2392 S" attributes.get('orderby', None)," p176 sI2393 S" attributes.get('groupby', None))" p177 sI2394 S' fields = adapter.expand_all(fields, tablenames)' p178 sI2395 S' return adapter.select(self.query, fields, attributes)' p179 sI2396 S'' sI2397 S' def iterselect(self, *fields, **attributes):' p180 sI2398 S' adapter = self.db._adapter' p181 sI2399 S' tablenames = adapter.tables(self.query,' p182 ssg97 S'(self=, *fields=[], **attributes={})' p183 sg99 S'select' p184 sa(dp185 g76 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/sqlite.py' p186 sg78 (dp187 S'fields' p188 S'[]' p189 sS'self' p190 S'' p191 sS').select' p192 S'>' p193 sS'attributes' p194 g21 sS'query' p195 S'' p196 sS'builtinsuper' p197 S"" p198 sS'global SQLite' p199 S"" p200 ssg84 I82 sg85 (dp201 I77 S" self.execute('PRAGMA foreign_keys=ON;')" p202 sI78 S'' sI79 S' def select(self, query, fields, attributes):' p203 sI80 S" if attributes.get('for_update', False) and 'cache' not in attributes:" p204 sI81 S" self.execute('BEGIN IMMEDIATE TRANSACTION;')" p205 sI82 S' return super(SQLite, self).select(query, fields, attributes)' p206 sI83 S'' sI84 S' def delete(self, table, query):' p207 sI85 S' db = self.db' p208 sI86 S' deleted = [x[table._id.name] for x in db(query).select(table._id)]' p209 ssg97 S'(self=, query=, fields=[], attributes={})' p210 sg99 g184 sa(dp211 g76 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p212 sg78 (dp213 S'fields' p214 S'[]' p215 sS'self' p216 S'' p217 sS'self._select_wcols' p218 S'>' p219 sS'sql' p220 g120 sS'query' p221 S'' p222 sS'colnames' p223 g120 sS'attributes' p224 g21 ssg84 I758 sg85 (dp225 I753 S' time_expire)' p226 sI754 S' ret._restore_fields(fields)' p227 sI755 S' return ret' p228 sI756 S'' sI757 S' def select(self, query, fields, attributes):' p229 sI758 S' colnames, sql = self._select_wcols(query, fields, **attributes)' p230 sI759 S" cache = attributes.get('cache', None)" p231 sI760 S" if cache and attributes.get('cacheable', False):" p232 sI761 S' return self._cached_select(' p233 sI762 S' cache, sql, fields, attributes, colnames)' p234 ssg97 S'(self=, query=, fields=[], attributes={})' p235 sg99 g184 sa(dp236 g76 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p237 sg78 (dp238 S'builtinSyntaxError' p239 S"" p240 ssg84 I605 sg85 (dp241 I608 S' # [Note - gi0baro] I think this should be removed since useless?' p242 sI609 S' # should affect only NoSQL?' p243 sI600 S' #: remove outer scoped tables if needed' p244 sI601 S' for item in outer_scoped:' p245 sI602 S' # FIXME: check for name conflicts' p246 sI603 S' tablemap.pop(item, None)' p247 sI604 S' if len(tablemap) < 1:' p248 sI605 S" raise SyntaxError('Set: no tables selected')" p249 sI606 S' query_tables = list(tablemap)' p250 sI607 S' #: check for_update argument' p251 ssg97 S'(self=, query=, fields=[], left=False, join=False, distinct=False, orderby=False, groupby=False, having=False, limitby=False, orderby_on_limitby=True, for_update=False, outer_scoped=[], required=None, cache=None, cacheable=None, processor=None)' p252 sg99 S'_select_wcols' p253 sasS'pyver' p254 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p255 sS'session' p256 g71 (S'sR\x06\x00\x00
chosenid:
None
closureid:
direction:
enddate:
last_orderby:
None
last_query:
db.closures.id>0
lognum:
route:
startdate:
statuser:
Joe
statustype:
1022T5AA
username:
a
' tRp257 sS'etype' p258 S"" p259 sS'date' p260 S'Thu Mar 19 16:01:14 2020' p261 sS'response' p262 g71 (S'sW\x1d\x00\x00
body:
<cStringIO.StringO object at 0x7f7cb4373ef0>
cookies:
session_id_multiform:
127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359
comment:
domain:
expires:
httponly:
max-age:
path:
/
samesite:
secure:
version:
delimiters:
{{
}}
files:
flash:
form_label_separator:
:
formstyle:
table3cols
generic_patterns:
*
headers:
X-Powered-By:
web2py
menu:
Home
False
/Multiform/default/home
List
False
/Multiform/default/list
Search
False
/Multiform/default/search
Request
False
/Multiform/default/submit
meta:
author:
Author
description:
describe your app
keywords:
keyword
models_to_run:
^\\w+\\.py$
^default/\\w+\\.py$
^default/results/\\w+\\.py$
postprocessing:
session_client:
127.0.0.1
session_cookie_compression_level:
None
session_cookie_expires:
None
session_data_name:
session_data_multiform
session_file:
<open file '/home/jdalbey/Dropbox/web2py/applications/Multiform/sessions/17d/0fd/127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359', mode 'rb+' at 0x7f7c9026f6f0>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/Multiform/sessions/127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359
session_hash:
785e848da96ed2e905f8229b01b93abd
session_id:
127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359
session_id_name:
session_id_multiform
session_locked:
True
session_masterapp:
Multiform
session_new:
False
session_storage_type:
file
status:
200
subtitle:
subtitle customize me!
title:
Multiform
view:
default/results.html
' tRp263 sS'locals' p264 (dp265 S'orderby_on_limitby' p266 S'True' p267 sS'orderby' p268 S'False' p269 sS'cacheable' p270 S'None' p271 sS'join' p272 g269 sS'tablemap' p273 g21 sS'outer_scoped' p274 S'[]' p275 sS'fields' p276 S'[]' p277 sS'self' p278 S'' p279 sS'cache' p280 S'None' p281 sS'limitby' p282 g269 sS'required' p283 S'None' p284 sS'distinct' p285 g269 sS'for_update' p286 g269 sS'groupby' p287 g269 sS'query' p288 S'' p289 sS'processor' p290 S'None' p291 sS'having' p292 g269 sS'left' p293 g269 sssS'traceback' p294 S'Traceback (most recent call last):\n File "/home/jdalbey/Dropbox/web2py/gluon/restricted.py", line 219, in restricted\n exec(ccode, environment)\n File "/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py", line 209, in \n File "/home/jdalbey/Dropbox/web2py/gluon/globals.py", line 421, in \n self._caller = lambda f: f()\n File "/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py", line 53, in results\n hwy = db(db.closures.ALL).select()\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 2395, in select\n return adapter.select(self.query, fields, attributes)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/sqlite.py", line 82, in select\n return super(SQLite, self).select(query, fields, attributes)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 758, in select\n colnames, sql = self._select_wcols(query, fields, **attributes)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 605, in _select_wcols\n raise SyntaxError(\'Set: no tables selected\')\nSyntaxError: Set: no tables selected\n' p295 s.