search

bids-standard / pybids

Python tools for querying and manipulating BIDS datasets.
https://bids-standard.github.io/pybids/
MIT License
225 stars 122 forks source link

sqlite3.OperationalError: table associations already exists #1079

Open MRIDude opened 3 months ago

MRIDude commented 3 months ago

I am currently running the newest version of pybids. On ubuntu 20.04 and 22.04. I am running three lines of code:

`import bids as BIDS

layout=BIDS.BIDSLayout('/data/jsp/human2/BidsDataset/PIB')

layout.save('/data/jsp/human2/BidsDataset/Scripts/PIBproject') `

I get the following error

Traceback (most recent call last): File "", line 1, in File "/data/jsp/human2/fcMRI/Aaron/locals/Ubuntu20.04/local/pkg/anaconda/envs/bids/lib/python3.12/site-packages/bids/layout/layout.py", line 365, in save self.connection_manager = self.connection_manager.save_database( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/data/jsp/human2/fcMRI/Aaron/locals/Ubuntu20.04/local/pkg/anaconda/envs/bids/lib/python3.12/site-packages/bids/layout/db.py", line 139, in save_database new_db.execute(line) sqlite3.OperationalError: table associations already exists

I have run these three lines before with out an issue. Have I done some thing wrong.

MRIDude commented 3 months ago

This morning I looked into this an little further. It is occurring because the sqlite file already exist. This has never happened to me before. However I have not run this script since before pybids 0.17.0 came out.