[web2py] Re: web2py -> py4web

I have a larger web2py app that would be a chore to migrate - hard to justify the time without clear incentives. It’s running Python 3.10 and not on GAE. Would be nice if there was at least some security updates. On Saturday, July 13, 2024 at 9:10:05 PM UTC-5 Massimo Di Pierro wrote: > Hello

[web2py] web2py.com "Not Secure" wrong SSL Cert

FYI - https://www.web2py.com is giving a "Not secure" warning because the SSL certificate is actually for *.pythonanywhere.com instead of web2py.com. Your connection is not private Attackers might be trying to steal your information from *www.web2py.com* (for example, passwords, messages, or

[web2py] Re: Python 3 - Traceback problems

Looks like if you use the latest git version then the error tickets work as expected. On Friday, February 15, 2019 at 10:04:50 AM UTC-6, Kevin Keller wrote: > > Is there any update to this? > > On Friday, 1 February 2019 17:21:40 UTC+1, Brian M wrote: >> >> So I'm t

[web2py] Python 3 - Traceback problems

Am I really the only one having this problem? Having the error ticket system not work seems like a pretty significant obstacle to using web2py with python 3.7 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Web2py with python3: difference in error reporting

Reported the same a few days ago but have heard nothing. :( https://groups.google.com/forum/m/#!topic/web2py/dTsDZJ8jhyg -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Python 3 - Traceback problems

So I'm trying to finally move my web2py apps over to Python 3.7 before Python 2.7 reaches EOL and, while for the most part they're working fine, I am finding that when there is a problem the web2py Error ticket is just about useless (doesn't tell you where the error actually occurs) because

[web2py] Re: Caching DAL Selects - only cache.ram works?

. 21. 22. Traceback (most recent call last): File "C:\Users\Brian\Documents\source_code\web2py_src\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:/Users/Brian/Documents/source_code/web2py_src/web2py/applications/caching_demo/controlle

[web2py] Re: 'Column table.id not found (SQLTABLE)'

Thank you for mentioning this - just wasted an hour plus trying to figure out why my code had stopped working only to find that it was because I'd done pip install pydal for something else and foolishly not used a venv. Uninstalled pydal and everything was good again. So warning to others,

[web2py] Re: Caching DAL Selects - only cache.ram works?

So it caching selects to disk or redis supposed to only work if you have uniquely named fields? It doesn't seem to make a difference if I set cachable=True or not. On Tuesday, April 3, 2018 at 5:15:25 PM UTC-5, Brian M wrote: > > Further investigation shows that cache.redis plays

[web2py] Re: Caching DAL Selects - only cache.ram works?

M UTC-4, Anthony wrote: >> >> It should work. Could be a bug specific to using pyodbc. Have you tried >> it with other databases/drivers? Feel free to file a PyDAL issue. >> >> Anthony >> >> On Tuesday, April 3, 2018 at 12:40:50 PM UTC-4, Brian M wrote: >&g

[web2py] Caching DAL Selects - only cache.ram works?

ly only exist for cache.ram or am I missing something? Brian -- 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 Issues) --- You received this message because you are subscribed

[web2py] Re: iterselect() and doing other DB actions - Connection is busy with results for another command

r the next person that might find this. On Wednesday, January 10, 2018 at 3:26:16 PM UTC-6, Anthony wrote: > > On Wednesday, January 10, 2018 at 2:48:34 PM UTC-5, Brian M wrote: >> >> Thank you Anthony, that works! >> >> Only issue is that while using iterselec

[web2py] Re: iterselect() and doing other DB actions - Connection is busy with results for another command

gt; Note, it may need to be all caps -- MARS_CONNECTION. > > Anthony > > On Wednesday, January 10, 2018 at 10:48:19 AM UTC-5, Brian M wrote: >> >> I'm attempting to process through record sets from DAL queries that can >> sometimes return hundreds of thousands of records.

[web2py] iterselect() and doing other DB actions - Connection is busy with results for another command

I'm attempting to process through record sets from DAL queries that can sometimes return hundreds of thousands of records. To try to keep memory usage under control I wanted to use iterselect() instead of a plain DAL select(). However, the problem I'm running into is that as I process each

[web2py] Re: Azure deployment recommendations?

the OS. Perhaps the scheduler can be run as a WebJob, looks like you can run command line stuff with that so maybe just the usual scheduler commandline invocation without the need for nssm? Brian On Thursday, May 25, 2017 at 12:03:35 AM UTC-5, Dave S wrote: > > > > On Wednesday, May 2

[web2py] Azure deployment recommendations?

indows service via NSSM) on Azure? Any tips or recommendations would be appreciated. Thanks, Brian M -- 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 Issues) --- You re

