Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
apache/mod_wsgi setup is working as expected now on mac On Friday, December 23, 2022 at 1:55:04 PM UTC-5 Ian W. Scott wrote: > Okay, my one remaining problem is logging output. I'm using the default > logging settings for web2py, and it usually is output in the apache error > log. Bu

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
2py internal server for simplicity. > > Anyway have you setup uwsgi to use the right python? > > Il giorno ven 23 dic 2022 alle ore 09:22 Massimiliano > ha scritto: > >> How do you start web2py? >> >> Il giorno ven 23 dic 2022 alle ore 03:39 Ian W. Scott >>

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
gt; In my dev machine I use the web2py internal server for simplicity. > > Anyway have you setup uwsgi to use the right python? > > Il giorno ven 23 dic 2022 alle ore 09:22 Massimiliano > ha scritto: > >> How do you start web2py? >> >> Il giorno ven 23 dic 202

[web2py] Re: Help on macos

2022-12-22 Thread Ian W. Scott
:43:56 PM UTC-5 Ian W. Scott wrote: > I've just moved to mac for my development and am trying to rebuild my > (formerly Linux) web2py dev environment. But I've hit a complete dead end: > - web2py is generating 500 errors in the browser > - there's no log output in the apache logs at all

[web2py] Help on macos

2022-12-22 Thread Ian W. Scott
I've just moved to mac for my development and am trying to rebuild my (formerly Linux) web2py dev environment. But I've hit a complete dead end: - web2py is generating 500 errors in the browser - there's no log output in the apache logs at all (so no error messages) - none of the db table files

[web2py] Re: Bypass web2py for static maintenance page

2022-09-21 Thread Ian W. Scott
Monday, September 19, 2022 at 6:07:18 PM UTC-4 Ian W. Scott wrote: > I'm trying to set up a static maintenance page under apache that doesn't > depend on web2py. The problem is that the mod_wsgi scriptalias directive > seems to override the rewrite instructions to serve the static maint

[web2py] Bypass web2py for static maintenance page

2022-09-19 Thread Ian W. Scott
I'm trying to set up a static maintenance page under apache that doesn't depend on web2py. The problem is that the mod_wsgi scriptalias directive seems to override the rewrite instructions to serve the static maintenance page. My apache config includes this: ErrorDocument 503

[web2py] Re: "TypeError: sequence of byte string values expected, value of type str found" when accessing admin

2020-05-01 Thread Ian W. Scott
Did you ever solve this problem? I'm running into the same thing. On Monday, April 8, 2019 at 12:56:49 PM UTC-4, João Matos wrote: > > When using Apache 2.4 (HTTPS using port 443) with web2py the application > works fine, but the admin interface always returns and error "Internal > Server

[web2py] Likely causes of admin server error?

2020-05-01 Thread Ian W. Scott
What are the "likely culprits" I should be looking at when I get an "Internal server error" accessing admin or appadmin on a fresh web2py installation? Here's what I've been trying so far. - Apache2 config file correctly configured? - I'm - accessing over https? - admin password set? -

Re: [web2py] Re: Server error when accessing admin

2020-05-01 Thread Ian W. Scott
. Scott wrote: > > Unfortunately I don't know anything about nginx. I've always worked with > apache2. Can anyone suggest how to debug this? I'm really at the end of my > rope here. > > On Thursday, April 30, 2020 at 10:37:58 AM UTC-4, Ian W. Scott wrote: >> >> Thank

Re: [web2py] Re: Server error when accessing admin

2020-04-30 Thread Ian W. Scott
Unfortunately I don't know anything about nginx. I've always worked with apache2. Can anyone suggest how to debug this? I'm really at the end of my rope here. On Thursday, April 30, 2020 at 10:37:58 AM UTC-4, Ian W. Scott wrote: > > Thanks very much > > Ian W. Scott, PhD > Asso

Re: [web2py] Re: Server error when accessing admin

