[web2py] Insert fontawesome icon into form submission button

Hi all, I'm trying to insert a fontawesome icon into a form submission button. The form is being created in the controller using FORM. form=FORM(INPUT(_name='bookmark',_id="bookmark",_type='hidden'), INPUT(_type='submit',_class='btn btn',_value=T('Bookmark'))) I've tried a

[web2py] Logger creating recursion error

Hi everyone, I suddenly started experiencing an application crash, with no code change whatsoever. I started to get a ` maximum recursion depth exceeded in cmp` error. ```Traceback (most recent call last): File "/home/jonsubscriptions/web2py/gluon/restricted.py", line 219, in restricted

Re: [web2py] Re: Changing main repo and database model modifications

tps://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Tue, Dec 8, 2020 at 9:48

Re: [web2py] Re: Changing main repo and database model modifications

et the error below: >>>> >>>> InternalError: (1054, u"Unknown column 'tag.in_between' in 'field list'") >>>> >>>> I'd really appreciate some guidance on this, as I'm going literally >>>> nuts with all the migration, frake migration,

Re: [web2py] Re: Changing main repo and database model modifications

Hi Clemens, Just some quick questions. 1) What happens with auth tables and python -S -M -P? it does not seem to create the .table files 2) Regarding migration and fake migration. I tried to summarize my understanding in the table below (use a fixed width font to see it properly). How does

Re: [web2py] Re: Changing main repo and database model modifications

is, as I'm going literally nuts >> with all the migration, frake migration, sql.log and tables business... >> Thanks, Jon. >> >> On Mon, Dec 7, 2020 at 2:03 PM Jon Subscripted >> wrote: >> >>> Hi all, >>> I want to change the main repo co

Re: [web2py] Re: Changing main repo and database model modifications

Thanks Clemens and Jim S. So I guess that I should use the "python web2py.py -M -S " command option to create the new table files, right? On Mon, Dec 7, 2020 at 8:54 PM Clemens wrote: > Please try *not* to use the .table files. You can just rename database > folder to database.orig and create

[web2py] Re: Changing main repo and database model modifications

tween' in 'field list'") I'd really appreciate some guidance on this, as I'm going literally nuts with all the migration, frake migration, sql.log and tables business... Thanks, Jon. On Mon, Dec 7, 2020 at 2:03 PM Jon Subscripted wrote: > Hi all, > I want to change the main repo copy from which

[web2py] Changing main repo and database model modifications

Hi all, I want to change the main repo copy from which I work but when I do it I'm not longer capable of modifying the database. BTW the old and new repo are not in the same machine. *My "sql.log" and every ".table" file are uploaded to the repo. *The old repo has migrations enabled (both in

Re: [web2py] Re: Dashboard library for Web2py performance/recommendation python vs. js

Thanks Alex! El El mié, 18 nov 2020 a las 14:38, Alex Beskopilny escribió: > dasjboards for web2py https://github.com/ali96343/facew2p > dashboards for py4web https://github.com/ali96343/facep4w > charts Highcharts.js > On Tuesday, November 17, 2020 at 11:47:04 AM UTC+3 Jonsubs wrote: > >> Hi

Re: [web2py] Dashboard library for Web2py performance/recommendation python vs. js

use this 2 templates: > Paper dashboard and AdminLTE. > > Cheers. > Chris. > > El El mar, 17 de nov. de 2020 a la(s) 05:47, Jon Subscripted < > jonsubscripti...@gmail.com> escribió: > >> Hi everyone, >> I need to implement a dashboard and some charts in my w

[web2py] Dashboard library for Web2py performance/recommendation python vs. js

Hi everyone, I need to implement a dashboard and some charts in my webapp. And honestly I'm a little bit lost and overwhelmed. >From a Web2py perspective which is the best approach? a) a python based solution (e.g. plotly) b) a JS based solution My app is hosted in Pythonanywhere. Is there any

[web2py] FLASH_MSG=ImportError

Hi everyone, I have a view that fails to load and redirects me directly to index.html. In the browser navigation bar I get: http://127.0.0.1:8000/?FLASH_MSG=ImportError I didn't find much information on this type of "ImportError". What does it mean? Thanks, Jon.

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

e 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? >>> >>> -Jim >>>

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

get >> the following message: >> >> '08/21/2020 11:48:56 AM' - web2py - WARNING - Mail.send failure:please >> run connect() first >> >> What does it mean? >> Thank

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

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: >

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

nt. >> Thanks, Jon. >> >> On Wed, Aug 19, 2020 at 7:49 PM Jon Subscripted >> wrote: >> >>> Hi everyone, >>> I'm having some trouble sending "lost password" emails to my users. >>> Whenever I test it I get an "Unable to send email&

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

Any suggestions on how to debug "password lost" email not being sent. Thanks, Jon. On Wed, Aug 19, 2020 at 7:49 PM Jon Subscripted wrote: > Hi everyone, > I'm having some trouble sending "lost password" emails to my users. > Whenever I test it I get an "Unable

[web2py] How to debug "lost password"

Hi everyone, I'm having some trouble sending "lost password" emails to my users. Whenever I test it I get an "Unable to send email" message. But I do not really know the reason. I tried with a standalone python script with the same configuration and it works. I'd like to know how to debug this

Re: [web2py] Re: How to debug appadmin CSV uploading

Thanks Dave! El El sáb, 16 may 2020 a las 23:18, Dave S escribió: > > > On Friday, May 8, 2020 at 12:41:16 PM UTC-7, Jonsubs wrote: >> >> Thanks! >> >> El El sáb, 2 may 2020 a las 3:10, Andrew Rogers >> escribió: >> >>> Can't help you Jon sorry. I tried to upload a while back but got a >>>

Re: [web2py] Re: How to debug appadmin CSV uploading

Thanks! El El sáb, 2 may 2020 a las 3:10, Andrew Rogers escribió: > Can't help you Jon sorry. I tried to upload a while back but got a > different issue (see > https://groups.google.com/forum/#!topic/web2py/03-7xKAioD8) So maybe > that feature has fallen into disuse? > > > On Friday, 1 May

[web2py] How to debug appadmin CSV uploading

Hi everyone, I'm trying to upload a CSV file to my MySQL database using appadmin. I do get a "data uploaded" flash message as if I succeeded, but data is not there. Could anyone suggest me how to debug this operation? Thanks, Jon.

[web2py] Re: 2 apps 1 DB, switching migration control from one app to the other

; Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Wed, Apr 29, 2020 at 1:02 PM Jon Subscripted wrote: > Hi everyone, > I have 2 apps that were using t

[web2py] 2 apps 1 DB, switching migration control from one app to the other

Hi everyone, I have 2 apps that were using the same DB (lets call them old_app and new_app). As the old_app created the DB, old_app had the migrations enabled and new_app had the migrations disabled. Both apps diverged and I would like to do it the other way round. new_app migrations enabled and

[web2py] Re: Creating cookie if not present and modify it if present

.. #calculate mu,phi,sigma response.cookies['elocookie'] = (mu,phi,sigma) response.cookies['elocookie']['expires'] = 72 * 3600 response.cookies['elocookie']['path'] = '/' logger.debug("new cookie elo %s %s %s"%(mu,phi,sigma)) Thanks, Jon. On Sat, Apr 18, 2020 at 8:33 PM Jon Subscripted

[web2py] Creating cookie if not present and modify it if present

Hi everyone, I'm facing some problems handling cookies. I need to store and update a value for non-auth users. I need to do it throughout the session (this could be done with session cookies) but also between different sessions. That's why I decided to use cookies. I tried to follow web2py books'

Re: [web2py] Re: SQLFORM labels and input boxes overlapping

Thanks Dave, I'll check it out! Libre de virus. www.avast.com <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

[web2py] SQLFORM labels and input boxes overlapping

Hi everyone, In some of my views using SQLFORM, specially when the label text is not short, the input box overlaps and covers part of the label text. How can I avoid this? As this is automatically generated HTML, I do not have clear where should I look. Regards, Jon.

[web2py] Re: Include control specific data in layout.html header

(): datalayer = get_datalayer('general','index') return dict(message=T('Welcome to my app!')) Thanks! Jon. On Wed, Apr 1, 2020 at 5:59 PM Jon Subscripted wrote: > Hi everyone, > I'm trying to include view specific data in each view header (it is > actually a GTM datalayer). >

[web2py] Re: Embed youtube video in markmin (à la web2py book)

Hi, any suggestions on how to implement this? Thanks, Jon. On Tue, Mar 31, 2020 at 2:00 PM Jon Subscripted wrote: > Hi everyone, > I have a part of my website shaped as web2py book. In order to handle long > texts in different languages. > > As you might know content is in

[web2py] Include control specific data in layout.html header

Hi everyone, I'm trying to include view specific data in each view header (it is actually a GTM datalayer). I thought the best way to do it was to define a global variable in db.py and to print a variable {{=datalayer}}, the each controller will overwrite it with specific data. It seems to be

[web2py] Embed youtube video in markmin (à la web2py book)

Hi everyone, I have a part of my website shaped as web2py book. In order to handle long texts in different languages. As you might know content is in *.markmin files that are reprocessed into HTML to be served by a generic controller. I'm trying to embed a youtube video in the *.markmin file. I

[web2py] Re: rotatingfilehandler logging not working in windows

Hi everyone, I've just found out that the application is actually logging correctly but not using "web2py/logs" folder. Thanks, Jon. On Sat, Feb 8, 2020 at 11:53 AM Jon Subscripted wrote: > Hi everyone, > I've still haven't figured out what I do wrong. > > Should

[web2py] Re: rotatingfilehandler logging not working in windows

Jon. On Wed, Feb 5, 2020 at 6:35 PM Jon Subscripted wrote: > Important detail. There's a typo in my previous email (but NOT in the > logging configuration file name). The logging configuration file name is > correctly named "logging.conf". > Thanks, Jon. > > On We

[web2py] Re: rotatingfilehandler logging not working in windows

Important detail. There's a typo in my previous email (but NOT in the logging configuration file name). The logging configuration file name is correctly named "logging.conf". Thanks, Jon. On Wed, Feb 5, 2020 at 6:26 PM Jon Subscripted wrote: > Hi everyone, > I'm trying to

[web2py] rotatingfilehandler logging not working in windows

Hi everyone, I'm trying to send myapps log to the rotatingfilehandler but something fails. It does log in the console but not in the file. web2py/logs folder is empty. For simplicity I'm using the "welcome" application. 1) I'm running web2py (version 2.18.5-stable+timestamp.2019.04.08.04.22.03)

Re: [web2py] Re: Cookie policy plugin

Thanks! On Wed, Jan 15, 2020 at 7:15 AM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I like this one: > > window.addEventListener("load", > function(){window.cookieconsent.initialise({"palette": {"popup": > {"background": "#000"},"button": {"background": "#f1d600"}}})}); > > > > On

[web2py] Cookie policy plugin

Hi everyone, Is there some easy way or specific plugin to implement EU cookie policy in Web2py? Thanks, Jon. -- 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)

Re: [web2py] Re: How to link images (under static/images) from static folder static html

e in locally (127.0.0.0), but not in PythonAnywhere. >> Thanks, Jon. >> >> On Mon, Jul 22, 2019 at 4:02 PM Jon Subscripted >> wrote: >> >>> Hi everyone, >>> I'm experiencing some problems trying to display static images in my >>> static htm

[web2py] Re: How to link images (under static/images) from static folder static html

Hi everyone, Any suggestions, please? It does work for me in locally (127.0.0.0), but not in PythonAnywhere. Thanks, Jon. On Mon, Jul 22, 2019 at 4:02 PM Jon Subscripted wrote: > Hi everyone, > I'm experiencing some problems trying to display static images in my > static html files. A

[web2py] How to link images (under static/images) from static folder static html

Hi everyone, I'm experiencing some problems trying to display static images in my static html files. Actually I get a 404 error, when I "inspect" what's going wrong. Some of the HTML files in my project are fully static (stored along with 403.html, 404.html, 500.html & 503.html) and display

[web2py] Uncaught TypeError at web2py-bootstrap4.js

Hi everyone, I'm getting the following error in the browser console "Uncaught TypeError: Cannot set property 'ajax_fields' of undefined at web2py-bootstrap4.js:2 at web2py-bootstrap4.js:82" I have no clue what does this mean nor how to fix it. Any suggestion on what should I look at?

Re: [web2py] Re: Problem updating list stored in session

Hi everyone, I keep on looking for the problem in order to avoid disgusting surprises in the near future. Is there any size limitation in session storage object? Thanks in advance. Regards, Jon. On Wed, Feb 27, 2019 at 12:57 PM Jon Subscripted wrote: > Thanks Leonel, > Yes, as you c

Re: [web2py] Re: Problem updating list stored in session

Thanks Leonel, Yes, as you comment the assignation was correct. I managed to fix it but I do not know why yet. It must be something else, somewhere else in the controller code (that's my guess). I went for the following quick and dirty test and it started to work: 1) duplicate the variables

[web2py] Problem updating list stored in session

Hi everyone, I'm having some trouble updating session data. I have a controller/view that allows to perform a query that returns a bunch of db ids. As I will be using these ids and I used a complex query to retrieve them I store them in the session, with the statement below. Thus another

Re: [web2py] Re: Long text internationalization

Thanks Dave, For now I do not expect to go for pages long texts. But still I'll take a look at how web2py-book is implemented. Regards, Jon. On Wed, Feb 13, 2019 at 12:39 AM Dave S wrote: > > > On Tuesday, February 12, 2019 at 3:57:36 AM UTC-8, Jonsubs wrote: >> >> Hi everyone, >> Which is the

Re: [web2py] Re: Long text internationalization

Thanks Leonel!! I'll use your plugin then. Regards, Jon. On Tue, Feb 12, 2019 at 1:37 PM Leonel Câmara wrote: > Large texts are actually fine as long as they're kind of static. > > For dynamic long texts I store them in a JSON field where I have a dict > with a key for each language I want to

Re: [web2py] Accessing MySQL data without define tables

th=255), > Field('address_2', type='string', length=255), > Field('city', type='string', length=255), > Field('state', type='string', length=20), > Field('zip', type='string', length=10), > . > > > *Ben Duncan* > DBA / Chief Software Architect > Missi

[web2py] Long text internationalization

Hi everyone, Which is the common practice when facing long text internationalization? For instance, What should be done when you want to render a web page, sharing a common layout, that has several paragraphs that must be completelly translated? Based on the manual (

Re: [web2py] Accessing MySQL data without define tables

12, 2019 at 10:49 AM Jon Subscripted wrote: > Thanks Ben, > I did what you suggested and somehow I think I moved on. > > Still I got a weird error: InternalError: (1060, u"Duplicate column name > 'fen__tmp'") > > import sys > > sys.path.append(r'C:\Users\Jon\

Re: [web2py] Accessing MySQL data without define tables

line 109, in raise_mysql_exception raise errorclass(errno, errval) InternalError: (1060, u"Duplicate column name 'fen__tmp'") I'm not aware of defining the 'fen' field twice, so I do not understande where did this come from. What does this mean? Regards, Jon. On Mon, Feb 11, 2019

Re: [web2py] Accessing MySQL data without define tables

inside the python program itself. > > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > > > On Mon, Feb 11, 2019 at 9:01 AM Jon Subscripted < > jonsubscripti...@gmail.com> wrote: > >> Thanks Ben, &g

Re: [web2py] Re: Migrate from sqlite to mysql

Hi Andrea, Is this " problem about requirements " a notification that MySQL installation wizard showed? If it is, in my experience you can ignore it and move on with the installation. Python3.X is optional for MySQL, it just suggests to install it. Regards, Jon. On Sun, Feb 10, 2019 at 12:19 PM

Re: [web2py] Accessing MySQL data without define tables

ost names (glob syntax allowed) >> # auth = Auth(db, host_names=configuration.get('host.names')) >> # auth = Auth(db, secure=True) >> # >> - >> #auth = Auth(db,signature=False) >> crud = Crud(d

Re: [web2py] Accessing MySQL data without define tables

Hope this helps > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > > > On Fri, Feb 8, 2019 at 7:17 AM Jon Subscripted > wrote: > >> Hi everyone, >> I'm trying to access the data stored in my ap

[web2py] Accessing MySQL data without define tables

Hi everyone, I'm trying to access the data stored in my app db from a different piece of software (apart from my web2py app). But I get an error AttributeError. Based on the manual: http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Using-DAL-without-define-tables

Re: [web2py] Re: problem with cpdb.py "EXCEPTION: could not set DAL"

D7-40BB-A1B8-4E2AA1F9FDF2> On Thu, Feb 7, 2019 at 1:05 PM Jon Subscripted wrote: > Hi everyone, > Eventually I managed to move on, without cpdb.py. > > I had to do it as Massimo suggests in this thread "Best way to migrate > from sqlite to postgresql (or other db)": > >

Re: [web2py] Re: problem with cpdb.py "EXCEPTION: could not set DAL"

u"Table 'test2.auth_group' doesn't exist") <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> &

Re: [web2py] Re: problem with cpdb.py "EXCEPTION: could not set DAL"

y of the database Field auth_cas.id is already bound to a table Any suggestions? What does this mean? Thanks, Jon. PS. I'm just using sqlite to sqlite copy for now, for the sake of simplicity. On Mon, Feb 4, 2019 at 10:06 AM Jon Subscripted wrote: > Hi Dave, > Yes, if you refer to the Py

Re: [web2py] Re: problem with cpdb.py "EXCEPTION: could not set DAL"

Hi Dave, Yes, if you refer to the Python installed in the computer I'm using Python 2.7.5. C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py>python scripts/cpdb.py -f applications/paravolcar10enero_tarde/databases -y sqlite://storage.sqlite -Y sqlite://storage3.sqlite -d ../gluon No handlers

[web2py] problem with cpdb.py "EXCEPTION: could not set DAL"

Hi everyone, I'm trying to copy my database (already populated) using cbpd.py but I get an error. (I'm working in Windows 10 with Web2py 2.17.2-stable+timestamp.2018.10.06.18.54.02) 1st I changed the database URI in appconfig.ini from sqlite://storage.sqlite to sqlite://storage3.sqlite 2nd I

[web2py] Re: MySQL based Web2Py app

\pydal\base.py", line 440, in __init__ self._dbname = REGEX_DBNAME.match(uri).group() AttributeError: 'NoneType' object has no attribute 'group' What does this mean? Thanks in advance. Regards, Jon. On Wed, Jan 30, 2019 at 5:06 PM Jon Subscripted wrote: > Hi everyone, > Is th

Re: [web2py] Re: How to solve '\x00' error

Thanks! On Tue, Jan 15, 2019 at 12:36 PM Leonel Câmara wrote: > Jonsubs yes it could if for some reason web2py wasn't graciously stopped > which can happen depending on the OS and if web2py is taking too long to > shutdown. Again don't leave migrations enabled otherwise the pickle files > will

[web2py] MySQL based Web2Py app

Hi everyone, Is there a step by step guide on how to create a MySQL based Web2Py app? I've been doing fine with SQLite so far, but my db is getting bigger and I need to move on. I tried to do it myself but I must be missing something. I already created a db in MySQL and I'm trying to create an

Re: [web2py] Re: Generate query based on other db table content

Ups!! Yes, you're right. Thanks, Jon. On Fri, Jan 25, 2019 at 10:00 PM Anthony wrote: > #- query generator based on db >> def get_training_query(training_id): >> training = db.training[training_id] >> player_query = player[training.player] >> color_query = color[training.color]

[web2py] Generate query based on other db table content

Hi all, I having a weird problem. I'm clueless. I do not even know how to look it up in the manual. I'm trying to store in the database (training table) user defined configurations that will lead to specific queries (accessed through list_problems_by_training controller's default view). These

Re: [web2py] Re: How to solve '\x00' error

Hi Leonel, Could a PC reboot lead to the same problem Mostwanted reported? Regards, Jon. Libre de virus. www.avast.com

Re: [web2py] Re: Show "count()" result in view

Thanks guys. That's exactly what I needed. Sorry I was not able to fint it myself... Regards, Jon. On Sat, Dec 29, 2018 at 4:19 AM Anthony wrote: > See > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting > . > > On Friday, December 28, 2018 at

Re: [web2py] Re: Show "count()" result in view

Thanks Stifan, I see how can I do that for the whole query. How can I do this row-wise? Can I create a "count_db" variable per row? As I'm grouping by game and counting how many entries I have per game (after grouping them), I would like to show the count per row. The closest I got so far is by

[web2py] Show "count()" result in view

Hi all, I'd like to know how to access the ".count()" result of a query from a view. I have the following query in the controller: rows = db(db.probdata).select(db.probdata.game,db.probdata.game.count(),groupby=db.probdata.game) And would like to show both the 'game' field and the number of

Re: [web2py] Re: dependencies inside 'static' folder

Thanks for your response Anthony, I'll try what you suggest. On Sun, Jun 24, 2018 at 5:20 AM, Anthony wrote: > On Saturday, June 23, 2018 at 11:05:35 PM UTC-4, Jonsubs wrote: >> >> Hi everyone, >> I'm a web2py newbie and I'm trying to use a third party JS library >> (chessboard.js from