[web2py] Re: widget.autocomplet vs IS_IN_DB : formatting, filtering

I've used bootstrap-select ( https://silviomoreto.github.io/bootstrap-select/examples/ ) to enhance standard select drop down lists and allow live searching. Would work well with your lists ofbecause the user can just type in part of any one of them and the options automatically filter

[web2py] Re: web2py behind IIS - 404 File or Directory Not Found.

I cannot truly help, but I do use IIS and have found that it can be cantankerous. I would suggest simply trying to get a static file from web2py then you can work on the IIS settings to allow certain types of files that it might be blocking. The 404 on a new IIS installation simply means you

[web2py] Re: TABLE and TBODY helpers add TR innapropriately

Leonel thanks for your help. I did need to put everything in the XML the way I was doing it because otherwise it all gets escaped. But that is because I was basically converting everything to a string first which is not what I wanted so you were right and I was confused. As far as why not put

[web2py] Re: TABLE and TBODY helpers add TR innapropriately

Anthony, this is what I was looking for. Thanks! I am trying not to build the html myself and use the helpers instead. I am going for readability and ease of use for others to modify later. In all the examples in the book nowhere did it show the append and insert for the HTML helpers I looked

[web2py] TABLE and TBODY helpers add TR innapropriately

I am trying to build a table from a joined set of db tables and need to do quite a bit of processing to make the links and buttons in each row. Making the code readable is important to me so I do not want to put one giant long line of code to do everything and make it impossible for another

[web2py] Re: Autoincrement which resets each month (not primary id)

it for you. ~Brian On Sunday, March 5, 2017 at 11:26:51 AM UTC-6, Paul Ellis wrote: > > I want to have a numbering system which is 2 digit year, 2 digit month and > then an autoincrement number which resets each month. 1703# > > Currently using SQLite with a view to move to

[web2py] Re: Difference of two date field in years

Like Anthony said, without seeing your code we can't help. What exactly do you mean by "is not able to recognize date fields as date"? As an alternative to dateutil you could also look into the Pendulum package (https://pendulum.eustace.io/) which makes playing with dates even easier. On

Re: [web2py] Re: Performance using MSSQL stored procedures

https://datatables.net/extensions/scroller/examples/ if you must have huge numbers of rows displayed. On Friday, December 2, 2016 at 2:25:14 PM UTC-6, Dave S wrote: > > On Friday, December 2, 2016 at 12:33:46 AM UTC-8, Gabor Nyul wrote: >> >> Brian, >> >> In fac

[web2py] Re: Javascript functions for Canvas not working

In case other have this sort of a problem where javascript events are affected by the css of bootstrap... the problem was in the css file: bootstrap.min.css somehow the relative position causes the event not to bubble up. How jacked up is that?

Re: [web2py] Re: Performance using MSSQL stored procedures

What Dave S. said is key > > "*If you had insight into what the users were looking for during their > examination of the data*, you may be able to provide a better query that > could *simplify the data presentation*." Sit down with your users and find out what it is that they *actually* need

Re: [web2py] Re: https causes site to be in text

. And then like Leonel did, try loading each resource one at a time to see if they all work. At least one of each type in each folder and so on, just to be sure. Good Luck, Brian On Thursday, December 1, 2016 at 10:40:59 AM UTC-8, peter wrote: > > In my nginx.conf I have > > . &g

[web2py] Javascript functions for Canvas not working

I have created a codepen that draws on the canvas and used a javascript addEventListener to capture the mouse clicks. I think that not working properly is my issue. What would be the proper procedure to grab a codepen sample and serve it up in the framework properly? I am still on the learning

Re: [web2py] Re: Performance using MSSQL stored procedures

