# terms.teach: OverflowError: Python int too large to convert to SQLite INTEGER

**URL:** <https://support.prodi.gy/t/terms-teach-overflowerror-python-int-too-large-to-convert-to-sqlite-integer/1130>\
**Category:** Uncategorized\
**Tags:** done, database, terms, solved, windows\
**Created:** [January 16, 2019, 3:12pm UTC](https://support.prodi.gy/t/terms-teach-overflowerror-python-int-too-large-to-convert-to-sqlite-integer/1130 "2019-01-16T15:12:54Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ines](https://sea2.discourse-cdn.com/flex020/user_avatar/support.prodi.gy/ines/32/3_2.png) [@ines](https://support.prodi.gy/u/ines)\
**Post date:** [January 16, 2019, 5:00pm UTC](https://support.prodi.gy/t/terms-teach-overflowerror-python-int-too-large-to-convert-to-sqlite-integer/1130/4 "2019-01-16T17:00:02Z")

</div>

Thanks and hmmm, this is really really strange. Coud you run `conda list` and check which version of `sqlite` it has installed by default? Maybe you’ve ended up with some old version with bad defaults compiled into it (which is a known issue).

To help debug this, could you find line 302 in `prodigy/components/db.py` and add a print statement above it that outputs the example it’s adding (to find the last one it eventually fails on)? For example, like this:

```python
print(eg)
eg = Example.create(input_hash=eg[INPUT_HASH_ATTR],
                    task_hash=eg[TASK_HASH_ATTR],
                    content=content)

```

To find the location of your Prodigy installation, you can run the following:

```bash
python -c "import prodigy; print(prodigy. __file__ )"

```

Finally, if this is all too annoying and you just want to get started, it might be easier to install [MySQL](https://dev.mysql.com/doc/refman/5.5/en/windows-installation.html) on your system. In your `prodigy.json`, you can set `"db": "mysql"` and then use the `"db_settings"` to specify your username, database and password. [See here](https://prodi.gy/docs/#db) for details.

---

_[View the full topic](https://support.prodi.gy/t/terms-teach-overflowerror-python-int-too-large-to-convert-to-sqlite-integer/1130)._