[web2py] Re: Strange invalid function issue after renaming controller name

2024-08-06 Thread Raul Monares
That has happened to me. Restarting uwsgi solved the problem On Thursday, August 1, 2024 at 1:03:11 AM UTC-6 at wrote: > Hello everyone, > > I'm encountering a strange issue. After renaming a controller and its > corresponding views and URLs, I'm receiving an "invalid function > (default/gohl_a

[web2py] Re: web2py -> py4web

2024-07-14 Thread Raul Monares
Hi Massimo I have several web2py applications in production. Big systems that would be difficult to move to py4web as they are growing all the time. But we're using Python 3.8. Also, GAE is not relevant to us Web2py has been fantastic. On Sunday, July 14, 2024 at 2:11:23 AM UTC-6 Clemens wrot

[web2py] Re: admin table query focus

2024-05-10 Thread Raul Monares
Excellent !! On Tuesday, April 23, 2024 at 2:31:01 PM UTC-6 snide...@gmail.com wrote: > I've long been bugged by going through the appadmin controller to do > database maintenance and not having the focus be anywhere useful. I think > I even have a comment about that somewhere in the forum. >

[web2py] Re: web2py 2.27.1 released

2023-11-18 Thread Raul Monares
Excellent !!! On Thursday, November 16, 2023 at 1:10:43 AM UTC-7 Massimo Di Pierro wrote: > web2py 2.27.1 was released > > - some linting and formatting > - added support to Python 3.11 > - fixed regexen and classname > - removed a circular dependency > > -- Resources: - http://web2py.com - htt

[web2py] Re: web2py 2.26.1 released

2023-10-29 Thread Raul Monares
Great news. I appreatiate your work on both platforms On Sunday, October 29, 2023 at 3:13:31 PM UTC-6 Massimo Di Pierro wrote: > Changelog: > - adds support of python up to version 3.11 > - fixes a bug with serialization of headers introduced in version 2.25.1 > - improves handling of unstable db

[web2py] Re: web2py 2.24.1 released

2023-04-02 Thread Raul Monares
Excelent news. Thanks !! On Thursday, March 23, 2023 at 5:43:34 AM UTC-6 xgp.l...@gmail.com wrote: > Thank you Massimo! > > El jueves, 23 de marzo de 2023 a las 0:20:20 UTC-5, Massimo Di Pierro > escribió: > >> Hello everybody, >> >> web2py 2.24.1 has been released. >> >> Thanks to Leonel, Cem,

[web2py] Re: web2py 2.23.0 released

2022-12-29 Thread Raul Monares
Great news. Thanks a lot !! On Thursday, December 29, 2022 at 3:15:56 AM UTC-7 Stephan wrote: > Thank you!! > > Massimo Di Pierro schrieb am Dienstag, 27. Dezember 2022 um 08:26:00 UTC+1: > >> Hello Everybody, >> >> My apologies for not being as engaged in this group as I used to be. >> >> web2py

[web2py] Re: Should I run sessions2trash.py even if I use Redis for sessions and set an expiration time?

2022-08-16 Thread Raul Monares
Thanks for sharing On Saturday, August 6, 2022 at 4:56:41 AM UTC-6 Lisandro wrote: > I'll try to answer my own question, in case it helps someone else. > Yes, you should run sessions2trash periodically, even if you're using > Redis and you're setting an expiration time for every session. > > As

[web2py] web2py.com down

