Can you post the complete instructions for the lines listed in the stack 
trace?  At least for the one in your code?

On Tuesday, June 23, 2020 at 10:10:32 AM UTC-4, Diego Tostes wrote:
>
>
> I am getting this error:
>
> Traceback (most recent call last):
>   File "/home/rebec/web2py/gluon/restricted.py", line 227, in restricted
>     exec ccode in environment
>   File "/home/rebec/web2py/applications/lavanderia/views/appadmin.html" 
> <https://edobhi.com/admin/edit/lavanderia/views/appadmin.html>, line 169, in 
> <module>
>     dict( ratio=ram['ratio'], hits=ram['hits'], misses=ram['misses']))}}
>   File "/home/rebec/web2py/gluon/sqlhtml.py", line 3274, in __init__
>     "Column %s not found (SQLTABLE)" % colname)
> KeyError: 'Column auth_user.id not found (SQLTABLE)'
>
>
> But when i check the DB:
>
> mysql> show columns in 
> auth_user;+--------------------+--------------+------+-----+---------+----------------+|
>  Field              | Type         | Null | Key | Default | Extra          
> |+--------------------+--------------+------+-----+---------+----------------+|
>  id                 | int(11)      | NO   | PRI | NULL    | auto_increment || 
> first_name         | varchar(128) | YES  |     | NULL    |                || 
> last_name          | varchar(128) | YES  |     | NULL    |                || 
> email              | varchar(512) | YES  |     | NULL    |                || 
> password           | varchar(512) | YES  |     | NULL    |                || 
> registration_key   | varchar(512) | YES  |     | NULL    |                || 
> reset_password_key | varchar(512) | YES  |     | NULL    |                || 
> registration_id    | varchar(512) | YES  |     | NULL    |                
> |+--------------------+--------------+------+-----+---------+----------------+8
>  rows in set (0.00 sec)
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ceb32c69-2363-4ee0-a32c-8cceaa975e83o%40googlegroups.com.

Reply via email to