Re: [web2py] How to perform a DB migration from outside the app where DB is defined?

anges associated. Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal) e-mail:ge...@memoriapersistente.pt URL:http://www.memoriapersistente.pt -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sour

Re: [web2py] Response flash message after email sent not working

se.flash = 'Reset password email sent' http://web2py.com/books/default/chapter/29/07/forms-and-validators#Forms-and-redirection -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail:ge...@memo

Re: [web2py] DAL how to increment column value

cord first in other to get the value to be incremented. But, if there are many users it might lead to corrupted values due to concurrency. As far as I know, the latest is the only sane approach to solve your problem. Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 1

Re: [web2py] Changes to sqlhtml.py are not detected on linux server.

those modifications. Any idea what may be going on? Sorry for the bad translation. Thanks. Hi, Have you deleted sqlhtml.pyc before restarting the server? Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail: ge...@memoriapersistente.pt URL

Re: [web2py] How to pass variables to db.executesql?

)s', placeholders=dict( id=someWeb2PyVariable ) ) Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.pt GnuPG: wwwkeys.eu.pgp

Re: [web2py] Login via an link/URL

use Auth.login_user() to authenticate the user. Having said that, please note that it is a (very) bad idea, since a "man in the middle" could easily intercept the mail and hack the session. Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal,

Re: [web2py] Re: Object type None error

    rowsrate = get_amc_rate(amcid)     return dict(record=record,rowsconlab=rowsconlab,rows=rows,rowsrate=rowsrate) the error occurs in the  line marked red. EXEC is not a SQL statement. -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSIST

Re: [web2py] Problem starting a distributed transaction

Às 14:40 de 03/07/20, Carlos Correia escreveu: Hi, I have this piece of code in a controller to test a distributed transaction but it fails with: "ValueError: need more than 0 values to unpack". def index(): response.flash = T("Hello World") db0 = DAL('postg

Re: [web2py] Re: two Database syncrho

Às 13:28 de 04/07/20, Carlos Correia escreveu: Às 06:14 de 01/07/20, Massimo Di Pierro escreveu: Yes. Only on PostgreSQL, MySQL and Firebird. Assuming the feature has not been broken over time, I do not know of anybody who used it. On Thursday, 11 June 2020 12:51:48 UTC-7, Ari Lion BR Sp

Re: [web2py] Re: two Database syncrho

rollers/default.py>, line 12, in index DAL.distributed_transaction_begin( db0, db1 ) File ".../web2py/gluon/packages/dal/pydal/base.py", line 341, in distributed_transaction_begin keys = ['%s.%i' % (thread_key, i) for (i, db) in instances] Best regards, Carlos Correia ===

[web2py] Problem starting a distributed transaction

uon/packages/dal/pydal/base.py", line 341, in distributed_transaction_begin keys = ['%s.%i' % (thread_key, i) for (i, db) in instances] What I am doing wrong? Thanks, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 (Signal, WhatsApp) e-mail: ge...@memoriapersistente.pt URL: http:

Re: [web2py] Re: Why would new code be ignored and old code be executed?

wrote: To track module changes try this from gluon.custom_import import track_changes; track_changes(True) Also, your problem looks like you have more then one web2py server running Regards, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 e-mail: ge

Re: [web2py] Re: Many records in one transaction

rds, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.pt GnuPG: wwwkeys.eu.pgp.net -- Resources: - http://web2py.com - http://web2py.com/book (Documentat

Re: [web2py] blob fields with PostGres

Às 05:45 de 15/01/20, Dave S escreveu: On Sunday, January 12, 2020 at 9:36:14 AM UTC-8, Carlos Correia wrote: Às 22:51 de 10/01/20, Dave S escreveu: > For web2py/pydal when the backend is PostGres, are blob fields translated to > bytea or to large object? > &

Re: [web2py] blob fields with PostGres

)? Psycopg2 (not Web2py) maps blobs to bytea, but has the 1GB limit. This thread explains how to deal with that (using lo_import and lo_export): https://postgresrocks.enterprisedb.com/t5/EDB-Postgres/problems-with-writing-reading-a-data-bytea/td-p/2095 , Regards, Carlos Correia

Re: [web2py] Re: Cookies and redirect

Às 03:28 de 22-08-2018, Anthony escreveu: > On Tuesday, August 21, 2018 at 12:37:16 PM UTC-4, Carlos Correia wrote: > > Hi, > > > Is it possible to set a cookie and redirect to another page in the same > controller? > > If yes, how? I tried this si

Re: [web2py] custom form web2py not work when i use selectpicker

