Re: [web2py] another python 3 minor bug in 2.18.2: b'Logged in'

[Kevin Keller]

Changing the logged in message to a custom one did not change the situation 
(see screenshot) nor did trying to fiddle some more with jquery.. I think I 
had a syntax error before.. 

flash.text( flash.text(message).replace('b', '') );

On Sunday, 3 March 2019 13:33:41 UTC+1, Kevin Keller wrote:
>
> Tried flash.text(message).replace('b', '');
> in static web2py.js without success.. 
> any other ideas?
>
> On Saturday, 2 March 2019 19:47:36 UTC+1, Kevin Keller wrote:
>>
>> Tried to fix it in gluon/html.py and gluon/tools.py but can't fix it
>>
>> Would appreciate some help. 
>>
>> It's minor but super annoying. 
>>
>> I also see a big T in front of table names when using app creation 
>> wizard. 
>>
>> Fixed it by renaming the table name labels manually. 
>>
>>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] another python 3 minor bug in 2.18.2: b'Logged in'

[Kevin Keller]

Tried flash.text(message).replace('b', '');
in static web2py.js without success.. 
any other ideas?

On Saturday, 2 March 2019 19:47:36 UTC+1, Kevin Keller wrote:
>
> Tried to fix it in gluon/html.py and gluon/tools.py but can't fix it
>
> Would appreciate some help. 
>
> It's minor but super annoying. 
>
> I also see a big T in front of table names when using app creation wizard. 
>
> Fixed it by renaming the table name labels manually. 
>
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Communication Error when Saving

[Kevin Keller]

I have teh same with the latest web2py from git, Python 3.7.1 on Windows 
10. 
Pressing save twice and merging finally saves..  as a workaround

On Sunday, 3 March 2019 08:57:03 UTC+1, Ricardo Antonio Zarco wrote:
>
> Hi,after upgrade to 2.18.2 i get the "Comunnicate error" when saving using 
> web browser/admin , the exception is:
>
> Versión
> web2py™ Version 2.18.2-stable+timestamp.2019.02.26.06.11.06
> Python Python 2.7.5: /usr/bin/uwsgi (prefix: /usr)Rastreo
>
> 1.
> 2.
> 3.
> 4.
> 5.
>
> Traceback (most recent call last):
>   File "/home/ec2-user/myapp/gluon/main.py", line 488, in wsgibase
> urllib_quote(xmlescape(response.flash).replace(b'\n', b''))
> NameError: global name 'urllib_quote' is not defined
>
> Error snapshot [image: help] 
> 
>
> (global name 'urllib_quote' is not defined)
>
>
>
> I think is a problem with de python 3 compatability what can i do? I need 
> to update my python version? Thanks
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Web2py version 2.18.2 Communications Error when in Admin.

[Kevin Keller]

The same here with python 3.7.1 on Windows10 latest Web2py from git from 
this morning. 
Pressing the save button twice brings up the merge dialogue, which does the 
trick for me for now.. 

On Tuesday, 26 February 2019 19:25:32 UTC+1, John McMaster wrote:
>
> Just installed web2py version 2.18.2 and now I get a communications error 
> when I save changes in an app.
>
> I get nothing in the error logs. 
>
> The apps run but when I go to edit them and click the save button at the 
> top of the lefthand page I  get a red communications error in the field to 
> the right of "Last saved on:"  <<< here that looks like this:
> Save file: [save disk icon] Saved file hash:  Last saved on:  toggle 
> breakpoint
>
>
> I have restarted the uwsgi and checked the logs only to see that all has 
> run cleanly.  I was getting a message that "probable another instance of 
> uWSGI is running on the same address (127.0.0.1:9) where 9 is the 
> port number assigned.
> I killed all instances and restarted the uWSGI and all is clean.
>
> However I still get an comunications error.
>
> Any ideas as to where to look for issues / configuration problems?
>
> Thank you 
>
>
>
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] another python 3 minor bug in 2.18.2: b'Logged in'

