[web2py] Postgres migration errors

Hi Everyone, I recently migrated my entire SQLite database to Postgre 9.x . While almost all my changes are working fine, I am getting errors for a few SQL statements like below for sections in my dashboard. (i) this statement and below statement is throwing the error - However if

[web2py] Re: Update row When run a controller

You've defined the field as "current_state" (notice the lowercase), but you're trying to update the field "Current_State" (notice the camel case). You need to replace this: db(db.Exp_Logs_Perm.id == '1').update(Current_State='1') with this db(db.Exp_Logs_Perm.id == '1').update(current_state='1')

[web2py] Re: Problems with making the first user who logs in the "admin"

On Thursday, July 26, 2018 at 1:43:28 PM UTC-4, Krista King wrote: > > I am taking over a legacy project that uses web2py for an application for > inputting simple forms. The developer claims that the first person who logs > into the app with a fresh DB is the admin, however this is not the case.

[web2py] Problems with making the first user who logs in the "admin"

I am taking over a legacy project that uses web2py for an application for inputting simple forms. The developer claims that the first person who logs into the app with a fresh DB is the admin, however this is not the case. The first user is just a regular user. I need to be able to have an admin

[web2py] Re: Navbar in Chrome does not appear correct

Found the problem, I was using localhost instead of 127.0.0.1 when accessing the local server, changed that to the IP address and not localhost, and the navbar magically fixed itself. On Thursday, July 26, 2018 at 8:02:26 AM UTC-4, ggivler wrote: > > In an interesting development, I checked anot

Re: [web2py] Re: How to configure redis with web2py

thanks for sharing On 26 July 2018 at 18:40, 黄祥 wrote: > pls read the book > *ref:* > http://web2py.com/books/default/chapter/29/13/deployment-recipes#Caching- > with-Redis > http://web2py.com/books/default/chapter/29/13/deployment-recipes#Sessions- > in-Redis > > best regards, > stifan > > -- >

Re: [web2py] Re: How to go publick with web2py

Thanks for your answer that was exactly what i was looking for..i ll try it soon and i ll inform you for any progress. Στις Πέμ, 26 Ιουλ 2018, 16:15 ο χρήστης 黄祥 έγραψε: > pardon, not sure what is exactly means go public, if you want web2py app > can be accessed from other pc's and network (lan)

[web2py] Re: How to go publick with web2py

pardon, not sure what is exactly means go public, if you want web2py app can be accessed from other pc's and network (lan), perhaps you can set your web server to allow it access from outside *e.g. using rocket (shipped with web2py)* python web2py.py -i 0.0.0.0 another thing is go public means in

[web2py] Re: How to configure redis with web2py

pls read the book *ref:* http://web2py.com/books/default/chapter/29/13/deployment-recipes#Caching-with-Redis http://web2py.com/books/default/chapter/29/13/deployment-recipes#Sessions-in-Redis best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http:

[web2py] Re: Changes not reflecting

did you compile your web2py app? if compiled, pls uncompiled first another possibility is did you use cache in your web2py app? while the function is updated but the data showed is using the cache, perhaps you can clear the cache best regards, stifan -- Resources: - http://web2py.com - http:/

[web2py] Changes not reflecting

Hi All I am facing strange behavior in web2py. When I make some changes in controller or models it's getting saved in file but changes is not reflecting in application. I have restarted the app multiple times but changes not reflecting in app. I have compiled the app and installed in new proje

[web2py] Re: Dealing with reserved keywords when you change or upgrade your database from SQLite to POSTGRES

This information is awesome. Thank you for sharing this with us. Glad I am coding web2py. Cheers, Rahul On Thursday, July 26, 2018 at 3:09:35 AM UTC+5:30, Anthony wrote: > > On Wednesday, July 25, 2018 at 3:36:58 PM UTC-4, pbreit wrote: >> >> ...or Anthony! >> >> Thanks, that's good info and re

[web2py] Re: Navbar in Chrome does not appear correct

In an interesting development, I checked another instance of web2py that I have running on a Centos box, the one references below was running on Windows and the navbar is looking correct, so I guess I will need to spend some time comparing the two instances and see if I can determine what is di

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

Thank Anthony, The error was getting just because I used {{=sum(b)}} in my view. now this works fine. Best On Thu, Jul 26, 2018 at 5:12 PM Anthony wrote: > On Thursday, July 26, 2018 at 7:39:05 AM UTC-4, sandeep patel wrote: >> >> @Anthony, This gives me an error.becouse of some values float

[web2py] Navbar in Chrome does not appear correct

Just upgraded to the latest version of 2.16.1 the version file contains: Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 Chrome version: Version 68.0.3440.75 (Official Build) (64-bit) The navbar in chrome does not look like the navbar firefox See the attached files. Does anyone have a css

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

On Thursday, July 26, 2018 at 7:39:05 AM UTC-4, sandeep patel wrote: > > @Anthony, This gives me an error.becouse of some values float type in the > field. > > ('float' object is not iterable) > How can I successfully sum all the values within this solution? > Please show your exact code and the

[web2py] How to configure redis with web2py

Hello all, I want to configure Redis with web2py. I don't have any idea about this. I need a help from all to complete this task. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/is

[web2py] Update row When run a controller

Hi there, i have created a website that controls a remote lab and i need every time a user logs in to execute an experiment no other user can log in to the same experiment station. All i want to do is to update a flag value in a specific table in the database. In thee controller of the experime

[web2py] How to go publick with web2py

Hi, guys How i can go public with web2py so i can connect to my web app from other pc's and networks?? I ve been lost ..! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Rep

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

@Anthony, This gives me an error.becouse of some values float type in the field. ('float' object is not iterable) How can I successfully sum all the values within this solution? Thanks On Thu, Jul 26, 2018 at 4:09 PM Anthony wrote: > #controller.py >> >> grid = SQLFROM.grid(query,..,...) >> a

Re: [web2py] Re: Sum/Total of the column values in SQLFROM.grid?

> > #controller.py > > grid = SQLFROM.grid(query,..,...) > a = grid.__dict__ > b = sum([int(i.number_of_bags) for i in a['dbset'].select()]) > > This is more efficient because the database calculates the sum for you and you don't have to load all of the database records into the web2py process: