[web2py] Re: AttributeError: 'SQLite' object has no attribute 'file_open'

Any workaround? I am kind of stuck in populating the test database -- 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

[web2py] Re: Unable to start web2py 2.15.2 with ssl

On Friday, August 4, 2017 at 3:57:29 PM UTC-7, José Leite wrote: > > Admin console information: > > 2.15.2-stable+timestamp.2017.07.19.12.18.41 > (A correr em Rocket 1.2.6, Python 2.7.13) > Just to be way too into verification, can you open a regular python shell, and do "import ssl" and

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Admin console information: 2.15.2-stable+timestamp.2017.07.19.12.18.41 (A correr em Rocket 1.2.6, Python 2.7.13) sexta-feira, 4 de Agosto de 2017 às 23:35:11 UTC+1, José Leite escreveu: > > Python 2.7.11 worked fine before the web2py upgrade. But I even tried to > update the version to the new

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

When the code was initially done we were not sure if we needed more than one entry in the list but we really ended up needing just one in this case. Thanks for your explanation. sexta-feira, 4 de Agosto de 2017 às 23:38:15 UTC+1, Anthony escreveu: > > On Friday, August 4, 2017 at 11:03:04 AM

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

On Friday, August 4, 2017 at 11:03:04 AM UTC-4, José Leite wrote: > > I changed the Syntax to: > > db.intro_lifestyles.tourism_segment_id.contains(segment.id) > I assumed you wanted to find records that include segment.id as the one and only element in the list, in which case you should use my

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Python 2.7.11 worked fine before the web2py upgrade. But I even tried to update the version to the new 2.7.13 (all 32bit - the machine is 64). sexta-feira, 4 de Agosto de 2017 às 23:27:03 UTC+1, José Leite escreveu: > > It doesn't print that information but the admin console says its Python >

[web2py] Re: Unable to start web2py 2.15.2 with ssl

It doesn't print that information but the admin console says its Python 2.7.11 and after my upgrade 2.7.13 sexta-feira, 4 de Agosto de 2017 às 22:57:53 UTC+1, Dave S escreveu: > > > > On Friday, August 4, 2017 at 2:48:19 PM UTC-7, José Leite wrote: >> >> Sorry I meant from source not .exe >> >>

[web2py] Re: Unable to start web2py 2.15.2 with ssl

On Friday, August 4, 2017 at 2:48:19 PM UTC-7, José Leite wrote: > > Sorry I meant from source not .exe > > When you start web2py, it will print not only its own version but the version of python it is using. Can you confirm that information here? /dps > sexta-feira, 4 de Agosto de 2017 às

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Sorry I meant from source not .exe sexta-feira, 4 de Agosto de 2017 às 22:47:07 UTC+1, José Leite escreveu: > > Yes I am running on a windows machine and run web2py from the .exe file > not from source. > > The command line is: > > C:\web2py\web2py.py -a admin -i 192.168.8.100 -p 443 -c

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Yes I am running on a windows machine and run web2py from the .exe file not from source. The command line is: C:\web2py\web2py.py -a admin -i 192.168.8.100 -p 443 -c server.crt -k server.key -Y but it doesn't start the https version of the site and all https://* calls to externeal services

[web2py] Re: MS-SQL DAL Problem ( connecting is ok )

Good evening! Yes, the fix worked! Yuhu!!! Thank you very much for your fast fix and reply. Have a nice weekend! On Friday, August 4, 2017 at 6:18:58 PM UTC+3, Massimo Di Pierro wrote: > > I committed a fix to pysql just now. Can you check it fixes the problem > for you? > > On Thursday, 3

[web2py] Re: Unable to start web2py 2.15.2 with ssl

On Friday, August 4, 2017 at 8:54:52 AM UTC-7, José Leite wrote: > > Well Leonel, > > before I upgraded to web2py 2.15.2 Python was working fine with ssl even > locally. > I have python 2.7.11 exactly because I needed the newest ssl protocols to > work with PayPal. > Strange...!?!?!?!!? > If

