[web2py] Source compile error - local vs. remote - frustrating

2012-08-17 Thread wdtatenh
My site is hosted on webfaction. The web2py src code is the same on local remote - both have the latest web2py src. Compiled my site locally, uploaded to my remote site and I get raise SystemError, 'compiled code is incompatible' SystemError: compiled code is incompatible The Webfaction

Re: [web2py] Source compile error - local vs. remote - frustrating

2012-08-17 Thread wdtatenh
Thanks - I'm installing python 2.7 on my machine and that should resolve the problem. --

[web2py] web2py and python 2.7 - won't compile

2012-08-17 Thread wdtatenh
Installed python 2.7. Trying to start up web2py and I get the following traceback - note URLLIB and SOCKET are located in ...python27/Lib Appreciate help. No handlers could be found for logger web2py Traceback (most recent call last): File web2py.py, line 16, in module import

[web2py] file w2p_apps does not exist

2012-08-06 Thread wdtatenh
Downloaded latest stable src and ran setup.py install and get error w2p_apps does not exist. Any suggestions as to how to remedy this issue. Thanks in advance Bill --

[web2py] updating web2py src on live site and web2py shutdown/restart

2012-08-06 Thread wdtatenh
I'm about to update the src code on a live site hosted by webfaction. I'm assuming that web2py server must be stopped and restarted. Web2py is running from the original installation script and has never had to be shutdown before. I've not gone through this on a live site performing a manual

Re: [web2py] updating web2py src on live site and web2py shutdown/restart

2012-08-06 Thread wdtatenh
python cmd shell python web2py.py On Monday, August 6, 2012 12:55:52 PM UTC-4, viniciusban wrote: You'll do this in a test environment before, right? ;-) On 08/06/2012 01:37 PM, wdtatenh wrote: I'm about to update the src code on a live site hosted by webfaction. I'm assuming

[web2py] mysql migration 5.0 to 5.5 - migrate=False, getting auth_users already exists

2012-07-26 Thread wdtatenh
I had to migrate to mysql 5.5. for another application I have. I did not attempt to migrate things through that administrative interface. Just did a RESTORE from a mysql dump to file. I have migrate=False in the DAL() statement. Am I missing something here? Appreciate any input on

[web2py] Re: mysql migration 5.0 to 5.5 - migrate=False, getting auth_users already exists

2012-07-26 Thread wdtatenh
Thanks so much. On Thursday, July 26, 2012 11:59:24 AM UTC-4, Niphlod wrote: yep. migrate=False in DAL set migrate=False for table definitions. the auth.define_table() needs to be set to migrate=False explicitely. On Thursday, July 26, 2012 5:48:23 PM UTC+2, wdtatenh wrote: I had

Re: [web2py] Re: Recommendations on model file size (database tables)

2012-07-18 Thread wdtatenh
Almost 90% of the queries are in DAL and not native SQL. Nothing too elaborate but there are a number of queries with joins - nothing elaborate and simple where clauses. I know the model is not the primary bottleneck as I've got thick controllers that definitely need to be thinned out and

Re: [web2py] Re: Recommendations on model file size (database tables)

2012-07-17 Thread wdtatenh
When I go through the exercise of re-tooling this site I will catalog what I did wrong and what I had to do get it right based on the input provided and perhaps it will be some benefit to others who won't make the same mistakes I made. :) --

[web2py] Recommendations on model file size (database tables)

2012-07-16 Thread wdtatenh
I've got to move a bunch of stuff around to speed up my site particularly on the controller folder. My question is that I have nearly 50+ tables defined in my db.py file. Is there any benefit to splitting these tables into multiple model files? The tables belong to a single database and most

Re: [web2py] Re: Recommendations on model file size (database tables)

2012-07-16 Thread wdtatenh
Thanks very much for this information. I need to examine it more closely but it looks darn good. I'm hoping with this change and re-organizing my controllers, then my site will speed up significantly. At present, it is slower than raw maple syrup and I can't afford to stay with web2py if I

[web2py] Re: Recommendations on model file size (database tables)

2012-07-16 Thread wdtatenh
://www.web2pyslices.com/slice/show/1479/model-less-apps-using-data-models-and-modules-in-web2py On Monday, July 16, 2012 1:45:23 PM UTC-7, wdtatenh wrote: I've got to move a bunch of stuff around to speed up my site particularly on the controller folder. My question is that I have nearly 50+ tables defined

[web2py] Web2py - internet explorer - admin login fails - http://127.0.0.1:8000/....

