Re: [web2py] Re: problem with left join and SQlFORM.grid

Sun, 22 Jul 2012 15:27:59 -0700

Massimo, I just tried pusing COPSIS to production and the migration is acting up again. Mre specifically, I have some extra fields defined on auth_user as follows: 

## 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)


and am getting the following error:

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",line205,inrestricted
    execccodeinenvironment
  File"/home/dlwatey/webapps/web2py/web2py/applications/COPSIS23/controllers/default.py"  
<https://www.copsis.org/admin/default/edit/COPSIS23/controllers/default.py>,line226,in<module>
  File"/home/dlwatey/webapps/web2py/web2py/gluon/globals.py",line175,in<lambda>
    self._caller=lambdaf:f()
  
File"/home/dlwatey/webapps/web2py/web2py/applications/COPSIS23/controllers/default.py"
  
<https://www.copsis.org/admin/default/edit/COPSIS23/controllers/default.py>,line85,inregister
    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",line8147,inselect
    returnadapter.select(self.query,fields,attributes)
  File"/home/dlwatey/webapps/web2py/web2py/gluon/dal.py",line1410,inselect
    rows=response(sql)
  File"/home/dlwatey/webapps/web2py/web2py/gluon/dal.py",line1400,inresponse
    self.execute(sql)
  File"/home/dlwatey/webapps/web2py/web2py/gluon/dal.py",line1489,inexecute
    return self.log_execute(*a, **b)
  File"/home/dlwatey/webapps/web2py/web2py/gluon/dal.py",line1483,inlog_execute
    ret=self.cursor.execute(*a, **b)
ProgrammingError:column auth_user.phone doesnotexist
LINE1: ...ey,auth_user.registration_id,auth_user.org_ref,auth_user....
                                                             ^



    db = DAL('postgres://idxxx:[email protected]: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.




Massimo Di Pierro <mailto:[email protected]>
Sunday, July 22, 2012 9:59 AM

Thanks for checking. This should be made a little easier. Sorry the 
nightly windows binary is still broken but it is in my todo list to 
fix it by tomorrow.


Massimo

On Sunday, 22 July 2012 05:23:00 UTC-5, david.waldrop wrote:
--



david waldrop <mailto:[email protected]>
Sunday, July 22, 2012 6:23 AM

Massimo, the orderby clause on SQLFORM.grid works like a charm.  1000 
thank you's for you support and help.  /david

david waldrop <mailto:[email protected]>
Sunday, July 22, 2012 5:45 AM
I downloaded the Windows Nightly build.
I will try running form source, so am unsure how to do so.
Trying now.

Massimo Di Pierro <mailto:[email protected]>
Saturday, July 21, 2012 9:51 PM

Source version of windows binary version? (the latter is not supposed 
to work yet)


On Saturday, 21 July 2012 16:43:22 UTC-5, david.waldrop wrote: --



david waldrop <mailto:[email protected]>
Saturday, July 21, 2012 5:43 PM

Massimo,  I tried to install nightly build, but have encountered an 
error.  I get a message when i run web2py that 
zipimport.zipimorterror: can't find module 'gluon'


i am running on win7 today


this is my 1st time getting the nightly build. i simply copied the 
structre over the top of my existing web2py directory
this did not work, so i went in and deleted all the files in the root 
of web2py and manually moved them form the downloaded nightly build.


Is there something else I can try?



--




<<inline: compose-unknown-contact.jpg>>























					Reply via email to