[web2py] Re: Grid edit behavior when no changes are made

On Friday, August 4, 2017 at 1:42:54 PM UTC-7, Seth J wrote: > > So, archives on this page: https://github.com/niphlod/web2py/releases > don't contain it?!?! > I'm not sure. I would expect the zip files to, but that's a dev's archive rather than the "official" web2py archive referenced in

[web2py] Re: deploy with scheduler

On Friday, August 4, 2017 at 12:20:18 PM UTC-7, Manuele wrote: > > Il 04/08/17 16:08, Manuele ha scritto: > > Dear all, > > > > I'm bound to decide which service to use for the deploy of a brand new > > web application, at the moment I'm trying Openshift but I'm open to > > alternatives,

[web2py] ACCESSING THE SAME DAL DATABASE FROM WEB2PY AND "STAND-ALONE" APP

Hi, I am trying to access the same mysql database in a web2py app (which created it) AND from a “stand-alone” python app (which primarily extracts information from it). I can access the the db from the web_2py app but access from the stand-alone fails with “RuntimeError: 'Failure to

Re: [web2py] book help

On Friday, August 4, 2017 at 9:32:58 AM UTC-7, Massimo Di Pierro wrote: > > The book is online https://github.com/web2py/web2py-book > You can fork it edit it, then submit a PR. You should be able to do > everything online. > > Massimo > I have a setup for it at home, but I don't expect to be

[web2py] Re: to XML() or to JSON.parse() ?

On Friday, August 4, 2017 at 7:48:36 AM UTC-7, Massimo Di Pierro wrote: > > It has been around for more than one year. It is an oversight that it is > not in the book. > > I noticed that when I was looking up the posts. Nov '14. /dps > On Monday, 31 July 2017 09:54:10 UTC-5, Pierre

[web2py] Re: web2py GUI graph

