[web2py] Re: Update web2py manually

[Константин Комков]

Dave, did you saw my project above? Is it return message or full welcome 
page on your computer? I saw iis logs and didn't find any helpful 
information. I use reutes.py in web2py folder and it contain that:

> routers = dict(
> # base router
> BASE=dict(
> default_function = 'index',
> default_language = 'ru',
> domains={
> 'oas.timacad.ru':'oas',
> 'www.oas.timacad.ru':'oas',
> }
> ),
> )

I have routes.example.py also and it contain

> from fileutils import abspath
> from languages import read_possible_languages
> possible_languages = read_possible_languages(abspath('applications', app))
> #NOTE! app - is an application based router's parameter with name of an
> #application. E.g.'welcome'
> routers = {
> app: dict(
> default_language = possible_languages['default'][0],
> languages = [lang for lang in possible_languages
>if lang != 'default']
> )
> } 

 I included logging in web2py in progress.log that:

> [2019-02-15 10:20:30] START
>
> [2019-02-15 10:20:30] EDIT ererer/models/db.py: 3
>
> But agax return welcome page and I don't see it here.
I have reinstalled python, fdb driver, url rewrite, wfastcgi and error 
remained. Maybe something wrong in project, but it correct work on 2 my 
computers and don't work on server. 

-- 
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] Python 3 - Traceback problems

[Brian M]

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.

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

[黄祥]

on the stackoverflow ben's sent seems like problem with mysql ver 8 running 
on windows
perhaps you can use docker to run mysql or mariadb or percona container 
(which running on top of linux os)

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.

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

[Dave S]

On Thursday, February 14, 2019 at 7:29:07 AM UTC-8, Andrea Fae' wrote:
>
> Yes
>
> Il giorno gio 14 feb 2019, 16:12 Ben Duncan  > ha scritto:
>
>> Ok, is the python AND the mysql on the same windows BOX ?
>> If not, could be a firewall issue.
>> [...] 
>>
> On Thu, Feb 14, 2019 at 7:48 AM andfae > 
>> wrote:
>>
>>> How to test via command prompt the connection between python and mysql?
>>>
>>>
can you do 
web2py.exe -S myapp -M


 If that fails to open a python shell, try adding -D 0 to that command line.

/dps

-- 
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: Update web2py manually

[Dave S]

On Thursday, February 14, 2019 at 12:34:29 AM UTC-8, Константин Комков 
wrote:
>
> I have updated web2py alredy but that error remained. I can not start new 
> project 2 week.
>


I think it would help for you to post part of your IIS logs showing the 
page load and the AJAX request (sanitize IPs, etc, of course).  You can 
also turn on logging in web2py, and include that logging information.  You 
probably want to put some logging into the controllers for your app.

Also, are you using routes.py or any other URL re-writing?

/dps
 

-- 
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: Center things in MARKMIN

[Val K]

Yes, just pass it:  
auth.wiki(extra = dict(centred = lambda text: DIV(text, _style = 
'text-align:center;')))

but it seems, that page should be edited/updated to get effect 


On Friday, February 15, 2019 at 12:03:28 AM UTC+3, rif wrote:
>
> Can I do this with auth.wiki?
>
> În joi, 14 feb. 2019, 22:58 Val K  a 
> scris:
>
>> # you can extend MARKMIN using ``...``: 
>>
>> MARKMIN("blah blah  *``*Title``:centred blah blah",  extra = dict(centred 
>> = lambda text: DIV(text, _style = 'text-align:center;')))
>>
>>
>> On Thursday, February 14, 2019 at 3:47:22 PM UTC+3, rif wrote:
>>>
>>> hey guys,
>>>
>>> I am using auth.wiki and I would like to center things (e.g. titles, 
>>> images) horizontaly on the page. 
>>> I didn't find any documentation on this, does anybody have any hints for 
>>> me?
>>>
>>> thanks,
>>> -rif
>>>
>> -- 
>> 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 a topic in the 
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/web2py/KZ4YjTlzzRM/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> web2py+un...@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: Center things in MARKMIN

