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 > lo

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
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 2022 alle ore

Re: [web2py] Re: Help on macos

2022-12-23 Thread Ian W. Scott
apache. > Can I ask you why? > 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? >>

[web2py] Re: Help on macos

2022-12-22 Thread Ian W. Scott
cember 22, 2022 at 8: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 lo

[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 ar

[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 st

[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 /maintenance/ma

[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 Error"

[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? - par

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

2020-05-01 Thread Ian W. Scott
PM UTC-4, Ian W. 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

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

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,

[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? Thank

[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 erro

[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 g

[web2py] Re: Help understanding memory use and selects

2019-09-04 Thread Ian W. Scott
ogic around minimizing db calls, even if the result is less elegant code. On Monday, September 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: > > >

[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 >> questi

[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-en

[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 knowledge

[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 actuall

[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 d

[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 fiel

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

2017-11-20 Thread Ian W. Scott
wrote: > > > > 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

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

2017-11-20 Thread Ian W. Scott
gt; > > > On Monday, November 20, 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

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

2017-11-20 Thread Ian W. Scott
still getting 404 errors. On Monday, November 20, 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 me

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

2017-11-20 Thread Ian W. Scott
So far I'm just 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 numb

[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 wro

[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
t; > > 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 generated > password should work. > > Ric

Re: [web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
replace in the > web2py/ 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 > wrote: > >> I seem to have forgotten the admin password for my web2py installation, >> so

Re: [web2py] Changing admin password

2017-02-16 Thread Ian W. Scott
in import 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 instan

[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
t; then delete 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 > wrote: > >> I'm using Postgresql and I need to migrate the data type of a field from >>

[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 - ht

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

2016-02-19 Thread Ian W. Scott
opt = w.element(_value=self.value) i = w.elements().index(opt) w.append(opt) del w[i - 1] else: print e except Exception, e: print e, type(

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

2016-02-18 Thread Ian W. Scott
On Thursday, February 18, 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

[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 corre

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

2016-01-21 Thread Ian W. Scott
n which case, you can return some Javascript code > to be executed when the response is returned. Alternatively, the third > argument can be an actual Javascript function, in which case, the returned > value will be passed to that function. > > Anthony > > > On Wednesday, Janua

[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. >>

[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 t

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

2015-09-15 Thread Ian W. Scott
have 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/a

[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 environm

[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 o

[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 pick

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

2015-08-14 Thread Ian W. Scott
class=field.type, > _value=value, > requires=field.requires) > > Field('comment', 'string', widget=my_string_widget) > > > On Fri, Aug 14, 2015 at 9:50 AM, Ian W. Scott > wrote: > >> I agree with Richard that the

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

2015-08-14 Thread Ian W. Scott
>> session.flash='Well are you happy now? Let me know in any case!' >> redirect(URL('list_fld_keep_values_tst', vars=dict(defs=request. >> vars.fld_lst) )) >> elif frm.errors: >> #do any >> response.fla

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

2015-08-12 Thread Ian W. Scott
n try it here and confirm your 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 > wrote:

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

2015-08-12 Thread Ian W. Scott
there but not correctly > display by the widget... > > Richard > > On Wed, Aug 12, 2015 at 1:21 PM, Ian W. Scott > 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

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

2015-08-12 Thread Ian W. Scott
nkeys} stepsdata.append(ndict) if isinstance(vv['words'], list): wordlists = [w.split('|') for w in vv['words']] else: wordlists = [vv['words'].split('|')] paths =

[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

[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

[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) web

[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: (relation "auth_user" alre

[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 problem

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

2015-05-05 Thread Ian W. Scott
aset, sorting in Python might be > slower than 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(

[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 the

[web2py] Re: SQLFORM hanging on insert

2015-04-11 Thread Ian W. Scott
ke of posterity. 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:

[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'

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

2015-04-11 Thread Ian W. Scott
t; > Richard > > On Fri, Apr 10, 2015 at 3:24 PM, Ian W. Scott > 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

[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 simpl

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

2015-03-26 Thread Ian W. Scott
an error message identifying the offending combination 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 fr

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

2015-03-26 Thread Ian W. Scott
and I could continue 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&#

[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 bu

[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 definition

[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) Wh

[web2py] Re: SQLFORM hanging on insert

2015-02-06 Thread Ian W. Scott
ing wrong with your 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

[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, Ia

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
> > python web2py.py -M -S > > > > 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

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
ed.' else: pass return dict(form=form) On Thursday, January 29, 2015 at 4:28:15 PM UTC-5, Niphlod wrote: > > what about if you start a shell and issue the insert statement with a > db.commit() ? does it hang also there ? > > On Thursday, January 29, 2015 at 10:

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
does it hang also 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

[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 fo

[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 an

[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

[web2py] Re: request_reset_password not returning a form

2015-01-27 Thread Ian W. Scott
rd, like this: > name@maildomain:password > > On Monday, January 26, 2015 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 ( >&

[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 cont

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

2015-01-12 Thread Ian W. Scott
oth directions namely > 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 fil

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

2015-01-09 Thread Ian W. Scott
is should have worked 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

[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: >

[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: Field('response1')

[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&#x

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

2014-07-10 Thread Ian W. Scott
gh that my ajax 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

[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&#x

[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 - http://web2py.c

[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

[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, 2

[web2py] Broken ajax links in component

2014-07-09 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] 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: > /paideia/plugin_listandedit/edit.load/word_forms/546?ord

[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] 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 migrate to UUID references in db without messing up reference fields

2014-06-03 Thread Ian W. Scott
o built the references. Moreover it requires comparing the > entire db and cannot be used on one 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

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

2014-05-24 Thread Ian W. Scott
7;,compute=lambda:web2py_uuid())) > > You can also create table that reference that field: > > > db.define_table('thing',Field('name'),Field('owner',requires=IS_IN_DB(db,'person.uuid','name')) > > Except the reference will not be enforced at the

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

2014-05-24 Thread Ian W. Scott
king. I have an application that > needs to use UUIDs myself, so thought 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 ve

[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&#x

[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 impor

[web2py] Re: Bootstrap3 package - help to test

2014-03-18 Thread Ian W. Scott
Although I'm replying late, I just want to say a huge "thanks" for tackling this. It's something I've wanted to get to for a few months, and it's great to see that I don't have to start from scratch. If there was an initial lack of response I suspect it's just that many people like me happened t

  1   2   >