On Friday, August 4, 2017 at 7:47:40 AM UTC-7, Massimo Di Pierro wrote: > > In the multi user mode, shows how many lines are added/removed over time > by the user. > I'm usually looking at the graph when I'm in between actions on either the appadmin side or the client side (yeah, I know, just

[web2py] Re: Grid edit behavior when no changes are made

So, archives on this page: https://github.com/niphlod/web2py/releases don't contain it?!?! On Friday, August 4, 2017 at 4:34:16 PM UTC-4, Dave S wrote: > > > > On Friday, August 4, 2017 at 1:17:08 PM UTC-7, Seth J wrote: >> >> Another quick question. How do I revert back to 2.14.6 or 2.14.5

[web2py] Re: Grid edit behavior when no changes are made

On Friday, August 4, 2017 at 1:17:08 PM UTC-7, Seth J wrote: > > Another quick question. How do I revert back to 2.14.6 or 2.14.5 then? > I downloaded the appropriate version archive and replaced all of the files > in the installation and it still gives me the same error message: > If

[web2py] Re: Grid edit behavior when no changes are made

Another quick question. How do I revert back to 2.14.6 or 2.14.5 then? I downloaded the appropriate version archive and replaced all of the files in the installation and it still gives me the same error message: Version web2py™ Version 2.14.5-stable+timestamp.2016.04.13.22.22.13 Python

[web2py] In the past DAL was accepting comma and replace by point before insert decimal result

Hello, I think I found a bug or at least a regression... I am pretty sure that in the past DAL was accepting "," as a decimal mark and replace it by "." before insert input data... This appears to be not longer the case... It now trigger this error : INSERT has more expressions than target

[web2py] Re: deploy with scheduler

Il 04/08/17 16:08, Manuele ha scritto: > Dear all, > > I'm bound to decide which service to use for the deploy of a brand new > web application, at the moment I'm trying Openshift but I'm open to > alternatives, the first mandatory requirement is that the service must > support the web2py

[web2py] Re: pyDAL - Spurious "cross join"

With a where clause, it works OK. However, in my example, I still should not have generated a CROSS JOIN. I guess it's just a pyDAL issue. On Friday, 4 August 2017 17:25:14 UTC+1, villas wrote: > > According to the book, I should be able to append 'join' statements to a > list. Here is

Re: [web2py] book help

The book is online https://github.com/web2py/web2py-book You can fork it edit it, then submit a PR. You should be able to do everything online. Massimo On Friday, 4 August 2017 10:43:14 UTC-5, CDA wrote: > > I'll be more than happy to assist. How do I start? > > On Aug 4, 2017 11:34 AM,

[web2py] pyDAL - Spurious "cross join"

According to the book, I should be able to append 'join' statements to a list. Here is what happens: >>> joinlist = [] >>> joinlist.append( db.res.on(db.extra_dates.res_id == db.res.id) ) >>> joinlist.append( db.prop.on(db.res.prop_id == db.prop.id) ) >>> db()._select(db.prop.id,

[web2py] Re: Insecure string Pickle with web2py 2.15.2

It solved the problem ... thanks again Leonel sexta-feira, 4 de Agosto de 2017 às 17:15:29 UTC+1, Leonel Câmara escreveu: > > This is weird I would just move all table files to a backup migration and > do a fake migration to recreate them and see if it solves the problem. > -- Resources: -

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Thanks, just submitted the issue. sexta-feira, 4 de Agosto de 2017 às 16:58:14 UTC+1, Leonel Câmara escreveu: > > Still, probably a bug if it still doesn't work with the has_ssl change, > submit an issue. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Insecure string Pickle with web2py 2.15.2

This is weird I would just move all table files to a backup migration and do a fake migration to recreate them and see if it solves the problem. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

Your db.py is fine. default.py should contain: def order(): response.view = 'default/order.html' order = SQLFORM(db.order, submit_button='Buy!', buttons=['submit'], formstyle='table3cols') if order.process(keepvalues=True).accepted:

[web2py] Re: Insecure string Pickle with web2py 2.15.2

The same error appears! Doesn't solve it... Error ticket for "HolidayExperience"Ticket ID 192.168.8.100.2017-08-04.16-58-01.7faba99b-7fcd-401e-9153-e8b071880ca4 insecure string pickleVersão web2py™ Version 2.15.2-stable+timestamp.2017.07.19.12.18.41 Python Python 2.7.11: C:\Python27\python.exe

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Still, probably a bug if it still doesn't work with the has_ssl change, submit an issue. -- 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

[web2py] Re: Unable to start web2py 2.15.2 with ssl

But you are right maybe I don't need it locally. sexta-feira, 4 de Agosto de 2017 às 16:54:52 UTC+1, José Leite escreveu: > > Well Leonel, > > before I upgraded to web2py 2.15.2 Python was working fine with ssl even > locally. > I have python 2.7.11 exactly because I needed the newest ssl

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Well Leonel, before I upgraded to web2py 2.15.2 Python was working fine with ssl even locally. I have python 2.7.11 exactly because I needed the newest ssl protocols to work with PayPal. Strange...!?!?!?!!? sexta-feira, 4 de Agosto de 2017 às 16:44:20 UTC+1, Leonel Câmara escreveu: > > You are

[web2py] Re: Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

faced with this! invalid function (default/order) Started off with that statement you see. Really confused at this , seems to be nobody else is having this problem! On Friday, August 4, 2017 at 3:59:34 PM UTC+1, Jim S wrote: > > In your controller, try: > > return dict(order=order) > > instead

Re: [web2py] Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

I declared that that didn't work if you read my text properly! On Friday, August 4, 2017 at 3:52:56 PM UTC+1, Áureo Dias Neto wrote: > > Your 'form' is in the variable order, here: order = SQLFORM(db.order,... > > use {{=order}} in the view > -- Resources: - http://web2py.com -

[web2py] Re: Unable to start web2py 2.15.2 with ssl

You are running a python version that was not compiled with ssl support. Since this is a development environment you could simply not demand https if the request is_local. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

Re: [web2py] book help

I'll be more than happy to assist. How do I start? On Aug 4, 2017 11:34 AM, "Massimo Di Pierro" wrote: > Can I ask for some help in editing the book. specifically: > > 1) describe {{=ASSIGNJS(js_var = python_var)}} > > 2) new syntax to store .table files in DB itself

[web2py] Re: Problems editing routes

You need to update your routes.py to do "from gluon import fileutils" instead of "import fileutils" -- 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

[web2py] Re: Unable to start web2py 2.15.2 with ssl

Ok Leonel, correction done but the rocket server can not provide a secure connection anyway. Is it a missing feature in the new version or am I doing something wrong? Este site não consegue fornecer uma ligação segura *127.0.0.1* enviou uma resposta inválida. - Experimente executar o

[web2py] Problems editing routes

Hi there, I am trying to set up routes for my application as explained in the book but am running into a problem: As soon as I add a file 'routes.py' to the *main* web2py folder I get an error message 'No module fileutils' - even if the file is empty. Also tried renaming the routes examples in

[web2py] book help

Can I ask for some help in editing the book. specifically: 1) describe {{=ASSIGNJS(js_var = python_var)}} 2) new syntax to store .table files in DB itself instead of in the filesystem (works with any DB) from gluon import DAL, Field from gluon.dal import InDBMigrator db =