2012-07-08 Thread wdtatenh
attempting to login to web2py admin using IE - login fails. - works fine on Mozilla Firefox http://127.0.0.1:8000/admin/default/index?send=/default/design/welcome Security settings for intranet are set low in IE... I also can't login as a user (parts of my website require user login) on my

[web2py] Re: Web2py - internet explorer - admin login fails - http://127.0.0.1:8000/....

2012-07-08 Thread wdtatenh
Thanks - tried it didn't work... even removed the tail and started with http://.localhost:8000

[web2py] Re: Web2py - internet explorer - admin login fails - http://127.0.0.1:8000/....

2012-07-08 Thread wdtatenh
Yes it does ask for my admin password but it just reloads the page with the same login screen. My browser has been set to accept any cookies and it still gives me the same response.

[web2py] Re: Web2py - internet explorer - admin login fails - http://127.0.0.1:8000/....

2012-07-08 Thread wdtatenh
OK - now it's working - thanks for the tips. On Sunday, July 8, 2012 9:21:45 AM UTC-4, Massimo Di Pierro wrote: Does it ask you for the admin password? On Sunday, 8 July 2012 07:44:46 UTC-5, wdtatenh wrote: Thanks - tried it didn't work... even removed the tail and started with http

[web2py] Website running extremely slow

2012-07-06 Thread wdtatenh
My website is deployed on webfaction. I've compiled the application before uploading. Doesn't seem to matter what page is requested, we're talking about 3 to 5 seconds to download (I have high speed internet). Any thoughts? When I go to the normal webfaction admin pages, I don't have these

Re: [web2py] import module fails

2012-06-22 Thread wdtatenh
Thanks. I do but I still get the same problem. It's interesting that I have another 3rd party module that I added and it works but mine which just has some functions test functions in it does not. I created that file under the module folder through the web2py web interface. --

[web2py] import module fails

2012-06-20 Thread wdtatenh
I'm running version 1.91.6 installed from binary for localhost testing. I'm attempting to add some modules to hold utility functions used by other controllers but I consistently get an import error. Suggestions? Thanks in advance --

[web2py] Re: Remote admin of sqlite - through ssh

2012-06-10 Thread wdtatenh
Unfortunately, the update didn't occur (was not a schema change) - simple insert to auth_membership table. Could see change when using local cmd/python shell. Wasn't visible when I check using appadamin. sqlite is fine in this case because the site is not a high traffic site and very low

[web2py] Remote admin of sqlite - through ssh

2012-06-09 Thread wdtatenh
I'm using sqlite for my database on a data intensive website that I want to push up very soon. I understand I need to go through ssh to administer things remotely. I definitely need to be able to administer groups and assign membership remotely via ssh. But will my changes show up if I make

[web2py] Successful login takes me to index - would like to go back to the prior page

2011-06-27 Thread wdtatenh
I'm building an application that uses the login features provided by web2py. Users could login at any time so I was hoping for a solution that would take the person to the last page they were on before they logged in instead of going to the index page. Any suggestions would be greatly

[web2py] SQLFORM layout - very frustrating

2011-06-15 Thread wdtatenh
I could really use an answer to this question. Using SQLFORM is there a simple notation to set the width of a select with IS_IN_SET defined in the model. Inserting {{=custom.form.widget.myField}} works but I don't see how I can set the width? I've experimented to my eye's bleed but nothing I've

[web2py] Re: SQLFORM layout - very frustrating

2011-06-15 Thread wdtatenh
That worked - thanks very so much.

[web2py] custom form dspval question

2011-06-09 Thread wdtatenh
Apologies didn't see this anywhere that showed a clear example of what I'm asking about. Have custom form - using inpval, dspval, etc. and would like to know if there is specific formatting that allows me to set form field properties? this part I get: {{=dspval.my_field_name}} My question is

[web2py] SQLite won't update via SQLForm

2011-02-23 Thread wdtatenh
Thanks in advance - I've created the sqlite table. The records that I've added thus far show up in the view. I can add new records without difficulty using SQLFORM. However, when I convert the controller to an update/delete form and hard wire the form to present a specific record in the view

[web2py] Re: SQLite won't update via SQLForm

2011-02-23 Thread wdtatenh
Thanks all - that was the fix.

[web2py] Accessing Web2py SQLITE instance via pythonwin

2011-02-15 Thread wdtatenh
Apologies if this answer is already posted elsewhere - a search didn't answer my question. Basically I need to pre-populate some sqlite tables used with my web2py app with a fair amount of data. Would like to run some scripts that performs this task via conventional pythonwin IDE.Thus far