well, the importation automatically dont fixed the keys, i don't
understand why end the importantion manual dont work because my code not
use the common functions or methods the web2py like SQLFORM or FORM, so the
relation is forced like ex
propriedade = db(db.PropriedadeRural.id ==
request.vars.propriedade).select().first()
db.Despesas.insert (propriedade = propriedade.id)
there is any idea for help me ?
Em quarta-feira, 16 de outubro de 2019 03:43:47 UTC-3, Massimo Di Pierro
escreveu:
>
> Do you have the original database. If you do you should export it from the
> web2py shell with db.export_to_csv_file and reimport it with
> db.import_from_csv_file. This is documented in the manual. The import will
> automatically fix your keys.
>
> If you use postgres you can use pgdump and pgrestore.
>
> If you do not have the original database then this may be hopeless.
>
> Massimo
>
>
>
>
> P.S. I do not speak english very well either but as long as we understand
> each other we are fine. :-)
>
>
> On Tuesday, 15 October 2019 06:40:24 UTC-7, Kimus wrote:
>>
>> Hello !!!
>>
>>
>> I need help , I have four tables in DB, but I migrated for other domain
>> so i stored the information in another DB, but it returned error,
>> inconpatible foreing key.
>> This ocorred because when uploaded the file "example auth_user" the
>> column ID is modifyed to other number, that is diferent from the original
>> table.
>>
>> someone could me help me, please, I need this ID to be not modifyed,
>> there is some way ??
>>
>> thanks :)
>>
>>
>> PS : I do not speak english, so i'm so sorry :(
>>
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/cfc019fd-4c6f-4ee4-9dcb-edb1d331d018%40googlegroups.com.