hey're easy for the user to access in a way that's easy for them. ~Brian On Wednesday, November 30, 2016 at 3:43:03 PM UTC-6, Gabor Nyul wrote: > > Well, my users have as good as no computer literary, so the reports > (lists) must be predefined for them. > Theyhave just to enter som

[web2py] setup_exe.py bbfreeze- Not building working executable

myself before (though not in over a year) and it doesn't look like the build related files have been updated in a couple of years so I don't know what's wrong. Anybody else out there managed to do a successful windows binary build recently or have any ideas about what might be wrong? Brian

[web2py] Re: Do conditionals short circuit for DAL?

Well even if you're writing the query using the DAL the actual data processing is being done by the database itself so that's where the "short circuiting" would need to happen and is dependent on the database's query optimization. Try running a SQL version of the query directly against the DB

[web2py] Re: Under Scheduler request.is_scheduler is None rather than True - Why?

ue (seems to work > after a quick test on Windows). > > Anthony > > On Monday, October 3, 2016 at 5:46:26 AM UTC-4, Niphlod wrote: >> >> can you please file a bug on https://github.com/web2py/web2py/issues ? >> I'd like to keep track of it and fix ASAP >> >>

[web2py] Re: Scheduler - response.render no longer working

;> I'll open an issue and propose a fix. >> >> Anthony >> >> On Monday, October 3, 2016 at 5:48:40 AM UTC-4, Niphlod wrote: >>> >>> hum. Trunk has been recently updated in the management of caching code >>> for controllers and views wonder if

[web2py] Re: Under Scheduler request.is_scheduler is None rather than True - Why?

https://github.com/web2py/web2py/issues/1484 On Monday, October 3, 2016 at 4:46:26 AM UTC-5, Niphlod wrote: > > can you please file a bug on https://github.com/web2py/web2py/issues ? > I'd like to keep track of it and fix ASAP > > On Monday, October 3, 2016 at 5:45:21 AM UTC+2

[web2py] Under Scheduler request.is_scheduler is None rather than True - Why?

Is there a reason why when something is run under the scheduler request.is_scheduler = None rather than True? When you access request.is_scheduler from outside of the scheduler you get False as one would expect. The current None value seems strange/non-intuitive. #this won't work if

[web2py] Scheduler - response.render no longer working

backwards compatibility breaking change been made to the scheduler environment? Any advice would be much appreciated. -Brian PS. I've seen https://groups.google.com/forum/#!searchin/web2py/response.render$20scheduler|sort:relevance/web2py/UsUvODL07zs/HrcCsxQcCQAJ which would seem related but I'm una

[web2py] Re: Manipulating Items in DropDown List using SQLFORM

