[web2py] Re: DAL contains query with single quote (with PG backend)

2019-07-15 Thread Manuele Pesenti
Il 15/07/19 14:45, Manuele Pesenti ha scritto: > "(housenumbers.city ILIKE '%sant\_olcese%' ESCAPE '\'))" with I beg your pardon because of the string was passed through GET method it was encoded and checked so the single quote was substituted by a underscore. I solved using POST method for

[web2py] Re: How to solve the Nginx error on digitalocean

2019-07-15 Thread Jim S
I don't think server can be a root element in this file. Do you have it under another element? I'd try it like this: web2py { server { listen 443; server_name server_domain_or_IP; root html; index index.html index.htm; ssl on;

[web2py] DAL contains query with single quote (with PG backend)

2019-07-15 Thread Manuele Pesenti
Hi! I have some trouble looking for records in PostgreSQL DB filtering using "contains" DAL method with substring containing single quote... I found the raw solution sobstituting the resulting query filter "(housenumbers.city ILIKE '%sant\_olcese%' ESCAPE '\'))" with "(housenumbers.city ILIKE

[web2py] How to solve the Nginx error on digitalocean

2019-07-15 Thread Maurice Waka
I have a usual 'working' nginx file which works fine when being tested. The /etc/nginx/nginx.conf file user www-data; worker_processes auto; pid /run/nginx.pid; include /etc/nginx/modules-enabled/*.conf; events { worker_connections 768; # multi_accept on; } http {