[web2py] Re: Insecure string Pickle with web2py 2.15.2

Try just one more thing. Where you have auth.define_tables(username=True, signature=False) Put: auth.define_tables(username=True, signature=False, migrate=True, fake_migrate=True) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: paired fields in web2py

I would do db.define_table('customer',Field('name')) db.define_table('product',Field('name')) db.define_table('invoice',Field('customer','reference customer')) db.define_table('invoice_item',Field('invoice','reference invoice'),Field(product','reference product'),Field('quantity','integer'))

[web2py] Re: Insecure string Pickle with web2py 2.15.2

Try just one more thing where you declare auth auth = Auth(db) try: auth = Auth(db, migrate=True, fake_migrate=True) -- 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] Re: Insecure string Pickle with web2py 2.15.2

But you are right the .table files are corrupted since I can not access them from the Admin interface also. Shall I delete them all? Or what shall I do? This never happened with installation of previous web2py versions. :-( sexta-feira, 4 de Agosto de 2017 às 16:13:33 UTC+1, José Leite

[web2py] Re: Insecure string Pickle with web2py 2.15.2

Are you using table files done on another machine or something like that? -- 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

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

Yes this is correct. The other syntax worked by accident. On Friday, 4 August 2017 10:03:04 UTC-5, José Leite wrote: > > I changed the Syntax to: > > db.intro_lifestyles.tourism_segment_id.contains(segment.id) > > and it is now working. > > Thanks a lot that would be a solution too... > >

[web2py] Re: MS-SQL DAL Problem ( connecting is ok )

I committed a fix to pysql just now. Can you check it fixes the problem for you? On Thursday, 3 August 2017 16:57:45 UTC-5, Razvan Cristian wrote: > > > Hello all! > > I am in the process of learning web2py. I downloaded the binaries and the > sources for windows and give it a run but i

[web2py] Re: Insecure string Pickle with web2py 2.15.2

Hello Leonel, I've already done a fake migration and nothing changed. db = DAL('postgres://postgres:%s@localhost:5432/HolidayExperience' % DEV_DB_PWD, fake_migrate_all=True) sexta-feira, 4 de Agosto de 2017 às 01:42:41 UTC+1, Leonel Câmara escreveu: > > It seems your .table files are

[web2py] Re: Weird problems generating menu from database

Yes. It is possible but I am a little confused by your model to be able to provide an example that works for you. Can you please provide your model again an example of data that should comprise the menu? Notice what you seek is done here:

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

Hello Dave, no this problem appeared on the production environment (Ubuntu 14.04, Apache 2 mod_wsgi and now with web2py 2.15.2). But it is already solved with contains() instead of ==. It seems a few things changes in version 2.15.2 and some syntaxes are no longer supported. I've had the help

[web2py] Re: Error with Reading ListReferences in web2py 2.15.2 from database

I changed the Syntax to: db.intro_lifestyles.tourism_segment_id.contains(segment.id) and it is now working. Thanks a lot that would be a solution too... quinta-feira, 3 de Agosto de 2017 às 23:18:23 UTC+1, Anthony escreveu: > > Have you tried: > > db.intro_lifestyles.tourism_segment_id ==

Re: [web2py] Datatables Query String Parsing

I also think the grid is obsolete and its code is ugly. The concept of pagination is old. I think it is much better to have an api and a [more] button that adds item at the bottom, until a new search is done. I will post a vue.js example of that as soon as I can. On Tuesday, 1 August 2017

[web2py] Re: Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

In your controller, try: return dict(order=order) instead of: return order -Jim On Friday, August 4, 2017 at 9:45:51 AM UTC-5, Samuel Gosling wrote: > > Hey guys completely new to web development and web2py , enjoying it so > far. It has a lot of potential. > > Need help loading my form in

[web2py] Re: SQLFORM.grid search type error reduce()

Just fixed in trunk. Can you please help test the fix? On Tuesday, 1 August 2017 03:46:13 UTC-5, Paul Ellis wrote: > > I am getting this error only when searching the auth_membership table > > I have put in a basic 'appadmin' in my webapp. I call it 'tooladmin' to > differentiate from the built

Re: [web2py] Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

Your 'form' is in the variable order, here: order = SQLFORM(db.order,... use {{=order}} in the view -- 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

[web2py] Re: grid show or hidden table coloumn

Yes. The SQLFORM.grid(..., fields=[dt.table.field1, ...],..) let you specify the fields to display. On Tuesday, 1 August 2017 03:32:58 UTC-5, 黄祥 wrote: > > is it possible to show or hidden table coloumn in grid base on user > choosen? > > thanks and best regards, > stifan > -- Resources: -

[web2py] Re: to XML() or to JSON.parse() ?

It has been around for more than one year. It is an oversight that it is not in the book. On Monday, 31 July 2017 09:54:10 UTC-5, Pierre wrote: > > thanks Anthony > > I'll use ASSIGNJS. I'd never heard of this helper.too bad it's > unpublished in the book > -- Resources: -

[web2py] Re: web2py GUI graph

In the multi user mode, shows how many lines are added/removed over time by the user. On Monday, 31 July 2017 03:49:36 UTC-5, Dave S wrote: > > In the web2py GUI, what does the "activity" graph show? > > In the case of interest, I'm running with Rocket on W10, and since only > the developer is

[web2py] Can't load form using {{=form}} only by {{=LOAD('default','def')}} or submit the form.

Hey guys completely new to web development and web2py , enjoying it so far. It has a lot of potential. Need help loading my form in my index.html as I can't using {{=form}} or in this case {{=order}} only by using the command {{=LOAD('default','order')}}. I believe this may be my problem in

[web2py] paired fields in web2py

Hello, Is it possible to create table with 2 fields for example, list:reference , which are being multiplied pairly. How to input this kind of info in one record of table Customer>Bob Product:BookAmount:20 Product:Pencil Amount:39 Customer>John Product:PenAmount:7

[web2py] deploy with scheduler

Dear all, I'm bound to decide which service to use for the deploy of a brand new web application, at the moment I'm trying Openshift but I'm open to alternatives, the first mandatory requirement is that the service must support the web2py scheduler, does anybody knows if is it supported by

[web2py] Re: web2py 2.15.0b1

>First issue with @mobilize import Hey everybody, I'm getting the same error with @mobilize after upgrade. Any ideas how to resolve? Thanks &