Skip to content

Failed to contact server to import session

[Nextcloud 16.0.4 / Phonetracks v0.5.2] When I try to import a gpx file, the following message is displayed:

Failed to contact server to import session

In the nextcloud logs you see the following message:

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ' INSERT INTO oc_phonetrack_points (deviceid, lat, lon, timestamp, accuracy, satellites, altitude, batterylevel, useragent, speed, bearing) VALUES ('35','-11,95791503','-76,98332837','1569547327',NULL,NULL,'315','31','PhoneTrack/0.0.12','8','33') , ('35','-11,95506858','-76,98264714','1569547388',NULL,NULL,'357','31','PhoneTrack/0.0.12','0','28') , ('35','-11,95116953','-76,98141076','1569547477',NULL,NULL,'378','31','PhoneTrack/0.0.12','0','37') , ('35','-11,95063702','-76,9807942','1569547537',NULL,NULL,'360','31','PhoneTrack/0.0.12','1','62') , ('35','-11,94833068','-76,9793217','1569547597',NULL,NULL,'368','30','PhoneTrack/0.0.12','4','34') , ('35','-11,94565616','-76,97851092','1569547657',NULL,NULL,'356','30','PhoneTrack/0.0.12','7','305') , ('35','-11,94555791','-76,97875122','1569547717',NULL,NULL,'391','29','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94578875','-76,97856994','1569547777',NULL,NULL,'410','29','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94577716','-76,97851314','1569547838',NULL,NULL,'398','29','PhoneTrack/0.0.12','1','111') , ('35','-11,94619672','-76,97799564','1569547988',NULL,NULL,'390','29','PhoneTrack/0.0.12','1','207') , ('35','-11,94611911','-76,97879602','1569548078',NULL,NULL,'392','29','PhoneTrack/0.0.12','1','289') , ('35','-11,94620921','-76,9790546','1569548170',NULL,NULL,'379','29','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94623983','-76,97901897','1569548324',NULL,NULL,'388','28','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94619145','-76,97898669','1569548726',NULL,NULL,'393','27','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94614769','-76,97896712','1569548937',NULL,NULL,'392','26','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94530752','-76,97994771','1569549477',NULL,NULL,'404','25','PhoneTrack/0.0.12','1','274') , ('35','-11,94489271','-76,9807998','1569549538',NULL,NULL,'390','25','PhoneTrack/0.0.12','1','293') , ('35','-11,94424578','-76,98099176','1569549598',NULL,NULL,'388','24','PhoneTrack/0.0.12','1','288') , ('35','-11,94397801','-76,98114454','1569549660',NULL,NULL,'385','24','PhoneTrack/0.0.12','2','14') , ('35','-11,94372409','-76,98121952','1569549924',NULL,NULL,'387','23','PhoneTrack/0.0.12','1','227') , ('35','-11,94374994','-76,98127575','1569549927',NULL,NULL,'386','23','PhoneTrack/0.0.12','1','227') , ('35','-11,94387033','-76,98141477','1569550624',NULL,NULL,'384','21','PhoneTrack/0.0.12','0','280') , ('35','-11,94403417','-76,98143605','1569550786',NULL,NULL,'386','21','PhoneTrack/0.0.12','0','259') , ('35','-11,9440777','-76,98132156','1569550935',NULL,NULL,'391','20','PhoneTrack/0.0.12','0','197') , ('35','-11,94402915','-76,98137334','1569551058',NULL,NULL,'388','20','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94397589','-76,9813344','1569551148',NULL,NULL,'390','19','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94391613','-76,98132037','1569551292',NULL,NULL,'394','19','PhoneTrack/0.0.12','0',NULL) , ('35','-11,9441166','-76,98132739','1569551407',NULL,NULL,'384','18','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94494263','-76,98070304','1569551497',NULL,NULL,'384','18','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94531612','-76,98006418','1569551559',NULL,NULL,'385','18','PhoneTrack/0.0.12','0','121') , ('35','-11,94585421','-76,97936343','1569551648',NULL,NULL,'392','18','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94618355','-76,97900578','1569551709',NULL,NULL,'400','18','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94607762','-76,97880471','1569551818',NULL,NULL,'388','18','PhoneTrack/0.0.12','0','126') , ('35','-11,9462281','-76,9788815','1569551918',NULL,NULL,'381','18','PhoneTrack/0.0.12','0','107') , ('35','-11,9463509','-76,97857515','1569552008',NULL,NULL,'392','18','PhoneTrack/0.0.12','0','322') , ('35','-11,94612285','-76,97898384','1569552068',NULL,NULL,'399','18','PhoneTrack/0.0.12','0','100') , ('35','-11,94629483','-76,97884152','1569552130',NULL,NULL,'389','17','PhoneTrack/0.0.12','0','125') , ('35','-11,94619124','-76,97894462','1569552217',NULL,NULL,'400','17','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94617489','-76,97898892','1569558956',NULL,NULL,'417','56','PhoneTrack/0.0.12','0','334') , ('35','-11,94613721','-76,97884238','1569559016',NULL,NULL,'430','57','PhoneTrack/0.0.12','0','165') , ('35','-11,94613791','-76,97904846','1569559076',NULL,NULL,'395','57','PhoneTrack/0.0.12','1','211') , ('35','-11,94614511','-76,97896006','1569559136',NULL,NULL,'388','58','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94599279','-76,97902457','1569559196',NULL,NULL,'411','58','PhoneTrack/0.0.12','0','309') , ('35','-11,94610859','-76,97893895','1569559257',NULL,NULL,'378','59','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94614435','-76,97896893','1569559737',NULL,NULL,'392','63','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94626925','-76,97896579','1569574196',NULL,NULL,'433','100','PhoneTrack/0.0.12','0','6') , ('35','-11,94608502','-76,9789066','1569574256',NULL,NULL,'384','100','PhoneTrack/0.0.12','0','137') , ('35','-11,94613797','-76,97897682','1569574316',NULL,NULL,'371','100','PhoneTrack/0.0.12','0','15') , ('35','-11,94610926','-76,97905941','1569574376',NULL,NULL,'391','100','PhoneTrack/0.0.12','0','355') , ('35','-11,94614122','-76,97892959','1569574556',NULL,NULL,'408','100','PhoneTrack/0.0.12','1','58') , ('35','-11,94612544','-76,97904282','1569574618',NULL,NULL,'423','100','PhoneTrack/0.0.12','1','266') , ('35','-11,94617639','-76,97900587','1569574856',NULL,NULL,'345','100','PhoneTrack/0.0.12','0','166') , ('35','-11,94613688','-76,97897674','1569574916',NULL,NULL,'317','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94609108','-76,97898222','1569574976',NULL,NULL,'344','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94614339','-76,97900112','1569575247',NULL,NULL,'378','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94619039','-76,97898936','1569575608',NULL,NULL,'392','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94610983','-76,97879224','1569576327',NULL,NULL,'419','100','PhoneTrack/0.0.12','0','101') , ('35','-11,94618186','-76,97897435','1569576387',NULL,NULL,'382','100','PhoneTrack/0.0.12','0','316') , ('35','-11,94620204','-76,97893204','1569576447',NULL,NULL,'382','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94617643','-76,97897293','1569576867',NULL,NULL,'389','100','PhoneTrack/0.0.12','0',NULL) , ('35','-11,94957174','-76,98032632','1569584732',NULL,NULL,'368','99','PhoneTrack/0.0.12','8','216') , ('35','-11,95297072','-76,98253757','1569584792',NULL,NULL,'361','99','PhoneTrack/0.0.12','13','216') , ('35','-11,95774487','-76,98340686','1569584852',NULL,NULL,'351','99','PhoneTrack/0.0.12','13','214') , ('35','-11,96010905','-76,98410875','1569584912',NULL,NULL,'332','99','PhoneTrack/0.0.12','1','150') , ('35','-11,96117194','-76,9844242','1569584972',NULL,NULL,'350','99','PhoneTrack/0.0.12','6','215') , ('35','-11,96526458','-76,98735362','1569585032',NULL,NULL,'330','98','PhoneTrack/0.0.12','9','215') , ('35','-11,96941252','-76,99040786','1569585092',NULL,NULL,'308','98','PhoneTrack/0.0.12','2','213') , ('35','-11,97326027','-76,9918716','1569585152',NULL,NULL,'287','98','PhoneTrack/0.0.12','13','171') , ('35','-11,9772645','-76,99184286','1569585212',NULL,NULL,'282','97','PhoneTrack/0.0.12','0','185') , ('35','-11,97866665','-76,99185691','1569585272',NULL,NULL,'259','97','PhoneTrack/0.0.12','0',NULL) , ('35','-11,9793817','-76,99194033','1569585332',NULL,NULL,'283','97','PhoneTrack/0.0.12','9','184') , ('35','-11,98329626','-76,99361668','1569585392',NULL,NULL,'286','97','PhoneTrack/0.0.12','7','213') , ('35','-11,98698014','-76,9957555','1569585452',NULL,NULL,'263','97','PhoneTrack/0.0.12','10','199') , ('35','-11,98955203','-76,99758001','1569585524',NULL,NULL,'252','97','PhoneTrack/0.0.12','3','318') , ('35','-11,99283717','-77,00086154','1569585633',NULL,NULL,'250','96','PhoneTrack/0.0.12','5','185') , ('35','-12,00002061','-77,00009449','1569585752',NULL,NULL,'242','96','PhoneTrack/0.0.12','3','166') , ('35','-12,00249136','-76,9992072','1569585812',NULL,NULL,'232','96','PhoneTrack/0.0.12','0',NULL) , ('35','-12,00761284','-76,99730673','1569585872',NULL,NULL,'236','95','PhoneTrack/0.0.12','16','158') , ('35','-12,01276942','-76,99458456','1569585933',NULL,NULL,'236','95','PhoneTrack/0.0.12','3','114') , ('35','-12,01374239','-76,99445804','1569585994',NULL,NULL,'228','95','PhoneTrack/0.0.12','2','178') , ('35','-12,01711751','-76,9928307','1569586111',NULL,NULL,'244','94','PhoneTrack/0.0.12','5','120') , ('35','-12,01737156','-76,99137413','1569586173',NULL,NULL,'255','94','PhoneTrack/0.0.12','0',NULL) , ('35','-12,01746155','-76,99133134','1569586241',NULL,NULL,'256','94','PhoneTrack/0.0.12','0',NULL) , ('35','-12,01768581','-76,99105278','1569586302',NULL,NULL,'302','94','PhoneTrack/0.0.12','0','72') , ('35','-12,01781808','-76,99000889','1569586420',NULL,NULL,'232','94','PhoneTrack/0.0.12','0','116') , ('35','-12,02067238','-76,99083652','1569586481',NULL,NULL,'254','93','PhoneTrack/0.0.12','6','192') , ('35','-12,02270474','-76,99149105','1569586541',NULL,NULL,'246','93','PhoneTrack/0.0.12','8','177') , ('35','-12,02583514','-76,99137944','1569586601',NULL,NULL,'254','93','PhoneTrack/0.0.12','0',NULL) , ('35','-12,02589477','-76,99137446','1569586661',NULL,NULL,'252','92','PhoneTrack/0.0.12','0',NULL) , ('35','-12,0259662','-76,99141043','1569586721',NULL,NULL,'254','92','PhoneTrack/0.0.12','0',NULL) , ('35','-12,02706019','-76,99124606','1569586781',NULL,NULL,'258','92','PhoneTrack/0.0.12','2','153') , ('35','-12,0301678','-76,99181232','1569586841',NULL,NULL,'228','92','PhoneTrack/0.0.12','0','175') , ('35','-12,03061788','-76,99314172','1569586901',NULL,NULL,'247','92','PhoneTrack/0.0.12','6','292') , ('35','-12,02892956','-76,99855727','1569587021',NULL,NULL,'255','92','PhoneTrack/0.0.12','7','257') , ('35','-12,02901754','-76,99909427','1569587082',NULL,NULL,'232','92','PhoneTrack/0.0.12','0','283') , ('35','-12,02901433','-76,99963119','1569587142',NULL,NULL,'236','91','PhoneTrack/0.0.12','0','242') , ('35','-12,03001328','-76,99971786','1569587263',NULL,NULL,'232','91','PhoneTrack/0.0.12','0',NULL) , ('35','-12,03035394','-77,00044065','1569587380',NULL,NULL,'253','91','PhoneTrack/0.0.12','1','241') , ('35','-12,03020385','-77,00055083','1569587441',NULL,'15','228','91','PhoneTrack/0.0.12','0',NULL) , ('35','-12,03022899','-77,00047325','1569587504',NULL,NULL,'230','91','PhoneTrack/0.0.12','0',NULL) , ('35','-12,03024278','-77,00054418','1569587669',NULL,NULL,'230','90','PhoneTrack/0.0.12','0','100') , ('35','-12,03025492','-77,00030823','1569587729',NULL,NULL,'236','90','PhoneTrack/0.0.12','0','123') , ('35','-12,02927756','-76,99800441','1569587789',NULL,NULL,'232','90','PhoneTrack/0.0.12','13','73') , ('35','-12,03308797','-76,99268225','1569587850',NULL,NULL,'240','90','PhoneTrack/0.0.12','12','113') , ('35','-12,03227608','-76,98957119','1569587931',NULL,NULL,'260','90','PhoneTrack/0.0.12','0',NULL) , ('35','-12,03221971','-76,98942343','1569587991',NULL,'19','258','90','PhoneTrack/0.0.12','0','73') , ('35','-12,03212547','-76,98907833','1569588077',NULL,NULL,'250','90','PhoneTrack/0.0.12','1','83') , ('35','-12,0311519','-76,98590717','1569588140',NULL,NULL,'256','90','PhoneTrack/0.0.12','9','75') , ('35','-12,02912299','-76,97735749','1569588208',NULL,NULL,'252','90','PhoneTrack/0.0.12','18','73') , ('35','-12,0238457','-76,96230508','1569588301',NULL,NULL,'291','90','PhoneTrack/0.0.12','18','70') , ('35','-12,02029937','-76,95183441','1569588365',NULL,NULL,'307','90','PhoneTrack/0.0.12','18','76') , ('35','-12,0199213','-76,94723818','1569588427',NULL,'15','321','89','PhoneTrack/0.0.12','0',NULL) , ('35','-12,01948985','-76,94712734','1569588529',NULL,NULL,'301','89','PhoneTrack/0.0.12','0','322') , ('35','-12,01936866','-76,94708219','1569588593',NULL,'15','317','89','PhoneTrack/0.0.12','0',NULL) , ('35','-12,01933408','-76,9470447','1569588696',NULL,NULL,'317','89','PhoneTrack/0.0.12','1','6') , ('35','-12,01855182','-76,94700172','1569588760',NULL,'14','318','88','PhoneTrack/0.0.12','0','4') , ('35','-12,01790841','-76,9470302','1569588821',NULL,NULL,'317','88','PhoneTrack/0.0.12','1','356') , ('35','-12,01749284','-76,94683462','1569588939',NULL,NULL,'314','88','PhoneTrack/0.0.12','0','356') , ('35','-12,01304265','-76,93449497','1569589197',NULL,'5','344','87','PhoneTrack/0.0.12','10','57') , ('35','-12,0105785','-76,93010989','1569589274',NULL,NULL,'351','87','PhoneTrack/0.0.12','2','60') , ('35','-12,00767148','-76,93111909','1569589340',NULL,NULL,'344','87','PhoneTrack/0.0.12','1','353') , ('35','-12,00531401','-76,93113478','1569589400',NULL,NULL,'346','87','PhoneTrack/0.0.12','0','321') , ('35','-12,00525036','-76,93059205','1569589461',NULL,NULL,'374','86','PhoneTrack/0.0.12','3','67') , ('35','-12,0032127','-76,92589498','1569589580',NULL,NULL,'380','86','PhoneTrack/0.0.12','7','76') , ('35','-12,00304363','-76,92338089','1569589640',NULL,NULL,'380','86','PhoneTrack/0.0.12','4','91') , ('35','-12,00313245','-76,92158092','1569589700',NULL,NULL,'383','86','PhoneTrack/0.0.12','0',NULL) , ('35','-12,00309599','-76,92014652','1569589760',NULL,NULL,'366','85','PhoneTrack/0.0.12','3','74') , ('35','-12,00224459','-76,91866196','1569589820',NULL,NULL,'386','85','PhoneTrack/0.0.12','5','67') , ('35','-11,99924815','-76,91621329','1569589880',NULL,NULL,'382','85','PhoneTrack/0.0.12','10','357') , ('35','-11,99689317','-76,91418955','1569589940',NULL,NULL,'390','85','PhoneTrack/0.0.12','17','67') , ('35','-11,99175167','-76,9057852','1569590000',NULL,NULL,'414','85','PhoneTrack/0.0.12','20','69') , ('35','-11,99017672','-76,90242506','1569590060',NULL,NULL,'408','85','PhoneTrack/0.0.12','2','193') , ('35','-11,99135417','-76,90203989','1569590121',NULL,NULL,'421','84','PhoneTrack/0.0.12','2','167') , ('35','-11,99191711','-76,90195672','1569590240',NULL,NULL,'421','84','PhoneTrack/0.0.12','1','16') , ('35','-11,99109635','-76,9016214','1569590300',NULL,'12','422','84','PhoneTrack/0.0.12','1','15') , ('35','-11,99076734','-76,90110857','1569590360',NULL,'10','422','84','PhoneTrack/0.0.12','1','116') , ('35','-11,99085007','-76,90047091','1569590420',NULL,'10','416','84','PhoneTrack/0.0.12','1','160') , ('35','-11,99092511','-76,90041367','1569590480',NULL,'12','427','84','PhoneTrack/0.0.12','0','213') , ('35','-11,99065004','-76,90023795','1569590540',NULL,'4','429','84','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99072276','-76,90027988','1569590736',NULL,NULL,'426','84','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99077216','-76,90028404','1569592900',NULL,NULL,'416','81','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99077226','-76,90021386','1569599532',NULL,NULL,'426','72','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99074274','-76,90027778','1569602629',NULL,NULL,'428','66','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99082516','-76,9004794','1569606882',NULL,NULL,'429','63','PhoneTrack/0.0.12','0','209') , ('35','-11,99089022','-76,90026783','1569607028',NULL,NULL,'427','63','PhoneTrack/0.0.12','0','290') , ('35','-11,99066016','-76,90026776','1569608004',NULL,NULL,'427','61','PhoneTrack/0.0.12','0','232') , ('35','-11,9909175','-76,90021925','1569608189',NULL,NULL,'427','60','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99084538','-76,90034847','1569608370',NULL,NULL,'427','60','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99077369','-76,90041509','1569608546',NULL,NULL,'427','60','PhoneTrack/0.0.12','1','237') , ('35','-11,99072312','-76,90012335','1569608733',NULL,NULL,'427','59','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99085992','-76,90031134','1569608776',NULL,NULL,'436','59','PhoneTrack/0.0.12','0','242') , ('35','-11,99076631','-76,90020782','1569608856',NULL,NULL,'427','58','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99073341','-76,90020523','1569609035',NULL,NULL,'427','58','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99081177','-76,90033289','1569609100',NULL,NULL,'427','58','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99058577','-76,90047835','1569609193',NULL,NULL,'428','58','PhoneTrack/0.0.12','0','282') , ('35','-11,99076413','-76,90029915','1569609316',NULL,NULL,'428','57','PhoneTrack/0.0.12','0','306') , ('35','-11,99067376','-76,90077119','1569609388',NULL,NULL,'428','57','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99096749','-76,90007485','1569609506',NULL,NULL,'428','57','PhoneTrack/0.0.12','0','122') , ('35','-11,99066981','-76,90024457','1569609617',NULL,NULL,'427','56','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99083693','-76,90011009','1569609683',NULL,NULL,'427','56','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99078231','-76,90020044','1569609749',NULL,NULL,'427','55','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99078294','-76,90019147','1569610373',NULL,NULL,'427','54','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99076079','-76,90027552','1569613890',NULL,NULL,'427','51','PhoneTrack/0.0.12','0','42') , ('35','-11,99074917','-76,90028792','1569613997',NULL,NULL,'427','51','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99080933','-76,90028468','1569614062',NULL,NULL,'427','51','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99081696','-76,90026367','1569614151',NULL,NULL,'427','50','PhoneTrack/0.0.12','1','297') , ('35','-11,99080262','-76,90033891','1569614232',NULL,NULL,'428','50','PhoneTrack/0.0.12','4','108') , ('35','-11,99054445','-76,90070868','1569614309',NULL,NULL,'429','50','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99064651','-76,90044276','1569614384',NULL,NULL,'430','50','PhoneTrack/0.0.12','2','296') , ('35','-11,99080747','-76,9001339','1569614457',NULL,NULL,'427','50','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99068886','-76,90032032','1569614529',NULL,NULL,'426','50','PhoneTrack/0.0.12','0','310') , ('35','-11,9907547','-76,89972212','1569614614',NULL,NULL,'426','50','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99079871','-76,90031706','1569614711',NULL,NULL,'427','49','PhoneTrack/0.0.12','1','204') , ('35','-11,99081596','-76,90023344','1569614787',NULL,NULL,'428','49','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99078841','-76,89960509','1569614863',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','94') , ('35','-11,99069889','-76,90017219','1569614932',NULL,NULL,'426','49','PhoneTrack/0.0.12','0','302') , ('35','-11,99064659','-76,90005279','1569615043',NULL,NULL,'428','49','PhoneTrack/0.0.12','0','279') , ('35','-11,99075896','-76,90022656','1569615103',NULL,NULL,'427','49','PhoneTrack/0.0.12','1','70') , ('35','-11,9908017','-76,90034479','1569615165',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','292') , ('35','-11,99071371','-76,90022487','1569615231',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','317') , ('35','-11,99054526','-76,900121','1569615361',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','9') , ('35','-11,99079384','-76,90023916','1569615456',NULL,NULL,'428','49','PhoneTrack/0.0.12','0','236') , ('35','-11,99068022','-76,90016193','1569615556',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','293') , ('35','-11,99070767','-76,90025519','1569615623',NULL,NULL,'427','49','PhoneTrack/0.0.12','0','178') , ('35','-11,99088642','-76,9002496','1569615697',NULL,NULL,'426','49','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,990743','-76,90028164','1569615847',NULL,NULL,'427','48','PhoneTrack/0.0.12','0','239') , ('35','-11,99076989','-76,90021869','1569615946',NULL,NULL,'428','48','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,9908049','-76,90014954','1569616151',NULL,NULL,'424','48','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99097785','-76,90012452','1569616335',NULL,NULL,'426','48','PhoneTrack/0.0.12','0','154') , ('35','-11,99094521','-76,90029535','1569616611',NULL,NULL,'426','47','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99087694','-76,90031469','1569616682',NULL,NULL,'427','47','PhoneTrack/0.0.12','1','49') , ('35','-11,99062977','-76,9001846','1569616822',NULL,NULL,'428','47','PhoneTrack/0.0.12','0','126') , ('35','-11,99094124','-76,90032719','1569616924',NULL,NULL,'424','47','PhoneTrack/0.0.12','0',NULL) , ('35','-11,9909013','-76,9002001','1569616996',NULL,NULL,'428','47','PhoneTrack/0.0.12','1','120') , ('35','-11,99078589','-76,90017061','1569617065',NULL,NULL,'427','47','PhoneTrack/0.0.12','0','33') , ('35','-11,99083457','-76,90025128','1569617141',NULL,NULL,'427','47','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99079155','-76,90021251','1569617311',NULL,NULL,'427','46','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99098468','-76,90017711','1569617373',NULL,NULL,'427','46','PhoneTrack/0.0.12','0','22') , ('35','-11,99087441','-76,90032039','1569617532',NULL,NULL,'427','46','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99084438','-76,90025426','1569617833',NULL,NULL,'427','46','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99070617','-76,90029378','1569617927',NULL,NULL,'427','46','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,9907324','-76,90030012','1569618028',NULL,NULL,'427','46','PhoneTrack/0.0.12','0','136') , ('35','-11,99069917','-76,90028725','1569618165',NULL,NULL,'427','46','PhoneTrack/0.0.12','0','177') , ('35','-11,99082808','-76,90012884','1569618235',NULL,NULL,'427','46','PhoneTrack/0.0.12','1','44') , ('35','-11,99079338','-76,90036246','1569618395',NULL,NULL,'427','45','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99092817','-76,90034894','1569618469',NULL,NULL,'427','45','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99085588','-76,89996881','1569618589',NULL,NULL,'427','45','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99084442','-76,90027752','1569618716',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99073303','-76,90015949','1569618832',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99068588','-76,9002152','1569618948',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,9907438','-76,90019114','1569619045',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99071581','-76,9003798','1569619120',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99073584','-76,90026451','1569619241',NULL,NULL,'427','44','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99088133','-76,89991105','1569619310',NULL,NULL,'427','44','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99070884','-76,90016935','1569619368',NULL,'8','427','42','PhoneTrack/0.0.12',NULL,NULL) , ('35','-11,99085158','-76,90025245','1569619485',NULL,NULL,'427','42','PhoneTrack/0.0.12','0',NULL) , ('35','-11,99079981','-76,90026452','1569619658',NULL,NULL,'427','42','PhoneTrack/0.0.12','0',NULL) ;':

SQLSTATE[01000]: Warning: 1265 Data truncated for column 'lat' at row 1 at <>

  1. /srv/www/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 184 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
  2. /srv/www/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 158 Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
  3. /srv/www/htdocs/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 178 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "\n ... ;", [])
  4. /srv/www/htdocs/nextcloud/apps/phonetrack/controller/pagecontroller.php line 4517 Doctrine\DBAL\Statement->execute()
  5. /srv/www/htdocs/nextcloud/apps/phonetrack/controller/pagecontroller.php line 2720 OCA\PhoneTrack\Controller\PageController->logMultiple("071309408a083e8b792cf973159ed2c6", "RedmiNote53", [[-11.95791503,- ... ]])
  6. <> OCA\PhoneTrack\Controller\PageController->gpxEndElement(null, "TRK")
  7. /srv/www/htdocs/nextcloud/apps/phonetrack/controller/pagecontroller.php line 2785 undefinedundefinedxml_parse(null, "0</batterylevel ... >", true)
  8. /srv/www/htdocs/nextcloud/apps/phonetrack/controller/pagecontroller.php line 2642 OCA\PhoneTrack\Controller\PageController->readGpxImportPoints(OC\Files\Node\File {}, "sasa.gpx", "071309408a083e8b792cf973159ed2c6")
  9. /srv/www/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 166 OCA\PhoneTrack\Controller\PageController->importSession("/gpslogger/sasa.gpx")
  10. /srv/www/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99 OC\AppFramework\Http\Dispatcher->executeController(OCA\PhoneTrack\C ... {}, "importSession")
  11. /srv/www/htdocs/nextcloud/lib/private/AppFramework/App.php line 126 OC\AppFramework\Http\Dispatcher->dispatch(OCA\PhoneTrack\C ... {}, "importSession")
  12. /srv/www/htdocs/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47 OC\AppFramework\App::main("PageController", "importSession", OC\AppFramework\ ... {}, {_route: "phonetrack.page.importSession"})
  13. <> OC\AppFramework\Routing\RouteActionHandler->__invoke({_route: "phonetrack.page.importSession"})
  14. /srv/www/htdocs/nextcloud/lib/private/Route/Router.php line 297 undefinedundefinedcall_user_func(OC\AppFramework\ ... {}, {_route: "phonetrack.page.importSession"})
  15. /srv/www/htdocs/nextcloud/lib/base.php line 975 OC\Route\Router->match("/apps/phonetrack/importSession")
  16. /srv/www/htdocs/nextcloud/index.php line 42 OC::handleRequest()

POST /index.php/apps/phonetrack/importSession from 1.1.1.2 by manuel.villacorta at 2019-09-28T15:10:44+00:00

There seems to be a problem when importing information from the points to the database.

Please, I need to view the gpx files

Edited by Manuel Alejandro Villacorta Arevalo