[Kevin Keller]

Tried to fix it in gluon/html.py and gluon/tools.py but can't fix it

Would appreciate some help. 

It's minor but super annoying. 

I also see a big T in front of table names when using app creation wizard. 

Fixed it by renaming the table name labels manually. 

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Issue with db.export_to_csv_file and Python 3.7

[Kevin Keller]

Could you make sure that your solutiona are reflected in the github tickets for 
export and import problems please?

Sure that would make it easier for Massimo to fix and merge the fixes for 2.18.3

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Error importing csv file in python3.6

[Kevin Keller]

There an issue filed on github already? 

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: dict values error in python 3.6

[Kevin Keller]

Can someone file an issue on github and also attach the solution please? Thanks 

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: dict values error in python 3.6

[Kevin Keller]

Ok, could you file an issue on github for. This please?



On Thu, 28 Feb 2019, 12:06 Lovedie JC,  wrote:

> Ok on p2.
> But I'm shifting to p3. 6
>
> On Thu, 28 Feb 2019, 13:54 Kevin Keller  wrote:
>
>> Seems a python3 vs python2 related error?
>>
>>
>> https://stackoverflow.com/questions/17431638/get-typeerror-dict-values-object-does-not-support-indexing-when-using-python
>>
>> Can you try to run your app with python2 for testing please ?
>>
>> On Thursday, 28 February 2019 05:36:04 UTC+1, Maurice Waka wrote:
>>>
>>> Hallo,
>>> While creating a db,
>>> def create():
>>> form = SQLFORM(db.food_data,submit_button=T('Submit'))
>>> form.element('input[value=Submit]')['_style']='background-color:
>>> #DA2128; color:#ff'
>>> if form.process().accepted:
>>>  response.flash="form accepted"
>>>  redirect(URL('default', 'searching'))
>>> return dict(form=form)
>>>
>>>
>>>
>>> Trying to enter data, I got this error:
>>>
>>> Traceback (most recent call last):
>>>  File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in 
>>> restricted
>>>  exec(ccode, environment)
>>>  File "/home/mauricewaka/web2py/applications/HWell/views/generic.html" 
>>> <http://127.0.0.1:8000/admin/default/edit/Hestque_Wellness/views/generic.html>,
>>>  line 81, in 
>>> TypeError: 'dict_values' object does not support i
>>>
>>> ndexing
>>>
>>> --
>> 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-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> 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-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: dict values error in python 3.6

[Kevin Keller]

Seems a python3 vs python2 related error?

https://stackoverflow.com/questions/17431638/get-typeerror-dict-values-object-does-not-support-indexing-when-using-python

Can you try to run your app with python2 for testing please ?

On Thursday, 28 February 2019 05:36:04 UTC+1, Maurice Waka wrote:
>
> Hallo,
> While creating a db, 
> def create():
> form = SQLFORM(db.food_data,submit_button=T('Submit'))
> form.element('input[value=Submit]')['_style']='background-color: 
> #DA2128; color:#ff'
> if form.process().accepted:
>  response.flash="form accepted"
>  redirect(URL('default', 'searching'))
> return dict(form=form)
>
>
>
> Trying to enter data, I got this error:
>
> Traceback (most recent call last):
>  File "/home/mauricewaka/web2py/gluon/restricted.py", line 219, in restricted
>  exec(ccode, environment)
>  File "/home/mauricewaka/web2py/applications/HWell/views/generic.html" 
> ,
>  line 81, in 
> TypeError: 'dict_values' object does not support i
>
> ndexing
>
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] another python 3 minor bug in 2.18.2: b'Logged in'

[Kevin Keller]

Could you open a ticket on github please with some supporting info.



On Wed, 27 Feb 2019, 12:32 黄祥,  wrote:

> similar issues happen during :
> - clear session, cache from web2py admin
> - remove app from web2py admin
>
> best regards,
> stifan
>
> --
> 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-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: 2.18.1 is OUT