[Radu Ioan Fericean]

Can I do this with auth.wiki?

În joi, 14 feb. 2019, 22:58 Val K  # you can extend MARKMIN using ``...``:
>
> MARKMIN("blah blah  *``*Title``:centred blah blah",  extra = dict(centred
> = lambda text: DIV(text, _style = 'text-align:center;')))
>
>
> On Thursday, February 14, 2019 at 3:47:22 PM UTC+3, rif wrote:
>>
>> hey guys,
>>
>> I am using auth.wiki and I would like to center things (e.g. titles,
>> images) horizontaly on the page.
>> I didn't find any documentation on this, does anybody have any hints for
>> me?
>>
>> thanks,
>> -rif
>>
> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/KZ4YjTlzzRM/unsubscribe.
> To unsubscribe from this group and all its topics, 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: Center things in MARKMIN

[Val K]

# you can extend MARKMIN using ``...``: 

MARKMIN("blah blah  *``*Title``:centred blah blah",  extra = dict(centred = 
lambda text: DIV(text, _style = 'text-align:center;')))


On Thursday, February 14, 2019 at 3:47:22 PM UTC+3, rif wrote:
>
> hey guys,
>
> I am using auth.wiki and I would like to center things (e.g. titles, 
> images) horizontaly on the page. 
> I didn't find any documentation on this, does anybody have any hints for 
> me?
>
> thanks,
> -rif
>

-- 
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: Weird behavior in sqlform / forms ...

[Ben Duncan]

Ok, will give it a shot tomorrow.
Yeah, I like to do things the long way. But I'm kinda restricted to getting
this accounting app to match (look and feel)
of a late 1990's PERL based application (Federal PACER system based ...)

It's what all the attorneys and court clerks are used to using in our state
...

*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Thu, Feb 14, 2019 at 2:29 PM Val K  wrote:

> It seems you  like handmade things;)
> I  don't see the closing tag -  
> Try to remove your handmade hidden field and place
> {{ =form.hidden_fields() }}
>
> and  it should be
> return dict(form=in_form)
> in the controller
>
>
>
>
> On Thursday, February 14, 2019 at 9:59:41 PM UTC+3, Ben Duncan wrote:
>>
>> Sure:
>>
>> But, it seems something is strange with firefox, closing the web browser
>> down and then opening it back up again, and it works the way it should...
>>
>> Gess .. Is it always this weird / hard in the world of web
>> programming ?
>>
>>
>> 
>> {{extend 'deflayout.html'}}
>> {{include 'mectopline.html'}}
>>
>> >action="{{=URL()}}"
>>method="post"
>>autocomplete="off"
>> >
>> 
>> Input form
>>
>>   
>>   Enter your User ID
>>   
>>   
>>
>> 
>>   
>>   Password
>>   
>>   
>> 
>>
>> 
>>   
>>   Remember Me
>>   
>> 
>>
>> 
>>   
>>   
>>   >   style='padding-left: 10px ; padding-right:10px'>
>>   
>> 
>>
>>
>>
>> Submitted variables
>> {{=BEAUTIFY(request.vars)}}
>>
>> 
>>
>> I am moving around here ...
>> 
>> Stuff a line ...
>> 
>> More sir stuff a lot ...
>> 
>> Eat MORE CHEESE AT MOE's
>> 
>>   
>> ~
>>  END
>> OF VIEW
>> ---
>> *Ben Duncan*
>> DBA / Chief Software Architect
>> Mississippi State Supreme Court
>> Electronic Filing Division
>>
>>
>> On Thu, Feb 14, 2019 at 12:52 PM Leonel Câmara 
>> wrote:
>>
>>> Can I see the rest of the view? It seems you're missing the form hidden
>>> fields which have the token.
>>>
>>> --
>>> 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+un...@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.

Re: [web2py] Re: Weird behavior in sqlform / forms ...

