neo4j-php / neo4j-php-client

Php client and driver for neo4j database
https://neo4j.com/developer/php/
MIT License
162 stars 40 forks source link

Random digit "1" appearing printed before the response of the PHP script corrupting json encoded output on ajax request #226

Closed atrandafir closed 1 month ago

atrandafir commented 1 month ago

Describe the bug

I have these Ajax requests that take data out of Neo4j in order to paint some charts and tables.

On the first daily run of my PHP web application, the ajax response is corrupted by the digit "1" appearing before the encoded JSON.

Example:

1{"rows":[{"e.ent_start":"2020-12-24"},{"e.ent_start":"2020-10-10"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2019-11-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-09-20"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2018-04-10"},{"e.ent_start":"2018-10-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-03-18"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-10"},{"e.ent_start":"2022-07-06"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-10-05"},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-05-10"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2004-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-05-25"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-03-05"},{"e.ent_start":"2018-08-21"},{"e.ent_start":"1899-01-01"},{"e.ent_start":"2015-04-15"},{"e.ent_start":"2022-02-17"},{"e.ent_start":"2021-11-09"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-11-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2018-02-25"},{"e.ent_start":"2017-10-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":0},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-11-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-06"},{"e.ent_start":"2021-09-01"},{"e.ent_start":"2018-08-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2018-06-14"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-28"},{"e.ent_start":"2016-10-05"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"1998-01-01"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2022-04-12"},{"e.ent_start":"2021-08-27"},{"e.ent_start":"2022-07-04"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-05-19"},{"e.ent_start":0},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2021-11-17"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2009-03-01"},{"e.ent_start":"2016-10-12"},{"e.ent_start":"2017-11-01"},{"e.ent_start":"2021-07-12"},{"e.ent_start":0},{"e.ent_start":"2022-11-03"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2021-05-21"},{"e.ent_start":"2011-07-14"},{"e.ent_start":"2022-03-01"},{"e.ent_start":"2014-11-18"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2019-09-01"},{"e.ent_start":"2021-12-21"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-06-01"},{"e.ent_start":"2022-06-06"},{"e.ent_start":"2019-07-01"},{"e.ent_start":"2016-01-06"},{"e.ent_start":"2022-08-12"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2016-10-16"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-01-31"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-11-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-11-10"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-11-01"},{"e.ent_start":"2020-03-01"},{"e.ent_start":"2022-05-12"},{"e.ent_start":0},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2022-02-04"},{"e.ent_start":"2022-01-10"},{"e.ent_start":"2001-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-01-17"},{"e.ent_start":"2022-03-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2021-11-10"},{"e.ent_start":"2022-01-12"},{"e.ent_start":"2022-02-01"},{"e.ent_start":0},{"e.ent_start":"2022-10-01"},{"e.ent_start":"2014-06-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":0},{"e.ent_start":"2020-09-01"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2016-04-08"},{"e.ent_start":"2021-02-04"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-01-26"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-06-13"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-18"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-02-15"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2006-01-01"},{"e.ent_start":"2020-03-06"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-07-01"},{"e.ent_start":"2021-01-22"},{"e.ent_start":"2011-11-14"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-06-17"},{"e.ent_start":"2019-07-25"},{"e.ent_start":"2016-08-24"},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":"2015-11-01"},{"e.ent_start":0},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-10-01"},{"e.ent_start":"2022-09-01"},{"e.ent_start":"2011-01-26"},{"e.ent_start":"2018-05-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2016-11-09"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2004-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2000-02-23"},{"e.ent_start":"2022-07-01"},{"e.ent_start":"2021-09-09"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2020-07-12"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-01-01"},{"e.ent_start":0},{"e.ent_start":"2018-03-14"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2022-03-06"},{"e.ent_start":"2022-07-18"},{"e.ent_start":"2020-04-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2012-05-29"},{"e.ent_start":"2010-10-29"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-05-17"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-04-05"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2020-10-15"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2019-10-14"},{"e.ent_start":"1995-01-01"},{"e.ent_start":"2003-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-05-15"},{"e.ent_start":"2023-01-01"},{"e.ent_start":"2022-03-09"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-05-04"},{"e.ent_start":"2013-03-20"},{"e.ent_start":"2022-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-08-22"},{"e.ent_start":"2020-02-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2015-01-12"},{"e.ent_start":"2023-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-01-01"},{"e.ent_start":"2022-03-21"},{"e.ent_start":"2018-05-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-07-12"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2014-12-01"},{"e.ent_start":"2016-10-07"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2017-10-24"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2022-11-07"},{"e.ent_start":"2017-10-20"},{"e.ent_start":"2018-09-21"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2014-03-13"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2015-07-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2023-03-10"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2022-04-29"},{"e.ent_start":"2009-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2016-11-01"},{"e.ent_start":"2022-01-05"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2019-08-15"},{"e.ent_start":"2020-07-01"},{"e.ent_start":"2022-10-11"},{"e.ent_start":"2012-06-11"},{"e.ent_start":"2019-03-29"},{"e.ent_start":"2018-10-01"},{"e.ent_start":0},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-07-01"},{"e.ent_start":"2023-01-11"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-11-25"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2023-03-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2015-03-15"},{"e.ent_start":"2022-03-03"},{"e.ent_start":"2022-09-22"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2016-06-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-05-15"},{"e.ent_start":"2017-01-04"},{"e.ent_start":0},{"e.ent_start":"2023-01-01"},{"e.ent_start":"2006-02-08"},{"e.ent_start":"2021-05-20"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-05-05"},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2022-03-24"},{"e.ent_start":0},{"e.ent_start":"2021-05-10"},{"e.ent_start":"2022-03-25"},{"e.ent_start":"2022-03-02"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2019-05-19"},{"e.ent_start":"2021-09-01"},{"e.ent_start":"2015-06-26"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"1955-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2020-09-25"},{"e.ent_start":"2016-01-08"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2020-11-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2009-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-01-01"},{"e.ent_start":"2020-06-11"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-04-05"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"1997-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2019-04-24"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2017-07-01"},{"e.ent_start":"2019-05-20"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2019-12-18"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2016-12-16"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2018-12-07"},{"e.ent_start":"2020-02-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2016-09-02"},{"e.ent_start":"2021-04-07"},{"e.ent_start":"2016-05-05"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-05-20"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-12-10"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-08-01"},{"e.ent_start":"2017-07-24"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"1997-01-01"},{"e.ent_start":"2021-08-22"},{"e.ent_start":0},{"e.ent_start":"2021-02-06"},{"e.ent_start":"2016-10-01"},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2022-03-14"},{"e.ent_start":"2018-10-01"},{"e.ent_start":"2022-04-11"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2022-05-01"},{"e.ent_start":"2016-04-20"},{"e.ent_start":"2022-02-10"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-02-06"},{"e.ent_start":"2020-05-08"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-03-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-08-08"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-12"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-05-01"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2019-11-01"},{"e.ent_start":"2021-03-20"},{"e.ent_start":"2017-10-11"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2020-10-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-02-14"},{"e.ent_start":"2019-08-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2015-05-19"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2015-04-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":0},{"e.ent_start":"2020-07-16"},{"e.ent_start":"2018-05-05"},{"e.ent_start":"2016-06-01"},{"e.ent_start":"2021-01-13"},{"e.ent_start":"2021-12-17"},{"e.ent_start":"2020-09-16"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-05-24"},{"e.ent_start":"2020-07-10"},{"e.ent_start":"2022-01-17"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-02-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2016-01-14"},{"e.ent_start":"2013-08-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-10-05"},{"e.ent_start":"2022-02-16"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2011-02-03"},{"e.ent_start":"2017-05-18"},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2019-07-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2017-09-01"},{"e.ent_start":"2022-03-09"},{"e.ent_start":0},{"e.ent_start":"2014-09-15"},{"e.ent_start":"2018-02-21"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2004-03-27"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2014-12-01"},{"e.ent_start":"2020-04-27"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-02-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-02-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2014-10-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2021-11-01"},{"e.ent_start":"2008-03-19"},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2018-01-09"},{"e.ent_start":"2013-08-24"},{"e.ent_start":"2018-06-04"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-12-12"},{"e.ent_start":"2014-06-07"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-08-16"},{"e.ent_start":"2017-06-17"},{"e.ent_start":0},{"e.ent_start":"2022-03-30"},{"e.ent_start":"2021-03-03"},{"e.ent_start":"2021-06-01"},{"e.ent_start":"2022-05-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2015-03-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-01-05"},{"e.ent_start":"2020-07-25"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2008-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2023-01-04"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-17"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-02-09"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-07-14"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-09-06"},{"e.ent_start":"2018-09-04"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-03-16"},{"e.ent_start":"2014-10-10"},{"e.ent_start":"2022-07-14"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-09-03"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2022-01-08"},{"e.ent_start":"2021-12-21"},{"e.ent_start":"2022-02-01"},{"e.ent_start":"2018-07-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-07-22"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2009-04-18"},{"e.ent_start":"2016-11-12"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-02-15"},{"e.ent_start":"2021-06-30"},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-10-02"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2022-01-22"},{"e.ent_start":"2017-08-21"},{"e.ent_start":"2021-11-01"},{"e.ent_start":"2019-11-01"},{"e.ent_start":"2021-06-15"},{"e.ent_start":"2012-11-01"},{"e.ent_start":"2019-02-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-05"},{"e.ent_start":"2022-09-20"},{"e.ent_start":"2021-07-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2017-02-06"},{"e.ent_start":"2018-02-18"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2022-04-08"},{"e.ent_start":"2005-02-03"},{"e.ent_start":0},{"e.ent_start":"2015-10-08"},{"e.ent_start":"2020-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-30"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2020-01-31"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2020-10-21"},{"e.ent_start":"2020-02-25"},{"e.ent_start":"2019-04-05"},{"e.ent_start":"2021-06-01"},{"e.ent_start":0},{"e.ent_start":"2020-11-12"},{"e.ent_start":"2020-05-16"},{"e.ent_start":"2017-11-01"},{"e.ent_start":"2022-02-04"},{"e.ent_start":"2019-09-01"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2014-02-07"},{"e.ent_start":"2022-03-18"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-05-24"},{"e.ent_start":"2021-12-07"},{"e.ent_start":"2020-07-22"},{"e.ent_start":"2021-10-30"},{"e.ent_start":"2021-11-21"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2021-12-13"},{"e.ent_start":"2022-02-05"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-01-06"},{"e.ent_start":0},{"e.ent_start":"2015-09-01"},{"e.ent_start":"2021-06-11"},{"e.ent_start":"2018-10-25"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2021-06-01"},{"e.ent_start":"2018-08-24"},{"e.ent_start":"2018-11-28"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-22"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2019-01-11"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2020-11-08"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2013-03-05"},{"e.ent_start":"2014-06-30"},{"e.ent_start":"2020-02-18"},{"e.ent_start":0},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2017-04-26"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2011-01-26"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-01"},{"e.ent_start":"2020-01-21"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2020-06-01"},{"e.ent_start":"2014-11-12"},{"e.ent_start":"2022-03-25"},{"e.ent_start":"2022-02-01"},{"e.ent_start":"2022-03-18"},{"e.ent_start":"2020-03-15"},{"e.ent_start":"2022-02-01"},{"e.ent_start":"2021-11-16"},{"e.ent_start":"2010-05-05"},{"e.ent_start":"2021-09-10"},{"e.ent_start":0},{"e.ent_start":"2021-07-26"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2011-07-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2012-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-11-26"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-15"},{"e.ent_start":"2021-11-03"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-02-22"},{"e.ent_start":"2020-09-25"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2022-03-30"},{"e.ent_start":"2020-02-10"},{"e.ent_start":"2021-10-20"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2016-12-16"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-10-31"},{"e.ent_start":"2017-01-17"},{"e.ent_start":"2021-12-02"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-09-24"},{"e.ent_start":"2019-10-01"},{"e.ent_start":"2020-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2022-04-07"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2019-07-22"},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2015-08-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-01-04"},{"e.ent_start":"2022-01-02"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-07-27"},{"e.ent_start":0},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2015-10-03"},{"e.ent_start":0},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2019-01-27"},{"e.ent_start":"2019-01-15"},{"e.ent_start":"2020-06-18"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-02-14"},{"e.ent_start":"2021-05-27"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-03-19"},{"e.ent_start":"2022-01-06"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2022-02-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2006-01-01"},{"e.ent_start":"2009-09-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2011-06-01"},{"e.ent_start":"2022-01-04"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2011-01-26"},{"e.ent_start":"2021-12-01"},{"e.ent_start":0},{"e.ent_start":"2020-03-19"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-10"},{"e.ent_start":"2019-05-13"},{"e.ent_start":"2022-02-04"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2018-08-18"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-03-08"},{"e.ent_start":"2020-06-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-15"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-09-24"},{"e.ent_start":"2017-02-01"},{"e.ent_start":"1999-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-02-17"},{"e.ent_start":"2022-01-15"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-09-10"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2019-10-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-06-01"},{"e.ent_start":"2021-02-15"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-11-25"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"1996-01-01"},{"e.ent_start":"2022-02-22"},{"e.ent_start":0},{"e.ent_start":"2017-12-01"},{"e.ent_start":"2020-04-01"},{"e.ent_start":0},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2018-05-15"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-16"},{"e.ent_start":"2021-09-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-12-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2016-07-06"},{"e.ent_start":"2015-04-07"},{"e.ent_start":0},{"e.ent_start":"2021-05-01"},{"e.ent_start":"2014-11-04"},{"e.ent_start":"2022-01-27"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2022-03-28"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2015-10-01"},{"e.ent_start":0},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2004-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":"2020-08-13"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2018-12-28"},{"e.ent_start":"2012-01-01"},{"e.ent_start":"2021-09-16"},{"e.ent_start":0},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-12-13"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2018-01-11"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2021-11-09"},{"e.ent_start":"2022-01-12"},{"e.ent_start":"2021-01-15"},{"e.ent_start":"2017-08-08"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2013-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2016-05-19"},{"e.ent_start":0},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2022-01-12"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-09-10"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2022-02-01"},{"e.ent_start":0},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2021-05-10"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-06-01"},{"e.ent_start":"1979-01-01"},{"e.ent_start":"2021-09-01"},{"e.ent_start":"2022-03-01"},{"e.ent_start":"2004-01-01"},{"e.ent_start":"2018-07-12"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-04-01"},{"e.ent_start":0},{"e.ent_start":"2021-08-04"},{"e.ent_start":"2022-04-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-07-07"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-03-01"},{"e.ent_start":"2021-02-25"},{"e.ent_start":"2009-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-12-31"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2019-09-13"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-08-20"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2011-09-07"},{"e.ent_start":"2021-04-02"},{"e.ent_start":"2021-05-11"},{"e.ent_start":0},{"e.ent_start":"2010-09-24"},{"e.ent_start":"2018-11-17"},{"e.ent_start":"2017-01-01"},{"e.ent_start":0},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-09-14"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2019-12-17"},{"e.ent_start":"2022-01-03"},{"e.ent_start":"2021-11-18"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-09-12"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-12-20"},{"e.ent_start":"2020-05-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-07-21"},{"e.ent_start":"2019-03-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-11-30"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-06-15"},{"e.ent_start":"2021-08-12"},{"e.ent_start":"2020-06-22"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2019-10-01"},{"e.ent_start":"2020-06-20"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"1902-01-01"},{"e.ent_start":0},{"e.ent_start":"2020-05-08"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-12-10"},{"e.ent_start":"2021-08-15"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-03-25"},{"e.ent_start":0},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2022-01-14"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-06-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2000-02-23"},{"e.ent_start":"2021-09-25"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-06-14"},{"e.ent_start":"2020-08-07"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2018-02-15"},{"e.ent_start":"2017-12-01"},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2020-02-05"},{"e.ent_start":"2021-02-01"},{"e.ent_start":"2019-10-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2017-07-07"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2019-08-28"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2016-12-16"},{"e.ent_start":"2021-10-12"},{"e.ent_start":"2015-09-26"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2002-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2011-07-01"},{"e.ent_start":"2019-10-31"},{"e.ent_start":0},{"e.ent_start":"2014-01-01"},{"e.ent_start":"2021-09-24"},{"e.ent_start":"2022-01-31"},{"e.ent_start":"2016-04-01"},{"e.ent_start":"2018-06-08"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-04-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2015-06-15"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-08-12"},{"e.ent_start":"2017-09-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2009-02-01"},{"e.ent_start":"2022-01-13"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2020-06-01"},{"e.ent_start":"2019-10-01"},{"e.ent_start":"1980-01-01"},{"e.ent_start":"2019-07-02"},{"e.ent_start":"2018-12-31"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2014-09-01"},{"e.ent_start":"2006-06-02"},{"e.ent_start":"2021-12-01"},{"e.ent_start":0},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-05-01"},{"e.ent_start":"2019-10-27"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2017-07-01"},{"e.ent_start":"2016-10-17"},{"e.ent_start":"2021-03-24"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2008-01-01"},{"e.ent_start":"2021-06-08"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2018-10-01"},{"e.ent_start":"2016-08-24"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-02-12"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2021-11-03"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2020-12-20"},{"e.ent_start":"2018-04-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-05-20"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-10-13"},{"e.ent_start":0},{"e.ent_start":"2021-02-19"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-02-01"},{"e.ent_start":"2008-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2011-01-26"},{"e.ent_start":"2018-02-07"},{"e.ent_start":"2021-02-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-02-03"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-11-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-05-18"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-04-29"},{"e.ent_start":"2021-10-25"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2021-05-05"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2015-08-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-04-29"},{"e.ent_start":"2021-03-24"},{"e.ent_start":0},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2018-10-06"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-03-19"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2015-01-01"},{"e.ent_start":"2019-12-01"},{"e.ent_start":"2018-11-21"},{"e.ent_start":"2018-08-01"},{"e.ent_start":0},{"e.ent_start":"2021-11-01"},{"e.ent_start":"1999-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-11"},{"e.ent_start":"2018-08-20"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-07-07"},{"e.ent_start":"2021-01-08"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":0},{"e.ent_start":"2001-05-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-12-15"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-08-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2007-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2020-02-14"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-03-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2016-05-26"},{"e.ent_start":"2018-07-01"},{"e.ent_start":"2020-09-01"},{"e.ent_start":"2021-07-21"},{"e.ent_start":"2018-09-04"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2008-01-23"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-11-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2019-07-25"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-12-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2023-02-27"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2015-04-01"},{"e.ent_start":"2018-11-26"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2009-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2022-01-01"},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":"2020-10-20"},{"e.ent_start":"2021-10-02"},{"e.ent_start":"2021-10-17"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-02-22"},{"e.ent_start":0},{"e.ent_start":"2020-11-20"},{"e.ent_start":"2019-07-23"},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2021-10-30"},{"e.ent_start":"2021-07-26"},{"e.ent_start":"2010-01-01"},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2012-05-02"},{"e.ent_start":"2019-12-11"},{"e.ent_start":"2018-06-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-07-20"},{"e.ent_start":0},{"e.ent_start":"2015-01-01"},{"e.ent_start":0},{"e.ent_start":"2021-10-01"},{"e.ent_start":"2011-01-01"},{"e.ent_start":"2021-09-06"},{"e.ent_start":"2021-04-12"},{"e.ent_start":"2020-12-21"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":"2014-06-25"},{"e.ent_start":"2020-05-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2008-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":0},{"e.ent_start":0},{"e.ent_start":"1999-03-07"},{"e.ent_start":"2017-03-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2020-11-20"},{"e.ent_start":"2020-09-14"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-12-22"},{"e.ent_start":0},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2021-07-01"},{"e.ent_start":"2021-12-21"},{"e.ent_start":"2022-01-01"},{"e.ent_start":"2019-09-01"},{"e.ent_start":"2021-08-27"},{"e.ent_start":"2021-06-01"},{"e.ent_start":"2018-08-01"},{"e.ent_start":"2020-11-06"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2006-01-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2017-03-09"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-04-14"},{"e.ent_start":"2021-08-01"},{"e.ent_start":"2017-04-11"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2018-04-28"},{"e.ent_start":"2020-09-06"},{"e.ent_start":0},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-03-01"},{"e.ent_start":"2007-01-01"},{"e.ent_start":"2017-01-01"},{"e.ent_start":"2021-11-10"},{"e.ent_start":"2014-05-01"},{"e.ent_start":"2019-11-22"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2021-04-01"},{"e.ent_start":"2021-01-04"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2014-11-11"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2021-10-31"},{"e.ent_start":"2016-06-01"},{"e.ent_start":"2015-10-16"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2014-07-01"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2017-09-17"},{"e.ent_start":"2019-04-24"},{"e.ent_start":"2015-04-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-09-21"},{"e.ent_start":"2013-12-28"},{"e.ent_start":"2007-01-29"},{"e.ent_start":"1997-01-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2011-11-01"},{"e.ent_start":"2018-02-03"},{"e.ent_start":"2021-09-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2018-01-01"},{"e.ent_start":"2016-01-01"},{"e.ent_start":"2016-01-31"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2020-05-18"},{"e.ent_start":"2021-03-18"},{"e.ent_start":"2021-12-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2017-12-01"},{"e.ent_start":0},{"e.ent_start":"2017-07-01"},{"e.ent_start":0},{"e.ent_start":"2019-01-01"},{"e.ent_start":"2013-04-01"},{"e.ent_start":"2021-01-01"},{"e.ent_start":"2019-04-01"},{"e.ent_start":"2020-01-01"},{"e.ent_start":"2021-10-10"},{"e.ent_start":"2021-11-01"}],"count":1274,"rows_by_year":{"1899":1,"1902":1,"1955":1,"1979":1,"1980":1,"1995":1,"1996":1,"1997":3,"1998":1,"1999":3,"2000":2,"2001":2,"2002":1,"2003":1,"2004":5,"2005":1,"2006":5,"2007":3,"2008":6,"2009":8,"2010":9,"2011":19,"2012":11,"2013":12,"2014":25,"2015":36,"2016":58,"2017":61,"2018":96,"2019":88,"2020":143,"2021":396,"2022":174,"2023":8},"year_groups":[1950,1960,1970,1980,1990,2000,2010,2020,2030],"plot_data":[{"type":"scatter","x":[1955,1979,1980,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022],"y":[1,1,1,1,1,3,1,3,2,2,1,1,5,1,5,3,6,8,9,19,11,12,25,36,58,61,96,88,143,396,174],"name":"Historical Data","line":{"color":"rgb(0, 0, 0)","width":3}},{"type":"scatter","x":[2022,2023],"y":[174,8],"name":"Last Year Segment","mode":"lines","line":{"color":"rgb(0, 0, 0)","width":3,"dash":"dot"}}],"plot_layout":{"title":"Organizations for Metaverse","legend":{"orientation":"h"},"plot_bgcolor":"#E7E7F0","paper_bgcolor":"#ffffff","margin":{"t":80,"r":40,"b":80,"l":40}}}

