Error extracting Fare Data

Question

Error extracting Fare Data

Closed this issue 6 years ago · 5 comments

Unable to extract latest Fare Data - RJFAF851.ZIP
Command:
DATABASE_USERNAME=root DATABASE_PASSWORD=*** DATABASE_NAME=fares dtd2mysql --fares ~/Desktop/RJFAF851.ZIP
Error:
Error processing RJFAF851.RST with data RTRCOF0001R00000359D TANError: Non-nullable field received null value: "0000"

Answer 1 · 2018-06-15T06:40:04.000Z

I've been unable to reproduce this issue - could you let me know what version of dtd2mysql you are using and what version of MySQL/MariaDB you have.

Answer 2 · 2018-06-15T08:46:48.000Z

Hi, we are using the following versions: Mysql: 5.7.22 dtd2mysql: v5.2.3 George

…

On Fri, Jun 15, 2018 at 7:40 AM, Linus Norton ***@***.***> wrote: I've been unable to reproduce this issue - could you let me know what version of dtd2mysql you are using and what version of MySQL/MariaDB you have. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#38 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AmaKcjDFIHqx7U8Y77yy6HB--EjxhRbNks5t81bGgaJpZM4UoVKw> .

-- George Robbins Founder & CEO railrepay @railrepay fb.com/railrepay +447811334466

Answer 3 · 2018-06-15T09:27:39.000Z

This is very strange, this bug was fixed back in 3.8.4 (9f946b4)

I'm still unable to reproduce the issue, and I can see it is processing RTRCOF0001R00000359D TAN without any issues.

Answer 4 · 2018-06-15T11:18:44.000Z

We have managed to get the data by altering the tables that caused the error, eg extend length from 12 to 256 and allow NULL value. Strange question do you have the ZIP filed from last year?

…

On Fri, Jun 15, 2018 at 10:27 AM, Linus Norton ***@***.***> wrote: This is very strange, this bug was fixed back in 3.8.4 (9f946b4 <9f946b4> ) I'm still unable to reproduce the issue, and I can see it is processing RTRCOF0001R00000359D TAN without any issues. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#38 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AmaKcu6AwiRHP3SE58lWVBERv2NMWTyEks5t834NgaJpZM4UoVKw> .

-- George Robbins Founder & CEO railrepay @railrepay fb.com/railrepay +447811334466

Answer 5 · 2018-06-15T11:22:55.000Z

I'll drop you an email regarding other feeds