I create extra fields in auth_user like this
## create all tables needed by auth if not custom tables
auth.settings.extra_fields['auth_user'] = [
Field('org_ref', 'integer', label="Organization"),
Field('phone', label="Phone"),
Field('show1stpage', 'boolean', label="Show Getting Started Page"),
Field('Invitedby', label="Invited By"),
Field('RegistrationCode', label="Registration Code")
]
## create all tables needed by auth if not custom tables
auth.define_tables(username=False, signature=False, Migrate=True)
and am getting the following error after migrate. I have tried fake_migrate
in all combinations.
If i comments out the most recent fileds (i.e. the ones not in the current
Postgres DB, the app will run, but blows up when I reference one of the new
fields)
If I add the fileds to the database directly (in the same order as the
create table in the /databases/log.sql file, I get the error below
Lastly I create a new table RegistrationCodes that is not getting created
in the Postgres DB either. Its as if the migrate is not doing anything.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
Traceback (most recent call last
):
File "/home/dlwatey/webapps/web2py/web2py/gluon/restricted.py", line 205, in
restricted
exec ccode in environment
File
"/home/dlwatey/webapps/web2py/web2py/applications/COPSIS23/controllers/default.py"
<https://www.copsis.org/admin/default/edit/COPSIS23/controllers/default.py>,
line 226, in <module>
File "/home/dlwatey/webapps/web2py/web2py/gluon/globals.py", line 175, in
<lambda>
self._caller = lambda f: f()
File
"/home/dlwatey/webapps/web2py/web2py/applications/COPSIS23/controllers/default.py"
<https://www.copsis.org/admin/default/edit/COPSIS23/controllers/default.py>,
line 85, in register
inviterec = db((db.invite.id == request.args(0)) & (db.invite.host_ref ==
db.auth_user.id)).select()
File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 8147, in select
return adapter.select(self.query,fields,attributes)
File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1410, in select
rows = response(sql)
File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1400, in
response
self.execute(sql)
File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1489, in execute
return self.log_execute(*a, **b)
File "/home/dlwatey/webapps/web2py/web2py/gluon/dal.py", line 1483, in
log_execute
ret = self.cursor.execute(*a, **b)ProgrammingError: column auth_user.phone
does not exist
LINE 1: ...ey, auth_user.registration_id, auth_user.org_ref, auth_user....
^
db = DAL('postgres://idxxx:pwxxx@127.0.0.1:5432/dlwatey_copsis',
migrate_enabled=True, fake_migrate_all=False)
I have tried the migrate=true, and fake_migrate flags but they are not
working. I continue to see what is going on but am getting worried andmay
have to revert to the old system.
--
