Re: [web2py] Re: web2py api call from angular 4

2018-01-22 Thread yogeshwar khalkar
Yes my angular app running on node.js server running on 4200 Virus-free. www.avast.com

[web2py] Re: Database administration error

2018-01-22 Thread Jim S
Seems like you might have a permissions error. Are you running web2py as root? Looks like web2py is install in the /opt directory. Is this a production or development machine? -Jim On Monday, January 22, 2018 at 5:49:30 PM UTC-6, SR wrote: > > When I try to open my Database Administration

[web2py] Re: Unable to create Auth tables

2018-01-22 Thread Jim S
See Anthony's original answer to this question. All you should need to do is remove the associated *.table files from the /databases folder. Also, make sure you have migrations turned on by setting migrate=True in you DAL() setup. -Jim On Monday, January 22, 2018 at 6:06:10 PM UTC-6, SR

[web2py] Re: Unable to create Auth tables

2018-01-22 Thread SR
How do we recreate the auth tables after it has been dropped in mysql database? I would really appreciate your help. On Monday, November 25, 2013 at 8:34:18 PM UTC-6, Anthony wrote: > > web2py thinks it already created those tables (you dropped them outside of > web2py, so it doesn't know

[web2py] Database administration error

2018-01-22 Thread SR
When I try to open my Database Administration window I am getting this error ticket: Error ticket for "cryoem"Ticket ID 10.51.133.94.2018-01-22.17-44-57.ddaeb556-9bc8-46b4-8dde-99a3c6eee6e7 (1025, "Error on rename of './db_cryoem/#sql-6313_9e' to './db_cryoem/auth_user' (errno: 150)")Version

[web2py] Re: web2py api call from angular 4

2018-01-22 Thread Dave S
On Monday, January 22, 2018 at 4:57:34 AM UTC-8, yogeshwar khalkar wrote: > > Please help me, > > > When I am try to login from angular 4 app to web2py rest api browser shows > error like > > OPTIONS http://127.0.0.1:8000/csautomation/user/login 405 (METHOD NOT > ALLOWED) > > *AND* > > Failed

[web2py] Re: ( parser stack overflow) when writing a row with 140 fields

2018-01-22 Thread Anthony
> > With 140 fields, you get queries nested 140 levels deep in parentheses, > which SQLite cannot handle. Of course, all of the nested parentheses are > not really necessary, so if you want to first check for the existence of a > record, one option is to avoid using .update_and_insert() and

[web2py] Re: ( parser stack overflow) when writing a row with 140 fields

2018-01-22 Thread Anthony
On Thursday, January 18, 2018 at 9:31:49 PM UTC-5, Jaison Raj wrote: > > Hi guys, > > I am trying to write a row with 140 fields into the database, with the > following script: > > controller: > *WCEL={item1:value1,item2:value2,...item140:value140}* > > *db.WCEL.update_or_insert(**(WCEL))* >

[web2py] Re: how to keep response.headers after redirect

2018-01-22 Thread Anthony
On Friday, January 19, 2018 at 7:49:22 AM UTC-5, vince wrote: > > i tried > raise HTTP(303,location="url",HEADER_TEST=True) > > but i can't find the HEADER_TEST header passed, is this still valid for > recent version of web2py? > That is the correct usage. When you say you cannot find the

Re: [web2py] Re: how to keep response.headers after redirect

2018-01-22 Thread Anthony
On Friday, January 19, 2018 at 8:38:23 AM UTC-5, Kiran Subbaraman wrote: > > Include the header values in a dictionary: > ``` > raise HTTP(303,location="url",{HEADER_TEST:True}) > That won't work. Perhaps you meant: raise HTTP(303, location="url", **{'HEADER_TEST': True}) Notice the need for

[web2py] how to hash the a users password in bash script

2018-01-22 Thread lucas
hello one and all, I'm creating a bash script that creates the new db with indexes, functions, etc. using Postgresql 9.2 for the DAL to use in web2py 2.16.1. as it stands now, the script works great and even creates the tables properly as setup in db.py, etc. I would like to insert some users

[web2py] web2py api call from angular 4

2018-01-22 Thread yogeshwar khalkar
Please help me, When I am try to login from angular 4 app to web2py rest api browser shows error like OPTIONS http://127.0.0.1:8000/csautomation/user/login 405 (METHOD NOT ALLOWED) *AND* Failed to load http://127.0.0.1:8000/csautomation/user/login: Response to preflight request doesn't