Re: [web2py] Migrate integer field to string type

Yes is you do it within the shell you better commit every 100 records depending of the size of the record, but since it just a single column and integer you can commit even every 500-1000 records I guess without issue... To do so you can use this snippet : for i, r in enumerate(db.select()):

Re: [web2py] Mithril i.e. the client MVC war continues

It blazingly fast... The comparison is extensive and informative... Thanks for sharing. Richard On Tue, Oct 25, 2016 at 5:33 AM, Michele Comitini < michele.comit...@gmail.com> wrote: > OK so you thought that vue.js was good enough... > > Take a look on mithril: > > http://mithril.js.org/ > > >

Re: [web2py] Re: Deployment question

Jim which web server are we talking now? Nginx? I think you should copy/paste configuration so we can have look, I can compare to mine... Just the relevant part would suffice... About threading notice of pandas it says holding lock in case of multiple dataframe copy, but Jim report he can't even i

Re: [web2py] Migrate integer field to string type

You can't just change the field type, you have to create another column of string type then insert your data from a select of the other column into it 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, I

Re: [web2py] Re: change the size of a text field in a form

F5 or Ctrl+R or delete cache may help sometimes... But it hards to know what you may doing wrong without any code... Richard On Mon, Oct 24, 2016 at 12:56 PM, Steven Vannoy wrote: > This is exactly what I'm trying to do, none of the suggestions below has > changed my form view at all. Must be d

Re: [web2py] Re: Deployment question

think it is anything I'm doing in my code. > > -Jim > > On Mon, Oct 24, 2016 at 9:48 AM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> I suggest you try to raise the limit... I don't know why it get in the >> configuration file, but I read

Re: [web2py] Re: Deployment question

I suggest you try to raise the limit... I don't know why it get in the configuration file, but I read it could be use to prevent memory leaks. It's also help preventing app from eating all the memory before crash the system... You maybe better understand why you code need so much memory and try to

Re: [web2py] Re: web2py + cordova + APIs

Copy/paste and accept update files that are different... Richard On Wed, Oct 19, 2016 at 8:01 PM, greenpoise wrote: > I tried cloning this to try it out (it might be the answer to my API > question) but it did not work and there is no w2p extension file. How can I > install to try it? > > > tha

Re: [web2py] Securing admin doc still accurate?

e parameters_8002.py file... Richard On Thu, Oct 13, 2016 at 3:52 PM, Richard Vézina wrote: > Nevermind, I figure it out... I had create a parameters_443.py file in my > restored system and didn't realize that I actually need to not create it > and create 8002 instead... > > :) &

Re: [web2py] Securing admin doc still accurate?

Nevermind, I figure it out... I had create a parameters_443.py file in my restored system and didn't realize that I actually need to not create it and create 8002 instead... :) Richard On Thu, Oct 13, 2016 at 3:44 PM, Richard wrote: > Hello, > > Is this section still accurate? : http://web2py.

Re: [web2py] Re: nginx/uwsgi problem on Debian

Check permissions... Richard On Mon, Oct 10, 2016 at 1:34 PM, Arve Fahlvik wrote: > What was the solution? Seems like I have a similar problem. > > Arve > > On Thursday, January 21, 2016 at 10:05:57 AM UTC+1, Johann Spies wrote: >> >> On 20 January 2016 at 16:3

Re: [web2py] How to format a sum field with thousands separators in SQLTABLE?

You may look this SO post : http://stackoverflow.com/questions/1823058/how-to-print-number-with-commas-as-thousands-separators On Thu, Oct 6, 2016 at 10:26 AM, DaneW wrote: > I have records with an amount field which is summed using Sum and Groupby > and the resulting rows displayed via SQLTABLE

Re: [web2py] Setup web2py in Vagrant provision phase

You have to work it, I bassically tell you how to do it then you have to formalize it. You have to grab information at the launch of the script with bash prompt and read to capture the prompt input then you have to alter the openssl command in order to pass it the option you grab in the first place

Re: [web2py] capturing primary key during insert