2020-04-30 Thread Ian W. Scott
Thanks very much Ian W. Scott, PhD Associate Professor of New Testament Tyndale Seminary, Toronto, Canada www.ianwscott.com (http://www.ianwscott.com) Paul's Way of Knowing: Story Experience and the Spirit (Baker Academic [Mohr Siebeck], 2006) The Online Critical Pseudepigrapha (SBL, 2006

[web2py] Re: Server error when accessing admin

2020-04-30 Thread Ian W. Scott
Thanks Annet for your help. Webfaction doesn't seem currently to make that install script available when you're creating a new application in a server. Web2py doesn't appear anywhere on the list of available application types. Do you know if it's available somewhere else on their service?

[web2py] Server error when accessing admin

2020-04-29 Thread Ian W. Scott
I'm setting up a fresh install of web2py (on webfaction) on centos7 with Apache 2.4.6 and PostgreSQL under Python 3.8. I've followed the server configuration section of the web2py manual and the welcome app itself is working fine. But when I try to navigate to Admin or appadmin I get a 500

[web2py] Re: Help understanding memory use and selects

2019-09-04 Thread Ian W. Scott
In case someone is looking for answers to my numbered questions, it seems from what I can tell that: 1. Memory used performing a select isn't released for quite a while afterwards, even if your code doesn't use that data again. So multiple selects will quickly make your memory usage

[web2py] Re: Help understanding memory use and selects

2019-09-04 Thread Ian W. Scott
r 2, 2019 at 3:44:18 PM UTC-4, Ian W. Scott wrote: > > I'm trying to lower the memory use of an app and have some general > questions about how memory is used in DAL selects: > > >1. Am I right that the memory used while performing the select isn't >released right away

[web2py] Re: Help understanding memory use and selects

2019-09-04 Thread Ian W. Scott
Thanks Dave. That was helpful. On Tuesday, September 3, 2019 at 3:29:02 AM UTC-4, Dave S wrote: > > > > On Monday, September 2, 2019 at 12:44:18 PM UTC-7, Ian W. Scott wrote: >> >> I'm trying to lower the memory use of an app and have some general >> questions a

[web2py] Help understanding memory use and selects

2019-09-02 Thread Ian W. Scott
I'm trying to lower the memory use of an app and have some general questions about how memory is used in DAL selects: 1. Am I right that the memory used while performing the select isn't released right away, even if the select isn't assigned to a variable? 2. I'm aware of iterselect.

[web2py] Problem importing installed module

2019-08-19 Thread Ian W. Scott
When I try to import pytz at the top of my db.py model I'm getting the following error: No module named 'applications.paideia.modules.pytz' "paideia" is the name of the application. I'm running python 3.7 and double-checked that pytz is accessible from the py3.7 interactive prompt. It is.

[web2py] Example mod_wsgi config file?

2019-08-19 Thread Ian W. Scott
The web2py book refers to a sample wsgi config file (web2py-wsgi.conf) that is supposed to be in the "scripts" folder. But it's not there in the current production release. Is that available somewhere? I'm running into some problems with my config. Thanks. -- Resources: - http://web2py.com -

[web2py] Re: Big picture issues in using react with web2py

2019-03-13 Thread Ian W. Scott
Thanks Anthony. That's very helpful. On Monday, March 11, 2019 at 7:02:31 PM UTC-4, Anthony wrote: > > On Monday, March 11, 2019 at 9:52:16 AM UTC-4, Ian W. Scott wrote: >> >> I'd like to use react to build a relatively freestanding, single-page >> front-end int

[web2py] Re: Big picture issues in using react with web2py

2019-03-11 Thread Ian W. Scott
Okay. Good. Is there documentation somewhere on how to serve a static index page? I can't seem to find it in the book. On Monday, March 11, 2019 at 9:55:26 AM UTC-4, Leonel Câmara wrote: > > That seems perfectly doable. It's very much ok to use web2py simply to > make an API for react to call.

[web2py] Big picture issues in using react with web2py

2019-03-11 Thread Ian W. Scott
I'd like to use react to build a relatively freestanding, single-page front-end interface that communicates with web2py for dbio and heavier processing. But I'm having a hard time wrapping my mind around how to approach integrating them. I realize that I'm running into some gaps in my

[web2py] Where is password reset link handled?

2018-01-16 Thread Ian W. Scott
I'm trying to debug an "invalid reset password" message when a user tries to reset their password via an emailed link. I'm confused, though, about where the emailed link is handled. I understand that it goes to default/user/reset_password, but where in gluon (tools.py?) is that response

[web2py] Re: "Invalid email" when requesting password reset

2017-11-30 Thread Ian W. Scott
I think you're right. It looks like the execution hangs up in Auth.request_reset_password at the point where the system is checking a setting for password case sensitivity: if not self.settings.email_case_sensitive: table_user.email.requires.insert(0, IS_LOWER()) I

[web2py] "Invalid email" when requesting password reset

2017-11-30 Thread Ian W. Scott
I have one user (and only one) whose email has suddenly started to be rejected by the auth login system. With the correct email address and password (I've double-checked) he gets "Invalid login." Then when he tries to use the password reset form he gets an "Invalid email" notice, as if the

[web2py] Re: Routes.py to filter out file version numbers

2017-11-20 Thread Ian W. Scott
: > > > > On Monday, November 20, 2017 at 7:04:00 PM UTC-8, Ian W. Scott wrote: >> >> I'm not getting web2py's 404 page because it's not the controller's page >> that isn't found. It's the stylesheet. >> > > Yeah, I just was about to admit I didn't try messing

[web2py] Re: Routes.py to filter out file version numbers

2017-11-20 Thread Ian W. Scott
0, 2017 at 6:02:38 PM UTC-8, Ian W. Scott wrote: >> >> Yes, that's right. I'm getting a 404 on each file with the added version >> string, which must mean that the routes.py isn't pointing the browser >> successfully to the real file (without the version string in the na

[web2py] Re: Routes.py to filter out file version numbers

2017-11-20 Thread Ian W. Scott
, 2017 at 8:38:17 PM UTC-5, Dave S wrote: > > > > On Monday, November 20, 2017 at 9:04:27 AM UTC-8, Ian W. Scott wrote: >> >> I'm still wondering if anyone can help with this. I found a minor error >> in the second member of the routes_in tuple (the period shouldn't b

[web2py] Re: Routes.py to filter out file version numbers

2017-11-20 Thread Ian W. Scott
testing this on the bundled rocket server, so I don't think there's any issue with server settings. Any help would be much appreciated. On Friday, November 17, 2017 at 10:12:58 AM UTC-5, Ian W. Scott wrote: > > Hi there. I'm dynamically adding version numbers to the filenames for > stat

[web2py] Re: Routes.py to filter out file version numbers

2017-11-17 Thread Ian W. Scott
I should add that one reason I'm having trouble debugging is because I'm not sure how to test the output of the rewrite. Is there any way to see exactly what the rule is going to output, given a particular filename? On Friday, November 17, 2017 at 10:12:58 AM UTC-5, Ian W. Scott wrote: > &

[web2py] Routes.py to filter out file version numbers

2017-11-17 Thread Ian W. Scott
Hi there. I'm dynamically adding version numbers to the filenames for static assets like css, js, and image files. (These version numbers aren't actually in the filenames. They're just added to the url in the and

Re: [web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
ere 123456 is you pass phrase. > > 443 is the port for which the password apply > > This will create parameters_443.py file that you drop/replace in the > web2py/ folder and then restart web2py instance and the new generated > password should work. > > Richard > >

Re: [web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
py/ folder and then restart web2py instance and the new generated > password should work. > > Richard > > On Thu, Feb 16, 2017 at 11:29 AM, Ian W. Scott <scot...@gmail.com > > wrote: > >> I seem to have forgotten the admin password for my web2py installation, >>

Re: [web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
save_password; > save_password('123456',443)" > > Where 123456 is you pass phrase. > > 443 is the port for which the password apply > > This will create parameters_443.py file that you drop/replace in the > web2py/ folder and then restart web2py instance and the new gener

[web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
I seem to have forgotten the admin password for my web2py installation, so I need to change it. Looking at posts here, the recommendation was: 1 - stop apache server 2 - restart web2py 3 - enter new password 4 - restart apache server I'm getting stuck at 2. The only way I know how to "restart"

Re: [web2py] Migrate integer field to string type

2016-10-25 Thread Ian W. Scott
lete the old useless column... You need to transform the integer > into text at the insert step... > > Richard > > On Mon, Oct 24, 2016 at 3:32 PM, Ian W. Scott <scot...@gmail.com > > wrote: > >> I'm using Postgresql and I need to migrate the data type of a field

[web2py] Migrate integer field to string type

2016-10-24 Thread Ian W. Scott
I'm using Postgresql and I need to migrate the data type of a field from "integer" to "string". Will it work to just change the field type in the model table definition? What will happen to the existing "integer" data? Any problems foreseen? Thanks, Ian -- Resources: - http://web2py.com -

[web2py] Re: Old field value returns in custom select widget

2016-02-19 Thread Ian W. Scott
e: > > When you pass a record to SQLFORM, it retains the changed values by > passing the values in request.post_vars to the respective field widgets. > Can't say what's going on in your case without the code. > > Anthony > > On Thursday, February 18, 2016 at 4:13:23 PM UTC-5, Ian W.

[web2py] Re: Old field value returns in custom select widget

2016-02-18 Thread Ian W. Scott
, 2016 at 4:06:06 PM UTC-5, Anthony wrote: > > On Thursday, February 18, 2016 at 3:54:43 PM UTC-5, Ian W. Scott wrote: >> >> Okay, that explains the behaviour. How, then, are values usually >> preserved on an ajax form for the built-in widgets? When I submit the form &g

[web2py] Re: Old field value returns in custom select widget

2016-02-18 Thread Ian W. Scott
: > > Hard to say without seeing more code, but note that the widgets are > constructed before any database IO, so any database changes from the > current submission will not be reflected in the returned copy of the form. > > Anthony > > On Thursday, February 18, 2016 at

[web2py] Old field value returns in custom select widget

2016-02-18 Thread Ian W. Scott
I've got a custom select widget class that is working nicely except that when I submit a form via ajax the refreshed widget shows the old (pre-submission) field value. But the changes have been made properly to the database. If I refresh the page containing the form (not via ajax) the new

Re: [web2py] Re: Get return value from controller function via ajax

2016-01-21 Thread Ian W. Scott
; On Wednesday, January 20, 2016 at 4:20:22 PM UTC-5, Ian W. Scott wrote: >> >> Thanks. So to clarify, if I serialize the return value as json in the >> controller, then I can use it in javascript. It looks like I still have to >> parse the json on the javascript

[web2py] Get return value from controller function via ajax

2016-01-20 Thread Ian W. Scott
I'm trying to use ajax calls to update the data for a chart dynamically. I don't want to make the chart a component that refreshes, I just want to get the controller return value back to the javascript in the view, so that I can update the chart via javascript. But web2py's ajax function seems

[web2py] Re: Get return value from controller function via ajax

2016-01-20 Thread Ian W. Scott
, Niphlod wrote: > > from gluon.serializers import json > > def uh(): > return json(blablabla) > > On Wednesday, January 20, 2016 at 8:45:55 PM UTC+1, Ian W. Scott wrote: >> >> I'm trying to use ajax calls to update the data for a chart dynamically. >> I d

[web2py] Error 'module' object has no attribute 'Reference_unpickler'

2015-09-15 Thread Ian W. Scott
Hi. I just tried to access the admin/errors/appname page and I got the following error: 'module' object has no attribute 'Reference_unpickler' Traceback (most recent call last): File "/home/ianwscott/webapps/web2py/web2py/gluon/restricted.py", line 227, in restricted exec ccode in

[web2py] Re: Error 'module' object has no attribute 'Reference_unpickler'

2015-09-15 Thread Ian W. Scott
some error reports up to 3 years old. I haven't messed with the error reporting system at all, so I'm not sure why this app would throw the error. Ian On Tuesday, September 15, 2015 at 2:25:13 PM UTC-4, Ian W. Scott wrote: > > Hi. I just tried to access the admin/errors/appname page and

[web2py] Re: How to store etree object that can't be pickled

2015-08-29 Thread Ian W. Scott
On Saturday, August 29, 2015 at 10:03:42 PM UTC-4, Leonel Câmara wrote: Well you can use etree.tostring and save that. Another alternative is to put it in cache ram which does not pickle. I'd like to avoid serializing out to a string because I'd then have to do the parsing over again on

[web2py] How to store etree object that can't be pickled

2015-08-28 Thread Ian W. Scott
I have a parsed lxml.etree object that I need to persist from one request to the next so that users can interact with it. The problem is that etree objects can't be pickled, so when I try to store it in session I get a PicklingError. I just tried using memcache instead, but it seems to use

Re: [web2py] Re: Keep values with a list:string field?

2015-08-14 Thread Ian W. Scott
25, 2014 at 6:33:26 PM UTC+3, Ian W. Scott wrote: I've got a SQLFORM.factory form set to keep values after processing with process(keepvalues=True). But it doesn't work on a list:string field. The (otherwise very nice) widget loses all but the first value when the form is submitted (i.e., all

Re: [web2py] Re: Keep values with a list:string field?

2015-08-14 Thread Ian W. Scott
, requires=field.requires) Field('comment', 'string', widget=my_string_widget) On Fri, Aug 14, 2015 at 9:50 AM, Ian W. Scott scot...@gmail.com javascript: wrote: I agree with Richard that the issue (or my issue at least) has to do with the widget, not with the internals

[web2py] Re: Keep values with a list:string field?

2015-08-12 Thread Ian W. Scott
I never got any suggestions on this, even though it seems like a significant limitation of the widget. Has anyone come up with a solution for keeping all the values in a list:string field after form submission? Thanks. On Wednesday, June 25, 2014 at 11:33:26 AM UTC-4, Ian W. Scott wrote

Re: [web2py] Re: Keep values with a list:string field?

2015-08-12 Thread Ian W. Scott
issue... Also, can you tell us which web2py version you use. Thanks Richard PS.: Once I confirm I have the issue we should open a ticket on github... # On Wed, Aug 12, 2015 at 1:41 PM, Ian W. Scott scot...@gmail.com javascript: wrote: No, they're not submitted if I re-submit the form

Re: [web2py] Re: Keep values with a list:string field?

2015-08-12 Thread Ian W. Scott
: message = BEAUTIFY(form.errors) On Wednesday, August 12, 2015 at 11:04:46 AM UTC-4, Richard wrote: Could you show your model and controller... This make no sens... Richard On Wed, Aug 12, 2015 at 10:45 AM, Ian W. Scott scot...@gmail.com javascript: wrote: I never got any

Re: [web2py] Re: Keep values with a list:string field?

2015-08-12 Thread Ian W. Scott
display by the widget... Richard On Wed, Aug 12, 2015 at 1:21 PM, Ian W. Scott scot...@gmail.com javascript: wrote: Sorry if I'm not explaining this well. The default widget for a list:string field is a vertically stacked list of inputs, one per value. There is a little + at right

[web2py] New import problem when testing web2py app with pytest

2015-05-15 Thread Ian W. Scott
I've been successfully using pytest for quite a while now to do unit testing for my web2py apps. Today, after upgrading to the latest web2py version (Version 2.10.4-stable+timestamp.2015.04.26.15.11.54) my tests won't run. When I try to run the tests in a test file (in the tests/ directory)

[web2py] Re: New import problem when testing web2py app with pytest

2015-05-15 Thread Ian W. Scott
Never mind! I discovered the problem in my conftest.py file. Thanks anyway! On Friday, May 15, 2015 at 3:57:47 PM UTC-4, Ian W. Scott wrote: I've been successfully using pytest for quite a while now to do unit testing for my web2py apps. Today, after upgrading to the latest web2py version

[web2py] After changing db adapter relation 'auth_user' already exists

2015-05-06 Thread Ian W. Scott
To work around my earlier unicode problem (I submitted an issue on Github) I switched from the pg8000 adapter to the psycopg2 adapter for my postgre database. Everything works fine as long as I have migrate set to False. But if I set migrate=True I get this error: class

[web2py] Re: Custom comparison function with orderby in select()

2015-05-05 Thread Ian W. Scott
having the database handle it. Anthony On Thursday, April 30, 2015 at 3:42:06 PM UTC-4, Ian W. Scott wrote: I want to sort the results of a select() based on a string field. Normally I can just use select(orderby=db.mytable.myfield), but the strings are not in Latin characters, so

[web2py] Re: Using Travis CI to test a web2py app on Github

2015-05-05 Thread Ian W. Scott
I was distracted from this thread, but a belated thanks for your response, Niphlod. To clarify, the error I posted was from Travis CI's remote process. I have no problem running my tests locally, but in that case I can start a web2py instance normally as part of the testing process. The

[web2py] Custom comparison function with orderby in select()

2015-04-30 Thread Ian W. Scott
I want to sort the results of a select() based on a string field. Normally I can just use select(orderby=db.mytable.myfield), but the strings are not in Latin characters, so the default string sorting produces unacceptable results. I've figured out how to create a comparison function using

[web2py] Re: SQLFORM hanging on insert

2015-04-11 Thread Ian W. Scott
. On Friday, February 6, 2015 at 12:10:58 PM UTC-5, Ian W. Scott wrote: Thanks for your response Massimo. I'll try to put together a minimal version today and post it. Ian On Thursday, February 5, 2015 at 4:46:46 PM UTC-5, Massimo Di Pierro wrote: Does it hang if you use sqlite? Can you provide

Re: [web2py] unicode error with postgre on 2.10.3 (with sample app)

2015-04-11 Thread Ian W. Scott
:24 PM, Ian W. Scott scot...@gmail.com javascript: wrote: Also, as I pointed out in my question I can insert the same string (with the same encoding) directly into the postgre database using the raw SQL code that is being sent by pydal to the postgre adapter. I inserted a print statement

[web2py] Re: Using Travis CI to test a web2py app on Github

2015-04-11 Thread Ian W. Scott
I take it from the lack of response here that what I want to is just impossible? On Wednesday, April 8, 2015 at 10:57:15 AM UTC-4, Ian W. Scott wrote: I've set up a travis-ci.org job to run my test suite (using pytest) whenever I push my app to its github repository. I'm running

[web2py] Using Travis CI to test a web2py app on Github

2015-04-08 Thread Ian W. Scott
I've set up a travis-ci.org job to run my test suite (using pytest) whenever I push my app to its github repository. I'm running into the basic problem that pytest can't find the gluon libraries, since there's nothing in my repo above the level of my app directory. Does anyone know of a simple

[web2py] Re: ProgrammingError violates unique constraint when inserting into a postgresql table

2015-03-26 Thread Ian W. Scott
Repairing the table definition didn't help. I'm now going to try the operations on a fresh table. On Thursday, March 26, 2015 at 10:42:33 AM UTC-4, Ian W. Scott wrote: Thanks Niphlod. I hired someone to migrate the db from sqlite to postgre and there seem to be some bugs in the migration. I

[web2py] Re: ProgrammingError violates unique constraint when inserting into a postgresql table

2015-03-26 Thread Ian W. Scott
to work through web2py's dal. So I realize that the issue now is partly my lack of understanding of postgre. But any help is much appreciated. Ian On Thursday, March 26, 2015 at 1:32:37 PM UTC-4, Ian W. Scott wrote: Repairing the table definition didn't help. I'm now going to try

[web2py] Re: ProgrammingError violates unique constraint when inserting into a postgresql table

2015-03-26 Thread Ian W. Scott
of values. Ian On Wednesday, March 25, 2015 at 6:12:18 PM UTC-4, Ian W. Scott wrote: In a test function I set up some testing data in a postgresql database by first deleting my test user's data and then inserting from a dictionary: db(db.tag_records.name == user_login['id']).delete

[web2py] Re: ProgrammingError violates unique constraint when inserting into a postgresql table

2015-03-26 Thread Ian W. Scott
Thanks Niphlod. I hired someone to migrate the db from sqlite to postgre and there seem to be some bugs in the migration. I hadn't noticed the lack of reference fields because they were originally there. I think the guy I hired must have removed them (?!). I'll try repairing the table

[web2py] ProgrammingError violates unique constraint when inserting into a postgresql table

2015-03-25 Thread Ian W. Scott
In a test function I set up some testing data in a postgresql database by first deleting my test user's data and then inserting from a dictionary: db(db.tag_records.name == user_login['id']).delete() db.commit() for tr in trecs: db.tag_records.insert(**tr)

[web2py] Re: SQLFORM hanging on insert

2015-02-06 Thread Ian W. Scott
code except you do not need db.commit() but it should not hurt. On Thursday, 5 February 2015 14:46:58 UTC-6, Ian W. Scott wrote: Hi folks. I still don't really know how to debug this problem beyond what I've done (identify the point in the gluon code where the hang happens). Can anyone

[web2py] Re: SQLFORM hanging on insert

2015-02-05 Thread Ian W. Scott
Hi folks. I still don't really know how to debug this problem beyond what I've done (identify the point in the gluon code where the hang happens). Can anyone at least suggest another strategy for debugging it? Thanks again, Ian On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
there ? On Thursday, January 29, 2015 at 10:05:30 PM UTC+1, Ian W. Scott wrote: Oh, and I'm running version 2.9.11-stable. On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wrote: I have a create form (SQLFORM) that works (a new record is actually created) but immediately after inserting

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
there ? On Thursday, January 29, 2015 at 10:05:30 PM UTC+1, Ian W. Scott wrote: Oh, and I'm running version 2.9.11-stable. On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wrote: I have a create form (SQLFORM) that works (a new record is actually created) but immediately after

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
application At the prompt issue: [1] db.commit() does it stall? Il giorno venerdì 30 gennaio 2015 18:10:23 UTC+1, Ian W. Scott ha scritto: If it helps at all, here's the controller function that creates and processes the form: if form.process(formname=formname).accepted

[web2py] Re: SQLFORM hanging on insert

2015-01-29 Thread Ian W. Scott
Oh, and I'm running version 2.9.11-stable. On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wrote: I have a create form (SQLFORM) that works (a new record is actually created) but immediately after inserting the new record the web2py process hangs. The form remains greyed out

[web2py] SQLFORM hanging on insert

2015-01-29 Thread Ian W. Scott
I have a create form (SQLFORM) that works (a new record is actually created) but immediately after inserting the new record the web2py process hangs. The form remains greyed out and no other functions will work (e.g., can't refresh the page or navigate away). But there's no error raised. Can

[web2py] Re: request_reset_password not returning a form

2015-01-28 Thread Ian W. Scott
Finally figured out the issue. I just didn't have a condition for request_reset_password in the view for default/user. Added that condition and it works like a charm. Ian On Tuesday, January 27, 2015 at 3:02:34 PM UTC-5, Ian W. Scott wrote: Thanks Cynthia. But I do have the right format

[web2py] Re: request_reset_password not returning a form

2015-01-27 Thread Ian W. Scott
at 1:04:05 PM UTC-7, Ian W. Scott wrote: When I click on Lost Password in the user menu I just get a page with a blank body. The url to which I'm forwarded seems right ( http://ianwscott.webfactional.com/paideia/default/user/request_reset_password?_next=/paideia/default/index) but there's

[web2py] request_reset_password not returning a form

2015-01-26 Thread Ian W. Scott
When I click on Lost Password in the user menu I just get a page with a blank body. The url to which I'm forwarded seems right (http://ianwscott.webfactional.com/paideia/default/user/request_reset_password?_next=/paideia/default/index) but there's no form on the page. It's as if the page

[web2py] Re: Problem migrating field type from 'string' to 'text' (postgresql)

2015-01-12 Thread Ian W. Scott
string to text and viceversa) @scott, have you enabled migration? ( DAL(db_uri, migrate=True)) Paolo On Friday, January 9, 2015 at 7:38:08 PM UTC+1, Ian W. Scott wrote: OK, I'm upgrading. Ran into a snag with my passwords file and finding the right port number, but when it's upgraded I'll

[web2py] Re: Problem migrating field type from 'string' to 'text' (postgresql)

2015-01-09 Thread Ian W. Scott
with that version but this is so old. Hard to day what the problem is. On Wednesday, 7 January 2015 13:42:52 UTC-6, Ian W. Scott wrote: 2.8.2-stable+timestamp.2013.11.28.13.54.07 (Running on Apache/2.2.17 (Unix) mod_wsgi/3.3 Python/2.7.8) On Wednesday, January 7, 2015 2:22:57 PM UTC-5, Massimo

[web2py] Problem migrating field type from 'string' to 'text' (postgresql)

2015-01-07 Thread Ian W. Scott
I need to migrate an existing database field from (the implicit default) 'string' to 'text'. Since all of the existing data will satisfy the new field contstraints (no 'string' will be ruled out as 'text') I just changed the field type in the model field definition. Old:

[web2py] Re: Problem migrating field type from 'string' to 'text' (postgresql)

2015-01-07 Thread Ian W. Scott
2.8.2-stable+timestamp.2013.11.28.13.54.07 (Running on Apache/2.2.17 (Unix) mod_wsgi/3.3 Python/2.7.8) On Wednesday, January 7, 2015 2:22:57 PM UTC-5, Massimo Di Pierro wrote: which web2py version/date? On Wednesday, 7 January 2015 12:49:29 UTC-6, Ian W. Scott wrote: I need to migrate

[web2py] Broken ajax links in component

2014-07-10 Thread Ian W. Scott
I'm in the process of upgrading a site from bs2 to bs3 and I've run into an unexpected (and possibly unrelated?) error. On one page I have links in one component that are supposed to update another component. The links are now broken and raise an error: Syntax error, unrecognized expression:

[web2py] Re: Broken ajax links giving unrecognized expression error

2014-07-10 Thread Ian W. Scott
Yes, it's in the browser's console, and it's targeting jquery.js line 3. On Thursday, July 10, 2014 6:02:18 AM UTC-4, Niphlod wrote: do this come up in the browser's console ? if yes, what line do they target of what js file ? On Wednesday, July 9, 2014 11:57:39 PM UTC+2, Ian W. Scott wrote

[web2py] Re: Broken ajax links in component

2014-07-10 Thread Ian W. Scott
Sorry for the double post of this question. My original post took several hours to appear, so I thought it hadn't gone through. On Wednesday, July 9, 2014 3:31:33 PM UTC-4, Ian W. Scott wrote: I'm in the process of upgrading a site from bs2 to bs3 and I've run into an unexpected

[web2py] Re: Broken ajax links in component

2014-07-10 Thread Ian W. Scott
I'm not running jquery 1.9. It's version 1.10.2. But I can try 1.11 and see what happens. On Thursday, July 10, 2014 6:32:27 AM UTC-4, Leonel Câmara wrote: Have you tried updating jquery to 1.11 this seems like a known jquery 1.9 bug. -- Resources: - http://web2py.com -

[web2py] Re: Broken ajax links giving unrecognized expression error

2014-07-10 Thread Ian W. Scott
It'll take a bit of time, but I'll see what I can do. On Thursday, July 10, 2014 8:37:31 AM UTC-4, Niphlod wrote: can you pack a minimal app to reproduce the issue ? On Thursday, July 10, 2014 12:54:03 PM UTC+2, Ian W. Scott wrote: Yes, it's in the browser's console, and it's targeting

[web2py] Re: Broken ajax links giving unrecognized expression error

2014-07-10 Thread Ian W. Scott
links could work before but now choked the bootstrap js. Maybe this is something we should keep in mind as people migrate from bootstrap 2 to 3. Anyway, thanks for your willingness to help Niphlod. On Wednesday, July 9, 2014 5:57:39 PM UTC-4, Ian W. Scott wrote: Some ajax links that used

[web2py] Re: Broken ajax links in component

2014-07-10 Thread Ian W. Scott
I found the culprit. The ajax links were in a list with the bootstrap classes nav nav-tabs. In bootstrap 3 the tabs js was choking on the url when an item was clicked. On Thursday, July 10, 2014 6:57:51 AM UTC-4, Ian W. Scott wrote: I'm not running jquery 1.9. It's version 1.10.2. But I can

[web2py] Broken ajax links giving unrecognized expression error

2014-07-09 Thread Ian W. Scott
Some ajax links that used to work have just broken and I'm not sure where to start in debugging. The links target a load component on the page (using cid) and they have started throwing this error: Syntax error, unrecognized expression:

[web2py] Keep values with a list:string field?

2014-06-25 Thread Ian W. Scott
I've got a SQLFORM.factory form set to keep values after processing with process(keepvalues=True). But it doesn't work on a list:string field. The (otherwise very nice) widget loses all but the first value when the form is submitted (i.e., all but the first text inputs for the field disappear).

[web2py] Re: how to making a field unique based on another field's value

2014-06-25 Thread Ian W. Scott
I believe you just set this through the requires property of the field: db.table2.table1_name.requires(IS_IN_DB(db, 'table1.name', db.table1._format)) That prevents entering any values in table1_name that aren't in table1.name. I believe you can also set

[web2py] Re: How to migrate to UUID references in db without messing up reference fields

2014-06-03 Thread Ian W. Scott
single table. I agree a better solution would be desirable. Massimo On Saturday, 24 May 2014 10:58:39 UTC-5, Ian W. Scott wrote: Thanks Massimo. I explained my problem a bit better (I hope) in my reply to Philip below. There are a couple of reasons why the approach you suggest isn't

Re: [web2py] How to migrate to UUID references in db without messing up reference fields

2014-05-24 Thread Ian W. Scott
it worth jumping in. On 14/05/14 16:44, Ian W. Scott wrote: I need to take an existing db and implement a UUID referencing system so that I can sync local db's with a central remote version. But I'm concerned that this will break reference fields that refer to the newly synced rows

[web2py] Re: How to migrate to UUID references in db without messing up reference fields

2014-05-24 Thread Ian W. Scott
',Field('name'),Field('owner',requires=IS_IN_DB(db,'person.uuid','name')) Except the reference will not be enforced at the DB level, only at the web2py level. Massimo On Friday, 23 May 2014 23:04:10 UTC-5, Ian W. Scott wrote: After 10 days I've received no help

[web2py] Re: How to migrate to UUID references in db without messing up reference fields

2014-05-23 Thread Ian W. Scott
After 10 days I've received no help on this. Is there something about the question that is inappropriate? On Wednesday, May 14, 2014 11:44:43 AM UTC-4, Ian W. Scott wrote: I need to take an existing db and implement a UUID referencing system so that I can sync local db's with a central

[web2py] How to migrate to UUID references in db without messing up reference fields

2014-05-14 Thread Ian W. Scott
I need to take an existing db and implement a UUID referencing system so that I can sync local db's with a central remote version. But I'm concerned that this will break reference fields that refer to the newly synced rows. My understanding is that the UUID field is necessary because a csv

[web2py] Change 'working...' message in ajax links

2014-03-18 Thread Ian W. Scott
I want to change the default 'working...' message presented in an ajax link while it is waiting for the callback to return. I couldn't find anything about this in the web2py manual, but looking in web2py.js it looks like the message can be overridden by setting the data-disable-with value on

  1   2   >