In my models.py where I setup the database tables I have a row db.define_table('item', Field('parentid','integer', label='Part of'), Field('itemtypeid', db.itemtypes, required=True, requires=IS_IN_DB(db,db.itemtypes,'%(name)s',orderby='id',error_message='Select

[web2py] Re: JSON getting the series data into view

Make sure you are using the correct URL to retrieve the data. I just did a test of that example from the book by creating a controller and index view and it works as expected. In your original post you show $.getJSON('/application/default/weekdays', and in your last reply you suggest you

[web2py] Re: Manipulating Items in DropDown List using SQLFORM

That makes sense but doesn't IS_IN_DB create foreign keys in database or other relationships between the tables that might be effected? On Sunday, September 4, 2016 at 5:08:23 AM UTC-4, Brian Boatright wrote: > > I'm using SQLFORM and was able to add an orderby to the original model &

[web2py] Manipulating Items in DropDown List using SQLFORM

I'm using SQLFORM and was able to add an orderby to the original model class to sort a resulted dropdown list sqlform was generating. Ideally I need to limit the items in the dropdown list by id to be id > 10, as the first 10 are static types and those over id 10 are user generated and

[web2py] "conent" instead of "content" and double nesting using db.parse_as_rest

I was building out a simple API and found a few issues with the output build using the experimental "parse_as_rest" feature. I'm using Telerik KendoUI Grid which is pretty robust and something we already use on C# MVC projects so I have some experience and help from my co-workers when I miss

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

so it's just something in the web2py code base that has a problem with the word "items" as a database table name. -- 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] Re: Cannot Create Table Named "Items" - Already Exists

thanks to Yoel pointing out that "item" works I just changed the table name to "item" instead of "items" but I would really like to see this issue fixed or at least explained. it's either a bug or a reserved word that isn't being detected correctly. Thanks all for the help so far. --

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

indeed! I'm new to web2py and python. if I knew a bit more I would try to edit the base.py function for define_table that might give some more details. the error stops right on line 819 of base.py. would be good to have self.tables print out as part of the error or even directly on the page.

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

I haven't figured out how to get an interactive console on my windows machine BUT I did upload the package to pythonanywhere and used their bash shell. The only tables created were the standard authentication tables.

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

just to be sure it wasn't some odd cache issue or something I missed I created a brand new simple app in the admin called "forum" and created a new model file models.py and created a very basic items table. # -*- coding: utf-8 -*- > db.define_table('items', >

[web2py] Re: Cannot Create Table Named "Items" - Already Exists

I always delete the database in mysql and create it again (no tables). Then delete all the files in the database folder. When it runs again, as far as I know, everything is clean. My connection string is just a simple > uri: mysql://root:password@localhost/project and I don't see anything

[web2py] Cannot Create Table Named "Items" - Already Exists

Is "items" a keyword for Python or Web2py? I'm using mysql and having web2py models file define a new table named "items" but it gives me an error that says the table already exists. If I change the name of the table to something like "items2" in the models.py file it works. The mysql

[web2py] Re: Reddit clone source code?

https://github.com/mdipierro/web2py-recipes-source/tree/master/source/02_building_your_first_applications/03_building_a_reddit_clone and the source code for the book is on github as well https://github.com/mdipierro/web2py-recipes-source/tree/master/source -- Resources: - http://web2py.com -

[web2py] Re: Is 'Container' a Reserved Word?

preferred the models in separate files, but maybe that's not possible when they have so many foreign keys. Is it possible to stage the order which the model files are read so table declarations will be in the right sequence? On Sunday, August 28, 2016 at 8:41:17 PM UTC-4, Brian Boatright wrote

[web2py] Is 'Container' a Reserved Word?

I've tried adding a model for "Containers" and "ContainerTypes" each time I get an error when it tries to create the tables when I click the Database Admin button. The other tables I'm defining are working fine. I have a few other tables that have "Type" in their mode/table name so when I

[web2py] Making web2py AVailable in Softaculous

I've been using nosupportlinuxhosting for a while and with good success. At $1 per website per month it's a bargain for project sites and development. They use cPanel and one of the features of Cpanel is Softaculous to make setting up a LOT of popular web software and frameworks available

RE: [web2py] Re: markmin

I'm passing in a get variable called x to the wiki page. I'm trying to read the value of x from the wiki page. Is there a way to do that? -Original Message- From: "Leonel Câmara" Sent: ‎5/‎8/‎2016 7:58 AM To: "web2py-users" Subject:

[web2py] Re: DAL connection to MSSQL

You can do it but you must tell the DAL that the table exists. It won't just discovered existing tables for itself. -- 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] DAL connection to MSSQL

I think db._tables only lists the tables you have defined within the DAL rather than going to the database itself and listing any tables that are there independent of the DAL (for example if you are connecting to a database that wasn't created through the DAL). Have you defined any tables

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

s coming form > new web2py version or not). > > Or could it be possible that you create the archive table manually back in > time? Or that some file in app/databases/ folder get deleted?? > > Richard > > > > On Tue, Feb 23, 2016 at 11:12 AM, Brian M <bmer...@gma

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

ms to work and is essentially doing a manual fake migration. But I'd still like to hear from Massimo or another dev whether or not this is intended to behave this way or if there really should be a fake_migrate argument for _enable_record_versioning() like there is for regular table definitions. Brian

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

is_active='is_active') > > Where I specified the name of the table to use for archiving records... > > You may have a look at your history table(s) and try to set the previous > parameters for each of your instanciation of the _enable_record_versioning() > > Richa

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

error message? > > On Mon, Feb 22, 2016 at 9:53 PM, Brian M <bmer...@gmail.com > > wrote: > >> The restore was done with MS SQL Server's built-in backup & restore so >> yes it has all of the tables and info. The dozens of other tables in my >> database

Re: [web2py] Restored DB, _enable_record_versioning() and fake migrations?

8:39:22 PM UTC-6, Richard wrote: > > If you restore database like for like, why are you bother with > fake_migrate... Just leave everything to migrate=False should be alright if > you dump contains all the tables... > > Richard > > On Mon, Feb 22, 2016 at 4:55 PM, Brian M &

[web2py] Restored DB, _enable_record_versioning() and fake migrations?

there and it doesn't need to try to recreate it. Brian -- 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 Issues) --- You received this message because you are subscribed to the Google

[web2py] Re: daily scheduler task - FIX

the times_failed becomes zero and now you're going to calculate incorrect next_run_time values (they'll likely end up in the past) and just end up with your task running extra again. So not quite so simple of a fix as I initially thought. :\ On Sunday, February 21, 2016 at 9:44:41 AM UTC-6, Brian M

[web2py] Re: daily scheduler task - FIX

the times_failed becomes zero and now you're going to calculate incorrect next_run_time values (they'll likely end up in the past) and just end up with your task running extra again. So not quite so simple of a fix as initially On Sunday, February 21, 2016 at 9:44:41 AM UTC-6, Brian M wrote

[web2py] Re: daily scheduler task - FIX

y think is right now that the problem and cause have been clearly identified. Brian On Sunday, February 21, 2016 at 7:14:33 AM UTC-6, Alex wrote: > > thanks for investigating on this, Brian. This really explains the strange > behavior. As a bugfix I'd suggest to consider the failed runs for

[web2py] Re: daily scheduler task

fix bug next_run_time=task.next_run_time, status=status ) I've made the above change to my local version of gluon/scheduler.py and it does appear to fix the problem so after. So if Massimo, Nilphod or another developer can review and add the patch I'm sure at least Alex & I would appreciate