[Val K]

It seems you  like handmade things;)
I  don't see the closing tag -  
Try to remove your handmade hidden field and place 
{{ =form.hidden_fields() }}

and  it should be 
return dict(form=in_form)
in the controller




On Thursday, February 14, 2019 at 9:59:41 PM UTC+3, Ben Duncan wrote:
>
> Sure:
>
> But, it seems something is strange with firefox, closing the web browser 
> down and then opening it back up again, and it works the way it should...
>
> Gess .. Is it always this weird / hard in the world of web programming 
> ?
>
>
> 
> {{extend 'deflayout.html'}}
> {{include 'mectopline.html'}}
>
> action="{{=URL()}}"
>method="post"
>autocomplete="off"
> >
> 
> Input form
>
>   
>   Enter your User ID
>   
>   
>
> 
>   
>   Password
>   
>   
> 
>
> 
>   
>   Remember Me
>   
> 
>
> 
>   
>   
>  style='padding-left: 10px ; padding-right:10px'>
>   
> 
>
>
>
> Submitted variables
> {{=BEAUTIFY(request.vars)}}
>
> 
>
> I am moving around here ...
> 
> Stuff a line ...
> 
> More sir stuff a lot ...
> 
> Eat MORE CHEESE AT MOE's
> 
>   
> ~
>  END 
> OF VIEW   
> ---
> *Ben Duncan*
> DBA / Chief Software Architect 
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Thu, Feb 14, 2019 at 12:52 PM Leonel Câmara  > wrote:
>
>> Can I see the rest of the view? It seems you're missing the form hidden 
>> fields which have the token.
>>
>> -- 
>> 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+un...@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] Mysql 8.0.15

[Ben Duncan]

Related possibly:

https://stackoverflow.com/questions/45368336/error-keyerror-255-when-executing-pymysql-connect


*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Thu, Feb 14, 2019 at 1:09 PM 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

[web2py] Mysql 8.0.15

[Andrea Fae']

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 
"C:\web2py\applications\testmysql\models\db.py", line 7


What is my mistake? Thank in advance for who will answer me. Maybe this mysql 
is not compatible with web2py 2.16? How can I test if web2py is able to connect 
to mysql? After this problem I have to migrate a sqlite application to mysql: 
this is my goal. Thank you

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.

Re: [web2py] Re: Weird behavior in sqlform / forms ...

[Ben Duncan]

Sure:

But, it seems something is strange with firefox, closing the web browser
down and then opening it back up again, and it works the way it should...

Gess .. Is it always this weird / hard in the world of web programming ?


{{extend 'deflayout.html'}}
{{include 'mectopline.html'}}



Input form

  
  Enter your User ID
  
  


  
  Password
  
  



  
  Remember Me
  



  
  
  
  




Submitted variables
{{=BEAUTIFY(request.vars)}}



I am moving around here ...

Stuff a line ...

More sir stuff a lot ...

Eat MORE CHEESE AT MOE's

  
~
 END OF
VIEW
---
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Thu, Feb 14, 2019 at 12:52 PM Leonel Câmara 
wrote:

> Can I see the rest of the view? It seems you're missing the form hidden
> fields which have the token.
>
> --
> 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: Weird behavior in sqlform / forms ...

[Leonel Câmara]

Can I see the rest of the view? It seems you're missing the form hidden 
fields which have the token.

-- 
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: error connecting to mysql

[Andrea Fae']

PLEASE HELP ME THANK YOU

Il giorno mercoledì 13 febbraio 2019 21:46:19 UTC+1, Andrea Fae' ha scritto:
>
> Hello. I have this error when I start application "ga"
>
> Error ticket for "ga"
> Ticket ID
>
> 127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa4-42c2-b1a9-ab14a466e72e
>  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/ga/models/db.py" 
> , line 34, in 
> 
> check_reserved=['all'])
>   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\ga\models\db.py
>
> 1.
>
>  at 0AC93830, file 
> "C:\web2py\applications\ga\models\db.py", line 8
>
>
>
> This is my appconfig.ini:
>
> ; App configuration
> [app]
> name= Welcome
> author  = Your Name 
> description = a cool new app
> keywords= web2py, python, framework
> generator   = Web2py Web Framework
>
> ; Host configuration
> [host]
> names = localhost:*, 127.0.0.1:*, *:*, *
>
> ; db configuration
> [db]
> uri   = mysql://root:passwordroot@localhost/gadb?set_encoding=utf8mb4
> migrate   = true
> pool_size = 10 ; ignored for sqlite
>
> ; smtp address and credentials
> [smtp]
> server = smtp.gmail.com:587
> sender = y...@gmail.com
> login  = username:password
> tls= true
> ssl= true
>
> ; form styling
> [forms]
> formstyle = bootstrap3_inline
> separator =
>
> I just created the db "gadb" in mysql.exe. You can see the db, but I only 
> created the db with the command
>
> my

Re: [web2py] Re: Weird behavior in sqlform / forms ...

[Ben Duncan]

Yes, in the view:

  
  
  
  


Let me check my config for the CSRF token ...

*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Thu, Feb 14, 2019 at 12:12 PM Leonel Câmara 
wrote:

> How are you submitting this form? It doesn't seem to be using POST, it
> seems you're just requesting a new page with the form using GET. In case
> that's not what's happening the other possible cause is that you have a
> session.forget somewhere or something is wrong with your cookies and the
> form thinks you don't have a valid CSRF token.
>
> --
> 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: Weird behavior in sqlform / forms ...

[Leonel Câmara]

How are you submitting this form? It doesn't seem to be using POST, it 
seems you're just requesting a new page with the form using GET. In case 
that's not what's happening the other possible cause is that you have a 
session.forget somewhere or something is wrong with your cookies and the 
form thinks you don't have a valid CSRF token.

-- 
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] Weird behavior in sqlform / forms ...

