search

med-material / ArduinoLogger

Source code for an Arduino Logger (Windows/Mac) used for the advanced human computer interaction (AMMI) course at AAU (Unity 2018.3.2f1)
MIT License
3 stars 2 forks source link

mac error "unknown column TimeStamp" - new release needed? #32

Closed hendrikknoche closed 4 years ago

hendrikknoche commented 4 years ago

On a MAC when trying to publish logs to the server I get the below error. I think we might have changed the table structure and the MAC release didn't get updated. image

bastianilso commented 4 years ago

The issue was in the database - we had no column for collecting timestamps for EDAIBI-Serial data. I added the column now. Could you try again?

hendrikknoche commented 4 years ago

one more field missing :-) - sorry need to verify this with the latest release.... image

bastianilso commented 4 years ago

Did you add it yourself? I can see there is a column called Millis inside the database. image

hendrikknoche commented 4 years ago

Hmm, strange. I think I might have added it at some point but it still throws the error

best

Hendrik

-- Hendrik Knoche Department of Architecture, Design & Media Technology Rendsburggade 14, 5-341 9200 Aalborg SV, DK

t: +45 8238 9438 m: +45 6051 3546

From: Bastian Ilso notifications@github.com Reply to: med-material/ArduinoLogger reply@reply.github.com Date: Friday, 20 March 2020 at 10:38 To: med-material/ArduinoLogger ArduinoLogger@noreply.github.com Cc: Hendrik Ole Knoche hk@create.aau.dk, Author author@noreply.github.com Subject: Re: [med-material/ArduinoLogger] mac error "unknown column TimeStamp" - new release needed? (#32)

Did you add it yourself? I can see there is a column called Millis inside the database.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/med-material/ArduinoLogger/issues/32#issuecomment-601609575, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAPEDH3MEMXKSFXSTFUEIATRIM2PXANCNFSM4LPNQQAQ.

hendrikknoche commented 4 years ago

it seems the error is on the database side, right?

bastianilso commented 4 years ago

@hendrikknoche could you save it to CSV and upload it to this thread? very peculiar, cause we do have the column there,.. [Fri Mar 20 08:41:52.229286 2020] [:error] [pid 39339] [client 172.29.53.237:65462] prepare() failed: Unknown column 'Millis' in 'field list'

hendrikknoche commented 4 years ago

here it is... it's the email most likely

Email;Millis;EDA;IBI;RawPulse;Pressure;Button ; 2020-03-20 11:48:18;hk@create.aau.dk;1;1;1857;0;0;81;0;0; 2020-03-20 11:48:18;hk@create.aau.dk;1;1;1867;4;0;80;0;0; 2020-03-20 11:48:18;hk@create.aau.dk;1;1;1878;0;0;81;0;0; 2020-03-20 11:48:18;hk@create.aau.dk;1;1;1888;4;0;81;0;0; 2020-03-20 11:48:18;hk@create.aau.dk;1;1;1898;0;1894;80;0;0;

bastianilso commented 4 years ago

Could you upload the CSV file itself? as an attachment (drag n drop)? sorry, i need to be sure I understand what is in what column

hendrikknoche commented 4 years ago

RTIIlog.csv.zip

bastianilso commented 4 years ago

image

It looks to me like there is something wrong with the output here + some minor unrelated issues:

The problem we see with columns mismatching/being too many, is likely the source of the DB logging problem. I have updated our php file with some extra debug logging. Could I ask you to do the following:

Then i will make a comparison and see what is happening. If all of this goes wrong, we might want to try some remote-control over MS teams and debugging in Unity.

hendrikknoche commented 4 years ago

let's do a screen share call around this. I cannot find that directory (after AAU it goes to RTII and there's no Data subdir). I'm getting another error image PID this time. Was I supposed to DL a new ino or dmg file? log.csv.zip

bastianilso commented 4 years ago

It seems like the main issue was the missing PID column in the database. The database uploading works now.