You mean character set UTF?
Make sure environment variable set to UTF.
Have had problems with Windows being NON UTF before.
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Tue, Feb 19, 2019 at 2:58 PM Andrea Fae' wrote:
> Hello, I
Hello, I deleted a foreign key and I was able to import. But I have a
strange problem. When I export all data is ok, when I import I don't have
problems to do now but in mysql database some information chenged!
Could it depend on the charset umtf?
Thank you in advance who will answer.
Il
Hi,
I am having the same error (Failure to connect).
I checked the connection to mysql using python command line
1
2
>>> import mysql.connector
>>> mysql.connector.connect(host='localhost',database='mysql',user='root',
password='')
and it is success.
What could be the reason of that error?
Yesterday night I solved the problem!
It was a problem about python driver...with pip I updated and now I juste
re-create the database in myslq
But trying to import the csv I have now this problem
>>> db.import_from_csv_file(open('c:\web2py\ga_export.csv','rb'))
Traceback (most recent call
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)
-
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
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
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
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
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
>
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
?
Yes it will create the db.define.
*Ben Duncan*
DBA / Chief Software Architect
Mississippi State Supreme Court
Electronic Filing Division
On Wed, Feb 13, 2019 at 1:55 PM Andrea Fae' wrote:
> Hello!
> I followed the instruction you wrote me.
> But at that point:" load web2py app, ensure migrate
Hello!
I followed the instruction you wrote me.
But at that point:" load web2py app, ensure migrate is true, so that will
create the tables defined in web2py"
I have this error:
Error ticket for "ga"Ticket ID
127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa4-42c2-b1a9-ab14a466e72e
Failure to
another way around you can use bundled software (xampp, mamp, wamp, ampps,
bitnami etc) or docker (mysql or python container)
best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
-
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
>
> but, what happen if I install python 3.7 on windows? Does web2py still use
> 2.7?
>
this question is vague
not sure what do you have in web2py? win version or source version?
if use source version, then web2py run on python is depending on the
command you use
*e.g. in ubuntu environment*
but, what happen if I install python 3.7 on windows? Does web2py still use
2.7?
Or installinh mysql without this connector?
What does you think? Other suggestions? I don't like to use different
things because I need to publish my application to pythonanywhere...
thanks
Il giorno domenica 10
pardon, not using windows atm, so cant test it
perhaps you have 2 options:
- try mariadb (not sure mariadb required python3 or not)
or
- use conda (miniconda (light version) or anaconda) to install python3 and
python2 in 1 machine
*ref:*
https://www.anaconda.com/distribution/
Hello, if I trye to install mysql 8 on my windows pc it tells me I have a
problem about requirements. I don't have installed python 3.7. But could I
have problem installing python 3.7 on my web2py based on python 2.17? thank
you in advance for your gently answers!
Il giorno sabato 9 febbraio
Thank you guys!
I will do a test and let you known.
Thank you for now.
Il giorno sabato 9 febbraio 2019 17:47:53 UTC+1, Ben Lawrence ha scritto:
>
> And turn off lazy-tables until mysql has built all the tables.
>
> On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote:
>>
>> - what version
And turn off lazy-tables until mysql has built all the tables.
On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote:
>
> - what version of mysql do I have to install to my PC where I have 2.17
>> version of web2py? Where can I find?
>>
>
> in windows env there are mysql and mariadb
>
>
> - what version of mysql do I have to install to my PC where I have 2.17
> version of web2py? Where can I find?
>
in windows env there are mysql and mariadb
*ref:*
https://downloads.mariadb.org
https://dev.mysql.com/downloads/mysql/
- is it necessary to install drivers or it is still
22 matches
Mail list logo