[Ben Duncan]

I'm never EVER getting either a n_form.process().accepted  nor a
in_form.errors hit in the controller

 The following python default code tested with BOTH SQLFROM.factory AND the
FORM

>From controller default.py: (Version with FORM)

def login():
print "Doing the LOGIN form ...\n"

in_form = FORM('login',
   INPUT(_name='userid' ),
   INPUT(_name='password') ,
   INPUT(_name='rememberlogin' ),
   INPUT(_type='submit'))
#in_form = SQLFORM.factory(
#Field('userid' , requires=IS_NOT_EMPTY()),
#Field('password' ),
#Field('rememberlogin' ),
#formstyle='divs',
#submit_button=' Submit ',
#table_name='login'
#)
#in_form[0][-1][1][0]['_class']='button'

print "Doing the process form testing ...\n"
if in_form.process().accepted :
print "Doing the LOGIN Accepts...\n"
response.flash = 'form accepted'
elif in_form.errors :
print "Doing the LOGIN error...\n"
response.flash = 'form has errors'

return dict()
#return dict(form=in_form)
--
And in the view (login.html) I have tried:

OR the SQLFORM value {{=from}} or EVEN nothing (both input type and =form
removed)

I Always NEVER EVER get the in_form.process().accepted : nor the
in_form.errors
hit.

Here is the Following logs from the print statements:

Thu Feb 14 11:34:59.578023 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51763] Starting the DEFAULT Python Stuff ...
[Thu Feb 14 11:34:59.579647 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51763] Doing the LOGIN form ...
[Thu Feb 14 11:34:59.579706 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51763]
[Thu Feb 14 11:34:59.579903 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51763] Doing the process form testing ...
[Thu Feb 14 11:34:59.579942 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51763]
[Thu Feb 14 11:36:19.560354 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51774] Starting the DEFAULT Python Stuff ...
[Thu Feb 14 11:36:19.562100 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51774] Doing the LOGIN form ...
[Thu Feb 14 11:36:19.562156 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51774]
[Thu Feb 14 11:36:19.562404 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51774] Doing the process form testing ...
[Thu Feb 14 11:36:19.562444 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51774]
[Thu Feb 14 11:36:25.923173 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51788] Starting the DEFAULT Python Stuff ...
[Thu Feb 14 11:36:25.924805 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51788] Doing the LOGIN form ...
[Thu Feb 14 11:36:25.924862 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51788]
[Thu Feb 14 11:36:25.925040 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51788] Doing the process form testing ...
[Thu Feb 14 11:36:25.925073 2019] [wsgi:error] [pid 29474] [remote
10.13.69.144:51788]