I refresh my screen and run all these AJAX requests again, and the bug goes away (the "1" in front of the json content disappears).

It only happens every day on the first run and this is why I consider this bug very weird.

I'm posting it here because I think it is either related to something going on with Neo4j library and dependencies or with the process of encoding/decoding the data. It might not be 100% related to Neo4j but then again, it ONLY happens on the AJAX requests that DO interact with Neo4j.

To Reproduce

I have built a Neo4j client by using the example app here: https://github.com/neo4j-examples/movies-php-client

<?php

namespace common\services;

use Yii;
use yii\base\Component;
use Laudis\Neo4j\Authentication\Authenticate;
use Laudis\Neo4j\Basic\Driver;
use Laudis\Neo4j\Basic\Session;
use Laudis\Neo4j\Types\ArrayList;

/**
 * https://github.com/neo4j-examples/movies-php-client/blob/main/index.php
 */
class Neo4jClient extends Component {

  public $uri;
  public $username;
  public $password;

  public function init() {
    parent::init();
  }

  /**
   * @var Session
   */
  private $session = null;

  public function getSession() {

    if ($this->session===null) {
      $uri = $this->uri;

      $auth = Authenticate::basic($this->username, $this->password);
      $driver = Driver::create($uri, authenticate: $auth);
      $this->session = $driver->createSession();
    }

    return $this->session;
  }

}