2022-01-30 Thread Raul Monares
The site is down :( -- 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 subscribed to the Google Groups "web2py-use

[web2py] Re: string validation

2021-05-12 Thread Raul Monares
I found this code on the web # Python code to find the URL from an input string # Using the regular expression import re def Find(string): # findall() has been used # with valid conditions for urls in string regex = r"(?i)\b((?:https?://|www\d{0,3}[.]|[a-z0-9.\-]+[.][a-z]{2,4}/)(?:[^\s()<>]+|\(

Re: [web2py] Re: Insert data in firebird database

2018-05-14 Thread Raul Monares
> INSERT INTO bin_files (PARENT, SRC_FILENAME, DATA) VALUES >> (33,'name.jpg','very >> very long base64 string'). >> After that Firebird has hanged. Web2py given an error message. >> Just in case, are there between names 'DATA' and 'DAT

[web2py] Re: Insert data in firebird database

2018-05-12 Thread Raul Monares
Take into account that the Firebird DAL adapter has a 64kb limit for inserting blobs. On Friday, April 27, 2018 at 4:27:48 AM UTC-6, Константин Комков wrote: > > Hello! I'm trying add data in my table. > tables.py > db_xml.define_table('xml_files', > Field('F'), > Field('I'), > Fiel

[web2py] Re: Insert data in firebird database

2018-04-28 Thread Raul Monares
If web2py didn't create the generator and trigger, you can do it manually with this DDL CREATE GENERATOR GENID_XML_FILES; SET TERM !! ; CREATE TRIGGER XML_FILES_BI FOR XML_FILES ACTIVE BEFORE INSERT POSITION 0 AS DECLARE VARIABLE tmp DECIMAL(18,0); BEGIN IF (NEW.ID IS NULL) THEN NEW.ID = G

[web2py] Re: ImportError with packages in site-packages.

2018-04-12 Thread Raul Monares
I have same problem. From command line the modules are imported correctly. Using python web2py.py also loads the modules. But nginx + uwsgi doesn't work. On Thursday, March 29, 2018 at 6:57:47 PM UTC-6, AlighaThor wrote: > > And yes...I restarted the server several times without any effect. The

Re: [web2py] embed a pdf

2018-02-26 Thread Raul Monares
I have this code that shows a PDF stored in a field "archivopdf" of table "facturas". It is embedded in an iframe request.args(0) has the primary key def facturasprevista(): facturas=db.facturas[request.args(0)] response.headers['Content-Type']='application/pdf' return facturas.ar

[web2py] Re: Auto Complete Forms

2017-06-20 Thread Raul Monares
Take a look at the AJAX function http://www.web2py.com/books/default/chapter/29/11/jquery-and-ajax#The-ajax-function You could assing to trigger it on blur On Tuesday, June 20, 2017 at 10:01:06 AM UTC-6, Rodrigo Corvalan wrote: > > > Dear I am new to web2py I would like to know if it is possib

[web2py] Re: Validation error, field:email while trying to conect to SQL Express

2017-02-21 Thread Raul Monares
I changed from SQL Server Express 2016 to SQL Server Express 2012 and had no problems. On Saturday, February 18, 2017 at 12:00:16 PM UTC-7, Leonel Câmara wrote: > > The error is not in the connection string or with the migrate settings. > > I would try this in the command line to see what the pro

[web2py] Re: Validation error, field:email while trying to conect to SQL Express

2017-02-17 Thread Raul Monares
On Friday, February 17, 2017 at 2:16:24 PM UTC-7, Dave S wrote: > > > > On Friday, February 17, 2017 at 12:36:01 PM UTC-8, Raul Monares wrote: >> >> I'm trying to use SQL Express for a project. When I try to sign up using >> the demo app, I get this error >>

[web2py] Validation error, field:email while trying to conect to SQL Express

2017-02-17 Thread Raul Monares
I'm trying to use SQL Express for a project. When I try to sign up using the demo app, I get this error Validation error, field:email All auth tables are created in the database. I tried migrate = false, migrate = true. Same result. The connection string is mssql4://tarkus:rushrush@localhost/D

Re: [web2py] Re: Empty strings stored as null in database

2016-04-14 Thread Raul Monares
I just tested 2.14.5 and the solution is working. Great job !! On Thursday, April 14, 2016 at 7:46:57 AM UTC-6, Richard wrote: > > Let test then!! > > On Thu, Apr 14, 2016 at 9:15 AM, Niphlod > > wrote: > >> I hear you and I'm happy (or not, not sure) to not being alone ranting >> about web2py's

[web2py] Re: web2py 2.14.4 is OUT

2016-04-13 Thread Raul Monares
I just did some tests. It still saves empty strings as null when using SQLFORM or CRUD and the string field has default=''. But when using db.table.insert the empty string is stored. On Tuesday, April 12, 2016 at 3:29:26 PM UTC-6, Massimo Di Pierro wrote: > > web2py 2.14.4 is out. > > It fixes s

[web2py] Re: Empty strings stored as null in database

2016-04-05 Thread Raul Monares
the >> base adapter, and that appears to correctly insert an empty string. >> >> Anthony >> >> On Monday, April 4, 2016 at 3:54:10 PM UTC-4, Raul Monares wrote: >>> >>> It appears that default='' in the field constructor is being ignored. >>

[web2py] Re: Empty strings stored as null in database

2016-04-04 Thread Raul Monares
It appears that default='' in the field constructor is being ignored. When I later do an update to the same field with an empty string, it is stored correctly in the database. On Friday, April 1, 2016 at 12:41:12 PM UTC-6, Raul Monares wrote: > > I'm using Firebird

[web2py] Re: Empty strings stored as null in database

2016-04-01 Thread Raul Monares
I'm using Firebird 2.5.4 on Freebsd 10.2 On Friday, April 1, 2016 at 12:01:00 PM UTC-6, Dave S wrote: > > On Thursday, March 31, 2016 at 7:39:23 PM UTC-7, Raul Monares wrote: >> >> Hello >> I just updated to version 2.14.3 and noticed that empty strings are being

[web2py] Empty strings stored as null in database

2016-03-31 Thread Raul Monares
Hello I just updated to version 2.14.3 and noticed that empty strings are being stored as null in database field. This didn't happened in 2.13.4. Is this the intended behavior ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: web2py 2.13.1 is OUT

2015-12-19 Thread Raul Monares
Excellent !! On Thursday, December 17, 2015 at 11:31:38 PM UTC-7, Massimo Di Pierro wrote: > > CHANGELOG > > ## 2.13.1 > > > - fixed oauth2 renew token, thanks dokime7 > > - fixed add_membership, del_membership, add_membership IntegrityError > (when auth.enable_record_versioning) > > - allow pas

[web2py] Re: BLOB fields in MSSQL Server

2015-02-10 Thread Raul Monares
I had a similar problem with truncated info in blob fields. This line fixed for me: db.executesql('SET TEXTSIZE 2147483647') right after the DAL connection On Tuesday, February 10, 2015 at 8:24:19 AM UTC-7, Jose wrote: > > Hello everyone > > I have the following: > > Web2py on Freebsd. > Da

[web2py] Re: FDB (firebird) adapter can't store blobs greater than 64k

2013-11-28 Thread Raul Monares
I think the solution is to use streamed blobs (from FDB documentation): # Insertion:cur.execute("insert into blob_test values (?)", (StringIO('abcdef'),)) # Retrieval using the "file-like" methods of BlobReader: cur.execute("select a from blob_test")cur.set_stream_blob('A') # Note the capital

[web2py] Re: web2py 2.6.3 is OUT (security update)

2013-09-15 Thread Raul Monares
Thanks Massimo On Sunday, September 15, 2013 11:13:21 AM UTC-6, Massimo Di Pierro wrote: > > This is very similar to 2.6.1 but fixes some problem with a missing admin > file (also fixed in 2.6.2) and a potential DoS security issue. > > The issue was first discovered in Django > https://www.djang

[web2py] Re: FDB (firebird) adapter can't store blobs greater than 64k

2013-07-02 Thread Raul Monares
rd documentation >>> >>> *Sub-type is 1.** * >>> >>> *This blob field sub-type is designed for the storage and manipulation >>> of text. Typically, this is free-form memo or notes data. Typically you >>> would use this blob field sub-type is for

[web2py] Re: FDB (firebird) adapter can't store blobs greater than 64k

2013-07-01 Thread Raul Monares
e-form memo or notes data. Typically you would > use this blob field sub-type is for storing large amounts of text data. > This is more convenient that a large VARCHAR because, unlike a VARCHAR, > there is no 32K limit.* > > > > On Monday, July 1, 2013 7:21:03 PM UTC+2, Ra

[web2py] FDB (firebird) adapter can't store blobs greater than 64k

2013-07-01 Thread Raul Monares
When trying to store a value greater than 64k in a Blob Field, I get this error: ('Error while preparing SQL statement:\n- SQLCODE: -104\n- Dynamic SQL Error\n- SQL error code = -104\n- Unexpected end of command - line 1, column 25', -104, 335544569) But with blobs smaller than 64k works fine.

[web2py] Problem with legacy db and primarykey

2013-03-22 Thread Raul Monares
I have a MSSQL database with a 4 column primary key: dbcomercial.define_table('libros', Field('bloque',writable=False), Field('grupo',writable=False), Field('sector',writable=False), Field('libro',w