[web2py] Re: daily scheduler task

My setup is on Windows with the scheduler running as a service via nssm. I have it set to run every 86400 seconds (24hrs) with infinite number of runs and retries. The timeout is something like 2 or 3 minutes. I am also using the "cron like" option so that it always runs at exactly the same

[web2py] Re: daily scheduler task

this sort of thing happen a few other times as well. Brian On Wednesday, February 3, 2016 at 1:43:26 PM UTC-6, Niphlod wrote: > > it really doesn't change that much if it's bad code or good one, it's > executed in web2py env that traps the exception. Unless you're overriding > mul

[web2py] Re: Select statement with MSSQL

You must first tell the DAL about the tables in your database before you can ask it to select data from them. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Table-constructor On Saturday, December 19, 2015 at 3:39:45 AM UTC-6, sa wrote: > > Hi, > > Can not select

[web2py] Re: defer query in controller

suggestion for how this can be achieved (i.e., something the > framework could do differently)? > > Anthony > > On Friday, December 4, 2015 at 3:42:00 PM UTC-5, Brian Craft wrote: >> >> Ah, I see. I'm not sure that helps me, because I want the browser to >> down

[web2py] Re: defer query in controller

27:19 PM UTC-8, Anthony wrote: > > On Thursday, December 3, 2015 at 5:37:51 PM UTC-5, Brian Craft wrote: >> >> I don't know what this means. >> > > He's saying to load a parent page (that does not run the query or return > any data), and once the parent pag

[web2py] Re: defer query in controller

e) helper. > > On Thursday, 3 December 2015 15:33:04 UTC-6, Brian Craft wrote: >> >> A large query is causing the client (browser) to become unresponsive, >> because web2py doesn't return anything to the client until the controller >> function has completed. >> >&

[web2py] defer query in controller

A large query is causing the client (browser) to become unresponsive, because web2py doesn't return anything to the client until the controller function has completed. It needs, instead, to return a chunked response header immediately, with the data to follow. From the controller I can return

[web2py] managing project source

Just looking at web2py for the first time, and I'm not sure what to do with it: can't manage it with pip, and app code is edited in-place with the web2py code? I was expecting to be able to install & manage web2py with standard python tools & manage my app code separately, in its own repo. How

[web2py] Re: LOAD and export to CSV

and set a link to > download it as part of the LOAD return, a two step process for the export > scenario. > I was just hoping someone had a better idea. > > Thanks, > Denes > > > > On Monday, September 28, 2015 at 8:38:37 PM UTC-4, Brian M wrote: >> >> Hav