Ok, What could I be doing wrong, or am I missing something critical here ?

Thanks ..


*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division

-- 
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] Run JAVA script in controller.

[Marco Mansilla]

Have you tried

   response.js = ""

Should help.

El jue., 14 de feb. de 2019 12:14, Ben Duncan  escribió:

> Is it possible to fire off a java script in the controller .py file?
>
> i.e.:
> if in_form.process(session=None, formname='login').accepted:
> response.flash = 'form accepted'
>
>[ << JAVASCRIPT FIRES OFF HERE>>]
>
> elif in_form.errors:
> response.flash = 'form has errors'
> else:
> response.flash = 'please fill the form'
>
> Thanks ...
>
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
> --
> 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: Migrate from sqlite to mysql

[andfae]

Yes

Il giorno gio 14 feb 2019, 16:12 Ben Duncan  ha scritto:

> Ok, is the python AND the mysql on the same windows BOX ?
> If not, could be a firewall issue.
>
> For the record, my python stand alone are truly stand alone (But I run
> LINUX , no Windowns here).
> So all my script are not thru the web2py but use the pydal library ...
>
>
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Thu, Feb 14, 2019 at 7:48 AM andfae  wrote:
>
>> How to test via command prompt the connection between python and mysql?
>>
>> Il giorno gio 14 feb 2019 alle ore 14:47 andfae  ha
>> scritto:
>>
>>> Yes I tried this usi too  uri = mysql://root:passwordroot@localhost/gadb
>>> I don't know what is the problem...
>>> Thank you
>>>
>>> Il giorno gio 14 feb 2019 alle ore 00:48 黄祥 <
>>> steve.van.chris...@gmail.com> ha scritto:
>>>
 RuntimeError: Failure to connect, tried 5 times:

 seems have a connection problem between python and mysql
 perhaps you can test the connection first (via command prompt)

 or perhaps an uri definition is wrong, had you try:
 *private/appconfig.ini*
 uri = mysql://root:passwordroot@localhost/gadb
 ?

 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 a topic in the
 Google Groups "web2py-users" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe.
 To unsubscribe from this group and all its topics, 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe.
> To unsubscribe from this group and all its topics, 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: Splitting form

[Ben Duncan]

Ok, I've gotten web2py working with the way I want.

Part of the problem is is needed to have:



then in the .html a formname assigned in the controller.

Everything is now shiny again 

*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Tue, Feb 12, 2019 at 5:20 PM Ben Duncan  wrote:

> Ok, got it thanks ...
>
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Tue, Feb 12, 2019 at 4:23 PM Dave S  wrote:
>
>>
>>
>> On Tuesday, February 12, 2019 at 1:40:25 PM UTC-8, Dave S wrote:
>>>
>>> On Tuesday, February 12, 2019 at 5:19:54 AM UTC-8, Ben Duncan wrote:

 Excuse my ignorance (Being a NEWBIE is irritating to me after having
 done CS stuff for 30+ years)
 But, Dave, exactly whats is turning on left-colum / right column
 support ?

 Thanks ..