[Kevin Keller]

Can you file an issue on github please?

On Wed, 27 Feb 2019, 09:26 黄祥,  wrote:

> Traceback (most recent call last):
>>   File "/Users/sugizo/project/python/web2py/gluon/restricted.py", line
>> 219, in restricted
>> exec(ccode, environment)
>>   File
>> "/Users/sugizo/project/python/web2py/applications/test/models/db_schema_0_auth.py",
>> line 9, in 
>> custom_auth_table = db[auth.settings.table_user_name]
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/base.py",
>> line 666, in __getitem__
>> return self.__getattr__(str(key))
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/base.py",
>> line 672, in __getattr__
>> return self.lazy_define_table(tablename, *fields, **kwargs)
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/base.py",
>> line 624, in lazy_define_table
>> polymodel=polymodel)
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/adapters/base.py",
>> line 798, in create_table
>> return self.migrator.create_table(*args, **kwargs)
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/migrator.py",
>> line 279, in create_table
>> query), table)
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/migrator.py",
>> line 488, in log
>> logfile.write(to_bytes(message))
>>   File
>> "/Users/sugizo/project/python/web2py/gluon/packages/dal/pydal/helpers/classes.py",
>> line 544, in write
>> self.data += data
>> TypeError: can only concatenate str (not "bytes") to str
>>
>
> found the culprit :
> *models/db.py*
> adapter_args = dict(migrator = InDBMigrator)
>
> when comment it out the traceback error disappear not sure if migrator =
> InDBMigrator broken in new version
> everything start from scratch (default welcome boostrap)
>
> best regards,
> stifan
>
> --
> 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-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] another python 3 minor bug in 2.18.2: b'Logged in'

[Kevin Keller]

Can you file an issue on github please?

On Tue, 26 Feb 2019, 20:36 Yi Liu,  wrote:

> b'Logged In' in flash message:
>
> [image: Screen Shot 2019-02-26 at 12.33.29.png]
> This is in auth, not something in my app, right?
>
> --
> 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-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Custom Delimiters Broken in 2.18.1?

[Kevin Keller]

Saw a 2.18.2 commit.
Was that addressed in thst commit?

Thanks!



On Mon, 25 Feb 2019, 06:08 Massimo Di Pierro, 
wrote:

> Damn you are right. I am releasing 2.18.2 with a fix.
>
> On Sunday, 24 February 2019 18:31:27 UTC-8, Limedrop wrote:
>>
>>
>> Hi there,
>>
>> I think the custom template delimiters are broken in 2.18.1.  Here's my
>> test code and the exception I'm getting:
>>
>>
>> CONTROLLER
>> def index():
>> response.delimiters = ('')
>> return dict(message=T('Welcome!'))
>>
>> VIEW - index.html
>> {{extend 'layout.html'}}
>>  Note that each column needs at least {{minCards}}
>> cards.
>>
>> EXCEPTION
>> File "\web2py2.18.1\web2py\gluon\restricted.py", line 230, in restricted
>> sys.excepthook(etype, evalue, tb) File
>> "c:\Users\Playtech\Documents\Development\web2py2.18.1\web2py\applications\app\views\default\index.html",
>> line 2, in 
>> NameError: name 'minCards' is not defined
>>
>>
>> Or have I done something wrong?
>>
>> Thanks
>>
>> --
> 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-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web2py with python3: difference in error reporting

[Kevin Keller]

I'm wondering if Massimo is tuu busy in his new job. I'd love to help, but this 
seem like a probleme rooted deeply in the core of web2py. Is there anyone that 
knows web2py as well as Massimo to have a look? I'm happy to help with testing. 
Just assuming things here btw. 

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Python 3 - Traceback problems

[Kevin Keller]

Is there any update to this?