[web2py] LOAD and export to CSV

Have you tried setting the appropriate content type header before returning? I've not done it inside a LOAD before but know that setting the content type will normally get the browser to download & save a CSV file rather than just display it. Brian -- Resources: - http://web2py.com -

[web2py] Re: All forms clear and do not submit

brackets. Something interesting is if we try to create a cookie from within Web2py with a square bracket, Web2py will encapsulate the value with quotes and the bug will not take effect. This was fixed in Python 2.7.10 (https://hg.python.org/cpython/raw-file/15c95b7d81dc/Misc/NEWS). Brian

[web2py] Re: All forms clear and do not submit

these cookies have a broader domain, they end up in my web2py app when users go to the culprit site. I'll have to investigate how these cookies interfere with web2py forms. Thank you, Brian On Thursday, August 20, 2015 at 10:19:55 PM UTC-7, Massimo Di Pierro wrote: Is there a proxy or a load balancer

[web2py] All forms clear and do not submit

, Brian -- 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 Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group

[web2py] Re: Bug in XML(...,sanitize=True) ?

. Will fix it today. On Friday, 26 June 2015 18:05:27 UTC-5, Brian M wrote: I'm working on upgrading to the latest web2py version and may have uncovered a bug in the sanitizer. If you use XML(form.var.something, sanitize=True) and form.var.something is just a plain string without any tags

[web2py] Bug in XML(...,sanitize=True) ?

I'm working on upgrading to the latest web2py version and may have uncovered a bug in the sanitizer. If you use XML(form.var.something, sanitize=True) and form.var.something is just a plain string without any tags then what you end up getting returned is an empty string rather than the

[web2py] Re: FYI - MSSQL, Executesql and data columns retrieved as strings

OK so what is the recommended adapter for news versions? I saw that there are like 4 different mssql adapters in the dal source but it wasn't really clear which one to use when. On Wednesday, June 17, 2015 at 1:42:02 AM UTC-5, Niphlod wrote: 10.0 for 2008, 11.0 for 2012, (or 12.0, if sql

[web2py] FYI - MSSQL, Executesql and data columns retrieved as strings

This is just a helpful tip should anyone else run into this problem. When using MS SQL 2012 (may also happen with 2010 and 2008) and the DAL's executesql() feature, if your query includes data type columns they'll have a tendency to be pulled in by pyodbc as unicode strings rather than dates.

[web2py] Anybody Using PTVS (Python Tools for Visual Studio)?

Is anybody developing with PTVS who's got debugging and everything setup and willing to share your config? -- 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 Issues)

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

I think that Weheh may be on to something. I had been using Apache 2.2.22 and just grabbed a fresh copy of 2.2.29 from Apache Lounge https://www.apachelounge.com/download/additional/ and tried it out on my desktop and it appears that static files are now being served directly by Apache rather

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

-Alive: timeout=5, max=100 Connection: Keep-Alive Content-Type: text/css; charset=utf-8 I've got Apache configured per the Windows section in the web2py book. (Which incidentally appears to be down at the moment) -Brian On Tuesday, March 31, 2015 at 4:09:53 PM UTC-5, Niphlod wrote: You need

[web2py] Re: mod_wsgi errors -- dead in the water

it predominantly on a page that does a lot of ajax calls. Brian On Monday, March 30, 2015 at 5:33:14 PM UTC-5, weheh wrote: On a Windows 7 server running the latest Apache, I'm getting the following mod_wsgi errors showing up in the Apache error.log file: mod_wsgi (pid=1233) Exception occurred

[web2py] Re: Web2py: Create a CSV file to download for an executesql result

']='attachment; filename=data_for_%s.csv' % date.today() return csv_stream.getvalue() which will cause browser to download the csv file with your chosen filename you could also turn around and save the datafile to the filesystem if you wanted. Hope this helps! Brian On Saturday, March 28

Re: [web2py] Re: Running multiple lines of SQL in executesql

Strange. Does that same query work if you enter it directly in your DB's interface? I'm guessing from the link you provided that you're using MySQL; I've only done it with MS SQL and SQLite but I'd think that the triple quoting technique should work with other databases too. On Wednesday,

[web2py] Re: Running multiple lines of SQL in executesql

Actually just surround your big long multi line SQL statement with triple quotes and it will work fine. I do that all the time. No need for the \ at each line break then either. You can declare and set your @variables all within one executesql query too. On Tuesday, March 10, 2015 at 2:36:28

[web2py] Re: Web2py, Apache and Ubuntu 14.04

, mweissen wrote: Solved. Thank you, Brian - you showed me the right way. The error message was ERR_CONNECTION_TIMED_OUT, but the browser shows only a message like page could be loaded (in German). Two things happend: - The new apache default.conf rewrites anything to https - In consequence

[web2py] Re: Web2py, Apache and Ubuntu 14.04

some of my problems in one of my earlier Ubuntu troubles threads to linked to. Brian On Sunday, October 5, 2014 2:41:09 PM UTC-5, mweissen wrote: One of my servers uses Ubuntu 13.04. Today I have changed to Ubuntu 14.04 and now it is not possible to access the webpage. There is a lot

[web2py] Re: Accesing table from external database

wrote: Thanks Brian and Carlos for the answer and sorry for my delay. external database means it's a database not created by Web2py. The matter is I'd like to reference a web2py table with another table from the external database. I know that this is not possible, but what could be the best

[web2py] Re: Accesing table from external database

What do you mean by external database? Are you actually meaning a legacy database that the DAL didn't create itself? You can certainly connect web2py to such a database through the DAL or even just using db.executesql(). If you need to get a list of valid options for your combobox you can do

[web2py] Re: Web2py Deployment Script for Ubuntu 14.04

I posted about this a couple weeks ago along with what worked for me ,,https://groups.google.com/forum/#!searchin/web2py/Apache$20Ubuntu%7Csort:date/web2py/o6OGQRQTN6Y/oJJQMGChgpcJ On Friday, July 18, 2014 7:14:18 AM UTC-5, Auden RovelleQuartz wrote: This recipe which had worked: { One

[web2py] Re: update database right from view?

it it is up to you to make sure that the text ID provided is actually in the database and that the chosen word form is actually a valid choice for that particular text. ~Brian On Wednesday, July 9, 2014 4:26:37 PM UTC-5, Maria Levchenko wrote: Sorry for novice question, but I can't handle

[web2py] Re: Ubuntu 14.04 Setup Script with Apache - Issues?

to avoid the issues. Thanks On Wednesday, June 18, 2014 11:08:33 PM UTC-4, Brian M wrote: Anybody else tried setting things up on Ubuntu 14.04 using scripts/setup-web2py-ubuntu.sh? I tried it this evening and ran into multiple issues 1) The generated sites-available/default configuration

