[web2py] Re: Can't connect to MySQL

2019-09-10 Thread backseat
This code fails: uri = configuration.get('db.uri') print uri db = DAL(uri) The uri printed is: 'mysql://rota:rota@localhost/rota?set_encoding=utf8mb4' This code works: db = DAL('mysql://rota:rota@localhost/rota?set_encoding=utf8mb4') That's exactly the same URI (it was copy and pasted in Vim)

[web2py] Re: Redis and Python3?

2019-09-10 Thread Massimo Di Pierro
:-) On Monday, 9 September 2019 22:40:36 UTC-7, Joe Barnhart wrote: > > ROFL! I don't think it's quite ready for my prime-time cash-producing > website yet. I'll definitely keep an eye on it and start playing around > with it. I need to keep you from making any decisions I don't like, after

[web2py] Quick Favor?

2019-09-10 Thread rjmolesa
Hey, I just signed the petition "Time Inc. : Bring back MySpace" and wanted to see if you could help by adding your name. Our goal is to reach 100 signatures and we need more support. You can read more and sign the petition here: http://chng.it/gGc8F6hVTM Thanks! Jenni -- Resources: - http://

[web2py] 1215 Cannot add foreign key constraint

2019-09-10 Thread Steve
Goodevening, I am trying to migrate from Sqite to MySQL. Unfortunatly when restoring the field in the DB tables i get the following error: (1215, u'Cannot add foreign key constraint') location of issue: Field('Insurance',db.insurance,label=T('Insurance')), When i look this up in google t

[web2py] Re: Can't connect to MySQL

2019-09-10 Thread backseat
> > MySQL is listening on the default port: > $ telnet localhost 3306 Trying ::1... Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. c 5.5.5-10.3.17-MariaDB-0+deb10u1�a3y(W]OS��-��5KZaY|$920;vmysql_native_password^CConnection closed by foreign host. -- Resources: - htt

[web2py] How do I solve this error: NameError: name 'person_id' is not defined in KPax2

2019-09-10 Thread Maurice Waka
I'm trying out a surveys app from KPax2/surveys/take_survey.. but got this error: Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. Traceback (most recent call last): File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "/home

[web2py] Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

2019-09-10 Thread Val K
why do you have to override ids? You can just create users with the required ids. -- 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 messa

[web2py] Can I use SQLFORM for get id row (only read)?

2019-09-10 Thread Константин Комков
Hello! I have SQLFORM: db.tt_main.GROUP_ID.requires = IS_IN_DB(db((db.a_groups.id == db.tt_main. GROUP_ID) & (db.a_groups.INACTIVE == 0) & (db.a_groups.FO == 1)),db.a_groups .id,'%(NAME)s') db.tt_main.MODULE.requires = IS_IN_DB(db(db.tt_main.MODULE), db.tt_main. MODULE) form = SQLFORM(db.tt_main,fi

[web2py] Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

2019-09-10 Thread Davidiam
We are planning on using Web2Py in a 3 tier release model (Development, Acceptance, Production) but as the ID fields in the auth tables are used as primary and foreign keys, we are concerned that this will cause inconsistencies between the different pillars. We will be using SSO for access to we

[web2py] Re: How can I update the record in one table with value entry of another table as soon as the value is entered?

2019-09-10 Thread mostwanted
I figured if I could update the amount field in db.product within the buy functiontion just around the same time i'm saving inside the db.sale table when purchasing then it should be easy but I am having a really hard time identifying only the purchased items by their ids & subtracting their qu

[web2py] PythonAnywhere to AWS

2019-09-10 Thread Ian Ryder
Hi all, I asked a question a while back about AWS and Nginx but didn't get a reply so trying a different path! I've got an app I need to move over to AWS - does anyone know the easiest way to get web2py up and running on Amazon? I tried the old scripts for nginx but they seem to be out of date.

[web2py] smartgrid linked table edit returns to main table listing and not to the linked table listing

2019-09-10 Thread icodk
smartgrid that shows list of parents from a parents table and a Children linked table. Clicking on the Children link on a specific parent line shows a list of children's of that parent. So far so good. Click on the edit button on specific child in the list I can edit this child. Finish editi

Re: [web2py] VSCODE with linter + debugging in WEB2PY

2019-09-10 Thread Murat KAŞIKÇIOĞLU
Hi, I work with VSCODE like this: - Open folder includes web2py.py file. - Insert some debug point to desired lines - Press F5 Also my environment: Windows 10 Pro Web2py Python 2.7 (maybe Py 3> works same.) Best. --- Murat KAŞIKÇIOĞLU +90 (533) 745-1400 Monir , 4 E