Somehow the table in db contains the field but the model does not.
We need to see you model.

On Tuesday, 23 June 2020 07:10:32 UTC-7, 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/295ff7b2-17f4-40e9-a050-5e07758c5f09o%40googlegroups.com.

Reply via email to