Às 20:41 de 21-08-2018, Rodrigo Gomes escreveu: > thanks, but the problem is not adding the selectpicker in the selects, the > problem is that by adding it to any select it does not recognize the input > data > > terça-feira, 21 de Agosto de 2018 às 14:17:48 UTC-3, Carlos C

Re: [web2py] custom form web2py not work when i use selectpicker

, 'person': 4}> > -- > 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 are s

[web2py] Cookies and redirect

response.cookies[ cookie_name ][ 'expires' ] = 24 * 3600 response.cookies[ cookie_name ][ 'path' ] = '/' response.cookies[ cookie_name ][ 'secure' ] = True redirect( URL( c='test', f='cookie_result' ) ) Thanks, Carlos Correia = MEMÓRIA PERSISTENTE GSM: 917 157 146 e

Re: [web2py] New table fields don't show

cod_m',   type='integer'), >     Field('nome',    type='string'), >     Field('regiao',  type='integer'), >     Field('tipo',    type='integer'), >     fake_migrate=True) > > Best regards, > Luís > I use to do DB migrations 'by hand', so that I can keep the full control

Re: [web2py] Web2py Postgresql Groupby issue

(Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email > to web2py+unsubscr...@googlegroups.com > <mai

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

How did you do it? I'm facing the same problem... Thanks -- 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 are

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

support system, surveys) without any problems. These ones I expect to publish as soon as possible (probably, during the holiday s). So I would say you should (at least) give it a good try ;-) Also, the mailing list is very helpful to any question you may have. Regards, Carlos Correia ==

Re: [web2py] Re: Progress bars and session

te a field in some db table and use it instead of session. Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 e-mail: ge...@memoriapersistente.pt URL: http://www.memoriapersistente.pt XMPP (Jabber): car...@memoriapersistente.pt (NOVO) GnuPG: wwwk

Re: [web2py] IMPORTANT - WEB2PY CONSULTING

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Please add me. URL: http://memoriapersistente.pt Country: Portugal The page is a bit outdated and shall be updated soon... Thanks, Carlos Correia On 15-02-2015 22:21, Massimo Di Pierro wrote: > We need to update the list of compan

Re: [web2py] how to get old version

py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: ht

Re: [web2py] Re: Bug on checkboxes

ter's name should be 'value', not '_value' and '_checked' is not needed: INPUT(_type="checkbox",_name=field.name,_class="checkbox",value="on") Cheers, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 / 967 511

Re: [web2py] PyCharm license for web2py dev - who wants?

e@googlegroups .com>. > For more options, visit https://groups.google.com/d/optout. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 218 471 841 (NOVO) GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memo

[web2py] One app to authenticate them all?

(again) in the app. Is there any way to avoid the (second) login in the targeted app? I know I could use a different database for Auth(), but don't know if it's even possible to avoid the last login. Thanks, - -- Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM

Re: [web2py] Re: Support for MS Access?

- -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG: wwwkeys.eu.pgp.net URL Suporte: https://t5

Re: [web2py] Re: Version 2.9.6 indeed breaks backward compat for some users

melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG: wwwkeys.eu.pgp.net URL Suporte: https://t5.m16e.com/gps

[web2py] Re: Help in server config

appreciate *very much *any help. Thanks, Sábado, 30 de Agosto de 2014 20:25:08 UTC+1, Carlos Correia escreveu: Hi, After migrating a web2py tree with several apps from one server to the other, I found that in the new server I had to put a symbolic link in admin/static to itself

Re: [web2py] Re: Help in server config

. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG: wwwkeys.eu.pgp.net URL Suporte: https

[web2py] Help in server config

Hi, After migrating a web2py tree with several apps from one server to the other, I found that in the new server I had to put a symbolic link in admin/static to itself with the release name prefixed by an underscore in order to get a normal (css/js) admin interface, i.e., in

Re: [web2py] Re: IS_IN_SET options list separator

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 24-06-2014 18:48, Massimo Di Pierro escreveu: There is no syntax to do this. Thanks for the answer. I'll try to fix it through javascript, ten. On Monday, 23 June 2014 12:49:21 UTC-5, Carlos Correia wrote: Hi, Is there a way

[web2py] IS_IN_SET options list separator

option disabled_/option option value=2Second/option option value=3Third/option /select Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt

Re: [web2py] orderby / case

-order-by-multiple-values-in-specific-order - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG

Re: [web2py] Database help

...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber

Re: [web2py] Re: Hide actions in navbar

') | which gives you a dictionary from which you can build your own navbar. Anthony Thank you, Anthony, Both solve my problem, at least, by now. Meanwhile, I'll try to submit a patch from trunk on Github. On Monday, May 5, 2014 9:36:29 PM UTC-4, Carlos Correia wrote: Hi

[web2py] Re: Hide actions in navbar

