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.