>>> The correct term is "sidebar", but it behaves like columns (magazine
>>> style, rather than newspaper style, I'd say), so I ask for your indulgence.
>>>
>>> In 2.17.1, the welcome app no longer has this present-but-disabled, but
>>> you can look at the examples app.  layout.html has conditionals for
>>> left_sidebar_enabled and right_sidebar_enabled, and several views in
>>> the default subdir have {{ block sidebar}} {{end}} (take a look at
>>> what.html, for instance).
>>>
>>>
>> In one of my apps, but not one I can reach from this location, I use the
>> left sidebar to  show a list of links, which is a common style, but my
>> sidebar isn't set off with a different background like them thar fancy
>> sites.
>>
>> /dps
>>
>> --
>> 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] Run JAVA script in controller.

[Ben Duncan]

Is it possible to fire off a java script in the controller .py file?

i.e.:
if in_form.process(session=None, formname='login').accepted:
response.flash = 'form accepted'

   [ << JAVASCRIPT FIRES OFF HERE>>]

elif in_form.errors:
response.flash = 'form has errors'
else:
response.flash = 'please fill the form'

Thanks ...

*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division

-- 
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: Migrate from sqlite to mysql

[Ben Duncan]

Ok, is the python AND the mysql on the same windows BOX ?
If not, could be a firewall issue.

For the record, my python stand alone are truly stand alone (But I run
LINUX , no Windowns here).
So all my script are not thru the web2py but use the pydal library ...


*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division


On Thu, Feb 14, 2019 at 7:48 AM andfae  wrote:

> How to test via command prompt the connection between python and mysql?
>
> Il giorno gio 14 feb 2019 alle ore 14:47 andfae  ha
> scritto:
>
>> Yes I tried this usi too  uri = mysql://root:passwordroot@localhost/gadb
>> I don't know what is the problem...
>> Thank you
>>
>> Il giorno gio 14 feb 2019 alle ore 00:48 黄祥 
>> ha scritto:
>>
>>> RuntimeError: Failure to connect, tried 5 times:
>>>
>>> seems have a connection problem between python and mysql
>>> perhaps you can test the connection first (via command prompt)
>>>
>>> or perhaps an uri definition is wrong, had you try:
>>> *private/appconfig.ini*
>>> uri = mysql://root:passwordroot@localhost/gadb
>>> ?
>>>
>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe.
>>> To unsubscribe from this group and all its topics, 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.

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

[andfae]

How to test via command prompt the connection between python and mysql?

Il giorno gio 14 feb 2019 alle ore 14:47 andfae  ha
scritto:

> Yes I tried this usi too  uri = mysql://root:passwordroot@localhost/gadb
> I don't know what is the problem...
> Thank you
>
> Il giorno gio 14 feb 2019 alle ore 00:48 黄祥 
> ha scritto:
>
>> RuntimeError: Failure to connect, tried 5 times:
>>
>> seems have a connection problem between python and mysql
>> perhaps you can test the connection first (via command prompt)
>>
>> or perhaps an uri definition is wrong, had you try:
>> *private/appconfig.ini*
>> uri = mysql://root:passwordroot@localhost/gadb
>> ?
>>
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe.
>> To unsubscribe from this group and all its topics, 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: Migrate from sqlite to mysql

[andfae]

Yes I tried this usi too  uri = mysql://root:passwordroot@localhost/gadb
I don't know what is the problem...
Thank you

Il giorno gio 14 feb 2019 alle ore 00:48 黄祥 
ha scritto:

> RuntimeError: Failure to connect, tried 5 times:
>
> seems have a connection problem between python and mysql
> perhaps you can test the connection first (via command prompt)
>
> or perhaps an uri definition is wrong, had you try:
> *private/appconfig.ini*
> uri = mysql://root:passwordroot@localhost/gadb
> ?
>
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe.
> To unsubscribe from this group and all its topics, 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] Center things in MARKMIN

[rif]

hey guys,

I am using auth.wiki and I would like to center things (e.g. titles, 
images) horizontaly on the page. 
I didn't find any documentation on this, does anybody have any hints for me?

thanks,
-rif

-- 
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: Update web2py manually

[Константин Комков]

I have updated web2py alredy but that error remained. I can not start new 
project 2 week.

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