[web2py] About putting values into database

2020-08-21 Thread Andrea Fae'
Hello, I'm about 1 year that i don't program in web2py and I don't remember nothing! So, easy question I have this table (I created esplicitally the field is_active, created_on, created_by, do not ask me why...it's another question...) db.define_table('ticket', Field('asset',

Re: [web2py] Re: How to debug "lost password"

2020-08-21 Thread Jim S
Hey Jon, I should have been more specific. What I was looking for was the actual server and port you're accessing for the mail server. Looks like it is stored in your config. Is that mail server accessible from you workstation? Can you telnet to it using the settings in the config file?

Re: [web2py] Re: How to debug "lost password"

2020-08-21 Thread Jon Subscripted
Hi everyone, Whe I run my web2py app locally (in my desktop in 127.0.0.1:8000) I get the following message: '08/21/2020 11:48:56 AM' - web2py - WARNING - Mail.send failure:please run connect() first What does it mean? Thanks, Jon. On Fri, Aug 21, 2020 at 11:45 AM Jon Subscripted wrote: > Hi

Re: [web2py] Re: How to debug "lost password"

2020-08-21 Thread Jon Subscripted
Hi Jim, It looks like this (see below): # - # configure email # - mail = auth.settings.mailer mail.settings.server = configuration.get('smtp.server')

[web2py] MS SQL and searchable=true

2020-08-21 Thread Andrea Fae'
Using search standard widget with MS SQL server and trying to search only typing a string causes this error for example when I search simply "202h719" it appears this Query Not Supported: ('42000', u'[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Argument data type text is invalid for

[web2py] Developers

2020-08-21 Thread Anthony Smith
Hi are there any programmers in Australia looking for work -- 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

[web2py] Re: DAL Could not create constraint or index

2020-08-21 Thread Andrea Fae'
...but this error is not clear with me Error ticket for "ITAsset"Ticket ID 127.0.0.1.2020-08-21.09-54-23.77579ea3-20b8-49ca-aed5-76c10960c92f ('23000', u"[23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'itassetdb.dbo.asset_archive';

[web2py] Re: DAL Could not create constraint or index

2020-08-21 Thread Andrea Fae'
I think the problem with archiving is when I defined archive table in mssql I defined a field named 'current_record" type int. Maybe type int is not correct, isn't it? Thank you Il giorno venerdì 21 agosto 2020 09:43:14 UTC+2, Andrea Fae' ha scritto: > > Hello, some updates. > In the databases

[web2py] Re: DAL Could not create constraint or index

2020-08-21 Thread Andrea Fae'
Hello, some updates. In the databases I can see only this (see attachment). I'm trying to manage record versionin (table archiving). I create for example asset.archive in mssql but web2py doesn't "see" the table. In fact the table is not listend in the appadmin page. The question is that tables