fixing your import process and/or correcting the wrong records.

On Tuesday, December 6, 2016 at 10:43:14 AM UTC+1, Ramos wrote:
>
> I exported to csv all major tables than imported them to my new app via 
> admin .
> I think i found the bug
> its here 
> &(db.status.id==db.events.event)
> status.id is integer but db.events.event is a text field that contains 
> "1"
> "2"
> "3"
> "4"
> "sometext"
> "anothertext"
> "6"
> "7"
> "8"
>
> How do i solve this?
>
> Regards
> António
>
>
> 2016-12-05 20:49 GMT+00:00 Niphlod <nip...@gmail.com <javascript:>>:
>
>> just check that all your columns where you do == have the same type. 
>> sqlite datatype handling is more resilient than standard, meaning that 
>> there is no strict type check.
>> dunno how you migrated data from sqlite to postgresql but probably 
>> something doesn't match .
>>
>> -- 
>> 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 <javascript:>.
>> 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.

Reply via email to