Error ticket for "myapp"Ticket ID
127.0.0.1.2017-03-12.21-35-27.2a6dfbe0-ddb4-43db-9e3d-e43542a6c1f2
<type 'exceptions.KeyError'> 'Column my_table.id not found (SQLTABLE)'
Version
web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Python Python 2.7.13: /usr/local/opt/python/bin/python2.7 (prefix:
/usr/local/Cellar/python/2.7.13/Frameworks/Python.framework/Versions/2.7)
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
Traceback (most recent call last):
File "/code/web-dev/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
File "/code/web-dev/web2py/applications/toplineups/views/appadmin.html"
<http://127.0.0.1:8000/admin/default/edit/toplineups/views/appadmin.html>, line
173, in <module>
{{if object_stats:}}
File "/code/web-dev/web2py/gluon/sqlhtml.py", line 3274, in __init__
"Column %s not found (SQLTABLE)" % colname)
KeyError: 'Column nba_match.id not found (SQLTABLE)'
Error snapshot [image: help]
<http://127.0.0.1:8000/admin/default/ticket/toplineups/127.0.0.1.2017-03-12.21-35-27.2a6dfbe0-ddb4-43db-9e3d-e43542a6c1f2#>
<type 'exceptions.KeyError'>('Column my_table.id not found (SQLTABLE)')
inspect attributes
Frames
-
*File /code/web-dev/web2py/gluon/restricted.py in restricted at line 227*
code arguments variables
-
*File /code/web-dev/web2py/applications/myapp/views/appadmin.html in
<module> at line 173* code arguments variables
-
*File /code/web-dev/web2py/gluon/sqlhtml.py in __init__ at line 3274*
code arguments variables
Function argument list
(self=<gluon.sqlhtml.SQLTABLE object>, sqlrows=<Rows (100)>,
linkto=<function <lambda>>, upload='/myapp/appadmin/download/db',
orderby=True, headers={}, truncate=16, columns=['nba_match.id',
'my_table.field1', 'my_table.field2', 'my_table.field3', 'my_table.field4',
'my_table.field5', 'my_table.field6'], th_link='', extracolumns=None,
selectid=None, renderstyle=False, cid=None, colgroup=False,
**attributes={'_class': 'sortable'})
Code listing
3269.
3270.
3271.
3272.
3273.
3274.
3275.
3276.
3277.
3278.
r = record._extra[colname]
row.append(TD(r))
continue
else:
raise KeyError(
"Column %s not found (SQLTABLE)" )
(tablename, fieldname) = matched_column_field.groups()
colname = tablename + '.' + fieldname
try:
field = sqlrows.db[tablename][fieldname]
Variables
colname 'my_table.id'
Context
On Sunday, March 12, 2017 at 8:30:50 PM UTC-4, Anthony wrote:
>
> On Sunday, March 12, 2017 at 7:27:08 PM UTC-4, LoveWeb2py wrote:
>>
>> Keep getting this error for all of my tables!! What is going on?
>>
>> What information would be helpful for me to post to get help?
>>
>
> The usual -- code and traceback.
>
--
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.
For more options, visit https://groups.google.com/d/optout.