The connection string goes like this: neo4j://123.123.123.123?database=neo4j`

Then I run a query on Neo4j and output the results:

<?php

namespace frontend\controllers\subject;

use Yii;
use yii\base\Action;
use yii\web\Response;

use common\models\mongo\Subject;
use yii\web\NotFoundHttpException;
use common\helpers\Tools;

use common\helpers\SourceTypeEnum;

class GetSourcePlotAction extends Action {

  public function run($slug, $source_type, $limit=10) {

    \Yii::$app->session->close(); // allow concurrent requests and dont wait to finish    

    $limit=15000; 

    $result = [
        'rows'=>[],
        'count'=>0,
    ];
    \Yii::$app->response->format = Response::FORMAT_JSON;

    $subject=Subject::find()->where(['ent_fsid'=>Tools::addFsidPrefix($slug)])->one();

    if (!$subject) {
      throw new NotFoundHttpException('Subject not found.');
    }

    $term = $subject->ent_name;

    /** @var \common\services\Neo4jClient $neo4jclient */
    $neo4jclient=Yii::$app->neo4j;

    $sid=$subject->ent_fsid;

    $cypher = <<<'CYPHER'
    MATCH (e:{entity})-[r]-(s:Subject)
    WHERE s.new_ent_fsid = $sid

    RETURN e.ent_start

    limit $limit
    CYPHER;
    $cypher = str_replace('{entity}', $source_type, $cypher);

    $rows = $neo4jclient->getSession()->run($cypher, [
        'sid' => $sid,
        'limit' => (int)$limit,
    ]);

    if (0 === $rows->count()) {
      $result['message']="Could not find rows for term: $term and type: $source_type";
    } else {
      // json_encode() Inf and NaN cannot be JSON encoded
      // https://stackoverflow.com/a/45330071/115050
      $rows_encoded=json_encode($rows->toArray(), JSON_NUMERIC_CHECK | JSON_PARTIAL_OUTPUT_ON_ERROR);

      $result['rows']=json_decode($rows_encoded, true);
      $result['count']=$rows->count();
    }

    return $result;
  }

}