On Friday, 1 February 2019 17:21:40 UTC+1, Brian M wrote:
>
> So I'm trying to finally move my web2py apps over to Python 3.7 before 
> Python 2.7 reaches EOL and, while for the most part they're working fine, I 
> am finding that when there is a problem the web2py Error ticket is just 
> about useless (doesn't tell you where the error actually occurs) because 
> web2py seems to be throwing its own exception while trying to handle the 
> actual exception resulting in tracebacks that look like this:
>
> Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
>
> Traceback (most recent call last):
>   File "C:\FMSC_py3\web2py\gluon\restricted.py", line 220, in restricted
> exec(ccode, environment)
> pyodbc.DataError: ('22003', '[22003] [Microsoft][SQL Server Native Client 
> 11.0][SQL Server]Arithmetic overflow error converting expression to data type 
> int. (8115) (SQLExecDirectW)')
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "C:\FMSC_py3\web2py\gluon\restricted.py", line 141, in __init__
> self.traceback = traceback.format_exc()
> AttributeError: 'NoneType' object has no attribute 'strip'
>
>
> I'm using Python 3.7.2 on Win7 with a freshly downloaded copy of the 
> web2py source and can reproduce this very easily within the included 
> Welcome App by adding this to the default.py controller
>
> def causeError():
> deliberate_error= 1/0
> return dict(deliberate_error=deliberate_error)
>
> Which results in the below ticket. Which, while it does say the correct 
> "division by zero" error, doesn't contain anything else useful in the 
> traceback to actually say where in the code the error happens.
>
> Error ticket for "welcome"Ticket ID
>
> 127.0.0.1.2019-02-01.10-10-20.33b63e41-eac2-4737-a257-37232cf4fb72
>  division by zeroVersion
> web2py™ Version 2.17.2-stable+timestamp.2018.10.06.18.54.02Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
>
> Traceback (most recent call last):
>   File "C:\FMSC_py3\web2py\gluon\restricted.py", line 220, in restricted
> except HTTP:
> ZeroDivisionError: division by zero
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "C:\FMSC_py3\web2py\gluon\restricted.py", line 141, in __init__
> self.traceback = traceback.format_exc()
> AttributeError: 'NoneType' object has no attribute 'strip'
>
> In file: C:\FMSC_py3\web2py\applications\welcome\controllers/default.py
>
> 1.
>
>  at 0x03F546A8, file 
> "C:\FMSC_py3\web2py\applications\welcome\controllers/default.py", line 8>
>
>
>
> This issue is making it very difficult to actually use web2py with Python 
> 3 because when you inevitably make coding mistakes you cannot easily find 
> them unlike under Python 2 where the web2py ticket's traceback tells you 
> exactly where the issue is.
>
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Python 3 - Traceback problems

[Kevin Keller]

I also wonder if someone is looking into this

On Friday, 15 February 2019 02:10:09 UTC+1, Brian M wrote:
>
> Am I really the only one having this problem? Having the error ticket 
> system not work seems like a pretty significant obstacle to using web2py 
> with python 3.7

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Mysql 8.0.15

[Kevin Keller]

Is the Web2py Mysql driver recent enough for Mysql 8? 
Try Mysql 7 or update the driver manually maybe?

On Thursday, 14 February 2019 20:09:22 UTC+1, Andrea Fae' wrote:
>
> Hello, I'm sorry but I'm not able to use web2py with this type of db.
>
> I just installed mysql version 8.0.15 on windows 10 pro and I have 
> connector for Python 3.7 and 2.7 installed 
> I created using mysql.exe a db named 'gadb', without any tables.
>
> with web2py I created a new "welcome" application changing db.py in this 
> way (not using appconfig.ini)
>
> i changed only this:
> db = DAL('mysql://root:rootpassword@localhost/gadb',pool_size=20)
> 
> commenting this
> """db = DAL(configuration.get('db.uri'),
>  pool_size=configuration.get('db.pool_size'),
>  migrate_enabled=configuration.get('db.migrate'),
>  check_reserved=['all'])"""
>
> but when I try to start the application I have this error:
>
> Error ticket for "testmysql"Ticket ID
>
> 127.0.0.1.2019-02-14.20-04-44.4a997a45-2232-4144-ab7e-6005309040bb
>  Failure to connect, tried 5 times: 
> Traceback (most recent call last): File 
> "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init__ 
> self._adapter = adapter(**kwargs) File 
> "C:\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 40, in 
> __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File 
> "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 368, in 
> __init__ super(SQLAdapter, self).__init__(*args, **kwargs) File 
> "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 52, in __init__ 
> self.reconnect() File "C:\web2py\gluon\packages\dal\pydal\connection.py", 
> line 172, in reconnect self.connection = self.connector() File 
> "C:\web2py\gluon\packages\dal\pydal\adapters\mysql.py", line 52, in 
> connector return self.driver.connect(**self.driver_args) File 
> "C:\web2py\gluon\contrib\pymysql\__init__.py", line 90, in Connect return 
> Connection(*args, **kwargs) File 
> "C:\web2py\gluon\contrib\pymysql\connections.py", line 688, in __init__ 
> self.connect() File "C:\web2py\gluon\contrib\pymysql\connections.py", line 
> 905, in connect self._get_server_information() File 
> "C:\web2py\gluon\contrib\pymysql\connections.py", line 1231, in 
> _get_server_information self.server_charset = charset_by_id(lang).name File 
> "C:\web2py\gluon\contrib\pymysql\charset.py", line 38, in by_id return 
> self._by_id[id] KeyError: 255Versione
> web2py™ Version 2.16.1-stable+timestamp.2017.11.14.05.54.25Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
> 15.
> 16.
> 17.
> 18.
> 19.
> 20.
> 21.
> 22.
> 23.
> 24.
> 25.
> 26.
> 27.
> 28.
> 29.
> 30.
> 31.
> 32.
> 33.
> 34.
> 35.
> 36.
>
> Traceback (most recent call last):
>   File "C:\web2py\gluon\restricted.py", line 219, in restricted
> exec(ccode, environment)
>   File "C:/web2py/applications/testmysql/models/db.py" 
> , line 33, 
> in 
> db = DAL('mysql://root:AeDeFsubfi3!@localhost/gadb',pool_size=20)
>   File "C:\web2py\gluon\packages\dal\pydal\base.py", line 169, in __call__
> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>   File "C:\web2py\gluon\packages\dal\pydal\base.py", line 474, in __init__
> "Failure to connect, tried %d times:\n%s" % (attempts, tb)
> RuntimeError: Failure to connect, tried 5 times:
> Traceback (most recent call last):
>   File "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init__
> self._adapter = adapter(**kwargs)
>   File "C:\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 40, in 
> __call__
> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>   File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 368, in 
> __init__
> super(SQLAdapter, self).__init__(*args, **kwargs)
>   File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 52, in 
> __init__
> self.reconnect()
>   File "C:\web2py\gluon\packages\dal\pydal\connection.py", line 172, in 
> reconnect
> self.connection = self.connector()
>   File "C:\web2py\gluon\packages\dal\pydal\adapters\mysql.py", line 52, in 
> connector
> return self.driver.connect(**self.driver_args)
>   File "C:\web2py\gluon\contrib\pymysql\__init__.py", line 90, in Connect
> return Connection(*args, **kwargs)
>   File "C:\web2py\gluon\contrib\pymysql\connections.py", line 688, in __init__
> self.connect()
>   File "C:\web2py\gluon\contrib\pymysql\connections.py", line 905, in connect
> self._get_server_information()
>   File "C:\web2py\gluon\contrib\pymysql\connections.py", line 1231, in 
> _get_server_information
> self.server_charset = charset_by_id(lang).name
>   File "C:\web2py\gluon\contrib\pymysql\charset.py", line 38, in by_id
> return self._by_id[id]
> KeyError: 255
>
> In file: C:\web2py\applications\testmysql\models\db.py
>
> 1.
>
>  at 126057B0, file 
>