Problems building database

[Joe Rapp]

Hello,

First of all, thanks for this great tool and making it oss.

I'm trying to build a database with the command line.

After creating a Datafile with the following:
world 'openmundi/world.db', setup: 'countries'
football 'openfootball/fr-france'

Running the sportdb build command seems to fail while parsing the world.db data:
...
[info] parsing data (hash) in zip 'antartica/2-more/continents' (world.db-master/antartica/2-more/continents.yml)...
[info] parsing data (hash) in zip 'asia/2-more/continents' (world.db-master/asia/2-more/continents.yml)...
[info] parsing data (hash) in zip 'caribbean/2-more/continents' (world.db-master/caribbean/2-more/continents.yml)...
[info] parsing data (hash) in zip 'central-america/2-more/continents' (world.db-master/central-america/2-more/continents.yml)...
[info] parsing data (hash) in zip 'europe/2-more/continents' (world.db-master/europe/2-more/continents.yml)...
[warn] hash reader - found implicit bool (no) for key; adding quotes to turn into string; see yaml.org/refcard.html (path=)

*** error: 70198166365280 is out of range for ActiveRecord::Type::Integer with limit 4

[Gerald Bauer]

Hello,
Thanks for trying football.db. Welcome.

What database are you using? e.g. mysql? Cheers.

[Joe Rapp]

Hi Gerald,

I'm completely new to football.db and a complete noob with ruby and/or rails, so sorry in advance for being a little slow.

I'm trying to create a db file for a national league (I tried the French league) and then use it in a nodejs server like in the example app(https://github.com/sportkit/sport.db.starter.node.js).

Database would be sqlite3 or Postgres, depending on size.

[Gerald Bauer]

Hello,

> *** error: 70198166365280 is out of range for ActiveRecord::Type::Integer with limit 4

I'm asking because it's a know bug with mysql , that is, the logs
table needs to a bigint with limit 8.

I'm using sqlite3 on my local machine and postgresql on heroku
where I have yet to get this error with the logs table.

Anyways, the quick workaround is to NOT log to the database (if
you're using your own build script). If not, I will try to
publish/push a fixed logutils-activerecord gem in the next days.
Thanks for your patience. Cheers.

[1] github.com/rubylibs/logutils-activerecord