mysql or mssql ? Windows + MSSQL is one of mine "de facto" setups.
I find hard to believe that the same app, same models and same db uri (so, same exact code) have a "preference" for working fine in an app and raising exceptions in another. Something MUST be different. On Monday, February 18, 2013 6:18:57 PM UTC+1, Andrew Buchan wrote: > > I should have added a bit more info... > > I'm running on MsSQL, and have 2 applications pointing at the same > database, one live and one mirror copy for minor changes. From one > application the data admin interface opens fine, from the other it gives me > the appadmin exceptions. The files in /model and /databases are identical > for both, and both apps running from the same instance of web2py. > > Also, I have to restart web2py altogether pretty much every time a migrate > operation fails. I can't be completely sure if this is something new, but > don't remember it being like that before I upgraded to 2.3.2. > > I've also raised issues > 1343<http://code.google.com/p/web2py/issues/detail?id=1343&q=andyhasit> > and 1344<http://code.google.com/p/web2py/issues/detail?id=1344&q=andyhasit> > with > the latter being a rather serious one that has had me chasing my tail > finding new places where this could crop up and covering up for it until it > there's a fix (my bad for not having a selenium test suite!). > > Although I'm sure most of my woes are down to things I'm doing wrong these > issues give me the feeling that changes to web2py over the last year or so > have not been thoroughly tested on MsSQL deployments. I know most of you > deploy on LAMP-ish setups, but I haven't got that option and feel I'm > incurring a lot of extra work for using a less favoured microsoft stack. > I'm stuck with windows on this one, but am wondering if anyone has any > experience implementing web2py on mysql in a windows environment? > > > Oh, and here's another exception. > > Traceback (most recent call last): > File "C:\Program Files\Hub Pages\web2py\gluon\restricted.py", line 212, in > restricted > exec ccode in environment > File "C:/Program Files/Hub > Pages/web2py/applications/HubFormsTidy/views/appadmin.html" > <http://localhost/admin/default/edit/HubFormsTidy/views/appadmin.html>, line > 88, in <module> > {{if hasattr(table,'_primarykey'):}} > KeyError: 'appadmin' > > > On Friday, February 15, 2013 3:27:58 PM UTC, Andrew Buchan wrote: >> >> Here's the exception I get: >> >> >> Traceback (most recent call last): >> File "C:\Program Files\Hub Pages\web2py\gluon\restricted.py", line 212, in >> restricted >> exec ccode in environment >> File "C:/Program Files/Hub >> Pages/web2py/applications/HubFormsTidy/views/appadmin.html" >> <http://localhost/admin/default/edit/HubFormsTidy/views/appadmin.html>, line >> 86, in <module> >> {{elif request.function=='update':}} >> KeyError: 'appadmin' >> >> >> >> -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