id = db.SuperObject.insert(**db.SuperObject._filter_fields(form.vars)) Should work, does it? Richard On Tue, Oct 4, 2016 at 5:42 PM, Alex Glaros wrote: > In doing a direct programatic insert without a form such as > db.SuperObject.insert(person_name = "Alex") > > is there a way to capture the

Re: [web2py] Setup web2py in Vagrant provision phase

prompt and read, then http://stackoverflow.com/questions/15476479/sign-certificate-without-prompt-in-shell-script Richard On Tue, Oct 4, 2016 at 2:04 PM, Marko Seppälä wrote: > Hi, > > I'm using Vagrant to create Ubuntu 14.04 virtual server. I use > setup-web2py-ubuntu.sh > script in provision

Re: [web2py] Re: Fresh install, getting error: table "auth_user" already exists

Check files owner, should be www-data recursively if you are in prod under ubuntu... On Thu, Sep 29, 2016 at 1:33 AM, pbreit wrote: > Appears to be a permissions issue as it goes away if I start web2py with > sudo. > > > On Wednesday, September 28, 2016 at 10:15:18 PM UTC-7, pbreit wrote: >> >>

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

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=reserved+word#Reserved-keywords Do you have it in your connection string? You should be notified that it a mysql reserved word... If not... Have you change database? New empty database sound like you restart data

Re: [web2py] Best way to pre-populate a database on start-up

