(dp1 S'output' p2 S" global name 'date' is not defined" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p5 sS'code' p6 S' at 0x7f7c9049a9b0, 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'__str__' p14 S"" p15 sS'__reduce__' p16 S'' p17 sS'__dict__' p18 S'{}' p19 sS'message' p20 S'"global name \'date\' is not defined"' p21 sS'__sizeof__' p22 S'' p23 sS'__init__' p24 S"" p25 sS'__setattr__' p26 S"" p27 sS'__reduce_ex__' p28 S'' p29 sS'__new__' p30 S'' p31 sS'__format__' p32 S'' p33 sS'__class__' p34 S"" p35 sS'__doc__' p36 S"'Name not found globally.'" p37 sS'__getitem__' p38 S"" p39 sS'__setstate__' p40 S'' p41 sS'__getattribute__' p42 S"" p43 sS'args' p44 S'("global name \'date\' is not defined",)' p45 sS'__subclasshook__' p46 S'' p47 sS'__unicode__' p48 S'' p49 sS'__delattr__' p50 S"" p51 sS'__repr__' p52 S"" p53 sS'__hash__' p54 S"" p55 ssS'evalue' p56 S"global name 'date' is not defined" p57 sS'request' p58 cgluon.html XML_unpickle p59 (S's-l\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_CACHE_CONTROL:
max-age=0
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:
33744
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_cache_control:
max-age=0
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:
33744
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 0x7f7c91189d50>
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 0x7f7c91189d50>
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, 15, 53, 59, 56790)
raw_args:
raw_extension:
None
url:
/Multiform/default/results
utcnow:
datetime.datetime(2020, 3, 19, 22, 53, 59, 56806)
wsgi:
<gluon.main.LazyWSGI object at 0x7f7c9053c750>
' tRp60 sS'frames' p61 (lp62 (dp63 S'file' p64 S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py' p65 sS'dump' p66 (dp67 S'environment' p68 S"{'A': , 'ANY_OF': , 'ASSIGNJS': , 'B': , 'BEAUTIFY': , 'BODY': , 'BR': , 'BUTTON': , 'CAT': , 'CENTER': , ...}" p69 sS'ccode' p70 S' at 0x7f7c9049a9b0, file "/...ations/Multiform/controllers/default.py", line 2>' p71 ssS'lnum' p72 I219 sS'lines' p73 (dp74 I214 S' if environment is None:' p75 sI215 S' environment = {}' p76 sI216 S" environment['__file__'] = layer" p77 sI217 S" environment['__name__'] = '__restricted__'" p78 sI218 S' try:' p79 sI219 S' exec(ccode, environment)' p80 sI220 S' except HTTP:' p81 sI221 S' raise' p82 sI222 S' except RestrictedError:' p83 sI223 S' # do not encapsulate (obfuscate) the original RestrictedError' p84 ssS'call' p85 S'(ccode= at 0x7f7c9049a9b0, 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 0x7f7c9049a9b0, file "/...ations/Multiform/controllers/default.py", line 2>)' p86 sS'func' p87 S'restricted' p88 sa(dp89 g64 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p90 sg66 (dp91 sg72 I206 sg73 (dp92 I195 S' return newID' p93 sI196 S' else:' p94 sI197 S" return 'T'+routeNum+'AA' # For a non-existing route" p95 sI198 S'' sI199 S'# Convert checkbox value to YES/NO' p96 sI200 S'def getCheckbox(ckBox):' p97 sI201 S' if (ckBox == "on"):' p98 sI202 S' return "YES"' p99 sI203 S' else:' p100 sI204 S' return "NO"' p101 ssg85 S'()' p102 sg87 S'' p103 sa(dp104 g64 S'/home/jdalbey/Dropbox/web2py/gluon/globals.py' p105 sg66 (dp106 S'self' p107 S'undefined' p108 sS'f' S'' p109 ssg72 I421 sg73 (dp110 I416 S" self.flash = '' # used by the default view layout" p111 sI417 S' self.meta = Storage() # used by web2py_ajax.html' p112 sI418 S' self.menu = [] # used by the default view layout' p113 sI419 S' self.files = [] # used by web2py_ajax.html' p114 sI420 S' self._vars = None' p115 sI421 S' self._caller = lambda f: f()' p116 sI422 S' self._view_environment = None' p117 sI423 S' self._custom_commit = None' p118 sI424 S' self._custom_rollback = None' p119 sI425 S" self.generic_patterns = ['*']" p120 ssg85 S'(f=)' p121 sg87 S'' p122 sa(dp123 g64 S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/default.py' p124 sg66 (dp125 S'global session' p126 S"" p127 sS'db.closures' p128 S'' p129 sS'session.startdate' p130 S"''" p131 sS').select' p132 g108 sS'date' p133 g108 sS'hwy' p134 g108 sS'global db' p135 S'' p136 sS'db.closures.startdate' p137 S'' p138 ssg72 I50 sg73 (dp139 I45 S' msg = "Closure ID = " + session.closureid' p140 sI46 S' elif (len(session.route) != 0):' p141 sI47 S' hwy = db(db.closures.route == session.route).select()' p142 sI48 S' msg = "route = " + session.route' p143 sI49 S' else:' p144 sI50 S' hwy = db(date(db.closures.startdate) >= date(session.startdate)).select()' p145 sI51 S' msg = "Start Date >= " + session.startdate' p146 sI52 S' count = len(hwy)' p147 sI53 S' # Show the results in table format. Get the radio call number from supervisor name lookup' p148 sI54 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.')))" p149 ssg85 S'()' p150 sg87 S'results' p151 sasS'pyver' p152 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p153 sS'session' p154 g59 (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
' tRp155 sS'etype' p156 S"" p157 sS'date' p158 S'Thu Mar 19 15:53:59 2020' p159 sS'response' p160 g59 (S'sW\x1d\x00\x00
body:
<cStringIO.StringO object at 0x7f7c911c98f0>
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 0x7f7c913bd780>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/Multiform/sessions/127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359
session_hash:
de9d6d588231d24f316f7d23b8a1df51
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
' tRp161 sS'locals' p162 (dp163 ssS'traceback' p164 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 206, 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 50, in results\n hwy = db(date(db.closures.startdate) >= date(session.startdate)).select()\nNameError: global name \'date\' is not defined\n' p165 s.