auth_user

[xgp.l...@gmail.com]

Hi all,

Im using auth_user table brought from web2py. When trying to log in i get an error:

psycopg2.errors.UndefinedColumn: column auth_user.first_name does not exist LINE 1: ...id", "auth_user"."email", "auth_user"."password", "auth_user...

Those fields are not ni my auth_user table. What should i do?

[Dave S]

I'm not sure if there is a way in py4web itself, but one approach would be to use psql or other offline tool to add that column to your table, and to set those values to null, the empty string, or "not available".  (I'm not sure which of those values would be acceptable to Auth )

/dps

[Dave S]

However, not having the field is curious, as it seems to be a column in my web2py auth_user table ... did you customize your web2py version?

/dps

[xgp.l...@gmail.com]

Hi,

Yes, auth_user was customized in web2py.. 

I understand there are some fields mandatory, but auth_user.first_name should not be one of those.

I use email for authentication.

Thanks,

[Dave S]

On Friday, May 1, 2026 at 3:40:48 PM UTC-7 xgp.l...@gmail.com wrote:

Hi,

Yes, auth_user was customized in web2py.. 

I understand there are some fields mandatory, but auth_user.first_name should not be one of those.

I use email for authentication.

Thanks,

I don't think auth_user.first_name is often used for authentication; it is more for profile use, I would think.

And it's not a big deal to force it to an empty value and then ignore it outside of Auth. 

/dps