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 last):
File "<console>", line 1, in <module>
File "c:\web2py\gluon\packages\dal\pydal\base.py", line 873, in
import_from_csv_file
*args, **kwargs)
File "c:\web2py\gluon\packages\dal\pydal\objects.py", line 1001, in
import_from_csv_file
curr_id = inserting(**ditems)
File "c:\web2py\gluon\packages\dal\pydal\objects.py", line 753, in insert
ret = self._db._adapter.insert(self, row.op_values())
File "c:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 486, in
insert
raise e
IntegrityError: (1452, u'Cannot add or update a child row: a foreign key
constraint fails (`gadb`.`auth_user`, CONSTRAINT `auth_user_ibfk_2` FOREIGN
KEY (`modified_by`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE)')
>>>
Sigh....!! What can I do?
Thanks
Il giorno venerdì 15 febbraio 2019 00:11:11 UTC+1, 黄祥 ha scritto:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