[web2py] Re: Trying to use the LOAD helper, if a button is clicked

Looks like the new datatables.net v1.10 has a new API so there are now probably better ways to do this than I showed. On Monday, June 23, 2014 4:51:53 AM UTC-5, Tomeu Roig wrote: Thanks Brian El lunes, 23 de junio de 2014 03:56:32 UTC+2, Brian M escribió: Tomeu, At the moment I'm just

[web2py] Re: Trying to use the LOAD helper, if a button is clicked

, new_record.table.foreign_id]) #issue command for adding new row to datatable response.js = 'vol_table.fnAddData('+table_update+');' Good luck ~Brian On Sunday, June 22, 2014 4:44:33 PM UTC-5, Tomeu Roig wrote: Thanks Brian, nice think to get a full href for pass to the $web2py.component

[web2py] Re: Ubuntu 14.04 Setup Script with Apache - Issues?

might need addressing. Brian On Wednesday, June 18, 2014 10:08:33 PM UTC-5, Brian M wrote: Anybody else tried setting things up on Ubuntu 14.04 using scripts/setup-web2py-ubuntu.sh? I tried it this evening and ran into multiple issues 1) The generated sites-available/default configuration

[web2py] Re: CSS and graphics not loading in admin interface (lighttpd)

It may be that response.static_version is enabled but the web server is not setup to handle the resulting URL. Try using your browser's developer tools to see what the URL for the missing files is; if it includes /static/_#.#/some/file.CSS this is your problem. See the deployment section of

  1   2   3   4   >