Hi, It seems no one is interested on this subject... Is there any kind of workaround that survives upgrades? Best regards, Carlos Quinta-feira, 16 de Maio de 2013 8:17:28 UTC+1, Carlos Correia escreveu: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I needed to hide registering

Re: [web2py][Javascript] Massimo here searching for some javascript devs ready to port web2py in JS

from it, send an email to web2py+unsubscr...@googlegroups.com mailto:web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917

Re: [web2py] Which Postgresql version?

for postgresql? Nothing special... psql is enough for must purposes. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt

Re: [web2py] New to Web2Py: Large Model

://www.web2pyslices.com/slice/show/1479/model-less-apps-using-data-models-and-modules-in-web2py Basicly, you move table defenitions from models to modules, only defining tables as needed. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219

Re: [web2py] Re: sqlite --- postgresql

then 2 minutes to setup a basic environment for Postgrsql. And maybe there's no need to switch. SQLite is not a toy. It's definitely not a toy, but maybe not the best option for web app which should muliple users at once? Sincerely, Gour - -- Com os melhores cumprimentos, Carlos

Re: [web2py] diffrence between web2py and django framework...

, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG: wwwkeys.eu.pgp.net URL Suporte: https://t5.m16e.com/gps -BEGIN PGP SIGNATURE

Re: [web2py] reference db.auth_user from other Database..

-cross-database-queries-with-postgres - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG

[web2py] Help needed in obscure bug (only on server)

a bug like this, without reverting all changes and applying them one by one? Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÃ?RIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http

Re: [web2py] Help needed in obscure bug (only on server)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Clarifying the question: what kind of bug in my code may be causing the session to expire? Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511

Re: [web2py] Help needed in obscure bug (only on server)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 20:23, Ricardo Pedroso escreveu: On Thu, Aug 8, 2013 at 2:36 PM, Carlos Correia car...@memoriapersistente.pt mailto:car...@memoriapersistente.pt wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm

Re: [web2py] Help needed in obscure bug (only on server)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 22:05, Ricardo Pedroso escreveu: On Thu, Aug 8, 2013 at 9:22 PM, Carlos Correia car...@memoriapersistente.pt mailto:car...@memoriapersistente.pt wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 20

Re: [web2py] Help needed in obscure bug (only on server)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 08-08-2013 21:56, Michele Comitini escreveu: Is BizDoc pickable? Yes. Otherwise Web2py would raise an exception (I think). 2013/8/8 Carlos Correia car...@memoriapersistente.pt mailto:car...@memoriapersistente.pt Em 08-08-2013 20 tel:08

[web2py] Hide actions in navbar

an extra parameter to Auth.navbar() that accepts an array of actions to hide. I attach the patch from [Version 2.3.2 (2012-12-17 08:59:58) stable] with the changes. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157

Re: [web2py] apache backdoor?

they do the same with any other binary in the system? Seems to be a c-panel issue, not apache's. - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http

Re: [web2py] postgres getting started (hello world)

'? Also you should tell psql to prompt the user's password: psql -U dbuser -d testdb -W or have it defined in a ~/.pgpass file - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge

Re: [web2py] DAL Keys

':[], } whey cant i use db.keys now ? how can i fix this Best Regards, -- - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http

[web2py] Possible regression in DAL?

if fields or colnames: 7251 fields = [] if fields is None else fields ProgrammingError: no results to fetch Before the upgrade, I was using Version 2.00.0 (2012-08-03 09:01:00) dev Thanks, - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA

Re: [web2py] Re: Possible regression in DAL?

in there that would have caused more problems. Check out latest trunk and try: db.executesql('truncate auth_event',fetch=False) else it expect the query to return something. On Monday, 3 September 2012 14:01:57 UTC-5, Carlos Correia wrote: Hi, After updating to trunk (Version 2.0.6 (2012-09-03

Re: [web2py] Re: Possible regression in DAL?

, Carlos Correia wrote: Hi, It fixed the issue, indeed. So I assume I'll have to review all the executesql's calls in order to add the fetch parameter to the ones that need it, which, in this case won't be a simple task :( What was the problem with the try/except block? Can't see one

Re: [web2py] Complex query in DAL?

use something like this to address that problem: from gluon.storage import Storage rows = db.executesql(..., as_dict=True) list = [] for r in rows: list.append( Storage( r ) return list - -- Com os melhores cumprimentos, Carlos Correia = MEMÓRIA PERSISTENTE, Lda. Tel

Re: [web2py] Re: data source configuration

think this is necessary but I really don't understand why. Is there a workaround for me? I have some ideas but nothing seems to be optimal. I'd prefer to avoid dirty hacks... thanks, Alex - -- Com os melhores cumprimentos, Carlos Correia