private/* would be a good place to store it. Richard On Wed, Aug 31, 2016 at 3:15 PM, Niphlod wrote: > same deal, "different" organization. > With an external script you can't call that function if not from an > external process. > Having it in a separated controller incurs in None performance-

Re: [web2py] Best way to pre-populate a database on start-up

To be added to the fabfile.py of web2py maybe?! On Tue, Aug 30, 2016 at 3:53 PM, Richard Vézina wrote: > Don't have privileges, but this is a good thread and should be marked as > informative somehow... > > Richard > > On Tue, Aug 30, 2016 at 2:24 PM, Dave S wrote

Re: [web2py] Best way to pre-populate a database on start-up

Don't have privileges, but this is a good thread and should be marked as informative somehow... Richard On Tue, Aug 30, 2016 at 2:24 PM, Dave S wrote: > > > On Tuesday, August 30, 2016 at 6:58:43 AM UTC-7, Richard wrote: >> >> Seems alright do you have issue with this? I would put a blank line

Re: [web2py] Best way to pre-populate a database on start-up

Seems alright do you have issue with this? I would put a blank line between model definition and the "if isempty()". I production, once the system get initialize you should remove those populating fixture to save execution time as the get execute at each request. What could wizely do is put all t

Re: [web2py] Re: Preceding backslash when using URL in ubuntu 16.04

You should consider using the script to properly install web2py : https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh You can then work from this basic installation to secure it better and fine tune performance, configure proper database, etc. Richard On Mon,

Re: [web2py] Re: How to enclose items within a link?

**{'other_attribute_name': 'other_attribute_value', ...}, after the last named attribute Richard On Wed, Aug 24, 2016 at 3:17 PM, Alex Glaros wrote: > I just tried this and solves my immediate problem, but am still curious if > can enclose items with w2p link. > > {{=A(T(''), _href=URL('default

Re: [web2py] LDAP authentication and user creation

For checking if user exist in LDAP you will need to write your own logic and query LDAP... For creating the user you have Admin or you can create a simple form that only admin can use for instance... There is also a way to provide admin app access by attributing to user a particular role : http://w

Re: [web2py] Decode string

No clue... On Fri, Aug 19, 2016 at 9:49 AM, António Ramos wrote: > Its a Post request to my controller. they are not in the url ( I think...) > > 2016-08-19 14:34 GMT+01:00 Richard Vézina : > >> if you pass json through url to have to parse the string json dump... >>

Re: [web2py] Decode string

gt; > thank you > > 2016-08-19 14:03 GMT+01:00 Richard Vézina : > >> You have to URL unquote not request.vars http://stacko >> verflow.com/questions/16566069/url-decode-utf-8-in-python >> >> If you do request.vars.yourvarname what do you have? >&

Re: [web2py] Decode string

; and i get in request.vars > {u'Sistema de Gest\xe3o\x00 \x00d\x00a\x00 \x00Q\x00u\x00': 1, 'b': 2} > > How do i get "Sistema de Gestão da Qualidade" from the request.vars? > > Regards > António > > > > 2016-08-18 19:49 GMT+01:00 Richard V

Re: [web2py] Decode string

I think it url encoded... Search google about it, it should be obvious then... Richard On Thu, Aug 18, 2016 at 2:12 PM, António Ramos wrote: > Im getting this data on request.vars from Google forms onsubmit event. > > u'Sistema de Gest\xe3o\x00 \x00d\x00a\x00 \x00Q\x00u\x00' > > how do i conver

Re: [web2py] Re: Deployment question

t; Topic :: Scientific/Engineering > > I'm experiencing this on multiple Ubuntu 16.04 systems. Pip has been > updated using: > > sudo pip install --upgrade pip > > ...before installing pandas which I installed using pip and not an ubuntu > package. > >

Re: [web2py] Re: Deployment question

;m > importing a module into a web2py controller and that module fails to import > on the 'import pandas as pd' line. > > Just to be clear, pandas works find on the box. It is when it runs on > web2py through the nginx/uwsgi stack that it fails. > > -Jim > >

Re: [web2py] Re: Deployment question

On Tue, Aug 16, 2016 at 3:30 PM, Richard Vézina wrote: > Strange! > > Missing dependency which didn't install because of a broken link? > > Richard > > On Tue, Aug 16, 2016 at 3:22 PM, Jim Steil wrote: > >> From my system: >> >> administrator@ubu

Re: [web2py] Re: Deployment question

Maybe try reinstall pip package, or if you use ubuntu package, use pip one instead... On Tue, Aug 16, 2016 at 3:16 PM, Richard Vézina wrote: > Can you identify the responsible piece of pandas code that cause the > issue? It don't make sens if you can't import pandas as pd in U1

Re: [web2py] Re: Deployment question

unning on Ubuntu 14.04 with the same version > of pandas. It fails on: > > import pandas as pd > > -Jim > > On Tue, Aug 16, 2016 at 1:02 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Massimo's has always said it wasn't secure, I i

Re: [web2py] Re: Deployment question

Massimo's has always said it wasn't secure, I ignore the exact reason(s)... I suggest downgrading pandas with this rational you were using is in previous version of pandas and nginx without this problem... I do use pandas (but not HDF5 Store) and I don't experiment this issue... neither in 12.04

Re: [web2py] Re: Deployment question

You can't downgrade pandas package? Richard On Tue, Aug 16, 2016 at 12:35 PM, Jim S wrote: > Ron > > It would depend on what OS you're running on the x86 box. This would be a > good place to start http://web2py.com/books/default/chapter/29/13/ > deployment-recipes > > Also, if you don't mind,

Re: [web2py] Weird

Please provide the exact and all model, controller code related to the issue. Without that it hard to say. Richard On Fri, Aug 12, 2016 at 3:06 AM, Vic Ding wrote: > Thanks for your reply, Richard. > in the database, there is an id field. I removed all the extra properties > of the grid and doi

Re: [web2py] Re: switch between standard and testing database?

About your question, I think he maybe had try an approach where he was passing some parameters in request... Richard On Wed, Aug 10, 2016 at 12:03 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Here how I realize it : > > # Production > if request.env.web2py

Re: [web2py] Re: switch between standard and testing database?

Here how I realize it : # Production if request.env.web2py_path.split('/')[2] == 'www-data' and request.application == 'app_name': # print 'Prod...' db = DAL('postgres://username_prod:password@127.0.0.1:5432/dbname', pool_size=1, migrate_enabled=False,

Re: [web2py] multiple controllers

I open this issue : https://github.com/web2py/web2py/issues/1421 It should maybe move into web2py-book issue tracker... Richard On Tue, Aug 9, 2016 at 4:30 AM, icodk wrote: > +1 > > > On Tuesday, August 9, 2016 at 10:05:02 AM UTC+2, Massimo Di Pierro wrote: >> >> Actually this is literally "Ro

Re: [web2py] multiple controllers

No prob, I create an issue about it, as I said I experiment it some time ago and it pretty annoyed me lost like 2-3 hours as I was making app upgrade, not fun at all... :) Richard On Mon, Aug 8, 2016 at 11:09 AM, icodk wrote: > Thanks Richard > I fixed it by restarting the Rocket server. > Sor

Re: [web2py] multiple controllers

Can you show the whole code... I suspect you have cached the original myfunc() and cache point to the default controller... It happen once to me in the past and it was really anoying... I guess we can improve error message in order to notice the user to think about look if the function is cached or

Re: [web2py] Weird

Do you have an "id" field defined? Richard On Sat, Aug 6, 2016 at 6:31 AM, Vic Ding wrote: > I created the table initially without the virtual field 'amount' and added > it lately. > When I use a string or number in the lambda like: lambda row: 'test', it > works fine. > However, when I use lam

Re: [web2py] Re: Improvements for DevOps

Maybe trunk is broken... On Sun, Aug 7, 2016 at 12:25 AM, bunnyhero wrote: > I just tried > > git clone --depth=1 --branch=R-2.14.6 --recursive --shallow-submodules > https://github.com/web2py/web2py.git > > and I got this error: > > error: no such remote ref 60e97e7cfd1da98f3cf38b202396

Re: [web2py] Re: Is it possible reload my model.py from an ajax request?

Yes, basic example... You need to input data into a denormalized table, so depend on the type of input you want to make product a vs b, some fields are going to be ignore or required... In this case there is many way of doing it... But I would like to be possible to define my validator once so it b

Re: [web2py] Re: Is it possible reload my model.py from an ajax request?

I mean you can't enforce On Fri, Aug 5, 2016 at 2:38 PM, Richard Vézina wrote: > That exactly one of my point about future of web2py and Massimo's > experimentation like w3 and more recently DBAPI ( > https://groups.google.com/d/msg/web2py-developers/jd7W_XS92aw/pZYzX0

Re: [web2py] Re: Is it possible reload my model.py from an ajax request?

That exactly one of my point about future of web2py and Massimo's experimentation like w3 and more recently DBAPI ( https://groups.google.com/d/msg/web2py-developers/jd7W_XS92aw/pZYzX07jAQAJ) Here : https://groups.google.com/forum/#!msg/web2py-developers/x23GReU0McM/5kX42ft-PAAJ So, what you ask,

Re: [web2py] Re: bounty pypi

As to remain backward compatible, I guess... A big task... Can you propose a package three structure we should comply to... We can then identify and list the blocking code piece then evaluate the changes requires then implement? I think the issue is more to map all the change needed to be done tha

Re: [web2py] display git version of my own web2py project

with no expiritation time On Fri, Jul 29, 2016 at 3:54 PM, Richard Vézina wrote: > You could also use web2py cache... > > :) > > Richard > > On Fri, Jul 29, 2016 at 12:39 PM, icodk wrote: > >> Might be useful for others >> I like to be able to see wh

Re: [web2py] display git version of my own web2py project

You could also use web2py cache... :) Richard On Fri, Jul 29, 2016 at 12:39 PM, icodk wrote: > Might be useful for others > I like to be able to see which version/tag my production web2py > application has. Here is how I do it(better ideas are welcome): > In db.py > > if not session.gitver: >

Re: [web2py] Re: bounty pypi

There is an exchange between me and Simone (Niphold) that explain a little of the complexity about Pypi packaging for web2py here : https://docs.google.com/document/d/11qcd5AmPoFNjuw_GAt8ceEJYUJ9gNPySHgWA4gNtZRM/edit Richard On Fri, Jul 29, 2016 at 10:09 AM, Marlysson Silva wrote: > It so much

Re: [web2py] Re: Improvements for DevOps

Nice answer... And constructive "critics". We will improve overtime, I guess... Richard On Thu, Jul 28, 2016 at 9:37 AM, Niphlod wrote: > These are all fair points, and I tried to change it over the years by > myself. > Unfortunately, everything I attempted failed, but let's "mitigate" point >

Re: [web2py] Re: Is there a way to find ID of inserted row if there is trigger after insert?

https://github.com/web2py/pydal/issues/399 And PR https://github.com/web2py/pydal/pull/400 On Wed, Jul 27, 2016 at 9:31 AM, Richard Vézina wrote: > Traceback (most recent call last): > File > "/home/richard/Documents/programmation/version_2146/web2py/gluon/restricted.py&quo

Re: [web2py] Re: switch between standard and testing database?

Hello Mirek, Did you give a look at how web2py.test is doing that? Bassically, a folder is created with the name of the app when at tests launch if the folder is there the testing database is used... Richard On Tue, Jul 26, 2016 at 6:24 AM, Mirek Zvolský wrote: > Finally I realized it using >

Re: [web2py] Re: Is there a way to find ID of inserted row if there is trigger after insert?

Traceback (most recent call last): File "/home/richard/Documents/programmation/version_2146/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/home/richard/Documents/programmation/version_2146/web2py/applications/sgddms/controllers/test.py"

Re: [web2py] Re: Is there a way to find ID of inserted row if there is trigger after insert?

Did we open a ticket and solve this one... I think I have this issue... I try to create an archive table and I fall on this error dal/pydal/adapters/postgres.py", line 181, in lastrowid return int(self.cursor.fetchone()[0]) I can't figure out why so far... Richard On Wed, Aug 6, 2014 at 2

Re: [web2py] Re: How active and 'professional' is web2py?

web2py is really good framework and you won't find any other with a learning curve as smooth as that... There is not seems that many major web site build over web2py, though I know for sure that there is many data centric app lying around in LAN of multiples business. Forces of web2py are : It e

Re: [web2py] orderby part of a string...

Something inside parenthesis, not sure if it specify the end of the string, in my case the parentheisis is at the end... :) Richard On Fri, Jul 8, 2016 at 5:56 PM, Dave S wrote: > > > On Friday, July 8, 2016 at 12:13:41 PM UTC-7, Richard wrote: >> >> Answer is yes it work just fine... >> >>

Re: [web2py] orderby part of a string...

Answer is yes it work just fine... db(db.ref_colorimeter_color.filter_parameter.belongs(['delta_a', 'delta_a_b'])).select(db.ref_colorimeter_color.color, orderby="substring(color, '\(([^\)]+)\)')") But with this : db.ref_colorimeter_color.color.regexp('\(([^\)]+)\)') It doesn't seems to work as

Re: [web2py] Re: Can't get a working web2py that will support many of the example apps. Most seem to be broken!

Can you show you mods to the welcome please... You may try to remove the auth.wiki() at line 60 of controllers/default.py though we need to understand how to reproduce this error. There maybe a bug in auth.wiki(). Difficult to say without knowing what you did... Richard On Fri, Jul 8, 2016 at

Re: [web2py] Re: Can't get a working web2py that will support many of the example apps. Most seem to be broken!

gid stand for group id... I grep the web2py code base you can see where gid is referenced : tools.py 6451:gid = group.id 6454:auth.add_membership(gid) contrib/fpdf/ttfonts.py 918:def getHMetric(self, numberOfHMetrics, gid): 920:if (gid < numberOfHMetrics):

Re: [web2py] Re: how to handle boolean's tri states?

Hello Alfonso, In my last email, I don't mean what I suggested before. But instead of using a boolean type field use just a string field (or a reference field better) so you can add new criteria if it ever happen in the future and you don't need to kind of customize the behavior of your boolean fi

Re: [web2py] Re: how to handle boolean's tri states?

I would rather use a string field with a drop box as it may arrive that you add more filter creteria, your three state bool wouldn't be enough once there... It makes your system less custom and easier to extend... Richard On Fri, Jul 8, 2016 at 10:41 AM, Alfonso Serra wrote: > You are right. T

Re: [web2py] Re: how to handle boolean's tri states?

Alfonso, What you use case? As HTML radio box doesn't allow NULL and by default web2py set bool field type as check box by default, it doesn't implment the NULL state as it doesn't make much sens to do it as false or NULL result in the same HTML tag state. You would need to use other widget repr

Re: [web2py] Querying auth_user by group

Notice : db().select(...) empty set will be abandonned (deprecated) probably... So better to specify table you are querying as you are writting new code... Ref.: https://github.com/web2py/pydal/issues/388 Richard On Thu, Jul 7, 2016 at 3:03 PM, Richard Vézina wrote: > Add a where clause

Re: [web2py] Querying auth_user by group

Add a where clause to remove them something like this : ~db.auth_group.startswith('user_') On Thu, Jul 7, 2016 at 2:57 PM, wrote: > Richard, > > Thank you for your reply. > > Using the code you suggested, implemented as this: > > users=db().select( > db.auth_user.id, db.auth_user.first_name

Re: [web2py] Querying auth_user by group

Why not do that instead of you first example : db(db.auth_user.id > 0).select(..., left=[db.auth_membership.on( db.auth_user.id == db.auth_membership.user_id), db.auth_group.on(db.auth_membership.group_id==db.auth_group.id)]) Richard On Thu, Jul 7, 2016 at 1:30 PM, wrote: > I assign each user

Re: [web2py] Re: multiple forms components issues

;form has errors' else: response.flash = 'please fill out the form' return dict(form=form) I will try later with custom form to see issue come from there... Richard On Thu, Jun 23, 2016 at 9:38 AM, Richard Vézina wrote: > Can try... But my guess is tha

Re: [web2py] Re: multiple forms components issues

Can try... But my guess is that it's cause by the "ifs" there must be some annoying thing happening cause of them... But when I look into the page source everything seems fine... I am suspecting something with javascript... Richard On Thu, Jun 23, 2016 at 5:28 AM, Massimo Di Pierro < massimo.dipi

Re: [web2py] Redirect to another page

Please provide code... I guess you are using component and .load get propagated, but can't be sure... Richard On Tue, Jun 21, 2016 at 4:17 PM, wrote: > Hi > > I am using {{redirect(URL('GetData'))}}, the result of this view is > getting appended to results of calling view, is there a way I can

Re: [web2py] Re: multiple forms components issues

Any clue? On Tue, Jun 21, 2016 at 10:51 AM, Richard wrote: > As you which!! > > # Controllers > Form 1 > def phone_numbers_form(): > """ > phone_numbers_form() allow to create/update/display phone(s) number(s). > > Args (vars): > readonlyform: If set to "True" the function on

Re: [web2py] Open a form popup only some user registered

You will need websocket_messaging/tornado for doing such a thing... Richard On Tue, Jun 21, 2016 at 12:21 AM, 'FERNANDO VILLARROEL' via web2py-users < web2py@googlegroups.com> wrote: > Dear All. > > I hope you could me explain how i can do the follow idea: > > If a have a user registered like us

Re: [web2py] Re: One-Step Production Deployment: Who Moved the Cheese?

Hello Horridohobbyist, You can also read the book on how to deploy Apache : http://www.web2py.com/books/default/chapter/29/13/deployment-recipes#Apache-setup We make a clean up in deployment scripts sometimes ago because many were outdated. We wand to avoid get to the same point (outdated stuff)

Re: [web2py] Problem with custom upload

No problem, I am glad you found your mistake. Richard On Fri, Jun 17, 2016 at 11:54 AM, 'Annet' via web2py-users < web2py@googlegroups.com> wrote: > Hi Richard, > > Thanks for your reply, renaming the application did not solve the problem. > However, > having a closer look at my code, I found th

Re: [web2py] Problem with custom upload

What happen if you put back org instead of com it is does fix things it kind of confirm that the issue come in part from there... On Fri, Jun 17, 2016 at 10:25 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hello Annet, > > Are you changing routes? > > On Fri, Ju

Re: [web2py] Problem with custom upload

Hello Annet, Are you changing routes? On Fri, Jun 17, 2016 at 9:12 AM, 'Annet' via web2py-users < web2py@googlegroups.com> wrote: > I have the following function: > > def logo(): > vertexID = get_vertexID(auth, session) > folder = 'vertexID' + str(vertexID) > table.image.uploadfolder

Re: [web2py] Re: A bunch of strange database errors

wingly > > On Thursday, June 16, 2016 at 12:54:28 PM UTC-4, Richard wrote: >> >> By curiousity which version were you having before upgrade? Depending of >> the version you have to update web2py specific app files... >> >> On Thu, Jun 16, 2016 at 12:53 PM, Rich

Re: [web2py] Re: A bunch of strange database errors

By curiousity which version were you having before upgrade? Depending of the version you have to update web2py specific app files... On Thu, Jun 16, 2016 at 12:53 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Yes you have to when cloning with git, if you don't pyDAL mo

Re: [web2py] Re: A bunch of strange database errors

did you clone --recursive? >> >> On Thu, Jun 16, 2016 at 12:41 PM, Richard Vézina >> wrote: >> >>> Do they share the same Database, if not it make no sens that auth_user >>> already exists... Did you modify the welcome app.ini db config? I ask >>

Re: [web2py] Re: A bunch of strange database errors

I would download and start fresh... How did you get 2.14.5? git clone? If so did you clone --recursive? On Thu, Jun 16, 2016 at 12:41 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Do they share the same Database, if not it make no sens that auth_user > already exist

Re: [web2py] Re: A bunch of strange database errors

Do they share the same Database, if not it make no sens that auth_user already exists... Did you modify the welcome app.ini db config? I ask because web2py use welcome as template for new app... On Thu, Jun 16, 2016 at 12:36 PM, Marty Jones wrote: > The reason I suspect a non-application-specifi

Re: [web2py] Re: A bunch of strange database errors

There shouldn't be issue specific to SQLite (I mean it should work properly), though there is maybe a specific unnoticed issue with it as there has been a big refactoring of pyDAL, I don't recall it the refactored pyDAL was present in 2.14.5 On Thu, Jun 16, 2016 at 12:22 PM, Marty Jones wrote:

Re: [web2py] Re: A bunch of strange database errors

Can you comment out the part of the scheduler, the db lock file may come from there... On Thu, Jun 16, 2016 at 12:05 PM, Marty Jones wrote: > Controller logic is below. Error 1 is occuring under the "dashboard" > function. Errors 2/3 under the user function. > > # -*- coding: utf-8 -*- > # this

Re: [web2py] A bunch of strange database errors

This seems uncompleted field model definition, no type, no reference auth.settings.extra_fields['auth_user']= [ Field('company'), ] I would define company referenced table before the auth_user extra field definition... For the other 2 errors, I think controller defaut about ~200+ lines would

Re: [web2py] A bunch of strange database errors

How did you upgrade ? Which version of web2py (2.14.6)? Richard On Thu, Jun 16, 2016 at 9:36 AM, Marty Jones wrote: > I uploaded a local application to my DigitalOcean droplet and have been > having a nightmare of a time with the databases. I get this variety of > errors on various pages: > > *

Re: [web2py] Are my permissions okay?

you shouldn't have to change permission only owner... sudo chown www-data.www-data -R ~/path/to/web2py Richard On Thu, Jun 16, 2016 at 9:13 AM, Marty Jones wrote: > I have ownership of my web2py folder set to www-data group and for > permissions I've used "sudo chmod 777 - R "~/path/to/web2py"

Re: [web2py] Re: generic.docx ?

I would recommand wordml 2003 over RTF... I did that in the past with lxml once you had get a grip of the name space of the xml format and figure out what the note you need and how to assemble them to make a properly formatted wordml it easy... But things like python-docx where not existing when I

Re: [web2py] Key Error when try to access records in DB tables

I think we would need more details, web2py version, more code, click on ID number?? in grid? Richard On Wed, Jun 15, 2016 at 1:36 AM, Joe wrote: > I can't understand what could possibly cause this. When I submit the form, > the form is processed, the page is redirected, email sent and the recor

Re: [web2py] generic.docx ?

There is https://python-docx.readthedocs.io/en/latest/ About the conversion from html I would say you will have to write it extracting with python beautifulsoup then you use the python-docx API for creating you docx Richard On Tue, Jun 14, 2016 at 11:46 PM, H. Das wrote: > Would it be possible

Re: [web2py] ReferenceError: web2py is not defined

Which version of web2py, trunk? I guess you should open a issue on github, but provide the exact path to reproduce the problem... Richard On Tue, Jun 14, 2016 at 2:56 PM, Manuele Pesenti wrote: > Il 14/06/16 17:56, Richard Vézina ha scritto: > > You miss web2py-bootstrap3.js in your

Re: [web2py] ReferenceError: web2py is not defined

You miss web2py-bootstrap3.js in your app? Was that error with default welcome or your app? On Tue, Jun 14, 2016 at 5:55 AM, Manuele Pesenti wrote: > Hi! > > I found some client side trouble using the validator IS_STRONG. > > Using this validator for such a field of a table and then visiting the

Re: [web2py] is it safe to create url in javascript?

You may need URL(..., scheme=True) depending if fancytree is picky or not... On Mon, Jun 13, 2016 at 4:44 PM, Richard Vézina wrote: > I not sure it safe or not, but it surely not portable... let say you app > is not at port 8000... > > use web2py to build you url using URL() helper

Re: [web2py] is it safe to create url in javascript?

I not sure it safe or not, but it surely not portable... let say you app is not at port 8000... use web2py to build you url using URL() helper and you just have to assign the output of URL() to a js var something like that : var url = {{=URL(c=controller, args=args, vars=vars)}} then source: {u

Re: [web2py] Moving auth_user and related tables to another schema

As far as I know web2py only support public schema, though as you mention I think can support other schema with rname... You mention to use it that way, it not working with auth if you create custom auth table model definition? Richard On Mon, Jun 13, 2016 at 10:04 AM, Johann Spies wrote: > W

Re: [web2py] Re: Ractive example

Where are we going? I also didn't had any answer here : https://groups.google.com/d/msg/web2py-developers/x23GReU0McM/5kX42ft-PAAJ Thanks Richard On Fri, Apr 17, 2015 at 10:56 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > No. That simply decides wheher to display the login menu.

Re: [web2py] Re: web2py 1.89.5

Damn it... It very old... I do have 1.88.2 and 1.91.something... But no 1.89.5 Sorry... I can only think of Massimo's that could help you with that... Richard On Thu, Jun 2, 2016 at 4:04 PM, Roman Molotkovski wrote: > Just checked the version file. It's says Version > 2.14.6-stable+timestamp.

Re: [web2py] Re: web2py 1.89.5

I will have it in my old VM pretty sure of that... As soon as I have time to reboot, will have a look, sadly I can't have 2 VMs side by side :( Richard On Sun, May 29, 2016 at 7:39 PM, Leonel Câmara wrote: > It should be on the code.google.com archive but I can't access it. An > alternative f

Re: [web2py] Knowledge Base app that runs on web2py?

Not sure what you search exactly... There is web2pyref : http://www.web2pyref.com/ though I don't know if the app had been released for others to clone it over github for instance... There is also web2py slice, the same thing applies don't know if you can get the app and work from there... Also the

Re: [web2py] many tyo many

I would suggest you to use things like Tag-it : http://aehlke.github.io/tag-it/ You can then use validate_and_insert web2py function to make sure you are not create security issue like sql injection if you insert ajax/post directly into the db. Richard On Wed, May 25, 2016 at 11:21 AM, goome wr

Re: [web2py] create dummy users programmatically

Use dedicated web2py function auth.register_bare() for instance... Look at test case here : https://github.com/web2py/web2py/blob/master/gluon/tests/test_tools.py#L647 Richard On Thu, May 19, 2016 at 9:34 AM, Pierre wrote: > for testing purposes: > > creation works but dummy users cannot login.

Re: [web2py] how to develop ATC?

:D I guess you may find someone who will help you to develop ATC with web2py here, but with Django you would better to ask their mailing-list... Richard On Fri, May 13, 2016 at 9:12 AM, hafte agebash wrote: > how to develop ATC(agument trafic control simulation tool) using the > python-django?

<    1   2   3   4   5   6   7   8   9   10   >