[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Niphlod
aside from the fact that that config is uber-simple and not what web2py ships usually. who is serving css's ? apache or web2py ? On Tuesday, March 31, 2015 at 7:05:25 AM UTC+2, weheh wrote: Thanks, Brian. My page does have a lot of ajax calls. The problem seems to be that some of my css

[web2py] Re: manually update password

2015-03-31 Thread Niphlod
why all this fuss ? let the form handle it instead of your code. On Tuesday, March 31, 2015 at 3:07:57 AM UTC+2, José Eloy wrote: Sorry for the delay in answering. I have the following code for modify the auth_user table: administrador = db2.auth_user(request.args(0)) or

[web2py] Cloning SQLlite into PostgreSQL

2015-03-31 Thread Gael Princivalle
Hello. Like a lot of users I need to clone an existing SQLlite db to new PostgreSQL db. I've read this post in web2py-developers by Alan Etkin: https://groups.google.com/forum/#!searchin/web2py-developers/sqlite$20postgres/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ However I've tried to use

[web2py] Re: Cloning SQLlite into PostgreSQL

2015-03-31 Thread Ron Chatterjee
As an alrenative. you can upload a csv file into web2py. Not a solution if you want to do things dynamically and all the time. But you can use the csv option. On Tuesday, March 31, 2015 at 4:11:18 AM UTC-4, Gael Princivalle wrote: Hello. Like a lot of users I need to clone an existing

[web2py] Re: 2.10.1 / Windows errors / cache

2015-03-31 Thread Massimo Di Pierro
2.10.2 fixes it as Leonel suggested. On Tuesday, 31 March 2015 19:15:00 UTC-5, Leonel Câmara wrote: Awww dammit we forgot to update the admin module. I attached an admin.py file you can replace the one in the gluon with to get this to work until we make a proper fix. -- Resources: -

[web2py] websocket messaging VS scheduler

2015-03-31 Thread Carlos Costa
I would like to use scheduler with a task sends websocket messages but it looks like they conflict with each other. I am able to run only one of them. If I start scheduler first, websocket freezes web2py. If I start websocket first scheduler do not run any worker. I start we2py with web2py.py

[web2py] Re: update table as boolean.

2015-03-31 Thread Anthony
Do you have a question? Any code to show? On Tuesday, March 31, 2015 at 6:27:12 PM UTC-4, archana subramanyam wrote: Hi When i click on check box and confirm button ...the db with colo 'X' must get updated to true (if checkbox is checked),else updted to false(if checkbox not checked and on

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread weheh
Thanks, Jim. 32-bit Apache Version 2.2.x mod-wsgi for python 2.7 On Tuesday, March 31, 2015 at 1:46:26 PM UTC-7, Jim S wrote: What versions of Apache and mod-wsgi? 32 bit or 64 bit? -Jim -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: 2.10.1 / Windows errors / cache

2015-03-31 Thread Kiran Subbaraman
Just cloned the repo, and noticed the 2.10.2 tag. Tried this again, in this codebase, and the errors remain. Please note, I have highlighted two issues that occur: * Install the sample app, view the default page. The page comes up just fine. Click page-refresh, and you see the first error:

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread weheh
I'm getting a 200 status on the css files that aren't being transferred correctly. Also, on Chrome Firebug I can't find the same Net tab and view you describe, so I can't find that X-Powered-By line. On Tuesday, March 31, 2015 at 2:09:53 PM UTC-7, Niphlod wrote: You need to activate the Net

[web2py] Re: Write dynamic query in DAL without extra nested parentheses

2015-03-31 Thread gb
Thanks, Gary! Works perfectly. On Tuesday, March 31, 2015 at 4:27:12 PM UTC-6, Gray Kanarek wrote: You want belongs, I think: query = db.product.id.belongs((selected_ids)) On Saturday, March 28, 2015 at 12:14:44 PM UTC-4, gb wrote: What is the DAL Code to generate a query like this:

[web2py] idea: new helpers

2015-03-31 Thread Dmitry Ermolaev
DIV( _class='row my_class') = ROW(_class='my_class') DIV( _class='col-sm-4 my_class') = COL4(_class='my_class') -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] you mean me?

2015-03-31 Thread Manuele Pesenti
I noticed a Manuele Presenti is mentioned here: http://www.web2py.com/books/default/chapter/29/01/introduction but if you mean to mention me (and I would be VERY proud of it!!) my correct surname is Pesenti :) but I have always correct the spelling till I was a child :) maybe I can correct my

[web2py] Re: Cloning SQLlite into PostgreSQL

2015-03-31 Thread Willoughby
Well it has a bunch of log statements, were all of those OK? On Tuesday, March 31, 2015 at 2:19:41 PM UTC-4, Gael Princivalle wrote: Thanks Ron but:with CSV export: auth_user_iduser 3 John 7 Sally And then you import your

[web2py] Re: Cloning SQLlite into PostgreSQL

2015-03-31 Thread Gael Princivalle
I'm sorry Willoughby but I don't understand your question. With this csv export/import the problem is that id's change. For example if you take a look to the auth_user table in my previous post, table auth_membership will have wrong auth_user id's: auth_membership.id

[web2py] Re: Cloning SQLlite into PostgreSQL

2015-03-31 Thread Willoughby
I was referring to the script from Alan Etkin in your first post. It logs every step - what did the log steps say when you ran it? On Tuesday, March 31, 2015 at 3:19:13 PM UTC-4, Gael Princivalle wrote: I'm sorry Willoughby but I don't understand your question. With this csv export/import

Re: [web2py] you mean me?

2015-03-31 Thread Marin Pranjić
Hehe, it seems that my name is written twice but both are wrong so maybe that's not me either :D Marin On Tue, Mar 31, 2015 at 5:34 PM, Manuele Pesenti manuele.pese...@gmail.com wrote: I noticed a Manuele Presenti is mentioned here:

[web2py] Re: Cloning SQLlite into PostgreSQL

2015-03-31 Thread Gael Princivalle
Thanks Ron but:with CSV export: auth_user_iduser 3 John 7 Sally And then you import your CSV file you will have: auth_user_iduser 1 John 2 Sally And so all

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Jim S
What versions of Apache and mod-wsgi? 32 bit or 64 bit? -Jim On Tuesday, March 31, 2015 at 3:34:28 PM UTC-5, Niphlod wrote: web2py appends a X-Powered-By : web2py header. On Tuesday, March 31, 2015 at 10:27:25 PM UTC+2, weheh wrote: How do I figure out whether web2py is serving the css

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Dave S
On Tuesday, March 31, 2015 at 1:34:28 PM UTC-7, Niphlod wrote: web2py appends a X-Powered-By : web2py header. I'm thinking you are saying that is put into the css file's response header; what's the best way to see that? Firefox's developer tool doesn't show headers in the CSS tab, and in

[web2py] web2py.com is down

2015-03-31 Thread Jim S
Something went wrong :-( This website is hosted by PythonAnywhere, an online hosting environment. Something went wrong while trying to load it; please try again later. If this is your PythonAnywhere-hosted site, there may be a bug in your code. Check your site's server and error logs for

[web2py] Re: web2py.com is down

2015-03-31 Thread Dave S
On Tuesday, March 31, 2015 at 1:48:02 PM UTC-7, Jim S wrote: Something went wrong :-( I get the same screen at the moment, from Southern California. FWIW, I have a site monitored by Uptime Robot; I got a notification in January, for an outage of an hour-and-a-half.

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Niphlod
You need to activate the Net tab ... you're probably inspecting a 304 response, which doesn't carry the header: hit ctrl+f5 to erase the cache and refresh the page. this is what it returns on my system Cache-ControlprivateConnectionkeep-aliveContent-Length117305Content-Typetext/css;

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Brian M
Mine shows this for a css file HTTP/1.1 200 OK Date: Tue, 31 Mar 2015 21:30:03 GMT Server: Apache/2.2.22 (Win32) mod_wsgi/3.3 Python/2.7.2 Content-Length: 2961 X-Powered-By: web2py Last-Modified: Sat, 15 Mar 2014 03:13:58 GMT Pragma: cache Cache-Control: private X-UA-Compatible: IE=edge

[web2py] update table as boolean.

2015-03-31 Thread archana subramanyam
Hi When i click on check box and confirm button ...the db with colo 'X' must get updated to true (if checkbox is checked),else updted to false(if checkbox not checked and on submitting form). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Table Migration on GAE

2015-03-31 Thread Sébastien Loix
I just downloaded and tested the latest source for testers on GAE. Migration does work perfectly for the tables inside the models but still does not work for the auth.settings.extra_fields['auth_user'] = (...Fields) It is no big deal for me as I have installed phpMyAdmin (as an app version)

[web2py] sorting ip address

2015-03-31 Thread Matheus Suffi
Hello, im trying to sort an IP adddres list, this is the only result i getting 192.168.1.1 192.168.1.10 192.168.1.11 i want to list in that order: 192.168.1.1 192.168.1.2 192.168.1.3 192.168.1.4 Any ideias ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: RuntimeError: table appears corrupted

2015-03-31 Thread James O' Driscoll
I had the same problem today. Had server running for less than a month, the table was from SQLITE. I am looking for preventative measures rather than reactionary. Regards, James On Thursday, July 11, 2013 at 9:23:18 PM UTC+10, Tomek Krasuski wrote: THX. W dniu sobota, 29 grudnia 2012

[web2py] Deployment Recipe Web2Py on PythonAnywhere

2015-03-31 Thread NeoToren
I have summarized my deployment recipe to PythonAnywhere: http://www.icd10doc.com/init/recipes/DeployWeb2PyPythonAnywhere Hope it helps. NeoToren -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: PythonAnywhere performance is significantly slower than locally

2015-03-31 Thread NeoToren
PythonAnywhere took care of it... Some rogue processes on their behalf Now everything is working great and I am happy as a clam on high-tide Thanks NeoToren On Saturday, March 21, 2015 at 4:21:40 PM UTC-4, NeoToren wrote: My website is using MySQL and consists mostly of queries and simple

[web2py] Re: SQL designer still not working

2015-03-31 Thread gb
Not sure exactly what you mean, but you can use this and select to export to web2py DAL: https://code.google.com/p/wwwsqldesigner/ (I've ported it here) https://github.com/borng/wwwsqldesigner Live Demo: http://ondras.zarovi.cz/sql/demo/ On Sunday, March 29, 2015 at 11:31:50 AM UTC-6, Ron

[web2py] web2py 2.10.1 is OUT

2015-03-31 Thread Massimo Di Pierro
- welcome app defaults to Bootstrap 3 - DAL - pyDAL (thanks Giovanni, Niphlod, Paolo) - new modular dal - fixed problems with GAE support - moved to full NDB support - improved connection pooling logic - optional cache.ram.max_ram_utilization = 90 (experimental) - improved cache.disk logic

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread weheh
How do I figure out whether web2py is serving the css files? On Tuesday, March 31, 2015 at 12:39:00 AM UTC-7, Niphlod wrote: aside from the fact that that config is uber-simple and not what web2py ships usually. who is serving css's ? apache or web2py ? On Tuesday, March 31, 2015 at

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Niphlod
web2py appends a X-Powered-By : web2py header. On Tuesday, March 31, 2015 at 10:27:25 PM UTC+2, weheh wrote: How do I figure out whether web2py is serving the css files? On Tuesday, March 31, 2015 at 12:39:00 AM UTC-7, Niphlod wrote: aside from the fact that that config is uber-simple and

[web2py] Re: Is web2py is good for below requirements?

2015-03-31 Thread Massimo Di Pierro
On Saturday, 28 March 2015 11:14:44 UTC-5, Anandhakumar Radhakrishnan wrote: Hi, I have planned to create a website with certain requirement please tell whether this will support in web2py. 1. Dynamic Page yes. That is what we do best but you may want to complete with a client side

[web2py] Re: Is web2py is good for below requirements?

2015-03-31 Thread Massimo Di Pierro
On Saturday, 28 March 2015 11:14:44 UTC-5, Anandhakumar Radhakrishnan wrote: Hi, I have planned to create a website with certain requirement please tell whether this will support in web2py. 1. Dynamic Page 2. Multi Vendors like olx.com 3. Email Services 4. Comparison charts And

[web2py] Re: SQLite: select within transaction

2015-03-31 Thread Niphlod
you're basically asking for a select ... for update, that isn't supported on many backends. Asking for it in SQLite means locking THE ENTIRE table . usually you'd mimick what you want (without hurting performances so much) with an additional field. db(db.table.id == x).update(hidden=True)

[web2py] Re: sorting ip address

2015-03-31 Thread Niphlod
use the power, luke! aside from various networking libraries out there, the problem is rather simple what you're getting back is the alphabetical order . what you need instead is to sort every triplet as an integer. In reality, python strings for ip addresses are good enough, if taken

[web2py] Re: Change the default application to run

2015-03-31 Thread Niphlod
have a look at http://web2py.com/books/default/chapter/29/04/the-core#URL-rewrite On Wednesday, April 1, 2015 at 12:27:11 AM UTC+2, wei zhu wrote: Hello Team I found the application welcome was set to the default application to run when you just type your_name.pythonanywhere.com. Is there

[web2py] Re: web2py 2.10.1 is OUT

2015-03-31 Thread Massimo Di Pierro
Also. Thanks to Kathy and Luca for all your GAE tests! On Tuesday, 31 March 2015 17:26:18 UTC-5, Massimo Di Pierro wrote: - welcome app defaults to Bootstrap 3 - DAL - pyDAL (thanks Giovanni, Niphlod, Paolo) - new modular dal - fixed problems with GAE support - moved to full NDB

[web2py] Re: Fixed issue 1422 introduced a bug in generic rss views?

2015-03-31 Thread Carlos Fillol Sendra
Removing str( and .encode('utf-8', 'replace')) strings from rss function in gluon.serializers.py seems to solve the issue (at least it worked for me). def rss(feed): if not 'entries' in feed and 'items' in feed: feed['entries'] = feed['items'] now = datetime.datetime.now()

[web2py] Re: Write dynamic query in DAL without extra nested parentheses

2015-03-31 Thread gb
I have a list of products (much less than 1000) that the users can select or unselect--I supposed I could only select on the unselected items. If it's above 80 or so sqlite throws class 'sqlite3.OperationalError' parser stack overflow, see code below: db.define_table(product) query =

[web2py] SQLite: select within transaction

2015-03-31 Thread Val K
Hi! Here is controller's logic: 1. Get field value: fld_v= db.table[i].any_field 2. Evaluate new value depending on existing one: new_fld_v=fun(fld_v) 3. Update record with new value: db(db.table.id==i).update(any_field=new_fld_v) The problem: After

[web2py] Change the default application to run

2015-03-31 Thread wei zhu
Hello Team I found the application welcome was set to the default application to run when you just type your_name.pythonanywhere.com. Is there a way to change it to any application I want? and one more question, if you type 127.0.0.XXX:8000, it will show

[web2py] Re: Write dynamic query in DAL without extra nested parentheses

2015-03-31 Thread Gray Kanarek
You want belongs, I think: query = db.product.id.belongs((selected_ids)) On Saturday, March 28, 2015 at 12:14:44 PM UTC-4, gb wrote: What is the DAL Code to generate a query like this: SELECT * FROM product WHERE product.id=1 OR product.id=2 OR product.id=3 OR product.id product.id=4 OR

[web2py] Re: sorting ip address

2015-03-31 Thread Niphlod
nope, wrong... sorry, I reaally need some bed time ^_^ You NEED to convert triplets to integers before sorting. no worries though... what_you_want = sorted(myips, key=lambda x:tuple(map(int, x.split('.' is the correct one. -- Resources: - http://web2py.com -

[web2py] Re: mod_wsgi error caused (maybe) by css transferred with MIME type text/plain

2015-03-31 Thread Dave S
On Tuesday, March 31, 2015 at 2:09:53 PM UTC-7, Niphlod wrote: You need to activate the Net tab ... you're probably inspecting a 304 response, which doesn't carry the header: hit ctrl+f5 to erase the cache and refresh the page. Ooops. Some trainer could make a living off me, eh? yes,

[web2py] Re: 2.10.1 / Windows errors / cache

2015-03-31 Thread Leonel Câmara
Awww dammit we forgot to update the admin module. I attached an admin.py file you can replace the one in the gluon with to get this to work until we make a proper fix. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -