I use SQLite for a site that has Biblio installed, and I'm finding that over the span of a couple of days, the database is filling up with lots of tables like biblio_0, biblio_1 and so on all the way up to biblio_48, and eventually the site breaks. Each of the tables appears to be a copy of the original table. In at least once instance, the biblio table itself was missing, while biblio_0 through biblio_48 still existed.

I suspect that Biblio might be trying to create a temporary table, or perhaps restructure the biblio table itself, on the fly, but that appears to be failing, but not cleaning up the temporary table.

This isn't happening on any of the other sites that I have that are both SQLite and Biblio (and there are probably a dozen or more), nor is it happening with any other tables in the site's database.

Any ideas on what may be the cause?

Comments

tjg’s picture

Just checking in on this, as there's been no response, and this is still a problem for me. The site in question has again wound up with a corrupted biblio table. This time, a biblio table existed but it had only one column and no data, while i had a bunch of tables like biblio_0, biblio_1 all the way up to biblio_36 this time.

Liam Morland’s picture

Version: 7.x-1.0-rc7 » 7.x-1.x-dev

I don't use SQLite. My impression is that Bibio doesn't work correctly with it. I don't have the resources to investigate.