Expected behavior

I should get a clean ajax response starting with { and ending in }.

Instead the ajax response starts with 1{ as if some part of the code printed the number 1 before the output.

Weird thing is it ONLY happens ONCE. Reload the page and it works well until the first run on next day.

Screenshots

image

Desktop (please complete the following information):

C:\Projects\fst-webapp>php composer.phar show -i laudis/neo4j-php-client
You are using the deprecated option "installed". Only installed packages are shown by default now. The --all option can be used to show all packages.
name     : laudis/neo4j-php-client
descrip. : Neo4j-PHP-Client is the most advanced PHP Client for Neo4j
keywords : bolt, client, cluster, database, driver, graph, high-availability, http, neo4j
versions : * 3.1.2
released : 2024-08-09, 1 month ago
type     : library
license  : MIT License (MIT) (OSI approved) https://spdx.org/licenses/MIT.html#licenseText
homepage :
source   : [git] https://github.com/neo4j-php/neo4j-php-client.git 7c2aa00378474bb43ff7b315c5a9055118d587dd
dist     : [zip] https://api.github.com/repos/neo4j-php/neo4j-php-client/zipball/7c2aa00378474bb43ff7b315c5a9055118d587dd 7c2aa00378474bb43ff7b315c5a9055118d587dd
path     : C:\Projects\fst-webapp\vendor\laudis\neo4j-php-client
names    : laudis/neo4j-php-client, psr/simple-cache-implementation

support
issues : https://github.com/neo4j-php/neo4j-php-client/issues
source : https://github.com/neo4j-php/neo4j-php-client/tree/3.1.2

autoload
psr-4
Laudis\Neo4j\ => src/

requires
ext-json *
ext-mbstring *
laudis/typed-enum ^1.3.2
php ^8.1
php-http/discovery ^1.13
php-http/message ^1.0
psr/http-client ^1.0
psr/http-factory ^1.0
psr/http-message ^1.0|^2.0
psr/simple-cache >=2.0
stefanak-michal/bolt ^7.0.1
symfony/polyfill-php80 ^1.2

requires (dev)
cache/integration-tests dev-master
friendsofphp/php-cs-fixer 3.15.0
kriswallsmith/buzz ^1.2
kubawerlos/php-cs-fixer-custom-fixers 3.13.*
monolog/monolog ^2.2
nyholm/psr7 ^1.3
nyholm/psr7-server ^1.0
phpunit/phpunit ^10.0
psalm/plugin-phpunit ^0.18
psr/log ^1.1
rector/rector ^1.0
symfony/uid ^5.0
symfony/var-dumper ^5.0
vimeo/psalm ^5.0

suggests
composer-runtime-api Install composer 2 for auto detection of version in user agent
ext-bcmath Needed to implement bolt protocol
ext-sysvsem Needed for enabling connection pooling between processes

provides
psr/simple-cache-implementation 2.0|3.0
PHP 8.1.19 (cli) (built: May 11 2023 12:00:16) (NTS Visual C++ 2019 x64)
Copyright (c) The PHP Group
Zend Engine v4.1.19, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.19, Copyright (c), by Zend Technologies

Additional context

Link to live server: https://tools.futurity.science/snapshot/metaverse

But again. The bug happens randomly and you'll only see it if you're the first visitor in that day.

I know it sounds weird but the only thing I can think of is that something like this happens somewhere internally:

  1. Some process checks if a local file exists and if it was generated in the past 12 hours
  2. If not, it generates it, and in that process it prints "1" to the php's output buffer
  3. On new requests since that file is "cached" and there's no need to generate it again, that "1" doesn't get printed until "next day"

Only thing I will try is to update the way I'm connecting to Neo4j since I'm using code from the Movies example and I see it is not the same code as the documentation on this repo.

stefanak-michal commented 1 month ago

If it happens only once a day it can be related to underlying bolt protocol library, it process collected analytics once a day. I don't see any echo or anything else what would cause it, but you can opt out from analytics with setting environment variable BOLT_ANALYTICS_OPTOUT to any value.

stefanak-michal commented 1 month ago

https://github.com/neo4j-php/Bolt/blob/d2e25fa798e5265af9e47fd94907da44a95b29bf/src/Bolt.php#L54

atrandafir commented 1 month ago

Thanks @stefanak-michal that was on my mind cause I have been inspecting the code, I'll try it out.

By the way, in the first deployment on the live server, I had some issues because for some reason php's default temp directory wasn't writable by the web server and I had to run this in order to temporarily fix it:

mkdir vendor/stefanak-michal/bolt/temp
chmod -R 777 vendor/stefanak-michal/bolt/temp
sudo chown -R bitnami:daemon vendor/stefanak-michal/bolt/temp/

Again I haven't tried to deploy it on a different server to see if this is common, but if anybody has that permission issue on the temp directorly they might run into this problem.

atrandafir commented 1 month ago

Hi again, effectively I have been able to reproduce the bug on demand:

Basically I modified Bolt library code to always run the track method no matter what:

image

image

And I got the bug:

image

And yes this solves it for now:

putenv("BOLT_ANALYTICS_OPTOUT=1");

Also can't really figure out by a short look at the track() method code what actually causes to print the 1 on the screen.

stefanak-michal commented 1 month ago

@atrandafir that is unfortunate you cannot tell what is causing it in your environment. Could be possible to share your php.ini with me?

atrandafir commented 1 month ago

Hi again @stefanak-michal yes it is solved on my environment by using the ENV opt out.

But I did found what solves the bug in the code, basically changing this from false to true on the cURL call:

CURLOPT_RETURNTRANSFER => true,

Apparently if we tell cURL to not return the transfer, it will print the result of curl_exec on the screen (true/false), and it is that true that gets printed as "1".

https://stackoverflow.com/questions/4803948/curl-exec-printing-results-when-i-dont-want-to

Then the results of the request will be returned but nothing gets done with it since it is not assigned to a variable, but the bug goes away at least.

So in other words, you could return the transfer, decode it and check if the actual analytics request was okay before deleting the file.

Anyways, that change fixes it.

stefanak-michal commented 1 month ago

Good to know, thanks for doing some reserach and feedback, I'll look into it when I'll be at computer

stefanak-michal commented 1 month ago

Issue was solved, therefore it can be closed.

transistive commented 1 month ago

Amazing