[web2py] Re: Asking support for MySQL create/alter column "AFTER" keyword

2018-01-23 Thread Alfonso Serra
This works only on newly created fields over MySQL. Moving fields around on your model wont reorder them. Version 2.15.3-stable+timestamp.2017.08.07.12.51.45 migrator.py line 364 field_position = sql_fields[key]['sortable'] after = "FIRST"

Re: [web2py] Tutorial on using chart library

2018-01-23 Thread Gualter Portella
Thanks, António! -- 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] Re: error: 'No module named sanitizer' after upgrading to 2.16.1

2018-01-23 Thread Ton Sjerps
Removing the statement altogether also works. I think the statement got there automatically by eclipse (or by means of an unintend use of a shortcut for doing that). I've seen more examples of this since using eclipse, be warned. Thanks for your help Op dinsdag 23 januari 2018 18:06:44 UTC+1

Re: [web2py] Re: Unable to create Auth tables

2018-01-23 Thread Jim Steil
That is to be expected because you didn't clear the database. It is trying to build the auth_user table, but it already exists. -Jim On Tue, Jan 23, 2018 at 11:43 AM, SR wrote: > I deleted the auth tables from the /databases folder in my MYSQL and tried > to rebuild

[web2py] Re: Unable to create Auth tables

2018-01-23 Thread SR
I deleted the auth tables from the /databases folder in my MYSQL and tried to rebuild it but getting this error: Ticket ID 10.51.133.94.2018-01-23.11-38-10.52ecfb9b-da14-4a88-a568-063c7b741936 (1050, "Table 'auth_user' already exists")Version web2py™ Version

[web2py] Re: error: 'No module named sanitizer' after upgrading to 2.16.1

2018-01-23 Thread Leonel Câmara
The problem here was that your controller is using: from sanitizer import sanitize When now you should use from gluon.sanitizer import sanitize -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Future of web2py

2018-01-23 Thread Gabor Nyul
Are there any news about the new version (web3py or what ever the name will be)? -- 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

[web2py] Re: Database administration error

2018-01-23 Thread Jim S
I'm assuming other migrations work just fine - is that correct? If that is the case then I'm thinking it is a problem with foreign keys. If not that, then I'm stumped. If it were me, I'd do the following: 1. Make a backup of the database 2. Delete the database 3. Recreate the database with

Re: [web2py] Tutorial on using chart library

2018-01-23 Thread António Ramos
Just a quick google search https://stackoverflow.com/questions/34326343/embedding-d3-js-graph-in-a-web2py-bootstrap-page https://github.com/greaneym/d3anim https://github.com/monotasker/plugin_d3 2018-01-23 14:39 GMT+00:00 Gualter Portella : > Hi everyone, > > I am looking

[web2py] Tutorial on using chart library

2018-01-23 Thread Gualter Portella
Hi everyone, I am looking for a tutorial in web2py that shows how to create dynamic graphs - fetching data from the database and passing them to the JS library through ajax or something similar. Does anyone know of any? Thanks. Gualter -- Resources: - http://web2py.com -

[web2py] Re: Database administration error

2018-01-23 Thread SR
I changed the signature =True in my "auth.define_tables" which created extra fields in the auth_user table and after that I am getting this error. Yes Web2py is installed in /opt directory. This is a production machine. On Monday, January 22, 2018 at 6:31:44 PM UTC-6, Jim S wrote: > > Seems like

[web2py] Re: Database administration error

2018-01-23 Thread SR
On Monday, January 22, 2018 at 5:49:30 PM UTC-6, SR wrote: > > 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 >